A US woman, initially reported missing after a car crash, was found dead in a "deep well" in what the police described as a "tragic accident."