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 ATL93LA122Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Seneca, SCThe pilot's improper preflight planning which resulted in fuel exhaustion.NTSB ATL93LA121Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAThe pilot's failure to maintain adequate clearance from the ground.NTSB ANC93LA109Accident · No injuriesLimited investigationFinal reportMaule M4 · Iliamna, AKThe pilot in command's improper taxi speed. A factor in the accident was the rough water.NTSB ANC93LA108Accident · No injuriesLimited investigationFinal reportCessna 206 · Skwentna, AKThe pilot's selection of unsuitable terrain. Factors related to the accident were: the submerged sand bar and the pilot's excessive taxispeed.NTSB DEN93LA072Accident · No injuriesLimited investigationFinal reportCessna 150M · Haswell, COFailure of the student pilot to maintain control of the aircraft during landing roll. Factors were: alternator failure, failure of the student pilot to follow procedures and directives, and failure of the student pilot to perform fuel consumption calculations.NTSB BFO93FA129Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · California, MDThe pilot initiating VFR flight in instrument meteorological conditions. Factors which contributed to the accident were: the pilot's failure to obtain a weather briefing, his lack of sleep, and the existing weather conditions.NTSB BFO93FA103Accident · 2 fatalField investigationFinal reportCessna 180K · Webster, NHThe pilot's inadequate preflight planning/preparation, his failure to assure proper weight and balance of the aircraft for takeoff, and his failure to obtain and/or maintain adequate airspeed, which resulted in a stall. A possible factor related to the…NTSB ATL93FA120Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Clayton, ALInadequate maintenance and inspection of the carburetor by maintenance personnel.NTSB ANC93FA107Accident · Minor injuriesField investigationFinal reportCessna 185 · Wasilla, AKThe pilot in command's failure to use all of the available runway (waterway). A factor in the accident was the pilot in command's lack of recent experience in the type of operation.NTSB SEA93LA145Accident · Minor injuriesLimited investigationFinal reportBellanca 17-31ATC · Jackson Hole, WYThe pilot's selection of an empty fuel tank, and fuel starvation. Factors include rough/uneven terrain.NTSB NYC93LA135Accident · No injuriesLimited investigationFinal reportBeech C23 · Montgomery, NYA power loss due to a collapsed air duct and a consequent blockage of induction air, which resulted in a forced landing and an on ground collision with a ditch.NTSB NYC93LA134Accident · No injuriesLimited investigationFinal reportCessna 150E · Oxford, METhe pilot's improper landing flare which resulted in a hard landing. A factor was the pilot's lack of experience.NTSB LAX93GA270Accident · Minor injuriesFinal reportBell 206L-3 · Agoura Hills, CAThe improper configuration of the aerial ignition device by the crew chief and an inadvertent activation of the unit by the pilot. The improper installation and configuration of the unit by maintenance personnel, inadequate crew coordination, and insufficient…NTSB FTW93LA201Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Spring, TXThe pilot's improperly planned approach and the resultant overshoot of the intended landing area. Factors were the partial power loss due to internal corrosion, and the inadvertent stall.NTSB ATL93LA119Accident · Minor injuriesLimited investigationFinal reportWaco ATO · Alma, GAThe failure of the aircraft engine master rod bearing.NTSB SEA93LA144Accident · No injuriesLimited investigationFinal reportCessna 182RG · Price, UTThe pilot's poor inflight decision. Factors include high density altitude, and control interference.NTSB NYC93FA133Accident · 2 fatalField investigationFinal reportAmerican General AA-1 · Vestal, NYThe loss of engine power due to fuel starvation from a fuel leak caused by inadequate maintenance by unqualified personnel, the pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and collision with the ground.NTSB LAX93LA269Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Van Nuys, CAA failure of the pilot to maintain directional control of the airplane during a go-around maneuver, subsequent improper remedial actions and an inadvertent stall. A factor in this accident was the pilot's lack of total aeronautical experience.NTSB FTW93LA199Accident · Serious injuriesLimited investigationFinal reportMaule MX-7-180 · Eufaula, OKThe pilots improper compensation for the wind conditions. A factor was the crosswindNTSB FTW93LA198Accident · No injuriesLimited investigationFinal reportCessna 172G · Fort Worth, TXThe power loss for undetermined reasons. Factors were the lack of suitable terrain for the forced landing and the inadvertent stall.NTSB CHI93LA240Accident · No injuriesLimited investigationFinal reportCessna R172K · Rice, MNThe pilot in command's failure to maintain proper clearance.NTSB CHI93LA239Accident · Serious injuriesLimited investigationFinal reportAeronca AC7B · Kearney, MOThe pilot in command's failure to maintain adequate airspeed and the aircraft exceeding maximum allowable gross weight.NTSB CHI93FA238Accident · 3 fatalField investigationFinal reportBeech 58 · Beardstown, ILthe pilot-in-command's continued VFR flight into IMC and his failure to maintain control of the airplane. Factors were the fog, drizzle, and an abrupt maneuver by the pilot-in-command.NTSB ATL93LA118Accident · No injuriesLimited investigationFinal reportCessna 188B · Centre, ALThe failure of maintenance personnel to properly torque the crankcase through bolts.NTSB ANC93LA105Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-350 · Gambell, AKIntentional personal injury. Factors in the accident were: the person's psychological condition, and the lack of sufficient procedures/airport staff by the operator(s).NTSB ANC93LA104Accident · No injuriesLimited investigationFinal reportCessna 140 · Juneau, AKThe pilot's failure to maintain directional control. A factor to the accident was the pilot's lack of total experience.NTSB SEA93LA142Accident · Serious injuriesLimited investigationFinal reportWeatherly 201B · Wilbur, WAVisual lookout was not maintained. The wires were a factor.NTSB NYC93LA139Accident · 1 fatalLimited investigationFinal reportTitan Tornado · East Moriches, NYFailure of the pilot to maintain adequate airpseed, which resulted in an inadvertent stall and collision with the terrain.NTSB NYC93LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Spencer, MAThe pilot's inadequate preflight planning for the high density altitude departure and the delay in aborting the takeoff roll, with insufficient runway remaining, resulting in a collision with treesNTSB CHI93FA234Accident · 1 fatalField investigationFinal reportCessna 210D · Salem, MIthe pilot's physical impairment.NTSB ANC93LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Uganik River, AKPilot in commands failure to compensate adequately for shifting wind conditions and his selection of unsuitable terrain on which to land. A factor in the accident was the rough uneven terrain landing strip.NTSB SEA93LA141Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Enumclaw, WAThe pilot's failure to attain the proper touchdown point. Factors to the accident were: lack of familiarity with geographic area and the grass.NTSB NYC93LA136Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Voluntown, CTThe pilot's failure to achieve the proper touchdown point which resulted in an overrun of the runway and collision with trees. A factor is the pilot's improper compensation for the wind condition.NTSB NYC93LA132Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Mitchellville, MDThe failure of the pilot to maintain a proper glide path during the final approach, which resulted in the airplane striking a moving vehicle.NTSB NYC93LA129Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-236 · West Milford, NJA manufacturer's defect which resulted in fatigue failure of the magneto impluse coupling spring and the loss of engine power. A factor was unsuitable terrain.NTSB NYC93LA128Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Ironton, OHThe loss of engine power for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.NTSB LAX93LA268Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Danville, CAThe pilot's poor fuel consumption calculations. Contributing to this accident was the downsloping terrain.NTSB DEN93LA070Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Boulder, COA failure by the pilot flying to adequately compensate for wind conditions which led to a loss of tail rotor control. A factor was: inadequate supervision by the pilot in command.NTSB CHI93LA237Accident · Serious injuriesLimited investigationFinal reportDaniel Squire HI-MAX · Omro, WIthe pilot's inadequate preflight planning and preparation. A factor in the accident is the downdraft.NTSB CHI93LA236Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Waukesha, WIThe pilot's failure to maintain airspeed above a stall.NTSB CHI93LA227Accident · No injuriesLimited investigationFinal reportCessna 182L · Aurora, ILThe disconnected nose gear upper torque link (landing gear steering). Directional control not possible was a factor.NTSB CHI93LA223Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Osceola, WIThe pilot in command's failure to maintain directional control.NTSB CHI93DEE02Accident · Minor injuriesFinal reportDouglas B-26B · Kankakee, ILthe failure of the piston assembly in the number ten cylinder of the right engine. A factor associated with the accident was the inoperative propeller feathering system for the right engine.NTSB SEA93LA139Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Snohomish, WAThe pilot misjudged the landing flare.NTSB NYC93FA127Accident · 2 fatalField investigationFinal reportBoeing Stearman PT-17 · Concord, NHLoss of airplane control as the result of incapacitation.NTSB MIA93LA147Accident · Serious injuriesLimited investigationFinal reportPiper PA-38 · St. Petersburg, FLThe loss of engine power for undetermined reasons, which resulted in the aircraft being ditched.NTSB LAX93LA267Accident · No injuriesLimited investigationFinal reportRyan ST-A · Fresno, CAThe pilot's failure to maintain directional control. Contributing to this accident was the partial loss of power for undetermined reasons, the high runway vegetation, and the left quartering tailwind.NTSB LAX93LA266Accident · No injuriesLimited investigationFinal reportGlenn BD-4 · Somerton, AZThe second pilot's misjudgement of altitude and distance from the runway which resulted in an undershoot, and the pilot-in-command's inadequate supervision in not taking timely corrective action. In addition, neither pilot had any experience in the airplane,…NTSB FTW93FA197Accident · 1 fatalField investigationFinal reportAir Tractor AT-502 · Petronila, TXFailure of the pilot to maintain sufficient airspeed, while maneuvering, which resulted in an inadvertent stall. A factor related to the accident was: his lack of altitude for recovery from the stall.NTSB CHI93LA232Accident · No injuriesLimited investigationFinal reportSchweizer G-164 · Northwood, NDThe pilot in command's failure to attain a proper touchdown point.