NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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 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 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 ANC89LA114Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Port Alsworth, AKA blocked fuel line between the fuel selector and the engine which caused fuel starvation.NTSB MKC89LA154Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Tunas, MOEngine failure due to fuel exhaustion because of improper flight planning by the pilot.NTSB MKC89LA152Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Excelsor Sprgs, MOThe catastrophic failure of the aircraft engine and the pilots failure to maintain directional control of the aircraft during the landing roll. Improper maintenance, the dark night conditions, and restricted visibility due to oil on the windscreen were…NTSB MKC89LA151Accident · Minor injuriesLimited investigationFinal reportPiper J3 "CUB" · Morrilton, ARThe abrupt handling of the airplane by the pilot. He failed to maintain airspeed and inadvertantly stalled and spun the airplane at an altitude insufficient for recovery.NTSB MKC89FA153Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Broken Bow, NEImproper planning/decision by the pilot by performing acrobatic flight with baggage in the rear cockpit of the aircraft, which probably restricted movement of the flight controls and resulted in uncontrolled flight and a spin.NTSB MIA89FA184Accident · 1 fatalField investigationFinal reportCessna 177 · Stuart, FLInadequate maintenance/servicing of the aircraft, which resulted in water and rust contamination of the fuel and a subsequent loss of engine power, and failure of the pilot to maintain flying speed, while maneuvering back toward the runway, which resulted in…NTSB LAX89DVG07Accident · No injuriesFinal reportSchweizer G-164B · Willows, CAFailure of the connecting rod on #1 cylinder of the aircraft powerplant.NTSB FTW89FA128Accident · 1 fatalField investigationFinal reportCessna P210N · Houma, LAIncapacitation of the 70 year old pilot, which led to the loss of control of the airplane.NTSB DEN89LA165Accident · Minor injuriesLimited investigationFinal reportHenry Vickers HCV-110 · Newcastle, WYThe failure to the magneto. The selection of a powerplant with a single magneto system was an improper choice and directly contributed to the cause. The pilot's misjudgement of the wind for the approach to a forced landing resulted in an improper ground…NTSB ATL89FA174Accident · 1 fatalField investigationFinal reportPiper PA-30 · Springfield, TNThe pilot's decision to continue flight into an area of known adverse weather which resulted in his ability to maintain control of the airplane. Contributing factor(s) was: the adverse weather conditions.NTSB SEA89FA126Accident · 3 fatalField investigationFinal reportPiper PA-22-150 · Elgin, ORFailure of the pilot to obtain/maintain adequate airspeed during takeoff/initial climb, which resulted in a stall. Factors related to the accident were: quartering tailwind, high density altitude, and the pilot's lack of recent experience in the aircraft.NTSB NYC89LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Plattsburgh, NYThe pilot's improper flare, improper recovery from a bounced landing, and failure to maintain directional control.NTSB MKC89LA150Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Jonesboro, ARThe pilot's encounter with unsuitable terrain during a forced landing made necessary by the separation of three feet of one of the propeller blades.NTSB MKC89LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Charles, MOAircraft control was not maintained by the pilot in command due to improper use of the flight controls in flaring the aircraft for landing and counteracting the effects of the cross-wind on the drifting aircraft.NTSB MKC89DER01Accident · 1 fatalFinal reportCessna T188C · Wannaska, MNThe pilot-in-command did not maintain airspeed, resulting in an inadvertent stall.NTSB MIA89LA183Accident · No injuriesLimited investigationFinal reportCessna 421B · Fort Lauderdale, FLImproper flare by the pilot. The light condition (dark night) was considered to be a contributing factor.NTSB FTW89LA126Accident · No injuriesLimited investigationFinal reportBeech 35 · Terrell, TXThe pilot's failure to maintain directional control. A factor related to the accident was: the pile of dirt (dirt bank) beside the runway.NTSB FTW89LA121Accident · No injuriesLimited investigationFinal reportBeech G35 · Roby, TXThe pilot's improper compensation for wind conditions & his failure to maintain directional control. Factors related to the accident were: the pilot's operation of the aircraft with a known deficiency (worn tire), the adverse wind conditions, and barrels…NTSB FTW89FA127Accident · 2 fatalField investigationFinal reportPiper PA-12 · Sanger, TXFailure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall at low altitude.NTSB DEN89LA157Accident · No injuriesLimited investigationFinal reportCessna 172M · Bicknell, UTFailure of the pilot to maintain adequate airspeed, which resulted in a stall. Factors related to the accident were: the pilot's selection of an unsuitable area (terrain) to land, unfavorable wind, & objects (fence & irrigation sprinkler).NTSB DEN89LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28RT-201T · Red Lodge, MTInadequate compensation for the wind conditions during landing roll, resulting in a loss of control. Contributing to the accident was the gusty wind condition.NTSB CHI89LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Gladwin, MIFailure of the pilot seated in the left seat of the airplane to use brakes to correct for a left turn caused by a bent tail wheel.NTSB CHI89DEP06Accident · Minor injuriesFinal reportAeronca 15AC · Fort Atkinson, WIWater contamination of the fuel and the pilot's inadequate preflight. Factors related to the accident were: lack of suitable terrain for a forced landing & trees.NTSB NYC89LA160Accident · No injuriesLimited investigationFinal reportCessna 152 · Oneida, NYLoss of directional control during landing due to wind change. The aircraft landed hard on the runway due to improper flare by the pilot and a delayed response to the ballooning of the acft.NTSB NYC89LA156Accident · No injuriesLimited investigationFinal reportCessna 185 · Fishers, NYLoss of control during an aborted takeoff due to improper float operation aborted takeoff procedure on terra firma, as opposed to the more logical environment of water, the intended element for the design hardware.NTSB NYC89LA155Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Gasport, NYFuel contamination (water) and an inadequate preflight by the pilot, which resulted in the loss of engine power.NTSB MKC89LA148Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Stockville, NETotal failure of the powerplant caused by a broken cylinder.NTSB MIA89LA182Accident · No injuriesLimited investigationFinal reportCessna T188C · Hollandale, MSThe failure of the turbocharger due to an improperly installed retaining nut. The soft/wet terrain was a contributing factor.NTSB MIA89FA181Accident · 1 fatalField investigationFinal reportWood-Oldfield Baby Great Lakes · Clermont, FLFailure of the pilot to maintain airspeed which resulted in an inadvertent stall/spin. A contributing factor was the pilot's lack of experience in the aircraft.NTSB LAX89LA228Accident · No injuriesLimited investigationFinal reportCessna 150 · Kelseyville, CAInadequate preflight planning/preparations and the improper fuel consumption calculations by the pilot.NTSB LAX89DVM04Accident · Serious injuriesFinal reportProgress Aero R&D Discovery · Chualar, CAThe experimental aircraft's inadvertent entry into a non-recoverable flat spin during a slow airspeed test; the aerodynamic characteristics that produced the spin were not determined.NTSB FTW89LA129Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Elmendorf, TXPilot's decision to discontinue the use of carburetor heat, in carburetor icing conditions, that led to a complete loss of power at an altitude insufficient for a safe landing on the airport.NTSB FTW89LA125Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Bulverde, TXFailure of the pilot to obtain and/or maintain sufficient airspeed to climb after takeoff and his delay in aborting the takeoff. A contributing factor was the rough/uneven terrain.NTSB FTW89LA120Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Austin, TXThe pilot's improper inflight planning/decision, which resulted in a situation where he was unable to maintain adequate rotor RPM. Factors related to the accident were: high temperature, tailwind, and trees.NTSB DEN89LA153Accident · No injuriesLimited investigationFinal reportStitts SA7D · Evanston, WYImproper compensation by the pilot for wind conditions. Contributing factors were: high density altitude, unfavorable wind, and downdraft.NTSB DEN89LA151Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Ennis, MTThe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall.NTSB DEN89FA152Accident · 1 fatalField investigationFinal reportBeech E33 · Angel Fire, NMImproper planning/decision by the pilot, his premature rotation for takeoff and subsequent failure to obtain or maintain sufficient speed to climb, and his failure to abort the takeoff (while there was sufficient rwy remaining). Contributing factors were: the…NTSB DEN89DTI02Accident · 1 fatalFinal reportMusick/Terratorn Tierra II · Lewistown, MTThe unqualified pilot allowed the aircraft to become airborne while taxiing at high speed, he failed to maintain control of the aircraft, and he inadvertently allowed it to enter a stall/spin and crashed. Factors related to the accident were: his failure to…NTSB CHI89LA125Accident · No injuriesLimited investigationFinal reportAerofab Lake LA 4-200 · Oshkosh, WIThe pilot's encounter with unsuitable terrain (rough water) and his inability to maintain directional control.NTSB CHI89LA123Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Tecumseh, MILoss of engine power for an undetermined reason. The embankment (dirt bank) was a contributing factor.NTSB CHI89FA124Accident · 1 fatalField investigationFinal reportCessna 150L · Sugar Grove, ILFailure to maintain airspeed above stall speed, and a stall/spin encountered with inadequate altitude for recovery. Factors related to the accident were: thunderstorm, pre-flight briefing not obtained and poor weather evaluation by the pilot.NTSB BFO89LA049Accident · No injuriesLimited investigationFinal reportBell 47J · Fruitland, MDPoor judgement of the pilot by flying, while physically impaired by alcohol, and his misjudgement of clearance between the helicopter and the structure. The dark night and object (structure) were considered to be contributing factors.NTSB NYC89LA154Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Middletown, RIThe failure of both magnetos shortly after takeoff. .NTSB NYC89LA153Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Newport, METhe aircraft fuel supply was contaminated by water and the pilot's inadequate preflight.NTSB NYC89LA152Accident · Minor injuriesLimited investigationFinal reportSchweizer 1-26 · Elmira, NYAn inadvertent encounter with a downdraft.NTSB MKC89FA159Accident · 6 fatalField investigationFinal reportCessna U206 · Pettigrew, ARImproper planning/decision by the pilot, his VFR flight into instrument meteorological conditions (IMC), and his loss of aircraft control due to spatial disorientation. Factors related the accident were: the adverse weather conditions, high terrain, the…NTSB MIA89WA180Accident · Serious injuriesForeign investigationCessna 310R · Rum Cay, BahamasNTSB LAX89DVG08Accident · No injuriesFinal reportHomebuilt BG 12 B-D · Montague, CAPilot misjudged the airplane's altitude and failed to extend the spoilers.NTSB FTW89LA124Accident · No injuriesLimited investigationFinal reportAero Commander Lark 100-180 · Gonzales, TXFailure of the aircraft engine, for undetermined reasons, during a low altitude maneuver.NTSB FTW89LA123Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Port Aransas, TXThe collapse of the taxiway, which was inadequately maintained.