A man was rescued after spending an hour trapped in his car as it hung over a bridge in England.