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 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.NTSB 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.NTSB NYC93LA071Accident · No injuriesLimited investigationFinal reportCessna 177B · Brookville, OHThe pilot's failure to maintain directional control. Contributing was the lack of recency of experience.NTSB LAX93LA167Accident · Serious injuriesLimited investigationFinal reportAero Commander ST-R · San Jose, CAThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall/spin.NTSB FTW93IA118Incident · No injuriesIncident investigationFinal reportBoeing 757-200 · Houston, TXEncounter with turbulence. A factor was the loss of electrical powerNTSB 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.NTSB ATL93LA070Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Augusta, GAThe pilot's improper fuel management, which resulted in fuel starvation and engine stoppage.NTSB 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.NTSB 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.NTSB 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).NTSB 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.NTSB 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.NTSB 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…NTSB CHI93LA136Accident · No injuriesLimited investigationFinal reportCessna T210 · Philadelphia, ILThe pilot's failure to ensure an adequate fuel supply to complete the flight.NTSB CHI93LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Sullivan, INThe student pilot's failure to maintain directional control.NTSB CHI93FA133Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Plattsmouth, NEThe pilot-in-command (CFI)'s failure to maintain airspeed.NTSB 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.NTSB 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.NTSB DCA93RA036Accident · No injuriesForeign investigationBoeing 767-251 · Guatemala City, PanamaNTSB CHI93LA131Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Northwood, NDThe flight instructor's inadequate supervision of the flight.NTSB 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.NTSB SEA93FA091Accident · 4 fatalField investigationFinal reportLake LA-4-200 · Gold Bar, WAThe pilot's failure to maintain adequate airspeed while maneuvering for a water landing.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB LAX93LA163Accident · No injuriesLimited investigationFinal reportCessna 177RG · Imperial, CAThe flight's encounter with a dust devil.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB SEA93LA086Accident · No injuriesLimited investigationFinal reportBoeing D75N1 · Davenport, WAUnsuitable terrain was selected for landing. A factor to the accident was: soft terrain.NTSB MIA93WA095Accident · No injuriesForeign investigationPiper PA-23-250 · Nassau, BahamasNTSB 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.NTSB 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 landingNTSB 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.NTSB 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.NTSB LAX93T#A02Accident · No injuriesClass 3Final reportBell 412 · Topanga, CANTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB MIA93WA094Accident · No injuriesForeign investigationCessna 402B · Congo Town, Congo - KinshasaNTSB 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.NTSB FTW93LA114Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Des Arc, ARThe pilot's loss of outside visual reference and loss of control.NTSB CHI93LA151Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Lapeer, MIThe pilot's failure to maintain directional control during the landing roll.