Is it possible you're thinking of the Halifax Explosion? That killed hundreds and destroyed a huge portion of the city, but that ship was carrying ammunition.

https://en.wikipedia.org/wiki/Halifax_Explosion