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 SEA91LA096Accident · No injuriesLimited investigationFinal reportCessna 150J · Mulino, ORThe pilot's inadequate remedial action. Factors include nose-gear vibration.NTSB NYC91LA124Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1124A · Oxford, CTThe failure of the pilot to maintain the proper landing descent rate and the resultant right main landing gear assembly collapse.NTSB LAX91LA189Accident · No injuriesLimited investigationFinal reportPiper PA 38-112 · Fresno, CAThe pilot-in-command's failure to maintain directional control and inadequate compensation for wind conditions during the landing touchdown. Contributing to the accident was the pilot-in-command's overconfidence in his ability while analyzing the forecast…NTSB FTW91LA071Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Longview, TXFuel exhaustion resulting in a complete power loss due to the pic/cfi's failure to refuel at intermediate destinations.NTSB DEN91LA066Accident · Minor injuriesLimited investigationFinal reportCessna 421 · Englewood, COPower loss on both engines as a result of exhaust system failure.NTSB DEN91FA065Accident · 1 fatalField investigationFinal reportPiper PA-31B-310 · Bennett, COIn-flight separation of the left engine cowl assembly that was not properly latched, and failure of the pilot to maintain minimum control speed, which resulted in his loss of aircraft control. Factors related to the accident were: an inadequate preflight…NTSB BFO91LA046Accident · Minor injuriesLimited investigationFinal reportCessna 310D · Christiansburg, VAInadequate maintenance. Contributing was an obstructed air filter.NTSB ATL91LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · Hampton, GAThe pilot's improper flare and his failure to execute an abort in a timely manner when a safe landing was not possible. Factors in the accident were the wet grass conditions at the airstrip, and the pilot's lack of recent total flying experience.NTSB MIA91LA131Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Vero Beach, FLFailure of the PA-28 pilot to maintain proper brake pressure, while diverting his attention to his notepad.NTSB NYC91IA133Incident · No injuriesIncident investigationFinal reportBoeing 747SP · Churchville, NYA failure of the sixth rotating airseal which led to an uncontained engine failure.NTSB LAX91LA188Accident · Serious injuriesLimited investigationFinal reportEnstrom F28C · Palm Springs, CAInadequate inspection of the fuel system resulting in an engine power loss and inflight fire due to a loose fuel connection.NTSB LAX91LA187Accident · No injuriesLimited investigationFinal reportBeech F33A · Goodyear, AZThe pilot's failure to ensure that the airplane's landing gear was extended by the passenger who he was allowing fly the airplane. A contributing factor related to the pilot's inadequate supervision of the passenger.NTSB NYC91FA123Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Hancock Village, NYThe loss of aircraft control and subsequent collision with trees after the pilot became physically incapacitated.NTSB MIA91LA130Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Leesburg, FLThe failure of the pilot to maintain directional control during the landig roll, and his failure to maintain airspeed during the attempted go-around which resulted in a descent and collision with two parked airplanes. Contributing to the accident was the…NTSB LAX91LA186Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Madera, CAFailure of the pilot to maintain adequate clearance from the guy wire.NTSB LAX91LA184Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Redlands, CAThe pilot's inadequate compensation for wind conditions and failure to maintain directional control.NTSB BFO91LA045Accident · No injuriesLimited investigationFinal reportGrumman AA5B · College Park, MDThe pilot's failure to maintain aircraft control. Related factors were: hydroplaning conditions on the wet runway and the pilot's lack of recent experience.NTSB SEA91FA095Accident · 1 fatalField investigationFinal reportCessna 150H · Sumpter, ORThe pilot's improper inflight planning and decisions and the pilot's VFR flight into IMC conditions.NTSB NYC91LA122Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-180 · Jessup, PAA power loss due to oil starvation for unknown reasons, over unsuitable terrain.NTSB NYC91LA121Accident · No injuriesLimited investigationFinal reportCessna 172 · Meadville, PAThe improper use of carburetor heat control by the pilot, which resulted in the total loss of engine power and the subsequent emergency forced landing in rough terrain. A factor relating to the accident was the lack of experience of the student pilot.NTSB MIA91LA129Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Winter Haven, FLFailure of the pilot to maintain directional control and improper use of the collective and cyclic flight controls after the loss of tail rotor effectiveness during the approach to land. Contributing to the accident was his lack of total experience in type…NTSB MIA91LA128Accident · 1 fatalLimited investigationFinal reportDonald L. Hedeman SONERAI-II · Jacksonville, FLThe pilot's improper adjustment of the carburetor.NTSB MIA91LA127Accident · No injuriesLimited investigationFinal reportTravel Air 2000 · Homestead, FLAn on ground encounter with weather conditions that were favorable for carburetor icing at a low power setting (glide power), and failure of the pilot to abort the takeoff after recognizing that the eng was not developing full power during the initial climb.NTSB LAX91LA185Accident · No injuriesLimited investigationFinal reportCessna 182B · Arvin, CA1) The pilot inadequately compensated for wind conditions; 2) the pilot's improper inflight decision; and 3) the pilot not attaining the proper landing touchdown point.NTSB LAX91LA183Accident · No injuriesLimited investigationFinal reportCessna 172N · Grass Valley, CAThe failure of the pilot to maintain directional control and to adequately compensate for the wind conditions resulting in an on ground loss of control and subsequent on ground collision with a drainage ditch.NTSB FTW91LA064Accident · Minor injuriesLimited investigationFinal reportBell 47G4 · Corpus Christi, TXThe initial restricted movement and eventual locking of the cyclic control as a result of the failure of the lateral servo. A factor was the installation of the failed component by an unqualified person.NTSB SEA91LA094Accident · No injuriesLimited investigationFinal reportCessna 180 · Vernal, UTThe pilot's impairment due to alcohol consumption and his failue to control the airplane during landing.NTSB CHI91LA145Accident · No injuriesLimited investigationFinal reportAeronca 7EC · O'Neill, NEThe pilot's selection of unsuitable terrain for a precautionary landing. Factors were the pilot's disregarding the weather briefing and his intentional flight into adverse weather.NTSB CHI91LA141Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Evansville, WIThe pilot's selection of unsuitable terrain for landing, not maintaining directional control and attempting a go-around without sufficient airspeed. A factor was the rutted runway surface.NTSB CHI91LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Hibbing, MNThe student pilot's improper flare of the airplane and the cfi's failure to maintain directional control during the recovery. A factor was the soft terrain.NTSB CHI91LA139Accident · No injuriesLimited investigationFinal reportCessna 172 · Detroit, MIThe proper touchdown point was not attained and the pilot failed to perform a go around. A factor related to the accident was the tailwind condition in which the pilot was attempting to land.NTSB CHI91IA144Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Chicago, ILThe failure of the ground crew to properly align the airplane in the gate alley during the push back from the gate.NTSB CHI91FA140Accident · 1 fatalField investigationFinal reportCessna P210 · Kansas City, MOThe pilot in command's intentional flight with known mechanical deficiencies in the aircraft which resulted in a fire & forced landing in unsuitable terrain. A factor contributing to the accident was improper maintenance to the turbocharger waste gate by…NTSB ATL91LA088Accident · 1 fatalLimited investigationFinal reportCessna 150J · Kure Beach, NCThe pilot's poor judgement, while impaired by alcohol, and his misjudgement of altitude/clearance above the water after initiating a low pass.NTSB MIA91FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-24-260 · Missing, FLUndetermined.NTSB CHI91LA143Accident · No injuriesLimited investigationFinal reportCessna 170A · Newell, SDThe pilot's improper aircraft handling.NTSB ATL91LA087Accident · No injuriesLimited investigationFinal reportCessna 150 · Copperhill, TNThe pilot's improper use of carburetor heat. A factor in the accident was the existing of carburetor icing conditions.NTSB NYC91FA120Accident · 1 fatalField investigationFinal reportPiper J5A · Newbury, MAThe loss of inflight control, which was the result of a jammed right aileron bellcrank assembly. Factors related to the accident were; the improper maintenance of the flight control system, and the incomplete preflight by the pilot.NTSB FTW91FA070Accident · 2 fatalField investigationFinal reportBell 206B · So. Marsh 275The inflight structural failure and separation of the vertical fin which led to a loss of control and mast bumping. The failure of the fin was due to inadequate corrosion control efforts by the operator.NTSB DEN91T#A01Accident · 2 fatalClass 3Final reportHughes TH-55 · Traskwood, ARNTSB CHI91LA138Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Millard, NEImproper use of APU by unknown personnel which resulted in the airplane's electrical wiring melting and subsequent short.NTSB CHI91LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Mccook, NEA poorly planned approach and inadequate visual lookout by the pilot.NTSB MIA91LA126Accident · 1 fatalLimited investigationFinal reportRudolph Zeller Lancair · Titusville, FLThe use of improper materials for construction of the alternate air door by the aircraft owner/builder resulting in failure and separation of the door which resulted in blockage of air flow to the carburetor and loss of all engine power.NTSB DEN91LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Steamboat Sprin, COThe CFI used poor judgement in giving a simulated engine failure by turning off the fuel selector valve.NTSB MIA91LA125Accident · 1 fatalLimited investigationFinal reportRutan Aircraft Factory Vari EZE · Panama City, FLThe pilot-in-command misjudged his altitude while conducting an aerobatic maneuver, resulting in an in flight collision with water.NTSB LAX91FA181Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Carpenteria, CA1) Inadequate weather evaluation by the pilot, 2) poor inflight decision to try and continue VMC flight, and 3) the pilot's lack of total experience.NTSB CHI91FA135Accident · Serious injuriesField investigationFinal reportPiper PA-24-250 · Wadsworth, ILThe pilot in command's failure to select the proper fuel tank and not performing emergency procedures when the engine ceased to run. A factor related to this accident was power transmissions wires located on the pilot's approach path to landing.NTSB SEA91LA093Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Elma, WAThe pilot used inadequate starting procedures. Factors to the accident were: the pilot did not use proper assistance and the passenger's inadvertent control interference.NTSB SEA91LA092Accident · Minor injuriesLimited investigationFinal reportSmelser KR-2 · Spokane, WAA failure of the fuel drain valve which resulted in fuel exhaustion and a loss of engine power.NTSB SEA91LA091Accident · 1 fatalLimited investigationFinal reportSchwartz Bushby MM-1 · Ephrata, WAThe pilot's loss of control after he initiated a maneuver at low altitude.