Police have named the 40-year-old man who died when the motorcycle he was riding collided with a car in Yorkshire.