Two people have died and a third is missing after the incident in the East Yorkshire seaside town of Withernsea.