Shocking CCTV footage has emerged of the moment a vehicle tears down a Melbourne street causing a multi-vehicle crash.