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 NYC93LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Pawtucket, RIThe failure of both pilots to see and avoid, resulting in a ground collision between their two airplanes.Apr 7, 1993 · N3866R · 2 aircraft · Minor damageNTSB NYC93LA072Accident · 1 fatalLimited investigationFinal reportCessna 140 · Doylestown, PAFailure of the pilot passenger to maintain adequate airspeed and the failure of the pilot in command to adequately supervise the flight.Apr 7, 1993 · N46TM · Substantial damageNTSB NYC93LA071Accident · No injuriesLimited investigationFinal reportCessna 177B · Brookville, OHThe pilot's failure to maintain directional control. Contributing was the lack of recency of experience.Apr 7, 1993 · N11828 · Substantial damageNTSB LAX93LA167Accident · Serious injuriesLimited investigationFinal reportAero Commander ST-R · San Jose, CAThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall/spin.Apr 7, 1993 · N1783S · DestroyedNTSB FTW93IA118Incident · No injuriesIncident investigationFinal reportBoeing 757-200 · Houston, TXEncounter with turbulence. A factor was the loss of electrical powerApr 7, 1993 · CFOOA · No damageNTSB DEN93LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Llano, TXThe pilot's continued VFR flight into IMC. Factors were: low ceiling, dark night, and the pilot's lack of total instrument time.Apr 7, 1993 · N81527 · DestroyedNTSB ATL93LA070Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Augusta, GAThe pilot's improper fuel management, which resulted in fuel starvation and engine stoppage.Apr 7, 1993 · N29AP · DestroyedNTSB SEA93LA089Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Casper, WYFuel exhaustion, and the pilot in command's poor inflight decision. Factors include an inadequate preflight by the pilot in command.Apr 6, 1993 · N5541P · Substantial damageNTSB SEA93LA087Accident · No injuriesLimited investigationFinal reportCessna T210M · Scappose, WAClearance from objects was not maintained. The pilot's poor inflight planning and the weather conditions were factors.Apr 6, 1993 · N16CE · Substantial damageNTSB SEA93FA088Accident · 4 fatalField investigationFinal reportMitsubishi MU-2B-35 · Casper, WYFailure of the pilot to maintain proper altitude during the night IFR approach in instrument meteorological conditions (IMC).Apr 6, 1993 · N96JP · DestroyedNTSB NYC93LA070Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Norridgewock, METhe pilot at the controls failed to maintain directional control of the airplane, and the flight instructor provided inadequate supervision. A related factor was the pilot at the controls had no flight experience in the make and model of airplane being flown.Apr 6, 1993 · N8775K · Substantial damageNTSB FTW93FA117Accident · 1 fatalField investigationFinal reportBeech C-45H · Mooringsport, LAA total loss of right engine power, and a partial loss of left engine power, for undetermined reasons.Apr 6, 1993 · N492DM · DestroyedNTSB DCA93MA037Accident · 2 fatalClass 1 · MajorFinal reportMcdonnell Douglas MD-11 · Shemya, AKThe national transportation safety board determines that the probable cause of this accident was the inadequate design of the flap/slat actuation handle by the Douglas aircraft company that allowed the handle to be easily and inadvertently dislodged from the…Apr 6, 1993 · B2171 · Minor damageNTSB CHI93LA136Accident · No injuriesLimited investigationFinal reportCessna T210 · Philadelphia, ILThe pilot's failure to ensure an adequate fuel supply to complete the flight.Apr 6, 1993 · N6471N · Substantial damageNTSB CHI93LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Sullivan, INThe student pilot's failure to maintain directional control.Apr 6, 1993 · N89098 · Substantial damageNTSB CHI93FA133Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Plattsmouth, NEThe pilot-in-command (CFI)'s failure to maintain airspeed.Apr 6, 1993 · N2530B · DestroyedNTSB NYC93LA069Accident · Minor injuriesLimited investigationFinal reportBeech E-55 · Leesburg, VAImproper use of the fuel selectors, which resulted in fuel starvation and loss of power in both engines. Darkness was a related factor.Apr 5, 1993 · N777EV · Substantial damageNTSB LAX93LA164Accident · No injuriesLimited investigationFinal reportRoy Rey Avid Flyer · Wasco, CACarburetor icing. Factors relating to the accident were the lack of a carburetor heat control system and the freshly plowed field.Apr 5, 1993 · N827H · Substantial damageNTSB DCA93RA036Accident · No injuriesForeign investigationBoeing 767-251 · Guatemala City, PanamaApr 5, 1993 · N767TANTSB CHI93LA131Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Northwood, NDThe flight instructor's inadequate supervision of the flight.Apr 5, 1993 · N108ND · Substantial damageNTSB CHI93FA129Accident · 1 fatalField investigationFinal reportAerospatiale ATR-42-300 · Chicago, ILthe unqualified baggage handler's attempting to load an unfamiliar airplane and inadequate training by the airline which employed the baggage handler.Apr 5, 1993 · N422MQ · Minor damageNTSB SEA93FA091Accident · 4 fatalField investigationFinal reportLake LA-4-200 · Gold Bar, WAThe pilot's failure to maintain adequate airspeed while maneuvering for a water landing.Apr 4, 1993 · N39375 · Substantial damageNTSB NYC93LA068Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Doylestown, PAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Contributing was the lack of total experience.Apr 4, 1993 · N5338W · Substantial damageNTSB CHI93LA130Accident · No injuriesLimited investigationFinal reportBeech B-55 · Green Bay, WIImproper replacement of the right wing by maintenance personnel which resulted in the vapor return lines being reversed, and the auxiliary tank vent to be disconnected.Apr 4, 1993 · N4167P · Substantial damageNTSB NYC93LA067Accident · Minor injuriesLimited investigationFinal reportSilva Seawind 3000 · Coatesville, PAImproper adjustment setting of the propeller pitch change mechanism and/or propeller governor output pressure, which resulted in a loss of positive thrust and a forced landing.Apr 3, 1993 · N465W · Substantial damageNTSB MIA93LA096Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Fort Walton Bch, FLThe pilot-in-command's failure to visually inspect the grapple hook/cable after deployment, to ensure it was free from all control surfaces prior to initiating a banner pickup.Apr 3, 1993 · N7011K · Substantial damageNTSB LAX93LA163Accident · No injuriesLimited investigationFinal reportCessna 177RG · Imperial, CAThe flight's encounter with a dust devil.Apr 3, 1993 · N34205 · Substantial damageNTSB LAX93LA162Accident · No injuriesLimited investigationFinal reportPiper J3 · Buckeye, AZThe pilot's inadequate visual look-out and failure to maintain clearance from the wires. Lack of experience in the geographical (airport) area was a factor.Apr 3, 1993 · N30503 · Substantial damageNTSB LAX93LA161Accident · Minor injuriesLimited investigationFinal reportCessna 150 · San Diego, CAThe failure of the wing flap control due to the improper type of fuse installed by unidentified persons. Factors relating to this accident were the flap motor partial failure due to corrosion and the total failure of the fuse due to the wrong type amperage.Apr 3, 1993 · N50287 · DestroyedNTSB FTW93LA116Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Fort Worth, TXPartial power loss due to improper maintenance and resultant discrepancies. A factor was the lack of suitable terrain.Apr 3, 1993 · N9337M · Substantial damageNTSB ATL93LA069Accident · No injuriesLimited investigationFinal reportJohn Thomason Laco 145 · Tuskegee, ALThe overload failure of the tail wheel leaf springs, which resulted in a loss of directional control during the landing roll.Apr 3, 1993 · N89ST · Substantial damageNTSB ANC93LA051Accident · No injuriesLimited investigationFinal reportCessna 170 · Anchorage, AKThe pilot in command's premature lift-off. Contributing factors were the pilot's failure to abort the takeoff, his lack of total expereince in the type airplane and type operation, and the slush covered runway.Apr 3, 1993 · N4190V · Substantial damageNTSB ANC93FA050Accident · 2 fatalField investigationFinal reportCessna 207 · Nome, AKThe pilot initiated VFR flight into instrument meteorological and whiteout conditions. Factors which contributed to the accident were: inadequate supervision of the pilot by the company, inadequate oversight by the federal aviation administration, the pilot's…Apr 3, 1993 · N6467H · DestroyedNTSB DEN93LA037Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Eckert, COThe pilot-in-command's failure to maintain adequate clearance from the truck during the landing. Factors which contributed to the accident were: the pilot's poor judgement in attempting the operation, and the driver's poor judgement in not vacating all…Apr 2, 1993 · N8210Y · Substantial damageNTSB ATL93MA068Accident · 4 fatalMajor investigationFinal reportFairchild SA227-TT · Blountville, TNFailure of the pilot to follow procedures concerning use of the engine inlet anti-ice system and/or continuous ignition while operating in icing conditions, which resulted in probable ice ingestion and loss of engine power; and the pilot's failure to maintain…Apr 2, 1993 · N500AK · DestroyedNTSB SEA93LA086Accident · No injuriesLimited investigationFinal reportBoeing D75N1 · Davenport, WAUnsuitable terrain was selected for landing. A factor to the accident was: soft terrain.Apr 1, 1993 · N56426 · Substantial damageNTSB MIA93WA095Accident · No injuriesForeign investigationPiper PA-23-250 · Nassau, BahamasApr 1, 1993 · N555AD · Substantial damageNTSB LAX93FA160Accident · 4 fatalField investigationFinal reportCessna 172P · Livermore, CAThe pilot's decision to attempt VFR flight into instrument meteorological conditions. Factors that contributed to this accident were: the pilot's lack of recent instrument experience, the rain and high wind conditions in the area.Apr 1, 1993 · N97462 · DestroyedNTSB FTW93FA115Accident · Minor injuriesField investigationFinal reportChance Vought F4U-4 · Breckenridge, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landingApr 1, 1993 · N68HP · Substantial damageNTSB DEN93FA038Accident · 3 fatalField investigationFinal reportAerospatiale SA316B · Aspen, COFailure of the flight control lower mixing unit due to fatigue, which resulted in the loss of control.Apr 1, 1993 · N3153R · DestroyedNTSB ATL93LA067Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G102 · Kingston, GAThe pilot's attempted return to the departure runway that resulted in a stall at an altutude that was too low to permit recovery.Apr 1, 1993 · N792G · Substantial damageNTSB LAX93T#A02Accident · No injuriesClass 3Final reportBell 412 · Topanga, CAMar 31, 1993 · N412LA · No damageNTSB DCA93MA033Accident · No injuriesClass 1 · MajorFinal reportBoeing 747-121 · Anchorage, AKThe lateral separation of the no. 2 engine pylon due to an encounter with severe or possibly extreme turbulence that resulted in dynamic multi-axis lateral loadings that exceeded the ultimate lateral load-carrying capability of the pylon, which was already…Mar 31, 1993 · N473EV · Substantial damageNTSB CHI93IA124Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42-300 · Moline, ILThe passenger's failure to extinguish a cigarette before placing it into the lavatory waste bin. Factors related to the incident were: an inoperative smoke detector in the lavatory, the manufacturer's inadequate maintenance program, and inadequate review of…Mar 31, 1993 · N426TE · No damageNTSB ATL93FA066Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Kennesaw, GAFailure of the flight instructor (CFI) to assure that a proper rate of climb was established after takeoff to maintain proper clearance above the terrain/obstacles. Factors related to the accident were: darkness and the excessive weight condition of the…Mar 31, 1993 · N4218E · DestroyedNTSB SEA93LA085Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164A · Walla Walla, WAA loss of engine power for undetermined reasons. The lack of a suitable landing area was a factor.Mar 30, 1993 · N8734H · DestroyedNTSB MIA93WA094Accident · No injuriesForeign investigationCessna 402B · Congo Town, Congo - KinshasaMar 30, 1993 · N60DN · Substantial damageNTSB LAX93FA165Accident · 1 fatalField investigationFinal reportCessna 152 · Dunsmuir, CAAn inadvertent encounter with rain and icing conditions. Factors in this accident included environmental conditions consisting of rain, icing, and darkness, and the pilot's overconfidence in his abilities to deal with the encountered weather conditions.Mar 30, 1993 · N89174 · DestroyedNTSB FTW93LA114Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Des Arc, ARThe pilot's loss of outside visual reference and loss of control.Mar 30, 1993 · N4437S · DestroyedNTSB CHI93LA151Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Lapeer, MIThe pilot's failure to maintain directional control during the landing roll.Mar 30, 1993 · N7732K · Substantial damage