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 CHI89LA186Accident · No injuriesLimited investigationFinal reportCessna 172 · Ypsilanti, MIThe failure of the plt to maintain directional control during the takeoff ground roll. Rain softened terrain adjacent to the runway surface is a contributing factor to the accident.Sep 17, 1989 · N736HC · Substantial damageNTSB CHI89LA185Accident · No injuriesLimited investigationFinal reportCessna C172R · Frankenmuth, MIThe pilot's failure to maintain control of the aircraft during takeoff as a result of a diversion of attention due to a possible engine problem.Sep 17, 1989 · N23666 · Substantial damageNTSB BFO89LA080Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Haymarket, VAImproper use of the fuel selector, which resulted in fuel starvation & loss of engine power; and improper use of emergency procedures after loss of engine power. The presence of high obstructions (trees) in the approach path to the emergency landing area was…Sep 17, 1989 · N40892 · DestroyedNTSB ATL89LA215Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Semmes, ALImproper replacement of the fuel cap gasket by the pilot, which resulted in a blocked fuel cap vent and fuel starvation. Trees in the emergency landing area contributed to aircraft damage.Sep 17, 1989 · N83732 · Substantial damageNTSB ATL89FA214Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Gordon, ALThe improper installation of the fuel gascolator bowl by maintenance personnel, which resulted in fuel leakage and a loss of fuel pressure to the engine.Sep 17, 1989 · N7503J · Substantial damageNTSB MIA89LA251Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Yulee, FLImproper planning/decision by the student pilot. Factors related to the accident were: the adverse weather conditions and the tree and ditch in the emergency landing area.Sep 16, 1989 · N67785 · Substantial damageNTSB LAX89FA304Accident · 2 fatalField investigationFinal reportRockwell 112B · La Grange, CAContinued VFR flight into instrument meteorlogical conditions (IMC) by the pilot, which resulted in spatial disorientation and loss of aircraft control. Related factors were: flight into known adverse weather by the pilot, the adverse weather conditions, and…Sep 16, 1989 · N1232J · DestroyedNTSB FTW89WA175Accident · No injuriesForeign investigationBell 206L-1 · Molongo, AngolaSep 16, 1989 · N3904L · Substantial damageNTSB FTW89FA166Accident · Serious injuriesField investigationFinal reportBeech BE 100 · Houston, TXThe inadequate preflight planning preparation & the improper inflight planning/decision by the PIC when he failed to refuel the aircraft which resulted in a total loss of power in both engines.Sep 16, 1989 · N204AJ · DestroyedNTSB FTW89DRG10Accident · 1 fatalFinal reportZenair CH-200 · Kerrville, TXImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.Sep 16, 1989 · N14LU · DestroyedNTSB DEN89LA210Accident · 1 fatalLimited investigationFinal reportLet L-13 · Buena Vista, COA premature release of the glider tow line by the glider pilot and his failure to maintain sufficient airspeed, while maneuvering back toward the runway, which resulted in an inadvertent stall.Sep 16, 1989 · N3458 · Substantial damageNTSB CHI89LA187Accident · No injuriesLimited investigationFinal reportCessna 120 · Shelbyville, INThe pilot failed to maintain proper alignment during the landing roll.Sep 16, 1989 · N1844N · Substantial damageNTSB ATL89FA213Accident · 6 fatalField investigationFinal reportBeech 100 · Mayfield, KYFailure of the pilot to follow IFR procedures and maintain the minimum descent altitude (mda). Factors related to the accident were: darkness, the adverse weather conditions, and the tree.Sep 16, 1989 · N887PE · DestroyedNTSB SEA89LA173Accident · 1 fatalLimited investigationFinal reportMiller Special JM-2 · Reno, NVStructural failure when design stress limits were exceeded after encountering hazardous meteorological conditions.Sep 15, 1989 · N74M · DestroyedNTSB MKC89LA183Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Barnesville, MNThe pilot's failure to insure that the aircraft contained an adequate fuel supply to complete the flight.Sep 15, 1989 · N3610L · Substantial damageNTSB MIA89LA250Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fernandina Bch, FLThe private pilot's failure to maintain airspeed on final approach, which resulted in a stall/mush. The turbulence was a related factor.Sep 15, 1989 · N91344 · Substantial damageNTSB LAX89FA314Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Ontario, CAFailure of the right propeller hub due to metal fatigue which resulted in catastrophic separation of the propeller. Contributing to the accident was damage done to the aircraft airframe in flight by the separating propeller making the aircraft uncontrollable.Sep 15, 1989 · N70PE · DestroyedNTSB FTW89IA168Incident · No injuriesIncident investigationFinal reportCessna 152 · Bethany, OKFailure of the Cessna 150 pilot to see-and-avoid the Cessna 152 (inadequate visual lookout), and failure of the tower controller to provide adequate service. Factors related to the accident were: high traffic density, which resulted in frequency congestion,…Sep 15, 1989 · N94808 · 2 aircraft · Minor damageNTSB DEN89FA217Accident · 3 fatalField investigationFinal reportPiper PA-31T2 · Louisville, COFailure of the pilot to maintain adequate airspeed, while maneuvering for spacing in the traffic pattern, which resulted in an inadvertent stall at low altitude.Sep 15, 1989 · N63XL · DestroyedNTSB CHI89LA184Accident · No injuriesLimited investigationFinal reportDouglas DC-3A · Columbus, INThe co-pilot's failure to relinquish control of the aircraft to the pilot-in-command after encountering directional control difficulties during roll-out, and excessive braking by the co-pilot.Sep 15, 1989 · N143JR · Substantial damageNTSB ATL89LA212Accident · No injuriesLimited investigationFinal reportSikorsky H-34J · Louisville, GAAn undetermined malfunction of the main rotor drive system.Sep 15, 1989 · N4556D · DestroyedNTSB ANC89LA165Accident · No injuriesLimited investigationFinal reportCessna U206 · Nondalton, AKFailure of the pilot to attain the proper touchdown point for the landing, his excessive airspeed, and his misjudgement of runway distance remaining. Factors related to the accident were: loose/wet gravel on the runway and the location of the parked aircraft…Sep 15, 1989 · N756NG · Substantial damageNTSB SEA89LA172Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · Hillsboro, ORThe pilot misjudging altitude and airspeed.Sep 14, 1989 · N358JS · Substantial damageNTSB LAX89LA312Accident · No injuriesLimited investigationFinal reportCessna 152 · Santa Paula, CAImproper in-flight planning/decision by the student pilot. Contributing factors were the parked aircraft, hangar, and the student pilot's lack of total experience.Sep 14, 1989 · N49697 · Substantial damageNTSB LAX89DUJ10Accident · Serious injuriesFinal reportAyres S-2R · Yuma, AZThe failure of the pilot to maintain directional control after landing on a dry gravel runway.Sep 14, 1989 · N4977X · Substantial damageNTSB DEN89LA216Accident · No injuriesLimited investigationFinal reportCessna 172N · Provo, UTThe pilot failed to maintain the proper glidepath during a practice instrument approach resulting in a collision with terrain. Contributing factor(s) was: the dark night light condition.Sep 14, 1989 · N75815 · Substantial damageNTSB CHI89TL#05Accident · No injuriesClass 3Final reportBeech D45 (T-34B) · Gaylord, MISep 14, 1989 · N10NR · Substantial damageNTSB ANC89LA164Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Stony River, AKPilot's failure to ensure that his landing area was properly clear prior to landing.Sep 14, 1989 · N62RT · Substantial damageNTSB MIA89IA249Incident · No injuriesIncident investigationFinal reportPiper PA-28-161 · Fort Pierce, FLThe student's failure to maintain directional control of the airplane. Contributing to the accident was the student's lack of experience.Sep 13, 1989 · N9207Q · Minor damageNTSB MIA89IA248Incident · No injuriesIncident investigationFinal reportBoeing 757-232 · Fort Lauderdale, FLImproper use of the elevator control.Sep 13, 1989 · N629DL · Minor damageNTSB MIA89IA247Incident · No injuriesIncident investigationFinal reportBeech G18S · Jackson, MSFailure of the pilot to correctly perform the emergency gear extension procedures. Contributing to the accident was the failure of the normal gear extension system.Sep 13, 1989 · N9604R · Minor damageNTSB LAX89FA311Accident · Serious injuriesField investigationFinal reportCessna 152 · Buena Park, CAAn inadequate performed preflight inspection by the dual student and the inadequate supervision of the dual student by the instructor pilot. Contaminated fuel was a factor in the accident.Sep 13, 1989 · N25776 · DestroyedNTSB LAX89DVA10Accident · No injuriesFinal reportAir Tractor AT-301 · Mendota, CAA loss of aircraft control by the pilot when he slowed the aircraft to begin a spray run. Contributing to the loss of control was the inoperative stall warning system.Sep 13, 1989 · N8578S · Substantial damageNTSB MIA89LA246Accident · No injuriesLimited investigationFinal reportCessna 150G · Marathon, FLThe pilot's misjudgement of clearance between his aircraft and the parked aircraft. Factors related to the accident were: sunglare and the location of the parked aircraft.Sep 12, 1989 · N3220J · Substantial damageNTSB DEN89LA214Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A-150 · Winston, NMDeteriorated carburetor float. Factors related to the accident were: high density altitude and the terrain conditions in the emergency landing area.Sep 12, 1989 · N9496D · DestroyedNTSB CHI89FA183Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas MD-80 · Chicago, ILA loss of hydraulic system pressure due to the operator's failure to replace a system component that had a known history of failures, and the pilot's improper use powerplant controls resulting in a degradation of rudder effectiveness. A contributing factor…Sep 12, 1989 · N244AA · Substantial damageNTSB ANC89LA162Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Trading Bay, AKThe pilot selected unsuitable terrain for his intended landing area. Wet terrain/hydroplaning conditions in the initial touchdown area and an object (stump) contributed to the occurrence.Sep 12, 1989 · N3680Z · Substantial damageNTSB SEA89LA171Accident · Minor injuriesLimited investigationFinal reportYakovlev YAK 11 · Reno, NVThe right main landing gear did not fully extend for an undetermined reason. Factors that contributed to the accident were: an engine power loss for unknown reasons and the rough terrain.Sep 11, 1989 · N134JK · Substantial damageNTSB SEA89LA169Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellensburg, WAThe pilot's failure to obtain current in-flight wind information in order to calculate that his remaining fuel supply was adequate to reach his final destination. Contributing was his inadequate preflight planning.Sep 11, 1989 · N25228 · Substantial damageNTSB MKC89FA196Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Bentonville, ARA loose oil line that became disconnected, when maintenance/inspection of the aircraft had not been completed, which resulted in loss of engine oil and subsequent failure of the connecting rod from lack of lubrication. A factor related to the accident was:…Sep 11, 1989 · N8995N · DestroyedNTSB LAX89LA308Accident · No injuriesLimited investigationFinal reportCessna 152 · Torrance, CAThe pilot's failure to maintain directional control during landing roll-out, which resulted a ground swerve. The pilot's relatively low level of flying experience and the berm beside the runway were related factors.Sep 11, 1989 · N95554 · Substantial damageNTSB LAX89FA307Accident · 1 fatalField investigationFinal reportAero Commander 680FLP · Kailua-Kona, HIInadequate maintenance, and operation by the pilot with known deficiencies in the aircraft. Factors related to the accident were: excessive wear in both engines, improper use of powerplant controls by the pilot, subsequent overtemperature/detonation in both…Sep 11, 1989 · N22LR · DestroyedNTSB FTW89LA164Accident · No injuriesLimited investigationFinal reportCessna 140A · Austin, TXThe pilot's failure to maintain directional control of the aidrcraft. The gusty crosswind condition was a related factor.Sep 11, 1989 · N9687A · Substantial damageNTSB CHI89LA182Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Newark, ILInadequate supervision by the flight instructor (CFI) and his delay in aborting the takeoff. Factors related to the accident were: malfunction of the flap system, which resulted in an improper flap setting for takeoff, and the soft runway condition.Sep 11, 1989 · N4841P · Substantial damageNTSB ANC89LA166Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Circle City, AKPilot failed to maintain directional during the landing roll.Sep 11, 1989 · N339T · Substantial damageNTSB ANC89LA163Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wood River, AKInnadequate preflight planning/preparation by the pilot. The wind conditions, high density altitude and trees were contributing factors.Sep 11, 1989 · N4099E · Substantial damageNTSB SEA89LA168Accident · No injuriesLimited investigationFinal reportCessna R182 · Jordan Valley, ORFailure of the pilot to maintain directional control. Factors related to the accident were: the pilot's selection of unsuitable terrain (closed/rough runway), and the crosswind.Sep 10, 1989 · N4934S · Substantial damageNTSB NYC89DHM05Accident · Minor injuriesFinal reportWoods Formula VEE SL-1 · Allaire Airport, NJThe improper flare and touchdown by the pilot in command while making a forced landing following loss of engine power.Sep 10, 1989 · N31549 · Substantial damageNTSB MIA89LA245Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLInadequate visual lookout by the Waco pilot, which resulted in his misjudgement of clearance between his aircraft and the Cessna 172 and a subsequent collision.Sep 10, 1989 · N32133 · 2 aircraft · Minor damageNTSB MIA89LA244Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Titusville, FLFailure of the private pilot (dual student) to assure the fuel selector was positioned to the proper tank, which resulted in fuel starvation; and inadequate supervision by the instructor pilot (CFI). The trees were a related factor.Sep 10, 1989 · N7946P · Substantial damage