An elderly woman who went missing while dressed in nightwear has died in hospital, police in the North have said.