A man has lost his fight for life, days after he was seriously injured in a tragic crash between Rotherham and Sheffield.