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.

NTSB ANC89LA114Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Port Alsworth, AKA blocked fuel line between the fuel selector and the engine which caused fuel starvation.Jul 5, 1989 · N1512C · Substantial damageNTSB MKC89LA154Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Tunas, MOEngine failure due to fuel exhaustion because of improper flight planning by the pilot.Jul 4, 1989 · N757EJ · Substantial damageNTSB 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…Jul 4, 1989 · N4175R · Substantial damageNTSB 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.Jul 4, 1989 · N1414N · Substantial damageNTSB 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.Jul 4, 1989 · N8636V · DestroyedNTSB 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…Jul 4, 1989 · N2923X · Substantial damageNTSB LAX89DVG07Accident · No injuriesFinal reportSchweizer G-164B · Willows, CAFailure of the connecting rod on #1 cylinder of the aircraft powerplant.Jul 4, 1989 · N3627G · Substantial damageNTSB FTW89FA128Accident · 1 fatalField investigationFinal reportCessna P210N · Houma, LAIncapacitation of the 70 year old pilot, which led to the loss of control of the airplane.Jul 4, 1989 · N5489W · DestroyedNTSB 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…Jul 4, 1989 · N4831N · Substantial damageNTSB 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.Jul 4, 1989 · N7554Y · DestroyedNTSB 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.Jul 3, 1989 · N6941B · DestroyedNTSB NYC89LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Plattsburgh, NYThe pilot's improper flare, improper recovery from a bounced landing, and failure to maintain directional control.Jul 3, 1989 · N48683 · Substantial damageNTSB 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.Jul 3, 1989 · N8976Q · DestroyedNTSB 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.Jul 3, 1989 · N49554 · Substantial damageNTSB MKC89DER01Accident · 1 fatalFinal reportCessna T188C · Wannaska, MNThe pilot-in-command did not maintain airspeed, resulting in an inadvertent stall.Jul 3, 1989 · N9438J · Substantial damageNTSB 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.Jul 3, 1989 · N149RT · Substantial damageNTSB 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.Jul 3, 1989 · N2946V · Substantial damageNTSB 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…Jul 3, 1989 · N4613D · Substantial damageNTSB 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.Jul 3, 1989 · N3353M · DestroyedNTSB 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).Jul 3, 1989 · N9560H · Substantial damageNTSB 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.Jul 3, 1989 · N4391A · Substantial damageNTSB 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.Jul 3, 1989 · N7093K · Substantial damageNTSB 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.Jul 3, 1989 · N1271H · Substantial damageNTSB 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.Jul 2, 1989 · N4953B · Substantial damageNTSB 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.Jul 2, 1989 · N1731R · Substantial damageNTSB 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.Jul 2, 1989 · N5266T · DestroyedNTSB MKC89LA148Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Stockville, NETotal failure of the powerplant caused by a broken cylinder.Jul 2, 1989 · N6629Q · Substantial damageNTSB 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.Jul 2, 1989 · N3775J · Substantial damageNTSB 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.Jul 2, 1989 · N2039 · DestroyedNTSB LAX89LA228Accident · No injuriesLimited investigationFinal reportCessna 150 · Kelseyville, CAInadequate preflight planning/preparations and the improper fuel consumption calculations by the pilot.Jul 2, 1989 · N5712E · Substantial damageNTSB 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.Jul 2, 1989 · N81D · Substantial damageNTSB 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.Jul 2, 1989 · N5827B · Substantial damageNTSB 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.Jul 2, 1989 · N15558 · Substantial damageNTSB 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.Jul 2, 1989 · N888CG · DestroyedNTSB 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.Jul 2, 1989 · N1113E · Substantial damageNTSB DEN89LA151Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Ennis, MTThe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall.Jul 2, 1989 · N3246H · Substantial damageNTSB 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…Jul 2, 1989 · N20CF · DestroyedNTSB 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…Jul 2, 1989 · N349SM · DestroyedNTSB 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.Jul 2, 1989 · N65717 · Substantial damageNTSB CHI89LA123Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Tecumseh, MILoss of engine power for an undetermined reason. The embankment (dirt bank) was a contributing factor.Jul 2, 1989 · N3939D · Substantial damageNTSB 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.Jul 2, 1989 · N16004 · DestroyedNTSB 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.Jul 2, 1989 · N6760D · Substantial damageNTSB NYC89LA154Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Middletown, RIThe failure of both magnetos shortly after takeoff. .Jul 1, 1989 · N5029S · Substantial damageNTSB NYC89LA153Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Newport, METhe aircraft fuel supply was contaminated by water and the pilot's inadequate preflight.Jul 1, 1989 · N43562 · Substantial damageNTSB NYC89LA152Accident · Minor injuriesLimited investigationFinal reportSchweizer 1-26 · Elmira, NYAn inadvertent encounter with a downdraft.Jul 1, 1989 · N2746H · Substantial damageNTSB 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…Jul 1, 1989 · N5304U · DestroyedNTSB MIA89WA180Accident · Serious injuriesForeign investigationCessna 310R · Rum Cay, BahamasJul 1, 1989 · N4985Y · DestroyedNTSB LAX89DVG08Accident · No injuriesFinal reportHomebuilt BG 12 B-D · Montague, CAPilot misjudged the airplane's altitude and failed to extend the spoilers.Jul 1, 1989 · N124HH · Substantial damageNTSB FTW89LA124Accident · No injuriesLimited investigationFinal reportAero Commander Lark 100-180 · Gonzales, TXFailure of the aircraft engine, for undetermined reasons, during a low altitude maneuver.Jul 1, 1989 · N3634X · Substantial damageNTSB FTW89LA123Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Port Aransas, TXThe collapse of the taxiway, which was inadequately maintained.Jul 1, 1989 · N15250 · Substantial damage