The USS Yorktown was found resting upright on the ocean bottom with all its AA guns pointed defiantly upward.
Yorktown died hard. Made Japanese aviators think they sank two carriers, then still took a submarine torpedo to put her down.
Given enough depth, most sunken ships will settle upright, because that is their natural stability.