A deadly rescue mission has left three people dead after two vessels got into trouble off the northern NSW coast overnight, with four people surviving .