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 NYC93LA165Accident · No injuriesLimited investigationFinal reportCessna 172 · London, OHThe student pilot's failure to maintain directional control of the airplane after landing, and subsequent departure from the runway and collision with terrain.NTSB LAX93LA332Accident · No injuriesLimited investigationFinal reportCessna 152 · Glendale, AZThe student pilot's improper flare and recovery from the ensuing bounced landing.NTSB LAX93LA331Accident · Serious injuriesLimited investigationFinal reportUltimate 10-80 · Chandler, AZThe noncertificated pilot's failure to follow the prescribed VFR procedures and poor visual lookout. The other aircraft pilot's restricted visual lookout was a factor in this accident.NTSB FTW93LA243Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Lafayette, LAThe engine failure for undetermined reasons. A factor was the lack of suitable terrain onto which a forced landing could be executed.NTSB CHI93LA333Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Custer Park, ILFuel contamination of unknown origin, that resulted in fuel system blockage and fuel starvation. A related factor was: high obstructions near the end of the runway.NTSB CHI93DEP04Accident · No injuriesFinal reportJordi, Ronald H. Challenger II · Plymouth, WIthe loss of engine power for undetermined reason(s).NTSB CHI93DEC01Accident · Minor injuriesFinal reportBradford Pietenpol Skyscout · Eaton Rapids, MIthe pilot's failure to maintain airspeed which resulted in an inadvertant stall. Factors related to the accident were the low altitude and the restricted movement of the carburetor needle.NTSB ATL93LA146Accident · No injuriesLimited investigationFinal reportCessna 150H · Monroe, NCWas the pilot's failure to determine actual fuel consumption enroute. A factor was inadequate supervision by the instructor pilot.NTSB ATL93LA145Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Hilton Head Is, SCA loss of engine power for undetermined reasons.NTSB ANC93LA156Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Galbraith Lake, AKThe pilots improper preflight planning/preparation. A factor was the unfavorable wind.NTSB ANC93LA155Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Jay Creek, AKThe pilot's selection of unsuitable terrain on which to land.NTSB NYC93LA164Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5B · Westerly, RIThe loss of engine power for undetermined reasons, and the subsequent forced landing and collision with soft terrain.NTSB MIA93LA179Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Rome, MSLoss of engine power for an undetermined reason. A factor related to the accident was: failure of the pilot to use all available runway for takeoff.NTSB MIA93FA180Accident · 2 fatalField investigationFinal reportGlasair SH-2F · Ocala, FLThe pilot-in-command's failure to maintain airspeed (vso) during a forced landing, resulting in an in-flight loss of control (stall), and subsequent in-flight collision with terrain. Contributing to the accident was the pilot-in-command's improper positioning…NTSB CHI93LA328Accident · Minor injuriesLimited investigationFinal reportChampion 7GCAA · Wilber, NEthe loss of engine power for an undetermined reason.NTSB CHI93FA329Accident · 2 fatalField investigationFinal reportCessna 310N · Rockford, ILan arcing electrical relay (solenoid) and subsequent overheating/fire of the starter wiring and adjacent fuel lines.NTSB CHI93DTG03Accident · No injuriesFinal reportPiper PA-25-235 · Washburn, NDthe loss of engine power due to a magneto failure.NTSB NYC93LA163Accident · No injuriesLimited investigationFinal reportCessna 172 · Hope Valley, RIThe engine failure as the result of ingestion of pieces of carburetor into the cylinders, and the subsequent forced landing and nose over during the landing roll after encountering soft terrain.NTSB LAX93LA330Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Showlow, AZA total loss of engine power due to a separation of the mixture control balljoint assembly at the carburetor mixture arm and subsequent forced landing.NTSB LAX93LA329Accident · No injuriesLimited investigationFinal reportPiper PA-34-220 · Pacific Ocean (Pacific Ocean)The loss of oil pressure to both engines for undetermined reasons.NTSB CHI93LA330Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Point Lookout, MOThe pilot's failure to attain the proper touchdown Point.NTSB ANC93FA152Accident · Minor injuriesField investigationFinal reportDe Havilland DHC-3 · Nikabuna Lake, AKFluid, fuel starvation as a result of the pilot-in-command's improper in-flight planning/decision. A factor in the accident was the operator's inadequate flight time and fuel upload record keeping.NTSB SEA93LA177Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Cheyenne, WYAn undetermined loss of engine power.NTSB SEA93FA178Accident · No injuriesField investigationFinal reportEnstrom F-28C · Seattle, WAShorted magneto condensers. Factors include a hidden obstruction in the landing area, and a reduction in rotor RPM from attempting to avoid the obstruction.NTSB NYC93LA162Accident · No injuriesLimited investigationFinal reportCessna 150 · Mcgaheysville, VAThe flight instructor's inadequate supervision resulting in a delayed go-around.NTSB NYC93LA161Accident · Serious injuriesLimited investigationFinal reportBeech A23 · Morgantown, WVThe pilot's failure to follow IFR procedures in which he descended below the decision height without visual detection of the runway. Factors are the fog conditions, trees and the pilot's inattention to altitude.NTSB MIA93T#A04Accident · No injuriesClass 3Final reportMcdonnell Douglas 369E · Jacksonville, FLNTSB MIA93LA178Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Benton, MSThe pilot-in-command's failure to maintain proper visual outlook.NTSB MIA93LA177Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Punta Gorda, FLThe pilot-in-command's improper use of the flight controls (cyclic and collective pitch) during a simulated autorotation with turn, resulting in an in flight collision with terrain with the tail skid and tailrotor blades.NTSB LAX93LA327Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Dos Palos, CAThe failure of the master rod which resulted in a complete loss of engine power and subsequent forced landing. The irrigation ditch was a factor in this accident.NTSB DCA93RA060Accident · Serious injuriesClass 1 · ForeignDouglas DC-8-61 · Guantanamo Bay, CubaNTSB ATL93LA144Accident · No injuriesLimited investigationFinal reportCessna 152 · Cleveland, TNThe pilot's failure to maintain directional control of the airplane while taxiing.NTSB ANC93LA153Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Little Delta Rv, AKThe pilot's failure to maintain control of the airplane during the takeoff climb. Factor was the gusty winds.NTSB ANC93LA151Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Goose Bay, AKThe loss of engine power due to fuel starvation. A factor in the accident was the inadequate installation information supplied with the STC for the engine upgrade.NTSB SEA93FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna 182L · Missing, WAUndetermined.NTSB NYC93FA159Accident · 2 fatalField investigationFinal reportSwearingen SA-226-TC · Hartford, CTFailure of the copilot (second-in-command) to follow the checklist, assure the gear was extended for landing and attain or maintain adequate airspeed (VMC); and failure of the pilot-in-command (PIC) to properly supervise the flight and take sufficient…NTSB MIA93LA181Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Delray Beach, FLThe pilot-in-command's/flight instructor failure to communicate his intentions with the student pilot to effect a positive transfer of the flight controls, and improper handling of the airplane on landing roll out, resulting in an on ground collision with a…NTSB LAX93LA326Accident · Serious injuriesLimited investigationFinal reportPilatus B4-PC11AF · Truckee, CAFailure of the pilot to conduct adequate preflight checks which resulted in the glider taking off with a frayed release hook cable, the pilot's failure to maintain airspeed, and the inadvertent stall.NTSB LAX93LA325Accident · No injuriesLimited investigationFinal reportGlassair SH-2R · Bakersfield, CAThe improper maintenance by the pilot the night before the accident which resulted in an oil line leak near the airplane's exhaust system.NTSB FTW93IA242Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B16 · San Antonio, TXThe fracture of the rudder quadrant due to stress corrosion. A factor was the manufacturer's improper selection of material.NTSB DEN93LA104Accident · No injuriesLimited investigationFinal reportCessna 152 · Carr, COFailure of the pilot in command to maintain directional control of the aircraft during landing roll. Factors were the pilot disregarding the tailwind, and rough and uneven terrain off the side of the runway.NTSB CHI93LA326Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Marshall, MNThe pilot's improper decision to depart after receiving a weather briefing which forecasted IMC en route and his loss of aircraft control due to spatial disorientation.NTSB CHI93LA325Accident · No injuriesLimited investigationFinal reportCessna 152-II · Keokuk, IAthe loss of engine power due to an exhaust valve failure. A factor related to the accident is the power line.NTSB ANC93T#A05Incident · No injuriesClass 3Final reportBell BH-206B · Kantishna, AKNTSB MIA93LA176Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Immokalee, FLThe pilot-in-command's failure to maintain airspeed (vs) while maneuvering resulting in a stall/mush.NTSB MIA93LA175Accident · Serious injuriesLimited investigationFinal reportRotec Engineering Rotec Rally 3 · Jay, FLFailure of the pilot in command to maintain airspeed (vs), inadvertent stall/mush by the pilot in command, and altitude insufficient for recovery. Contributing to the accident was lack of total experience by the pilot in command and in flight encounter with…NTSB LAX93LA322Accident · Serious injuriesLimited investigationFinal reportCessna 182C · Tinian (Pacific Ocean)the pilot's failure to retract the flaps during the initial climb, and, his failure to maintain an adequate airspeed, which led to an inadvertent stall.NTSB FTW93LA241Accident · No injuriesLimited investigationFinal reportCessna 140 · Bastrop, LAThe pilot's failure to maintain directional control and his improper compensation for existing wind conditions. Factors were the crosswind and the pilot's lack of total experience in the type of aircraft.NTSB FTW93LA240Accident · No injuriesLimited investigationFinal reportCessna 177B · Houston, TXEngine power loss due to fuel exhaustion for undetermined reasons. Factors were the pilot's failure to monitor and recalculate fuel consumption en route and the lack of suitable terrain onto which the forced landing could have been executed.NTSB BFO93WA145Accident · 1 fatalForeign investigationCessna 208B · Valensol, France