The historic 1924 racing schooner Pilot, formerly a popular floating restaurant at Pier 6, sank overnight at its maintenance mooring in Red Hook earlier this week.