Footage shows moment when an HGV truck smashed into three vehicles on a quiet street