The transformer fails in a "ball of flame". The "flame" only lasts for a second (probably just a spark?), but it is visible for miles.

I don't know how much redundancy they have. I know that my power went out for a few hours a couple months ago when a substation failed. I've seen the "ball of flame" (probably just a spark, it only lasted a second) that knocked out power for a small city.