A man is fighting for life after a car plunged into the River Wharfe after veering off the road.