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 LAX90FA300Accident · 4 fatalField investigationFinal reportCessna T-210-M · Placerville, CAThe pilot's misidentification of the airport and his failure to select an adequate altitude above the terrain. Factors in the accident were the pilot's disregard for his night time medical limitation and lack of geographic familiarity with the area.NTSB FTW90DQG04Accident · 1 fatalFinal reportPiper PA-25-235 · Lubbock, TXFailure of the pilot to maintain adequate airspeed and altitude during a turn-around maneuver, which resulted in the aircraft stalling into the ground.NTSB CHI90FA239Accident · 1 fatalField investigationFinal reportChampion 7GCAA · Clark Lake, MIPoor judgement of the pilot due to consumption of alcohol, and his failure to maintain proper altitude and clearance above water, while performing aerobatic maneuvers.NTSB FTW90DPG11Accident · No injuriesFinal reportAir Tractor AT401 · Altheimer, ARThe pilot's failure to align the airplane with the runway during landing.NTSB FTW90DPG10Accident · No injuriesFinal reportCessna 188A · Hunter, ARThe pilot's failure to maintain proper clearance above the crops.NTSB DEN90DTE06Accident · Serious injuriesFinal reportCessna 188A · Holyoke, COA stall mush which occurred when the pilot retracted the flaps prematurely following takeoff, causing the aircraft to settle into the ground.NTSB DEN90DTE05Accident · No injuriesFinal reportCessna 188B · Eckley, COA failure on the part of the pilot in command to maintain adequate terrain clearance.NTSB CHI90FA236Accident · 7 fatalField investigationFinal reportPiper PA-32R-300 · Watertown, WIInitiation of VFR flight into adverse weather and instrument meteorologial conditions. Factors which contributed to the accident were the adverse weather conditions and the pilot's self-induced pressure to maintain currency.NTSB CHI90FA235Accident · 1 fatalField investigationFinal reportCessna 180 · Howell, MIThe pilot's failure to maintain adequate clearance above terrain while maneuvering during takeoff. A factor in the accident was the pilot's attempt to display the aircraft's performance.NTSB DEN90LA171Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Silver City, NMThe pilot's improper planning which resulted in a flight in conditions which exceeded the performance capability of the aircraft. The high density altitude was a factor.NTSB NYC90FA192Accident · 1 fatalField investigationFinal reportBellanca 7GCAA · Saltaire, NYThe pilot misjudged his altitude.NTSB CHI90FAMS3Accident · 2 fatalMissing aircraftFinal reportCessna 172M · Kewaunee, WIUndetermined.NTSB SEA90LA157Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Ellensburg, WAThe pilot did not adequately level off the helicopter and collided with the terrain.NTSB CHI90DEM08Accident · 2 fatalFinal reportCessna 150L · Holland, MIUndetermined. Factors related to the accident were: darkness & impairment of the pilot due to carbon monoxide.NTSB FTW90DPG07Accident · No injuriesFinal reportSchweizer G-164B · Sherrill, ARPremature lift off and subsequent stall.NTSB CHI90DEM07Accident · 1 fatalFinal reportPitts SA-1 · East Jordan, MIThe pilot-in-command's failure to maintain altitude during low altitude aerobatics.NTSB FTW90DPG04Accident · No injuriesFinal reportAir Tractor 301A · Foreman, ARThe pilot's inadvertent stall/mush.NTSB SEA90LA147Accident · Minor injuriesLimited investigationFinal reportLake LA-250 · Rawlins, WYPilot's improper planning/decision, and his misjudgement of the aircraft's climb capability in conditions of high density altitude and unanticipated atmospheric conditions. The high density altitude and rising terrain were related factors.NTSB FTW90DRD14Accident · 1 fatalFinal reportGrumman G-164A · Sommerset, LAThe pilot's failure to attain adequate clearance above crops at the end of the runway.NTSB SEA90LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Island Park, IDImproper planning/decision by the pilot. The high density altitude and the pilot's overconfidence in the aircraft's ability were related factors.NTSB CHI90DER02Accident · 2 fatalFinal reportNorth American P-51D · Mayer, MNUndeterminedNTSB MKC90LA148Accident · Minor injuriesLimited investigationFinal reportPiper PA28-151 · Columbia, MOAircraft control not maintained resulting in a stall/mush by the PIC.NTSB DEN90LA156Accident · No injuriesLimited investigationFinal reportCessna 188 · Michigan, NDThe failure of the pilot to maintain proper alignment during landing.NTSB ANC90LA112Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Coldfoot, AKThe airplane encountered a downdraft shortly after takeoff from which the airplane could not overcome with power. Contributing to the accident was the heavily loaded airplane and the engine not developing full power due to improper maintenance.NTSB LAX90FA244Accident · 1 fatalField investigationFinal reportCessna 172N · Avalon, CAThe pilot's improper in-flight planning, decision, and his intentional low flying near mountainous terrain. Contributing factors related to the pilot's not maintaining/following proper VFR procedures, the related distraction of the open cabin door, and the…NTSB SEA90FA122Accident · 5 fatalField investigationFinal reportCessna T210L · Ashford, WAThe pilot's continuation of VFR flight into instrument meteorological conditions.NTSB FTW90DRG04Accident · No injuriesFinal reportAir Tractor AT-301 · Mission, TXThe pilot's failure to maintain proper clearance above the crops he was spraying. A factor was the tree induced mechanical turbulence encountered during the descending turn.NTSB MKC90LA138Accident · No injuriesLimited investigationFinal reportHiller 12-E · Watson, MNPilot misjudged his flare and collided with the terrain.NTSB ANC90FA101Accident · 5 fatalField investigationFinal reportCessna 207A · Aialak Bay, AKThe pilot-in-command's attempt to fly under visual flight rules while in instrument meteorological conditions. Contributing factors to the accident were the low ceiling and surrounding mountainous terrain.NTSB CHI90LA158Accident · No injuriesLimited investigationFinal reportCessna 310 · Moraine, OHThe pilot-in-command's failure to maintain adequate ground clearance during his approach to landing. Contributing factors were reduced visibility in fog and rain.NTSB SEA90LA105Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Jerome, IDThe pilot did not maintain a proper altitude while maneuvering to reverse direction.NTSB NYC90FA135Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Greenville, MEFailure of the pilot to maintain the proper altitude, while searching for the destination airport at night. Factors related to the accident were: darkness, fog obscuring the destination airport lights, mountainous terrain, and the lack of visual perception at…NTSB FTW90FA120Accident · 1 fatalField investigationFinal reportSukhoi SU-26MX · Oklahoma City, OKFailure of the pilot to recover from the aerobatic maneuver and subsequent stall/spin, due to inadequate altitude. Fatigue may have been a related factor.NTSB FTW90DPA06Accident · No injuriesFinal reportPiper PA-25-260 · Rosebud, TXInadvertent stall/mush. A factor was: premature rotation.NTSB CHI90DEM04Accident · 1 fatalFinal reportVanek 300 · Vriesland, MIThe pilot's misjudgment of the altitude. A factor related to the accident was the low ceiling.NTSB CHI90LA153Accident · No injuriesLimited investigationFinal reportCessna 172 · Millersburg, OHFailure of the pilot to maintain directional control during a go-around attempt. The pilots lack of total aviation experience and his motion sickness are factors associated with the accident.NTSB LAX90FA219Accident · 1 fatalField investigationFinal reportAerotek Pitts S2A · Thermal, CAThe pilot's inadequate handling of the airplane during an aerobatic maneuver.NTSB SEA90FA098Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Susanville, CAAn improper inflight decision on the part of the pilot when he misjudged the aircraft's climb in close proximity to rising terrain.NTSB LAX90FA211Accident · 1 fatalField investigationFinal reportBeech 35-33 · Paso Robles, CAUndetermined.NTSB LAX90LA158Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Phoenix, AZThe pilot failed to maintain control of the airplane.NTSB ATL90DKG04Accident · No injuriesFinal reportAir Command 532 · Rome, GAThe pilot attempted a flat spiraling spin maneuver at an altitude that was too low to effect a safe recovery.NTSB DCA90MA030Accident · Serious injuriesClass 1 · MajorFinal reportBoeing 737-2X6C · Unalakleet, AKDeficiencies in flightcrew coordination, their failure to adequately prepare for and properly execute the unk LOC rwy 14 nonprecision approach and their subsequent premature descent.NTSB FTW90LA112Accident · No injuriesLimited investigationFinal reportMooney M-20F · Aledo, TXInadequate preflight planning/preparation, in as much as the performance data was not used by the pilot in command. Factors were the high density altitude, inadequate airspeed, and premature liftoff.NTSB BFO90FA050Accident · 4 fatalField investigationFinal reportRockwell 114 · Anawalt, WVFailure of the pilot to maintain proper altitude and clearance above the terrain. Factors related to the accident were: darkness, mountainous terrain, and low ceiling.NTSB CHI90LA138Accident · No injuriesLimited investigationFinal reportCessna 152 · Bad Axe, MIFailure of the pilot to abort the takeoff with sufficient runway to stop the aircraft. Contributing to the accident is a lack of total flying experience.NTSB LAX90LA182Accident · 2 fatalLimited investigationFinal reportCessna 150H · Goleta, CAThe pilot's failure to maintain control of the airplane. Factors which contributed to the accident were the dark night and the pilot's lack of night flying experience.NTSB NYC90GA105Accident · 4 fatalFinal reportBellanca 17-31A · Davis Park, NYThe airplane impacting the water at a high speed for unknown reason(s).NTSB DEN90LA108Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Powderville, MTPilot failed to maintain terrain clearance during descent on an aerial application swath run, resulting in an in flight collision with the terrain. That the pilot misjudged the pull up altitude is considered a contributing factor.NTSB NYC90LA103Accident · No injuriesLimited investigationFinal reportRobinson R22 · Millville, NJThe student pilot's improper use of the flight controls, and inadequate supervision of the flight by the instructor (CFI). Contributing to the accident was the lack of total time and experience of both the student and instructor.NTSB FTW90DPA03Accident · No injuriesFinal reportBell-Moore 47G-2A · Sivell Bend, TXClearance was not maintained by the pilot-in-command.