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 ANC91LA057Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Dillingham, AKCarburetor icing and the pilot's failure to follow proper procedures and directives pertaining to carburetor heat.May 9, 1991 · N83582 · Substantial damageNTSB LAX91LA206Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Redding, CAThat the pilot failed to brief the passenger and the passengers intentional control interference.May 8, 1991 · N140ED · Substantial damageNTSB FTW91DRA01Accident · No injuriesFinal reportRockwell S2R-600 · Beaumont, TXThe failure of the engine for undetermined reasons. Factors were the lack of suitable terrain for a forced landing and the rough terrain that was encountered.May 8, 1991 · N4228X · Substantial damageNTSB SEA91FA099Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Ravensdale, WAThe in-flight breakup of the airplane as a result of the pilot exceeding the speed and stress limits for the airplane. A factor relating to the accident was the center of gravity loading that exceeded the aft limits.May 7, 1991 · N2859M · DestroyedNTSB NYC91LA127Accident · No injuriesLimited investigationFinal reportCessna 414A · Piqua, OHThe pilot's incomplete preflight of the fuel quantity and the inaccurate fuel gages, which resulted in fuel starvation and total loss of engine power and subsequent forced landing on rough terrain. Factors relating to the accident were the pilot's improper…May 7, 1991 · N222SV · Substantial damageNTSB MIA91LA137Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Bunnell, FLLoss of control in flight due to a foreign object which restricted the movement of the elevator flight control.May 7, 1991 · N7270G · Substantial damageNTSB LAX91LA202Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Ojai, CAThe pilot's inadequate compensation for the wind condition. A factor related to the accident was the downdraft weather condition.May 7, 1991 · N89828 · Substantial damageNTSB LAX91LA193Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Yuma, AZThe failure of the pilot-in-command to perform fuel consumption calculations which resulted in a total loss of engine power due to fuel exhaustion.May 7, 1991 · N304JD · Substantial damageNTSB FTW91FA074Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-20 · Kenefic, OKImproper planning/decision by the pilots of both aircraft, and the Mitsubishi pilot's misjudgment of his position, while attempting to fly formation at night with an aircraft that did not have all navigation lights operative. Factors related to the accident…May 7, 1991 · N106MA · 2 aircraft · DestroyedNTSB DEN91FA068Accident · Serious injuriesField investigationFinal reportBell 206B-3 · Houston, TXEngine mount delamination and lack lubrication, causing the drive shaft to fail. Poor servicing of the helicopter was a related factor.May 7, 1991 · N717NH · DestroyedNTSB LAX91LA205Accident · Minor injuriesLimited investigationFinal reportBell 206 · Searchlight, NVCannot be determined in that the helicopter was stolen and the certainty of the resulting damage to the helicopter may have been intentional or accidental.May 6, 1991 · N49720 · DestroyedNTSB LAX91LA201Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Madera, CAThat the pilot failed to properly recover from a bounced landing. Contributing to this accident was the pilot's lack of experience in the airplane.May 6, 1991 · N86295 · Substantial damageNTSB LAX91LA199Accident · No injuriesLimited investigationFinal reportCessna 182 · Phoenix, AZThat the pilot failed to properly preflight the airplane to assure the engine contained an adequate oil supply. Contributing to this accident was total failure of the connecting rod due to lack of lubrication.May 6, 1991 · N4996D · Substantial damageNTSB LAX91FA203Accident · 1 fatalField investigationFinal reportCessna 182A · Lee Vining, CAThe failure of the pilot to maintain aircraft control due to spatial disorientation during a night approach.May 6, 1991 · N2137G · DestroyedNTSB DEN91FA067Accident · 1 fatalField investigationFinal reportBeech A-36 · Hartley, TXUndetermined.May 6, 1991 · N1093B · DestroyedNTSB CHI91LA147Accident · No injuriesLimited investigationFinal reportBeech 58P · Wichita, KSA go around was not performed resulting in the proper touchdown not being attained by the pilot.May 6, 1991 · N6407M · Substantial damageNTSB CHI91DCQ05Accident · No injuriesFinal reportCessna A188B · Mingo, KSFailure of the pilot to maintain a visual lookout while performing aerial application. A factor associated with the accident is soft terrain in the selected landing area.May 6, 1991 · N9374R · Substantial damageNTSB ATL91FA090Accident · Serious injuriesField investigationFinal reportMcdonnell Douglas MD-88 · Atlanta, GAThe van driver's inadequate visual lookout and poor division of attention.May 6, 1991 · N938DL · Substantial damageNTSB SEA91LA098Accident · Serious injuriesLimited investigationFinal reportRichard Cheney Teratorn Tierra II · Morgan, UTThe inadvertant stall and the pilot's steep banked turn. Factors relating to the accident were the pilot's lack of qualification to conduct the flight and the strong tailwind conditions.May 5, 1991 · N134TA · DestroyedNTSB NYC91LA126Accident · No injuriesLimited investigationFinal reportHughes 269B · Lincoln Park, NJAn inflight loss of control during a hover due to improper use of the flight controls by the pilot and the failure of the pilot to completely use the minimal visual references available.May 5, 1991 · N3TL · Substantial damageNTSB NYC91DGT02Accident · Minor injuriesFinal reportKolb Twinstar · Williamsport, PAAn engine seizure as the result of overheating.May 5, 1991 · N94MW · Substantial damageNTSB LAX91LA200Accident · No injuriesLimited investigationFinal reportCessna T-337-D · Fullerton, CAThe loss of power in the front engine due to the improper and incomplete installation of the engine in the aircraft by a mechanic.May 5, 1991 · N2688S · Substantial damageNTSB LAX91LA198Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Keanae, HIThe total failure in fatigue of the helicopter's spur adapter gearshaft. A contributing factor was related to the lack of a suitable emergency landing site.May 5, 1991 · N9219F · Substantial damageNTSB LAX91LA197Accident · No injuriesLimited investigationFinal reportCessna 150 · Fernley, NVThe failure of the pilot to adequately assess the climb performance of the accident airplane due to being under the influence of alcohol.May 5, 1991 · N45301 · Substantial damageNTSB LAX91LA196Accident · Minor injuriesLimited investigationFinal reportErcoupe 415C · King City, CAThe total loss of engine power which resulted from the drain valve fitting on a newly installed gascolator dislodging during cruise flight.May 5, 1991 · N99893 · Substantial damageNTSB LAX91LA195Accident · Serious injuriesLimited investigationFinal reportCessna U206 · Tulare, CAAn in-flight fire in the cabin/crew compartment area of the aircraft, due to failure of a fuel line located in the left doorpost area.May 5, 1991 · N2160F · DestroyedNTSB LAX91LA194Accident · No injuriesLimited investigationFinal reportLancair 320 · Fall River Mill, CAFailure of the pilot-in-command to compensate for wind conditions and to recover from a bounced landing which resulted in an on ground loss of control. Contributing to the accident was the wind conditions and turbulence at the airport at the time of the…May 5, 1991 · N320MC · DestroyedNTSB FTW91LA073Accident · No injuriesLimited investigationFinal reportCessna 150J · Cypress, TXFailure of the PIC to maintain proper airspeed and the inadvertent stall experienced by the pilot rated passenger. A factor was the pic's failure to attain runway alignment.May 5, 1991 · N60544 · Substantial damageNTSB CHI91LA146Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Ann Arbor, MILoss of engine power due to carburetor ice, and the pilot's failure to use carburetor heat. Factors related to the accident were: carburetor icing conditions, and a false indication from the carburetor air temperature gage.May 5, 1991 · N2360K · Substantial damageNTSB BFO91FA048Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Odessa, DEThe pilot's failure to recover from a stall. Contributing was an intentional stall of the aircraft, pilot inexpereince and inadequate altitude.May 5, 1991 · N9285 · DestroyedNTSB MIA91LA136Accident · No injuriesLimited investigationFinal reportBeech F-90 · Key West, FLOverload failure of the nose landing gear resulting in the collapse of the nose landing gear during the landing roll.May 4, 1991 · N208RC · Substantial damageNTSB MIA91LA135Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Stuart, FLAn inadequate annual inspection which failed to detect corrosion on the rudder cable. The pilot lost direction control during landing when the rudder cable broke.May 4, 1991 · N78583 · Substantial damageNTSB LAX91LA192Accident · No injuriesLimited investigationFinal reportCessna 180 · Truckee, CAThat the pilot improperly used the flight controls and brakes to arrest the runway excursion. Contributing to this accident was encountering unfavorable winds, crosswind conditions, and lack of experience in this type of airplane.May 4, 1991 · N9147C · Substantial damageNTSB LAX91LA191Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Delano, CAThat the pilot improperly performed the autorotation by misjudging the flare altitude. Contributing to this accident was the total failure of the freewheeling sprag clutch due to excessive wear and the soft dirt terrain.May 4, 1991 · N4414 · Substantial damageNTSB FTW91FA072Accident · Serious injuriesField investigationFinal reportCessna 182A · Fentress, TXThe improper major modification of the airplane by the operator, and the resultant separation of the door, window and windshield. A factor was the installation of a non approved jump door.May 4, 1991 · N6172B · Substantial damageNTSB FTW91DRA02Accident · Serious injuriesFinal reportW. R. Mathis Midget Mustang · Nacogdoches, TXPower loss due to engine starter failure for undetermined reasons.May 4, 1991 · N43WM · Substantial damageNTSB BFO91LA047Accident · No injuriesLimited investigationFinal reportAerospace Tech. of Australia N22B · Richardsville, KYThe loss of engine power brought on by a failure of the no.2 main engine bearing. Contributing to the accident was the lack of sufficient power on the remaining engine to maintain level flight.May 4, 1991 · N5590M · Substantial damageNTSB ATL91LA091Accident · Serious injuriesLimited investigationFinal reportBoeing B767-287ER · Memphis, TNThe delayed inflight decision by the pilot to maneuver the aircraft away from thunderstorm activity.May 4, 1991 · N651US · No damageNTSB ANC91LA056Accident · No injuriesLimited investigationFinal reportCessna C-170B · Manley Hot Sprg, AKThe pilot's selecting unsuitable terrain for landing. Contributing to the accident was the rough landing area.May 4, 1991 · N2744D · Substantial damageNTSB SEA91LA100Accident · No injuriesLimited investigationFinal reportCessna A185F · Orting, WAThe pilot's failure to maintain directional control of the aircraft. Contributing to the accident was a vibration in the left main landing gear.May 3, 1991 · N2450J · Substantial damageNTSB NYC91FA125Accident · No injuriesField investigationFinal reportBoeing 727-100QC · Windsor Locks, CTA catastrophic and uncontained failure of the no.3 engine which resulted in a fuel fed fire.May 3, 1991 · N425EX · DestroyedNTSB FTW91LA076Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Pioneer, LAThe pilot's use of a runway unsuitable due to recent rains.May 3, 1991 · N7361 · Substantial damageNTSB ANC91LA055Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Eek, AKWas the hard landing caused when the pilot encountered a downdraft during the final approach portion of the landing. Contributing to the accident was the downdraft and the dirt/river bank just short of the runway.May 3, 1991 · N4593T · Substantial damageNTSB SEA91LA097Accident · 1 fatalLimited investigationFinal reportGrumman AA-1B · Douglas, WYAn inadvertent stall with inadequate terrain clearance. Factors include flight in mountainous terrain at an altitude where remedial action was not possible.May 2, 1991 · N1412R · DestroyedNTSB MIA91WA134Incident · No injuriesForeign investigationBeech TC-45J · Nassau, BahamasMay 2, 1991 · N6688 · Minor damageNTSB MIA91LA133Accident · No injuriesLimited investigationFinal reportCessna 150L · Lake Wales, FLFailure of airport personnel to perform airport maintenance which resulted in inaccurate wind information due to a deteriorated windsock, and failure of the student pilot to maintain directional control during the landing roll with a tail wind. Also,…May 2, 1991 · N5829L · Substantial damageNTSB LAX91FA190Accident · 4 fatalField investigationFinal reportMooney M20F · Quincy, CAThe pilot's inadvertent flight into IMC and thereafter his failure to maintain directional control of his airplane. Factors which contributed to the accident related to the pilot's improper weather evaluation which resulted in his delayed emergency procedure,…May 2, 1991 · N9624M · DestroyedNTSB FTW91LA075Accident · No injuriesLimited investigationFinal reportCessna 337D · Alpine, TXThe pilot's failure to maintain directional control of the airplane. A factor was the pilot's continued takeoff in unfavorable wind.May 2, 1991 · N86116 · Substantial damageNTSB FTW91DPG05Accident · 1 fatalFinal reportAyres S2R-T34 · Wheatley, ARThe failure of the flagman to follow established procedures.May 2, 1991 · N4015Z · Minor damageNTSB ANC91LA054Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Beluga, AKThe engine failure due to undetermined causes. Contributing to the accident was the unsuitability of the available landing area.May 2, 1991 · N40676 · Substantial damage