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 CHI93DCG01Accident · 2 fatalFinal reportEmory W. Greer, JR. VARI-EZE · Olathe, KSthe pilot's failure to secure a fuel cap during the preflight inspection of the airplane, and the pilot's failure to maintain aircraft control during the emergency landing. Factors associated with the accident are the unsecured fuel cap and the foreign object…NTSB ANC93IA093Incident · No injuriesIncident investigationFinal reportCessna 206 · Portage, AKThe failure of the number two cylinder connecting rod bearing due to the shifting of the bearing within its journal race which produced an oil starvation/thermal distress event.NTSB MIA93LA142Accident · No injuriesLimited investigationFinal reportSayer, Trevor A. Rans S-12 · New Smyrna Bch, FLFailure of the pilot to maintain adequate airspeed and inadvertent stall/spin. Contributing to the accident was total loss of engine power due to fuel starvation. This was due to improper placement of a component of the fuel system by the builder/pilot.NTSB MIA93FA141Accident · 1 fatalField investigationFinal reportCessna 150J · Niceville, FLThe inadequate annual inspection of the airplane by other maintenance personnel and the failure of the pilot to maintain airspeed above a stall.NTSB LAX93LA254Accident · No injuriesLimited investigationFinal reportCessna 150L · Yucaipa, CAthe flight instructor's selection of unsuitable terrain for the forced landing demonstration. A factor in the accident was the high density altitude existing at the time of the mishap.NTSB LAX93LA251Accident · No injuriesLimited investigationFinal reportAlon A2 · Goodyear, AZthe pilot's failure to maintain adequate obstruction clearance while taxiing. A factor in the accident was the pilot's attention being diverted by the movement of two trucks.NTSB LAX93LA250Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Salida, CAthe pilot's failure to attain the proper touchdown point during the attempted landing. A factor in the accident was the unfavorable wind conditions for the balloon landing.NTSB FTW93TA#07Accident · No injuriesFinal reportPiper PA-18-150 · Del Rio, TXNTSB FTW93FA187Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Texas City, TXThe pilot's failure to recover from the intentional maneuver for undetermined reasons.NTSB CHI93LA206Accident · Serious injuriesLimited investigationFinal reportClaude E. Merrin Zenair Stol CH-701 · Grayslake, ILThe pilot-in-command's failure to maintain aircraft control. The pilot-in-command's lack of total experience in aircraft type was a factor.NTSB ATL93LA110Accident · Serious injuriesLimited investigationFinal reportAerotek Zuni · Brownsboro, ALThe pilot's misjudgment of distance and altitude which resulted in the collision with trees short of the runway.NTSB ATL93LA109Accident · No injuriesLimited investigationFinal reportCessna 170 · Mooresville, NCPoor maintenance practices during the rebuilding of the aircraft which allowed the fuel system to become contaminated and resulted in the subsequent fuel starvation of the engine.NTSB ANC93LA090Accident · No injuriesLimited investigationFinal reportCessna 402 · Kivalina, AKThe failure of the pivot link for the downlock mechanism and the improper rigging of the landing gear locking mechanism by company maintenance personnel.NTSB ANC93LA089Accident · Minor injuriesLimited investigationFinal reportPiper PA-3 · Knik, AKThe improper use of the flight controls by the student pilot and inadequate supervision by the CFI pilot-in-command.NTSB ANC93LA088Accident · No injuriesLimited investigationFinal reportCessna 185 · Arctic Village, AKThe pilot's selection of unsuitable terrain for a landing. A factor related to the accident was: the soft/thin (weak) ice condition of the lake surface.NTSB ANC93IA087Incident · No injuriesIncident investigationFinal reportPZL Warzawa-Okecie PZL-104 Wilga 80 · Haines, AKThe parking brake failure due to a broken bracket; intentionally leaving the airplane unattended with the engine running by the pilot-in-command; and the improper planning and decision of the pilot-in-command by not using wheel chocks.NTSB LAX93LA249Accident · No injuriesLimited investigationFinal reportHughes 369D · Kahului, HIThe failure of the pilot to maintain adequate ground obstruction clearance while engaged in a cattle herding operation.NTSB FTW93LA186Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Edgewood, NMPower loss to the right engine due to the magneto grounding leads being loose and an inadequate annual inspection. A factor was a lack of suitable terrain.NTSB DEN93LA068Accident · No injuriesLimited investigationFinal reportCessna 172N · Livermore, COA partial power loss when the rocker box for one cylinder disengaged. A factor was: unsuitable terrain for a forced landing.NTSB CHI93LA203Accident · Minor injuriesLimited investigationFinal reportPiper PA-36 · Mc Laughlin, SDPilot in command's failure to maintain proper clearance.NTSB CHI93LA202Accident · No injuriesLimited investigationFinal reportCessna 170B · Janesville, WIThe pilot in command's failure to maintain directional control of the aircraft.NTSB CHI93LA201Accident · 1 fatalLimited investigationFinal reportBell 47G-2A-1 · Phlox, WIWas the pilot in command's failure to maintain aircraft control. A factor to the accident was the inadequate cyclic control.NTSB CHI93GA204Accident · 2 fatalFinal reportBeech 95-C55 · Fort Madison, IAthe pilot-in command's failure to maintain control of the aircraft. Factors were door not secured, checklist not followed, diverted attention of the pilot-in-command, and emergency procedure not followed.NTSB MIA93LA140Accident · No injuriesLimited investigationFinal reportMooney M20E · Miami, FLThe pilot-in-command's improper flare during a forced landing which resulted in a hard landing. Contributing to the accident was the total loss of engine power for undetermined reasons.NTSB CHI93LA198Accident · Serious injuriesLimited investigationFinal reportBeech 200 · Wonder Lake, ILThe failure of the pilot of the Beech 200, N210PH, to maintain sufficient runway alignment to prevent the airplane from departing the runway.NTSB ATL93LA108Accident · No injuriesLimited investigationFinal reportCessna 421B · Attalla, ALThe failure of the left engine turbocharger due to rotor shaft seizure, which resulted in a loss of engine power.NTSB ATL93FA107Accident · 2 fatalField investigationFinal reportCessna TP206 · Epworth, GAThe pilot's failure to maintain vertical clearance above the trees while maneuvering which resulted in the collision with trees.NTSB NYC93LA109Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Glen Mills, PAAn improperly planned approach in which the flare was not attained, and which resulted in a hard landing.NTSB NYC93LA108Accident · Serious injuriesLimited investigationFinal reportMooney M20J · New Haven, CTThe loss of airplane control as a result of the pilot encountering spatial disorientation. Factors in this accident were the low ambient light conditions and the lack of runway end identifier lightsNTSB FTW93LA184Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Canyon Lake, TXThe movement of the pilot's seat aft which resulted in his loss of control, his inability to regain control, and the ensuing inadvertent stall. A factor was the inadequate inspection of the airplane.NTSB FTW93FA185Accident · No injuriesField investigationFinal reportConvair 440 · Greenville, TXThe pilot-in-command's failure to follow the published emergency procedures. Factors were engine fire warning system activating for undetermined reasons, and the resultant ac power loss when that engine was secured. The lack of recent expereince in type…NTSB FTW93FA183Accident · 1 fatalField investigationFinal reportEagle DW-1 · Goree, TXThe pilot's failure to maintain adequate airspeed. A factor was the pilot's lack of experience in the airplane.NTSB CHI93FA200Accident · 2 fatalField investigationFinal reportBeech A-36 · Tony, WIthe pilot's decision to continue flight into known adverse weather and exceeded the design strees limits of the airplane. Factors associated with the accident were inadequate preflight planning/preparation, clouds, turbulence, icing conditions, and the lack…NTSB NYC93LA106Accident · Serious injuriesLimited investigationFinal reportHenry J. Camacho Seahawk · Orange, MAThe pilot's excessive rotation and failure to obtain adequate airspeed which resulted in an inadvertent stall and inflight collision with the terrain. A factor was the pilot's inexperience in the type aircraft.NTSB NYC93LA105Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Provincetown, MAThe pilot's failure to recover from a bounced landing and to maintain aircraft control which resulted in the airplane nosing over. Improper landing flare is a contributing factor.NTSB LAX93IA245Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Los Angeles, CAthe inadvertent deployment of an overwing emergency excape slide due to the inadequate latching of the slide compartment door following access by maintenance personnel. A factor in the accident was the inadequate door closing procedure specified by the…NTSB FTW93LA181Accident · No injuriesLimited investigationFinal reportDrlik Falcon XC · Albuquerque, NMThe extraneous and uncommanded roll and yaw deviations caused by inadequate airplane design which precluded the pilot from taking corrective action and led to the ensuing hard landing.NTSB CHI93LA196Accident · No injuriesLimited investigationFinal reportCessna 172N · St. James, MIThe pilot landed too long on a wet runway.NTSB CHI93FA193Accident · 1 fatalField investigationFinal reportBeech E18S · Ypsilanti, MIThe pilot-in-command's inadequate preflight preparation, false indication (on/off) of attitude indicator, and attitude indicator switched off. Factors were fog, low ceiling, the pilot-in-command's improper use of the attitude indicator, and his lack of total…NTSB NYC93LA104Accident · No injuriesLimited investigationFinal reportCessna 150J · West Caldwell, NJThe complete loss of engine power as a result of carburetor icing, the subsequent forced landing and impact with the terrain.NTSB NYC93LA100Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Cincinnati, OHThe pilot's improper inflight planning and decision resulting in fuel exhaustion, and the subsequent forced landing and collision with power lines.NTSB NYC93FA102Accident · 1 fatalField investigationFinal reportCessna 150E · Selbyville, DEThe pilot's failure to maintain proper airspeed resulting in an inadvertent stall/spin and collision with the terrain. A factor related to the accident was the pilot's lack of experience in the banner towing operation.NTSB FTW93LA180Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Dumas, ARThe pilot's inadequate compensation for wind conditions.NTSB BFO93GA102Accident · 2 fatalFinal reportBeech B24R · Manassas, VAFailure of the pilot to maintain adequate airspeed while maneuvering for a precautionary landing which resulted in an inadvertent stall. A related factor was that the pilot's attention was diverted by the open door.NTSB ANC93LA083Accident · No injuriesLimited investigationFinal reportBeech 56TC · Chistochina, AKThe pilot's improper decision to land on a rough airstrip.NTSB ANC93IA084Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Anchorage, AKThe failure of the nose landing gear inner cylinder from an overload/overstress condition.NTSB NYC93LA101Accident · No injuriesLimited investigationFinal reportCessna 172P · Lincoln Park, NJThe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control of the airplane, which resulted in a ground swerve and a collision with trees.NTSB MIA93LA139Accident · No injuriesLimited investigationFinal reportBeech 23 · Tampa, FLThe pilot-in-command's improper landing flare, which resulted in the aircraft bouncing and entering a porpoise maneuver. Contributing to the accident was his failure to recover from the bounced landing and perform a go-around.NTSB LAX93LA244Accident · 1 fatalLimited investigationFinal reportBeech K-35 · Eureka, NVThe pilot disregarding the advice that visual flight rules were not recommended; the pilot's inadequate weather evaluation along his route of flight; the pilot attempting flight into known adverse weather conditions; the pilot's loss of aircraft control due…NTSB LAX93FA242Accident · 2 fatalField investigationFinal reportPiper PA-23-150 · Diablo, CAThe pilot in command's continued flight into instrument meteorological conditions, and the improper in flight planning and decision making by the pilot.