Shocking video footage shows the aftermath of a three-vehicle crash caused by a van driver who was more than double both the drink and drug limits.