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 CHI94DTK01Accident · No injuriesFinal reportWeatherly 620 · Ridgeview, SDfuel starvation due to the pilot's improper fuel tank selection.NTSB ATL94LA105Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Foley, ALThe pilot's failure to maintain airspeed during the forced landing, resulting in an inadvertent stall and collision with the ground. The pilot's inadequate preflight and resultant improper positioning of the fuel selector were factors.NTSB ANC94LA058Accident · No injuriesLimited investigationFinal reportPiper J5A · Lake George, AKThe pilot's failure to maintain clearance from trees during takeoff. A factor in the accident was the bent gear leg.NTSB ANC94LA057Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Kenai, AKFuel exhaustion as a result of the student pilot-in-command's failure to refuel. The lack of suitable terrain for a forced landing was a factor.NTSB NYC94LA091Accident · No injuriesLimited investigationFinal reportCessna 305A · Franklin, VAThe loss of airplane directional control during landing as a result of a tire failure, and the subsequent collision with soft terrain.NTSB MIA94LA149Accident · Serious injuriesLimited investigationFinal reportBeech 65 · Pensacola, FLImproper installation of nuts on the nosewheel (split rim) through-bolts by unknown personnel, which resulted in a subsequent failure (separation of the wheel halves).NTSB MIA94FA148Accident · 2 fatalField investigationFinal reportCessna A150M · Indiantown, FLThe pilot's impairment of judgment and performance due to alcohol and drugs, which led to his improper planning/decision, and his failure to maintain adequate airspeed during a maneuver.NTSB LAX94LA223Accident · No injuriesLimited investigationFinal reportGrumman AA-1C · Torrance, CAa fatigue failure of the carburetor fuel inlet fitting. A fuel flow system modification and an inadequate annual inspection were factors in the accident.NTSB FTW94LA173Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Page, AZThe total loss of engine power for undetermined reason. A factor was the lack of suitable terrain at the pilot's disposal.NTSB CHI94LA170Accident · No injuriesLimited investigationFinal reportCessna 152 · Harlan, IAthe delayed remedial action by the flight instructor. A factor related to the accident was the wet runway surface.NTSB ANC94LA060Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Pilot Point, AKThe Pilot's failure to maintain control of the airplane during takeoff.NTSB MIA94LA147Accident · Minor injuriesLimited investigationFinal reportErcoupe 415D · Boynton Beach, FLInadvertent use of the mixture control while on final approach to land. Contributing to the accident was the separation of the mixture control cable from the carburetor.NTSB FTW94LA207Accident · No injuriesLimited investigationFinal reportCessna 182L · Mineola, TXThe pilot's delayed landing flare and his improper bounced landing technique.NTSB FTW94LA179Accident · No injuriesLimited investigationFinal reportBoeing B-75 · Deming, NMA loss of control on the ground due to the pilot's improper compensation for the crosswind. A factor was the crosswind.NTSB FTW94LA171Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Pottsboro, TXThe pilot's failure to determine, prior to landing at the airport, that the runway length would be inadequate for a safe takeoff, and his subsequent failure to follow the manufacturer's recommended short-field takeoff procedures. Factors in the accident were:…NTSB FTW94LA170Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob 6103 Twin Astir · Forrest City, ARThe pilot's loss of aircraft control when he diverted his attention to closing the canopy. A factor was his failure to properly close the canopy prior to takeoff.NTSB CHI94LA169Accident · No injuriesLimited investigationFinal reportCessna 150K · Jasonville, INthe loss of engine power due to fuel exhaustion as a result of an inadequate aircraft preflight inspection.NTSB CHI94LA168Accident · No injuriesLimited investigationFinal reportCessna 182B · Glencoe, MNcollision with a fence post during landing roll after an inadvertent landing at the wrong field.NTSB ATL94LA103Accident · Serious injuriesLimited investigationFinal reportFairchild M-62 · Hendersonville, NCThe failure of the pilot to maintain airspeed while maneuvering in the traffic pattern, resulting in an inadvertent stall.NTSB ATL94FA102Accident · 1 fatalField investigationFinal reportBeech A36 · Statesville, NCA LOSS OF CONTROL FOR UNDETERMINED REASON(s).NTSB SEA94LA127Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Princeton, IDInadvertent retarding of throttle by pilot. Factors include trees.NTSB SEA94LA126Accident · No injuriesLimited investigationFinal reportChristen Industries Husky · Ogden, UTThe pilot's inadequate compensation for wind condiitons. The wind gusts were a factor.NTSB SEA94LA125Accident · Serious injuriesLimited investigationFinal reportKelly Long EZ · Lindon, UTPiston failure and unsuitable terrain for a successful forced landing.NTSB SEA94FA124Accident · 2 fatalField investigationFinal reportRyan Navion L-17B · Olympia, WAAn inflight fire for an undetermined reason.NTSB SEA94FA123Accident · 2 fatalField investigationFinal reportBellanca 8GCBC · Challis, IDThe pilot's failure to maintain clearance from terrain.NTSB NYC94LA089Accident · 1 fatalLimited investigationFinal reportTownsend, H.L. Briegled BG-12A · Readington, NJThe pilot failed to maintain airspeed while maneuvering which resulted in an inadvertent stall/spin. A factor was the lack of experience in the make and model of glider.NTSB NYC94LA088Accident · 1 fatalLimited investigationFinal reportAeronca 11AC · Berwick, METhe pilot's inadequate preflight which fail to detect proper operation of the elevator which resulted in the loss of control inflight. A factor is inadequate maintenance which consisted of misrigging of the elevator flight controls.NTSB NYC94LA087Accident · No injuriesLimited investigationFinal reportLutz Acro Sport II · Hornell, NYThe pilot's failure to maintain a proper glidepath. A factor in this accident was the pilot's lack of total experience in this type of airplane.NTSB NYC94LA086Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Addison, NYThe pilot's improper inflight planning and decision, resulting in fuel exhaustion and the subsequent forced landing and collision with trees.NTSB NYC94LA085Accident · No injuriesLimited investigationFinal reportBeech A-24-R · Hamburg, NYThe pilot's failure to establish a positive climb rate, which resulted in an inflight collision with trees. Factors were a tailwind, the pilot's premature raising of the flaps, and his failure to do a go around.NTSB MIA94LA146Accident · No injuriesLimited investigationFinal reportMid State Ultra Light Challenger II · Islamorada, FLThe pilot-in-command's failure to maintain airspeed (VS) while landing in turbulent air resulting in an in-flight loss of control (inadvertent stall), and subsequent in-flight collision with terrain.NTSB LAX94LA222Accident · No injuriesLimited investigationFinal reportHillberg EH-101 · Corona, CAthe pilot's loss of control of the helicopter while hovering downwind. A lack of test-flight data to establish the aircraft's performance limitations was a factor in the accident.NTSB FTW94LA172Accident · Serious injuriesLimited investigationFinal reportCameron V-77 · Durango, COThe pilot did not attain a proper level off during landing. A downdraft which was encountered was a factor.NTSB FTW94LA169Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Bryan, TXThe pilot's failure to refuel resulting in a total loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94FA168Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Wingate, TXWas the pilot's failure to maintain proper alignment. Factors were the wind, and the pilot's improper corrections.NTSB CHI94LA167Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Wausaukee, WIthe pilot's inadequate preflight of the airplane.NTSB CHI94DCG01Accident · 1 fatalFinal reportDavis TRI-Q 200 · Joplin, MOLoss of engine power for undetermined reasons, and the pilot's failure to maintain control of the airplane. Factors which contributed to the accident were: the pilot intentionally operating an airplane with known deficiencies, his lack of experience in the…NTSB SEA94FA121Accident · 4 fatalField investigationFinal reportAero Commander 500A · Livermore, CAA fuel system leak, inadequate preflight by the pilot (PIC), and by the non-flying pilot/passenger intentionally allowing operation of the aircraft with a known deficiency (fuel leak). A factor related to the accident was: the lack of suitable terrain for a…NTSB LAX94LA221Accident · Minor injuriesLimited investigationFinal reportBell 206A · Ukiah, CAthe pilot's inadequate compensation for the existing wind conditions which resulted in a loss of tail rotor effectiveness event and a subsequent loss of directional control.NTSB FTW94LA175Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Del Rio, TXFuel starvation induced power loss due to an exhaust system leak resulting in an electrical system inflight fire in the area of the fuel pump. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA174Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Stuttgart, ARWas the pilots failure to maintain terrain clearance.NTSB CHI94LA166Accident · Serious injuriesLimited investigationFinal reportGrumman G-164 · Hillsboro, NDthe pilot's failure to maintain clearance from a tree.NTSB CHI94LA165Accident · No injuriesLimited investigationFinal reportBurkhart Grob BG 103 · Ionia, MIa hard landing as a result of the early disconnect of the glider launch/tow equipment.NTSB ATL94LA104Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Memphis, TNThe pilot's failure to maintain clearance from the earthen dike during the swath run.NTSB SEA94LA122Accident · 1 fatalLimited investigationFinal reportVickers Spitfire Mark Xviii · Great Falls, MTThe pilot's failure to maintain aircraft control while in instrument meteorological conditions (IMC). Factors include the pilot's poor inflight decision to attempt an IMC climb in an aircraft not certified for instrument flight rules (IFR) operation, and his…NTSB SEA94LA120Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Rio Linda, CAThe pilot's improper mixture leaning procedure. Factor(s) were: the disconnected ignition lead, dark night conditions, unsuitable terrain and the fence.NTSB MIA94LA144Accident · Minor injuriesLimited investigationFinal reportBell 206B · St. Petersburg, FLThe failure of the number five bearing, shaft, or thomas coupling for undetermined reasons. Contributing to the accident was the pilot-in-command's delayed response in conducting the emergency procedure by not reducing the throttle to idle position, and…NTSB LAX94LA220Accident · Minor injuriesLimited investigationFinal reportRobinson R22-B · Stockton, CAA failure of the pilot-in-command of a landing helicopter to maintain sufficient clearance from a second helicopter.NTSB FTW94LA182Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Boerne, TXThe pilot-in-command's inadequate supervision of his deplaning passenger.NTSB CHI94LA164Accident · No injuriesLimited investigationFinal reportBeech B23 · Faribault, MNa hard landing as a result of the flight instructor's delayed remedial action. A factor associated with the accident is the student pilot's improper flair.