A seriously ill patient has died after his ambulance was in a crash with a car on its way to hospital in Northern Ireland, police said.