A N.B. man has died and two others are in hospital following a two-vehicle collision in Cambridge, N.S.