Two people are dead after a shocking crash on a bridge in Melbourne's north west.