NTSB investigations
3,485 cases where the first occurrence was “In flight collision with terrain/water”.
Cases, newest first
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1 WHERE c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230) ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB SEA92LA031Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Missoula, MTThe pilot's poor in-flight decision, failure to perform a missed approach, and improper altitude. Factors include poor preflight planning/preparation, and weather conditions below approach minimums.NTSB SEA92LA030Accident · Minor injuriesLimited investigationFinal reportArtic S-1B2 · Lysite, WYThe pilot's failure to maintain clearance with terrain. Factors contributing to the accident were rising terrain, downdrafts, and the pilot's inadequate compensation for wind conditions.NTSB DEN92FA016Accident · 1 fatalField investigationFinal reportCessna 210M · Albuquerque, NMInsufficient terrain clearance altitude selected by the pilot in command.NTSB MIA92LA042Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Charlotte, NCThe pilot in commands failure to maintain tailrotor ground clearance while hovering resulting in the tail striking the ground and the subsequent separation of the tailrotor and gearbox.NTSB LAX92FA058Accident · 5 fatalField investigationFinal reportPiper PA31-350 · Temple Bar, AZThe pilot-in-command's poor inflight decision by not electing to proceed to an alternate airport and to continue to the flight under visual flight rules into instrument meteorological conditions. The low ceilings and visibilities across the flight route and…NTSB LAX92LA057Accident · 1 fatalLimited investigationFinal reportPiper PA-34-200T · Pine Valley, CAThe pilot's failure to monitor the proper altitude over obserable rising terrain. A contributing factor was the pilot's encounter with a strong downdraft.NTSB FTW92LA039Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Las Cruces, NMThe pilot's misjudgment of the airplane's performance which led to a situation where it could not climb above the rising terrain. A factor was the high density altitude which existed in the mountains at the time of the accident.NTSB NYC92LA040Accident · No injuriesLimited investigationFinal reportPiper PA28R-200 · Piqua, OHThe pilot allowed the airplane to get too low on short final and struck the terrain short of the runway. Factors in the accident were the proper glide path was not maintained, resulting in the intended touchdown point not being attained.NTSB CHI92LA038Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Iowa, IAThe pilot's failure to extend the landing gear which resulted in the propeller blades contacting the runway during the landing. A factor related to the accident was the pilot's failure to follow a checklist during the approach.NTSB FTW92LA026Accident · Serious injuriesLimited investigationFinal reportBell 47G3B2A · Texarkana, TXThe pilot's failure to maintain proper terrain clearance during takeoff. A factor was his lack of total experience in helicopters.NTSB NYC92LA031Accident · 2 fatalLimited investigationFinal reportMooney M20C · Painesville, OHThe pilot's failure to see and avoid the powerline tower structure while executing a visual approach to the airport. Factors related to the accident were the lack of proper radio equipment necessary to execute the instrument approach, restricted visibility…NTSB ATL92FA024Accident · 1 fatalField investigationFinal reportCessna 208B · Destin, FLThe pilots failure to follow instrument flight rules procedures by disregarding the minimum descent altitude for the approach and failing to maintain clearance from the terrain. A factor in the accident was the pilot's over confidence in his personal ability.NTSB LAX92FA283Accident · 5 fatalField investigationFinal reportCessna 336A · Big Bear City, CA1) The pilot inadequately evaluating the weather, and 2) the pilot making the inflight decision to continue flight into adverse weather conditions. Factors in this accident were 1) the inability of the pilot to see the mountainous terrain due to the ambient…NTSB LAX92LA044Accident · No injuriesLimited investigationFinal reportCessna 170B · Lake Havasu, AZThe pilot's; 1) inadequate preflight preparation, 2) failure to obtain current NOTAM information, and 3) failure to obtain a current altimeter setting. Factors in the accident were the dark night condition and the pilot election not to use the landing light.NTSB MIA92GA024Accident · 1 fatalFinal reportCessna 172N · Okeechobee, FLThe pilot-in-command's failure to maintain altitude during a low pass at night. Contributing factors were the pilot's likely spatial disorientation due to the lack of surface visual clues, the dark night conditions, and the patchy fog conditions.NTSB LAX92LA039Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Williams, AZThe pilot's failure to maintain visual lookout.NTSB NYC92FA026Accident · 2 fatalField investigationFinal reportPiper L-3 · Plymouth, MAThe improper decision by the non-instrument-rated pilot to attempt VFR flight in instrument meteorological conditions, at a low altitude, which resulted in a collision with the water. Factors related to the accident were: the overconfidence of the pilot in…NTSB NYC92FA025Accident · 2 fatalField investigationFinal reportBeech V35B · Newfield, NJInflight collision with the ground for undetermined reasons.NTSB LAX92FA033Accident · 3 fatalField investigationFinal reportCessna 337F · Bullhead City, AZThe pilots failure to maintain a proper descent rate and to adequately judge the above ground altitude of the aircraft during the approach. Factors in the accident were: 1) the dark night conditions, 2) the pilot's degraded visual perceptive ability, and 3)…NTSB BFO92FA005Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · West Wardsboro, VTThe pilot's flight into known adverse weather. Contributing to the accident was the pilot's inadequate flight and weather planning.NTSB BFO92LA003Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Waynesboro, VAImproper in-flight planning/decision by the instructor (CFI). Contributing to the accident was the instructor's failure to properly monitor the student's performance.NTSB SEA92FA222Accident · 3 fatalField investigationFinal reportMaule M-5-235C · Moran, WYThe pilot's failure to maintain clearance and altitude from terrain while maneuvering, and his failure to adequately compensate for the wind conditions. Factors contributing to the accident are terrain-induced turbulence, unfavorable winds, gusty high winds,…NTSB SEA92LA015Accident · No injuriesLimited investigationFinal reportCessna 177A · Trout Lake, WAAn inadequate compensation for wind, and proper climb rate not being maintained. Factors include inadequate preflight planning, the pilot's over-confidence in his own ability and the ability of the aircraft, lack of experience in this type of operation, and a…NTSB SEA92FA001Accident · 1 fatalField investigationFinal reportNorth American Navion · Ola, IDAn incapacitating heart attack while in flight.NTSB NYC92LA001Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Auburn, METhe pilot was buzzing and stalled the airplane at too low an altitude to recover.NTSB LAX91LA412Accident · 2 fatalLimited investigationFinal reportChristian Ind. Eagle II · Incline Village, NVThe failure of the pilot to recover from the maneuver in a timely manner which resulted in the airplane striking the water.NTSB SEA91LA252Accident · No injuriesLimited investigationFinal reportCessna 152 · Malaga, WAThe instructor pilot's failure to insure adequate terrain clearance during the go-around maneuver. Factors contributing to the accident were 1) rising terrain, 2) high density altitude condition, and 3) the instructor pilot's delay of the go-around.NTSB NYC91LA254Accident · 1 fatalLimited investigationFinal reportRobinson R-22 · Point Judith, RIThe pilot become disoriented and lost control of the helicopter. Contributing to the accident was a dark night, flight over water, and the pilot's lack of total flight experience.NTSB LAX91LA402Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Buckeye, AZThe passenger/certified flight instructor's poor judgement by interfering with the PIC and his failure to execute a timely go-around. Contributing to this accident was the cfi's misjudgment of altitude.NTSB LAX91FA399Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Cupertino, CAThe pilot's failure to maintain the proper altitude, his improper inflight decision to attempt flight below the base of an overcast layer of clouds toward rising mountainous terrain and the flight's inadvertent entry into instrument meteorological conditions.…NTSB BFO92DOA01Accident · 1 fatalFinal reportPiper PA-28-181 · Belington, WVThe pilot's failure to maintain clearance above the terrain which resulted in inflight collision with the terrain. Contributing was mountainous terrain.NTSB SEA91LA237Accident · 1 fatalLimited investigationFinal reportCessna 170B · Curtis, WAA misjudged maneuver due to physical impairment by alcohol. Contributing to the accident was overconfidence in personal ability.NTSB LAX91FA394Accident · 2 fatalField investigationFinal reportCessna 210 · Rialto, CAThe pilot's inadequate weather evaluation and poor inflight planning/decision. The pilot's impairment due to the use of drugs was a factor in the accident.NTSB LAX91LA391Accident · 1 fatalLimited investigationFinal reportSchweizer 269C · Kahului, HIThe student pilot entry into an uncontrolled descent while attempting to perform an autorotation. The student pilot's lack of total experience was a factor in the accident.NTSB FTW91DRD08Accident · No injuriesFinal reportCessna 152 · Ruston, LAThe cfi's exceeding the airplane's takeoff performance capability.NTSB CHI91FA291Accident · 2 fatalField investigationFinal reportBeech 95 · Killdeer, NDThe pilot's disregarding the weather forecast; his improper in-flight decision to continue a VFR flight into instrument meteorological conditions; and his failure to maintain adequate clearance from terrain. The mountainous hilly terrain and low ceiling were…NTSB LAX91LA387Accident · 1 fatalLimited investigationFinal reportRotorway Exec 90 · Phoenix, AZUndetermined.NTSB DEN91DTE02Accident · 1 fatalFinal reportCresawn Pitts S1-C · Calhan, COThe pilot's failure to attain adequate aircraft control to avoid terrain collision.NTSB ATL91LA169Accident · Minor injuriesLimited investigationFinal reportBates, Frank L Skybolt · Yatesville, GAThe pilot's failure to maintain a proper altitude during maneuvering flight.NTSB NYC91LA227Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Galloway, OHImproper supervision by the flight instructor which resulted in an inadvertent ground contact and a dynamic rollover. A factor related to the accident was improper use of the flight controls by the non-rated student pilot.NTSB NYC91LA226Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Nantucket, MAThe pilot's descent below the ILS glide path and his delay in initiating a missed approach which resulted in collision with the terrain.NTSB LAX91LA378Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth VENTUS-B · Mojave, CAThe glider pilot's inadequate altitude to clear terrain. Factors which related to the pilot being low could not be established because the pilot had no memory of the accident, and no witnesses were identified who observed the glider other than during its…NTSB SEA91FA223Accident · 3 fatalField investigationFinal reportAerospatiale 350 B1 · Walton, ORThe pilot's failure to maintain clearance from terrain.NTSB FTW91LA157Accident · No injuriesLimited investigationFinal reportCessna 172K · Fisher, ARThe pilot's failure to use the aircraft performance data to compute the takeoff distance. A factor was the high density altitude.NTSB CHI91DCJ07Accident · No injuriesFinal reportPiper PA-25-150 · Stapleton, NEThe pilot's disregard for aircraft performance data. Related factors are the pilot's poor weather evaluation, and delayed remedial action.NTSB ANC91FA132Accident · 3 fatalField investigationFinal reportCessna 172 · Eklutna Lake, AKThe pilot's failure to maintain terrain clearance. Contributing to the accident was the high terrain.NTSB SEA91FA216Accident · 4 fatalField investigationFinal reportPilatus Britten-Norman BN-2A-26 Islander · Ketchikan, AKThe pilot's attempting to operate VFR in instrument meteorological conditions. Factors contributing to the accident were upsloping terrain in the aircraft's flight path as well as weather conditions resulting in an obscuration of the terrain.NTSB ANC91LA130Accident · Minor injuriesLimited investigationFinal reportCessna U206-G · Rainy Pass, AKThe pilot exceeded the climb performance of the aircraft.NTSB DEN91LA114Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Clovis, NMFailure of the pilot to maintain clearance from rising/uneven terrain. Factors related to the accident were: the light conditions at dusk, and the lack of visual cues for the pilot.NTSB LAX91LA357Accident · No injuriesLimited investigationFinal reportRobinson R22B · Chandler, AZThe failure of the student pilot to maintain adequate control of the helicopter and stop a descent, while maneuvering. The pilot's disorientation was a contributing factor.