A Coast Guard investigation into the grounding in March of a cargo ship in the Chesapeake Bay faulted the pilot tasked with helping the ship navigate the waterway.