The ex-USS Oriskany, a World War II-era Essex-class aircraft carrier, was sunk this year off the coast of Pensasola to become an artifical reef. A mailing list I’m on had a link to pictures of the sinking taken from a helicopter.
Pretty impressive to watch an aircraft carrier sink. Check out the photos here.
I can only imagine that the sinking of my ship, USS Elliot (DD-967) , was similar, though I believe it lies in deeper water and thus was probably not anchored like the Oriskany was (the anchors make the ship land on the seabed right side up).