A pilot who crashed on top of a New York City high rise building was "did not know where he was" and was flying in and out of clouds just before the accident.