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 ATL94LA069Accident · Minor injuriesLimited investigationFinal reportCessna 150L · N. Myrtle Beach, SCThe improper procedures used by ground personnel during banner tow operations.NTSB ATL94LA068Accident · No injuriesLimited investigationFinal reportBeech C23 · Dahlonega, GAThe poor in-flight decision by the pilot to divert his attention from the runway on short final in order to retrieve a flashlight.NTSB ANC94LA042Accident · Minor injuriesLimited investigationFinal reportBell 206B · Wrangell, AKThe pilot-in-command's failure to assure that he had the proper clearance from obstructions prior to landing on the platform. A factor in the accident was the high obstruction (tree strump).NTSB NYC94LA073Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G109B · Nashua, NHThe certified flight instructor's delay in taking remedial action, which resulted in the motor-glider colliding with trees.NTSB MIA94LA100Accident · Serious injuriesLimited investigationFinal reportBell 206L · Orlando, FLThe pilot's failure to cross-check a faulty engine speed indication with other engine performance indications to verify whether an engine malfunction had actually occurred, and his failure to maintain adequate rotor RPM during an emergency landing. The…NTSB CHI94LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Dubuque, IAthe student pilot's improper recovery from a bounced landing. The student pilot's lack of total flight experience was a factor.NTSB ATL94LA070Accident · No injuriesLimited investigationFinal reportMooney M20J · Muscle Shoals, ALWas the loose throttle cable, and the pilot's failure to abort the takeoff when the engine did not produce full power. A factor was the inadequate maintenance inspection of the engine.NTSB SEA94LA090Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Driggs, IDDirectional control was not maintained. A factor to the accident was: inadequate remedial action.NTSB NYC94LA072Accident · Serious injuriesLimited investigationFinal reportRandolph Flagg Boredom Fighter · Norridgewock, METhe loss of engine power for undetermined reasons.NTSB NYC94LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Amherst, MAThe student pilot's inadvertently becoming lost, and the subsequent precautionary landing in a field, resulting in a collision with soft terrain and nose over.NTSB LAX94LA173Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Santa Maria, CAAn engine failure due to the improper installation and service of an incorrect model magneto by maintenance personnel, and the failure of the pilot-in-command to follow published airplane emergency procedures.NTSB LAX94LA172Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Simi Valley, CAThe student pilot's improper hovering autorotation by allowing the helicopter to drift laterally and rearward, resulting in the helicopter rolling over during touchdown, and the flight instructor's inadequate supervision of the flight.NTSB CHI94LA122Accident · No injuriesLimited investigationFinal reportCessna 172P · Wheeling, ILthe pilot's inadequate compensation for wind conditions. A factor associated with the accident was the crosswind.NTSB CHI94FA113Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Chesterfield, MOsuicide by the pilot.NTSB ATL94LA067Accident · 1 fatalLimited investigationFinal reportCessna 140 · Celina, TNThe pilot's failure to maintain a proper altitude, and his failure to maintain clearance from the transmission wire.NTSB FTW94LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Rayville, LAThe pilot's failure to maintain adequate airspeed during the turn to final approach.NTSB CHI94FA330Accident · 1 fatalField investigationFinal reportBell 47G-5A · Wisconsin Rpds, WIUndetermined.NTSB SEA94LA089Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Gillette, WYProcedures/directives were not followed and partial failure of the landing gear selector switch. A factor to the accident was an inoperative gear warning system.NTSB MIA94FA098Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Sarasota, FLFailure of the pilot(s) to maintain control of the airplane due to spatial disorientation. Factors related to the accident were: A malfunction that resulted in a loss of normal radio transmission, and the pilot(s) lack of recent experience in this make and…NTSB CHI94LA121Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Ellsworth, NEthe jammed impulse coupling on the left magneto which caused the crankshaft drive gear to shear from the crankshaft.NTSB CHI94LA119Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · New Richmond, WIthe failure of the pilot to maintain directional control.NTSB CHI94LA118Accident · No injuriesLimited investigationFinal reportCessna TU206B · Canton, ILthe pilot's inadequate compensation for wind conditions. A factor associated with the accident was the crosswind.NTSB ANC94GA041Accident · Minor injuriesFinal reportGrumman G21A · Mt. Fairweather, CanadaThe pilot's improper decision in attempting to outclimb the rising terrain with the existing airplane climb performance. Factors which contributed to the accident were: the pilot's inadequate preflight of the airplane, the over maximum gross weight of the…NTSB NYC94LA070Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Albion, NYthe pilot's loss of directional control during the landing roll, and the subsequent collision with soft terrain and nose over. Factors related to the accident were: the snowbanks on either side of the runway, and the pilot's lack of recent flight experience.NTSB NYC94LA069Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Batavia, OHThe loss of engine power as the result of a fractured cylinder head.NTSB LAX94FA171Accident · 2 fatalField investigationFinal reportCessna 206 · Show Low, AZthe pilot's intentional VFR flight into known adverse IMC weather conditions. Inadequate preflight planning, dark night operations, and weather conditions that included low ceilings and mountain obscuration were factors in the accident.NTSB FTW94LA109Accident · No injuriesLimited investigationFinal reportCessna 175 · Leesville, LAThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB CHI94LA120Accident · No injuriesLimited investigationFinal reportDefelici Kitfox III · Oxford, IAthe failure of the pilot-in-command (CFI) to maintain directional control. A factor related to the accident was the inadvertent interference with the flight controls by the student pilot.NTSB CHI94LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Romeo, MIthe pilot's improper use of carburetor heat. A factor in the accident is weather conducive to the formation of carburetor ice.NTSB CHI94FA116Accident · Serious injuriesField investigationFinal reportCanadair CL=601-3A · Bassett, NEthe pilot in command's inadequate planning/decision making and inadequate preflight inspection after receiving a load of contaminated fuel. Related factors are the contaminated fuel, improper refueling by FBO personnel, and the dark night light conditions.NTSB SEA94LA087Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Dutch John, UTThe pilot's inadequate compensations for wind conditions. The gusty crosswind was a factor.NTSB NYC94GA066Accident · 1 fatalFinal reportHughes 369A · Northford, CTThe loss of engine power for undetermined reasons, and the pilot's failure to maintain rotor RPM during the forced landing autorotation, resulting in a loss of aircraft control and collision with trees. Also causal to the accident was the pilot's lack of…NTSB NYC94FA067Accident · 1 fatalField investigationFinal reportCessna 414 · Defiance, OHThe pilot's inadequate inflight decision and planning, which resulted in fuel exhaustion and the total loss of engine power.NTSB LAX94LA169Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Currie, NVthe pilot's poor weather evaluation and continued flight into instrument meteorological conditions. The snow, mountain obscuration, and icing conditions were factors in this accident.NTSB LAX94LA168Accident · Serious injuriesLimited investigationFinal reportFighter Rebuilders F-2G · Mesa, AZthe airplane sustained a total loss of power and an in-flight fire for undetermined reasons.NTSB FTW94LA107Accident · No injuriesLimited investigationFinal reportCessna 210L · Haskell, OKWas the loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA105Accident · No injuriesLimited investigationFinal reportCessna 150M · Steamboat Sprgs, COThe pilot's selection of too low an altitude in high mountainous terrain.NTSB FTW94FA102Accident · 4 fatalField investigationFinal reportTaylorcraft DCO-65 · San Antonio, TXThe failure of the pilot of the other aircraft to maintain adequate clearance during formation flight. A factor was the pilot's inadequate preflight planning and preparation regarding inflight formation procedures.NTSB ATL94LA066Accident · No injuriesLimited investigationFinal reportBoeing PT-17 · Chamblee, GAThe pilot's failure to compensate for the wind condition during landing. A factor is a tailwind.NTSB SEA94LA086Accident · No injuriesLimited investigationFinal reportCessna 182G · Belgrade, MTThe loss of engine power for undetermined reasons. The intentional ground loop and the fence were factors in the accident.NTSB SEA94FA085Accident · 2 fatalField investigationFinal reportDouglas DC-3C · Spokane, WAThe failure of the pilot-in-command to maintain airspeed. Factors to the accident were: cylinder fatigue, dark night and stall encountered.NTSB NYC94LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Fairfield, NJThe failure of the pilot to attain a proper touchdown, at the proper speed which resulted in an overrun and contact with a fence. A factor was the failure of the pilot to follow his initial air traffic instructions.NTSB NYC94FA065Accident · 2 fatalField investigationFinal reportPiper Aerostar 601P · Limerick, PAThe pilot's failure to ensure that ice was properly removed from the airplane before flight, possibly due to impairment of judgment caused by a prescription drug (valium) that was not approved for use while flying. Factors related to the accident were: the…NTSB NYC94FA064Accident · 1 fatalField investigationFinal reportSwearingen SA-26AT · Winchester, VAThe pilot's decision to operate the airplane with known deficiencies in the fuel quantity measuring system which resulted in a power loss due to fuel starvation, followed by improper emergency procedures which resulted in a loss of control inflight and…NTSB MIA94LA096Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Wimauma, FLThe failure of the person removing the chock to maintain sufficient clearance from the propeller. A contributing factor was the total lack of experience by person on ground.NTSB MIA94FA097Accident · 2 fatalField investigationFinal reportGrumman G-73T · Key West, FLFailure of the pilot-in-command to assure the bilges were adequately pumped free of water (adequately preflighted), which resulted in the aft center of gravity limit to be exceeded, and failure of the aircrew to follow the checklist. A factor related to the…NTSB FTW94LA111Accident · No injuriesLimited investigationFinal reportCessna 172M · Flippin, ARThe student pilot's premature flare and the resultant inadvertent stall.NTSB FTW94LA106Accident · No injuriesLimited investigationFinal reportCessna 172L · Buena Vista, COThe improper supervision of the instructor pilot. A factor was the loss of directional control by the student pilot.NTSB CHI94LA114Accident · No injuriesLimited investigationFinal reportCessna 150M · Independence, MOwere the premature lift-off, and the failure of the pilot to maintain control of the airplane.NTSB ANC94LA040Accident · No injuriesLimited investigationFinal reportCessna 180 · Eureka Lodge, AKThe pilot-in-command's selection of unsuitable terrain for a landing.