The USS Johnston went down all guns blazing while engaging a vastly superior Japanese fleet. BBC article here.
Oolite Naval Attaché
A Fletcher-class destroyer!!
( https://en.wikipedia.org/wiki/USS_Johnston_(DD-557)). They were in service in the Hellenic Navy too.
https://www.hellenicnavy.gr/en/145-en/history-tradition/636-velos-d-16-(1959---1991).html
Not so deep, but also a ship that went down fighting. Now a tourist diving site:
The Japanese battleship Yamato was involved in the Battle off Samar (where the Johnston went down).
She and her sister ship, Musashi, were the heaviest and most powerfully armed battleships ever constructed, displacing 72,800 tonnes at full load and armed with nine 46 cm (18.1 in) Type 94 main guns, which were the largest guns ever mounted on a warship.
Oolite Naval Attaché