I think the Barney Theme song is the biggest disaster ever...but, uhhhh, that's probably not what you were looking for....!!

I guess I would go with "The wreck of the Edmund Fitzgerald" also. Now if a song about war counts I would say "The Town That I Loved So Well".

Frank