[SC Swamp Fox]

The USS Stark was hit by two Exocets in 1987. The Exocets each carried a 352 lb. warhead. 37 sailors were killed. The crew fought the fires all night and they received assistance from other U.S. Navy ships in the area. They saved the ship.

The USS Stark was a Perry Class Frigate (445ft, 3638 tons)
Decommissioned: 1999, Scrapped: 2005

[Tinian]

Here's a link to a film of the missile strike.

(It's in the bottom window.)

There appears to be two explosions. All you need to see is the first 10 seconds or so.