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 ANC91LA159Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Dry Bay, AKThe pilot failed to maintain adequate airspeed and stalled the airplane. Contributing to the accident was the unsuitable terrain on which the pilot chose to land.NTSB ANC91LA136Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Aspen Creek, AKThe partial loss of power for undetermined reasons and the rough terrain.NTSB NYC91LA221Accident · No injuriesLimited investigationFinal reportGrumman AA5B · Hampton, NHThe pilot rotated the airplane prematurely, resulting in an inadvertent stall at too low an altitude to allow recovery. Factors related to the accident were, the pilot's complacency, failure to determine the airplane's performance capabilities prior to take…NTSB MIA91LA204Accident · Serious injuriesLimited investigationFinal reportBellanca 7EA · Venice, FLThe pilot's loss of control of the airplane on takeoff ground roll due to his lack of experience and flight time in this type of airplane. A contributing factor is an on-ground encounter with a crosswind.NTSB LAX91LA371Accident · No injuriesLimited investigationFinal reportCessna 152 · Avalon, CAA loss of engine power for undetermined reasons and subsequent ditching while flying over the ocean.NTSB LAX91LA370Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Wallace, CAThe pilot's failure to properly align his airplane with the runway and his failure to maintain directional control during takeoff. Contributing factors related to the presence of rough and downhill terrain adjacent to the runway.NTSB LAX91LA369Accident · No injuriesLimited investigationFinal reportHiller UH12D · Sparks, NVThe encounter with rough, unsuitable terrain during a precautionary landing. Contributing to the accident was the pilot's decision to make an autorotation after encountering an airframe vibration.NTSB FTW91FA158Accident · Serious injuriesField investigationFinal reportBeech K35 · Tulsa, OKTotal power loss due to failure of the crankshaft bearings and connecting rod cap bolts resulting from the maintenance facilities' failure to overhaul the engine. A factor was the lack of suitable terrain for the forced landing.NTSB DEN91LA118Accident · No injuriesLimited investigationFinal reportLet L-13 · Aspen, COThe pilot turning off the runway with excessive speed.NTSB CHI91LA271Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Saginaw, MIDirectional control was not maintained by the pilot which resulted in a ground loop. A factor related to the accident was a crosswind.NTSB ANC91LA135Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Mystic Pass, AKThe pilot lost control of the airplane. Contributing to the accident was unfavorable wind and turbulence.NTSB ANC91LA134Accident · No injuriesLimited investigationFinal reportCessna T-207A · Coville Lake, AKA total failure of the power output shaft bolts due to fatigue. Contributing to the accident was the rough and uneven terrain.NTSB ANC91LA133Accident · No injuriesLimited investigationFinal reportBeech B-18H · White Mountain, AKThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB SEA91LA221Accident · Minor injuriesLimited investigationFinal reportCessna C-210L · Cheyenne, WYMaintenance personnel did not perform a proper top overhaul. This resulted in engine failure due to the failure of a connecting rod bearing. Factors include the hard landing resulting from the premature landing flare by the pilot.NTSB NYC91LA220Accident · Minor injuriesLimited investigationFinal reportDouglas DC-3 · Apple Creek, OHImproper planning/decision by the pilot(s), and improper use of the fuel system/fuel selector. The location of trees was a related factor.NTSB NYC91LA219Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Meadville, PAEngine failure resulting from the fatigue failure of the number 2 cylinder exhaust valve and the subsequent forced landing at night. A factor related to the accident was the restricted visibility.NTSB LAX91LA375Accident · Serious injuriesLimited investigationFinal reportBeierle Thunder Gull J · Santa Margarita, CAThe failure of the wing spar when the design limits of the airplane was exceeded by the pilot. Contributing to the accident was an inadequate airframe design and an abrupt movement of the flight controls by the pilot.NTSB LAX91LA373Accident · No injuriesLimited investigationFinal reportCessna 152 · Montague, CAThe pilot's improper flare and improper go-around procedure. Contributing to the accident was the lack of total pilot experience.NTSB LAX91LA372Accident · No injuriesLimited investigationFinal reportCessna 182 · Columbia, CAThe pilot of the aircraft experienced a bounced landing on his initial landing attempt. He executed a go-around and landed without incident on the second attempt. Substantial damage to the firewall was discovered afterwards. The pilot believes the bounced…NTSB LAX91FA366Accident · Serious injuriesField investigationFinal reportPiper PA-32RT-300 · Van Nuys, CA(1) The pilot's improper preflight preparation; (2) the pilot's failure to follow the airplane manufacturer's performance data by his selection of an improper flap position for takeoff; and (3) the pilot's choice of a runway too short for a safe takeoff.…NTSB FTW91LA156Accident · No injuriesLimited investigationFinal reportCessna 150J · Tomball, TXAn improper recovery from a bounced landing.NTSB FTW91LA154Accident · No injuriesLimited investigationFinal reportBell L4 Experimental · Arlington, TXThe pilot's failure to maintain adequate rotor RPM during the planned autorotation and his improper touchdown.NTSB CHI91LA270Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Watertown, SDAttempted formation flying with N4535E by the pilot of N16098. Factors associated with the collision were: nonperformance of preflight planning, and failure to follow procedures and directives by the pilot of N16098.NTSB SEA91FA220Accident · 3 fatalField investigationFinal reportBellanca 17-30A · Arlington, WYThe loss of engine power for an undetermined reason. Factors contriubting to the accident were trees and the pilot's failure to maintain adequate clearance above the trees.NTSB NYC91LA223Accident · No injuriesLimited investigationFinal reportCessna 150 · Ashland, METhe pilot's premature liftoff. Factors were the rough airstrip and the soft terrain encountered during landing.NTSB NYC91FA218Accident · 1 fatalField investigationFinal reportCessna 150M · Marlboro, NJThe pilot's improper aircraft handling which resulted in an inadvertent stall and loss of control at an altitude insufficient for recovery. Factors related to the accident were an engine failure due to fuel exhaustion and improper preflight preparation.NTSB MIA91WA203Accident · No injuriesForeign investigationCessna 172N · Nassau, BahamasNTSB LAX91LA367Accident · No injuriesLimited investigationFinal reportCessna R182 · Fredonia, AZFailure of the carburetor mixture control, resulting in loss of engine power. A factor related to the accident was: lack of compliance with marvel-schebler service bulletin (sb) #A1-78.NTSB FTW91LA153Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Haskell, OKImproper installation of avionics equipment resulting in interference with flight control.NTSB FTW91LA152Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Ward, ARThe pilot's failure to maintain directional control.NTSB CHI91LA272Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Freeburg, ILImproper use of the mixture control by the pic/cfi. A factor related to the accident was inadequate friction on the mixture control lever.NTSB CHI91DCJ07Accident · No injuriesFinal reportPiper PA-25-150 · Stapleton, NEThe pilot's disregard for aircraft performance data. Related factors are the pilot's poor weather evaluation, and delayed remedial action.NTSB ANC91FA132Accident · 3 fatalField investigationFinal reportCessna 172 · Eklutna Lake, AKThe pilot's failure to maintain terrain clearance. Contributing to the accident was the high terrain.NTSB SEA91LA218Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Mead, WAImproper preflight planning by the pilot, and the pilot's delay in aborting the takeoff. Factors related to the accident were: the high temperature and unfavorable wind condiiton.NTSB SEA91IA219Incident · Minor injuriesIncident investigationFinal reportBoeing 747-151 · Seattle, WAA fire in the number 4 engine, resulting from a fuel leak at the main fuel control unit, due to improper maintenance by unknown/undetermined person. The L5 emergency exit failed to operatee due to a broken plastic pulley guard in the slide release mechanism.NTSB NYC91LA222Accident · No injuriesLimited investigationFinal reportCessna T-210-M · Clearfield, PAVapor lock of the fuel system resulting in fuel starvation. A factor related to the accident was the failure of the owner to comply with a service letter calling for insulated fuel lines forward of the fire wall.NTSB NYC91LA216Accident · No injuriesLimited investigationFinal reportCessna TU206G · Block Island, RIImproper planning/decision by the pilot by electing to takeoff with a known deficiency with the equipment. The deficiency (cracked/leaking float) was a related factor.NTSB CHI91LA269Accident · No injuriesLimited investigationFinal reportCessna 172E · Harbor Springs, MIThe pilot's failure to adequately compensate for wind conditions. A factor associated with the accident was his delay in initiating the go-around.NTSB ANC91LA131Accident · No injuriesLimited investigationFinal reportCessna 206 · Funnel Lake, AKThe pilot's failure to attain proper airspeed. Contributing to the accident was the high wind encountered during takeoff and the terrain.NTSB SEA91LA217Accident · Serious injuriesLimited investigationFinal reportBeech B24R · Shady Cove, ORImproper re-installation of an oil line by maintenance personnel, which resulted in an oil leak from a loose line and subsequent seizure of the engine. Uneven terrain in the emergency landing area was a related factor.NTSB MIA91LA200Accident · No injuriesLimited investigationFinal reportCessna 152 · Marianna, FLThe student pilot's failure to maintain proper airspeed during landing and failure to execute a go-around in a timely manner.NTSB MIA91IA201Incident · No injuriesIncident investigationFinal reportPiper PA-28-140 · Clearwater, FLTotal loss of engine power due to fuel starvation caused by improper fuel tank selector position by the pilot-in-command. Contributing to the incident was the pilot's total lack of experience.NTSB FTW91LA151Accident · Minor injuriesLimited investigationFinal reportBeech A23-24 · Tomball, TXThe total loss of engine power for undetermined reasons. A factor in the accident was the unsuitable terrain at the pilot's disposal.NTSB CHI91LA268Accident · No injuriesLimited investigationFinal reportCessna 150 · St. Clair, MODirectional control was not maintained by the pilot.NTSB SEA91LA215Accident · No injuriesLimited investigationFinal reportCessna 172N · Everett, WAThe student pilot's failure to maintain directional control. A factor related to the accident was: the taxiway marker's lack of frangibility due to its construction.NTSB SEA91FA216Accident · 4 fatalField investigationFinal reportPilatus Britten-Norman BN-2A-26 Islander · Ketchikan, AKThe pilot's attempting to operate VFR in instrument meteorological conditions. Factors contributing to the accident were upsloping terrain in the aircraft's flight path as well as weather conditions resulting in an obscuration of the terrain.NTSB NYC91LA215Accident · Minor injuriesLimited investigationFinal reportBeech E18S · Martinsville, OHA failure of one engine for undetermined reasons. Additionally, the heavy gross weight resulted in inadequate single engine performance, which lead to a forced landing.NTSB LAX91LA363Accident · Minor injuriesLimited investigationFinal reportBell 47G · Kettleman City, CAA non-mechanical loss of engine power due to fuel exhaustion by the pilot's improper calculation of the fuel supply and subsequent hard landing.NTSB FTW91LA148Accident · No injuriesLimited investigationFinal reportBeech B19 · Poteau, OKThe improper flare technique utilitzed by the pilot under instruction. A factor was the failure of the check pilot to intervene.NTSB FTW91FA149Accident · 2 fatalField investigationFinal reportCessna 150K · Waller, TXThe instructor pilot's failure to take remedial action during stall/spin training. Factors were the instructor's overconfidence in his personal ability and the student's apprehension of stalls.