The pilot and passenger on board a light aircraft which crashed in North Yorkshire have died, police have said.