A major Yorkshire road has been closed after a car overturned.