One person was found dead at the scene and two others died in hospital following a distressing incident early on Sunday morning.