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 ANC96LA064Accident · No injuriesLimited investigationFinal reportAviat A-1 · Togiak, AKThe pilot's failure to remove frost from the surface of the wings and his delay in aborting the takeoff. Factors in the accident were the presence of frost on the wings and a deteriorated climb performance.NTSB MIA96LA133Accident · No injuriesLimited investigationFinal reportMooney M20C · Cullowhee, NCThe pilot's inadequate compensation for wind conditions. The gusty/crosswind condition was a related factor.NTSB MIA96LA132Accident · Minor injuriesLimited investigationFinal reportAerotek Pitts S-2A · Reidsville, NCthe pilot failed to maintain control of the airplane while performing an acrobatic maneuver.NTSB SEA96LA081Accident · Minor injuriesLimited investigationFinal reportForth Acro 2 · Rock Springs, WYthe pilot's improper decision to attempt a takeoff from a road with gusting crosswinds, and his failure to adequately compensate for wind conditions during the takeoff. Factors contributing to the accident were gusts, crosswinds, and windshear.NTSB ANC96LA051Accident · Serious injuriesLimited investigationFinal reportCessna 206G · Whittier, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors in the accident were low ceilings and whiteout conditions.NTSB LAX96LA160Accident · No injuriesLimited investigationFinal reportSchweizer SGS1-34 · Inyokern, CAthe pilot misjudged altitude while maneuvering in mountainous terrain. Contributing factors were: the pilot's inadequate in-flight planning and the lack of available thermal lift over the rapidly rising rough terrain.NTSB LAX96LA156Accident · 1 fatalLimited investigationFinal reportTwibell Tangent 65 · Lucerne Valley, CAthe pilot's failure to maintain altitude. Factors in the accident were: the pilot's decision to buzz the area and his ostentatious display.NTSB ATL96FA074Accident · 2 fatalField investigationFinal reportCessna P210N · Marathon, FLfailure of the pilot to maintain sufficient altitude during an over-water approach at night. Factors relating to the accident were darkness and pilot fatigue.NTSB LAX96LA146Accident · Serious injuriesLimited investigationFinal reportLuckett Flybaby 1A · Castiac, CAThe pilot's improper in-flight planning/decision. The terrain condition and low ceiling were related factors.NTSB FTW96FA156Accident · Serious injuriesField investigationFinal reportThunder and Colt 180A · Hartsel, COThe pilot's selection of unsuitable terrain on which to make a landing. The rocky terrain was a related factor.NTSB CHI96LA115Accident · 1 fatalLimited investigationFinal reportCessna 182H · East Jordan, MIthe pilot's failure to maintain clearance with the terrain during the landing. Factors related to the accident were the snow covered ice pile at the end of the runway and the pilot's perception of the height of the pile.NTSB LAX96FA139Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Moreno Valley, CAVFR flight by the noninstrument-rated pilot into instrument meteorological conditions (IMC). The terrain and adverse weather conditions were related factors.NTSB ATL96LA057Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Cummings, GAthe pilot's abrupt retraction of the flaps and his failure to coordinate airspeed with flap retraction which resulted in the lack of airplane performance.NTSB MIA96FA089Accident · 2 fatalField investigationFinal reportCessna 172D · Hawthorne, FLthe pilot's failure to maintain the proper glidepath during an instrument approach.NTSB FTW96LA131Accident · No injuriesLimited investigationFinal reportRobinson R22B · Garland, TXFailure of the pilot to maintain sufficient altitude and tail rotor clearance from the terrain, while demonstrating rearward movement in a hover.NTSB MIA96LA086Accident · 1 fatalLimited investigationFinal reportNorth American SNJ-5 · West Palm Beach, FLFailure of the pilot to maintain adequate altitude/clearance above the water, while performing a low level maneuver (wing over). The pilot's ostentatious display of aerobatic flight was a related factor.NTSB MIA96LA085Accident · Minor injuriesLimited investigationFinal reportPiper PA-30-160 · St. Petersburg, FLthe pilot's failure to maintain the glide slope and becoming distracted by a passenger.NTSB LAX96FA115Accident · 3 fatalField investigationFinal reportCessna 172N · Julian, CAthe pilot's delay in requesting assistance to avoid high terrain. Factors were: the downdrafts, mountainous terrain, and the pilot's improper in-flight planning.NTSB LAX96FA114Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · New River, AZfailure of the pilot to maintain proper altitude/clearance above the terrain, while performing an aerobatic maneuver.NTSB MIA96LA175Accident · 1 fatalLimited investigationFinal reportPiper PA-60-601P · Atlantic Ocean (Atlantic Ocean)pilot incapacitation.NTSB SEA96LA054Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Ashland, ORthe dual student's improper touchdown, and the instructor's delayed remedial action. The crosswind was a related factor.NTSB FTW96FA136Accident · 2 fatalField investigationFinal reportMbb BO-105 · Gulf Of MexicoThe pilot's failure to maintain clearance from the ocean for unknown reasons.NTSB LAX96LA194Accident · No injuriesLimited investigationFinal reportBell 206B · Barstow, CAfailure of the pilot to maintain adequate terrain clearance, while maneuvering around a ground vehicle at low altitude.NTSB LAX96LA107Accident · No injuriesLimited investigationFinal reportCessna 177 · Corona, CAimproper planning/decision by the pilot-in-command (PIC), and his failure to ensure that adequate airspeed was obtain and/or maintain during lift-off/initial climb. A factor relating to the accident was: the PIC allowed the airplane's maximum gross weight…NTSB SEA96TA046Accident · Minor injuriesFinal reportChristen Industries A-1 · Lakeview, ORfailure of the pilot to maintain altitude/clearance from the terrain (snow covered, frozen lake). Factors relating to the accident were: the pilot's attention being diverted to a perceived safety hazard, and lack of visual cues for pilot perception of…NTSB MIA96LA074Accident · 1 fatalLimited investigationFinal reportYakovlev YAK-52 · Boynton Beach, FLPilot impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his failure to maintain sufficient altitude above the terrain while performing an aerobatic maneuver. Factors relating to the accident were: the pilot's…NTSB FTW96FA145Accident · 1 fatalField investigationFinal reportPiper PA-34-220T · Estes Park, CODescent into mountainous terrain for reasons undetermined.NTSB LAX96FA103Accident · 1 fatalField investigationFinal reportCessna 402B · Kamuela, HIfailure of the copilot (pilot-rated cargo loader, who was flying the aircraft) to establish and maintain a positive rate of climb after taking off at night; and inadequate supervision by the pilot-in-command (PIC), by failing to ensure that proper altitude…NTSB NYC96LA053Accident · Minor injuriesLimited investigationFinal reportMitsubishi MU-2B-6 · Allentown, PAthe pilot's failure to comply with IFR procedures in that he attempted an instrument approach with visibility below the required minimums, and his delayed execution of a missed approach. A factor was the reduced visibility due to clouds.NTSB NYC96LA051Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Auburn, METhe pilot's improper planning/decision and failure to attain proper alignment with the landing area. Factors relating to the accident were: darkness, and the inoperative radio transmitter, which precluded the pilot from activating the runway lights.NTSB NYC96LA050Accident · No injuriesLimited investigationFinal reportCessna 172M · Nashua, NHthe pilot's inadequate crosswind compensation during the go-around.NTSB NYC96LA044Accident · 1 fatalLimited investigationFinal reportCessna 182E · Pymatuning, PAthe pilot's intentional suicide.NTSB SEA96FA034Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Kapowsin, WAthe pilot's failure to maintain aircraft control and terrain clearance. Turbulence was a factor.NTSB LAX96FA249Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Death Valley, CAthe non-instrument rated pilot's intentional VFR flight into instrument meteorological conditions.NTSB LAX96FA078Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · San Jose, CAThe failure of the air traffic controller to comply with instructions contained in the Air Traffic Control Handbook, FAA Order 7110.65, which resulted in the flight being vectored at an altitude below the minimum vectoring altitude (MVA) and failure to issue…NTSB MIA96FA047Accident · 3 fatalField investigationFinal reportCessna 205 · Culebra, PRFailure of the pilot to maintain sufficient altitude/clearance above the terrain, while maneuvering at night. Factors relating to the accident were: darkness with no visible horizon, and the pilot's lack of recent experience in night flight.NTSB SEA96FA029Accident · 1 fatalField investigationFinal reportCessna 340A · Mead, WAthe pilot's failure to maintain terrain clearance in mountainous terrain. Factors contributing to the accident were: dark night conditions, mountainous terrain, and instrument meteorological conditions.NTSB FTW96LA070Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Pawnee, OKThe pilot's failure to maintain adequate clearance from the terrain.NTSB CHI96FA048Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Laupahoehoe, HIthe pilot falling asleep at the controls due to fatigue. Factors were: the pilot's inadequate preflight preparation and the dark night.NTSB BFO96LA029Accident · 1 fatalLimited investigationFinal reportCessna 150K · Seville, OHpilot suicide (intentional in-flight collision with terrain).NTSB BFO96FA027Accident · 2 fatalField investigationFinal reportGraichen Christen Eagle II · Malinta, OHfailure of the pilot to maintain proper altitude, while performing aerobatic maneuvers.NTSB SEA96FA024Accident · 2 fatalField investigationFinal reportBeech C24R · Bozeman, MTfailure of the pilot to follow the specified approach track (proper IFR procedure), and his associated failure to maintain altitude or clearance from mountainous terrain. Factors relating to the accident were: the pilot's failure to abide by the aircraft…NTSB SEA96FA022Accident · 1 fatalField investigationFinal reportCessna 152 · Provo, UTpilot suicide (intentional in-flight collision with rising terrain). A factor relating to the accident was: pilot anxiety/apprehension.NTSB BFO96FA022Accident · 3 fatalField investigationFinal reportBeech 58 · Cleveland, OHthe pilot's improper IFR procedure, by failing to maintain a positive rate of climb (and terrain clearance) after takeoff. Factors relating to the accident were: darkness, and the lack of visual references over water and under overcast cloud conditions.NTSB SEA96LA015Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Douglas, WAThe pilot fell asleep.NTSB LAX96FA045Accident · 2 fatalField investigationFinal reportBell 47D1 · Shafter, CAthe pilot misjudged the altitude and ground clearance while performing an unwarranted low altitude flight maneuver.NTSB CHI96LA031Accident · No injuriesLimited investigationFinal reportBeech 35 · Belleville, KSthe pilot misjudging his approach to the runway. Factors relating to the accident were: the weather conditions, a sick passenger that diverted the pilot's attention, the snow covered terrain, and the pilot's decision not to execute the missed approach…NTSB BFO96LA018Accident · No injuriesLimited investigationFinal reportBeech 35 · Phillipsburg, OHThe flight instructor's (CFI's) inadequate supervision of the flying pilot, and the flying pilot's abrupt handling of the airplane during an attempted go-around. Factors relating to the accident were: the flying pilot's lack of familiarity with light piston…NTSB ANC96LA012Accident · No injuriesLimited investigationFinal reportCessna 207 · Toksook Bay, AKThe pilot's inadequate planning/decision, improper use of the flaps, and inadequate removal of snow/frost from the wings of the airplane. An upsloping runway and snow conditions were factors in the accident.NTSB FTW96FA027Accident · 1 fatalField investigationFinal reportBeech 65-B80 · Paint Rock, TXThe pilot's impairment of judgment and performance due to alcohol which resulted in his improper decision to shutdown an engine, and his failure to maintain adequate airspeed for single-engine flight.