The commanders of ships in less serious incidents have had their careers terminated. Those happen yearly.
This is the biggest difference between USN and Naval Air investigations. In NA if the pilot survives he might not be at fault. If he dies it is pilot error. In the USN no matter what the CO is always at fault and rightly so.