Le Passage du Gois, France
This road is only open for a few hours a day, as rising tides leave it underwater for the rest of the time. Be sure to carefully read the schedule of the tides before you drive across, or you may wind up sinking midway through.