The Terminator
"It's over" and then...
Rock and Roll High School
The pyrotechnics on the roof of the school were overloaded and caught a tree fire. Also annoyed the neighborhood as I think they were shooting at 3am.
The Atomic Cafe
This documentary is chock full of atomic bomb test footage and period "atomic" songs.
The Who on The Smothers Brothers
A prank gone wrong, Pete suffered permanent hearing loss.
And aren't there a bunch of films that used demolitions of casinos and other building in the context of a film?
Real explosions are always "better" than CGI effects. That's just a computer cartoon.