The commander bears at least some responsibility for everything that happens on his command. The Navy will do a thorough investigation and probably lots of things will be to blame, but "he was asleep at the time" is not a get out of jail free card.