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.

NTSB CHI94DTK01Accident · No injuriesFinal reportWeatherly 620 · Ridgeview, SDfuel starvation due to the pilot's improper fuel tank selection.May 24, 1994 · N5296W · Substantial damageNTSB 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.May 24, 1994 · N5512P · Substantial damageNTSB 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.May 24, 1994 · N35395 · Substantial damageNTSB 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.May 24, 1994 · N94583 · DestroyedNTSB 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.May 23, 1994 · N5234G · Substantial damageNTSB 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).May 23, 1994 · N6166Y · Minor damageNTSB 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.May 23, 1994 · N9856J · DestroyedNTSB 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.May 23, 1994 · N9514U · DestroyedNTSB 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.May 23, 1994 · N1422E · Substantial damageNTSB 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.May 23, 1994 · N80812 · Substantial damageNTSB ANC94LA060Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Pilot Point, AKThe Pilot's failure to maintain control of the airplane during takeoff.May 23, 1994 · N99PJ · Substantial damageNTSB 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.May 22, 1994 · N93763 · Substantial damageNTSB FTW94LA207Accident · No injuriesLimited investigationFinal reportCessna 182L · Mineola, TXThe pilot's delayed landing flare and his improper bounced landing technique.May 22, 1994 · N42EM · Substantial damageNTSB 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.May 22, 1994 · N85289 · Substantial damageNTSB 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:…May 22, 1994 · N9687W · Substantial damageNTSB 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.May 22, 1994 · N156SS · Substantial damageNTSB 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.May 22, 1994 · N6039G · Substantial damageNTSB CHI94LA168Accident · No injuriesLimited investigationFinal reportCessna 182B · Glencoe, MNcollision with a fence post during landing roll after an inadvertent landing at the wrong field.May 22, 1994 · N7261E · DestroyedNTSB 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.May 22, 1994 · N61845 · DestroyedNTSB ATL94FA102Accident · 1 fatalField investigationFinal reportBeech A36 · Statesville, NCA LOSS OF CONTROL FOR UNDETERMINED REASON(s).May 22, 1994 · N1551K · DestroyedNTSB SEA94LA127Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Princeton, IDInadvertent retarding of throttle by pilot. Factors include trees.May 21, 1994 · N50WS · DestroyedNTSB SEA94LA126Accident · No injuriesLimited investigationFinal reportChristen Industries Husky · Ogden, UTThe pilot's inadequate compensation for wind condiitons. The wind gusts were a factor.May 21, 1994 · N103TB · Substantial damageNTSB SEA94LA125Accident · Serious injuriesLimited investigationFinal reportKelly Long EZ · Lindon, UTPiston failure and unsuitable terrain for a successful forced landing.May 21, 1994 · N8JE · Substantial damageNTSB SEA94FA124Accident · 2 fatalField investigationFinal reportRyan Navion L-17B · Olympia, WAAn inflight fire for an undetermined reason.May 21, 1994 · N1669Z · DestroyedNTSB SEA94FA123Accident · 2 fatalField investigationFinal reportBellanca 8GCBC · Challis, IDThe pilot's failure to maintain clearance from terrain.May 21, 1994 · N86980 · Substantial damageNTSB 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.May 21, 1994 · N6552N · DestroyedNTSB 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.May 21, 1994 · N3167E · DestroyedNTSB 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.May 21, 1994 · N5181V · Substantial damageNTSB 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.May 21, 1994 · N3335V · Substantial damageNTSB 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.May 21, 1994 · N8041R · Substantial damageNTSB 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.May 21, 1994 · UNREG · Substantial damageNTSB 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.May 21, 1994 · N10TE · Substantial damageNTSB 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.May 21, 1994 · N1992B · No damageNTSB 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.May 21, 1994 · N6372A · Substantial damageNTSB 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.May 21, 1994 · N8895W · DestroyedNTSB CHI94LA167Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Wausaukee, WIthe pilot's inadequate preflight of the airplane.May 21, 1994 · N7867H · Substantial damageNTSB 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…May 21, 1994 · N800Q · DestroyedNTSB 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…May 20, 1994 · N601MK · DestroyedNTSB 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.May 20, 1994 · N206HS · DestroyedNTSB 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.May 20, 1994 · N14773 · Substantial damageNTSB FTW94LA174Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Stuttgart, ARWas the pilots failure to maintain terrain clearance.May 20, 1994 · N9678 · Substantial damageNTSB CHI94LA166Accident · Serious injuriesLimited investigationFinal reportGrumman G-164 · Hillsboro, NDthe pilot's failure to maintain clearance from a tree.May 20, 1994 · N551Y · DestroyedNTSB 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.May 20, 1994 · N140BG · Substantial damageNTSB ATL94LA104Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Memphis, TNThe pilot's failure to maintain clearance from the earthen dike during the swath run.May 20, 1994 · N6816Q · Substantial damageNTSB 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…May 19, 1994 · N41702 · DestroyedNTSB 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.May 19, 1994 · N6747G · DestroyedNTSB 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…May 19, 1994 · N72Z · Substantial damageNTSB 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.May 19, 1994 · N140PH · 2 aircraft · Substantial damageNTSB FTW94LA182Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Boerne, TXThe pilot-in-command's inadequate supervision of his deplaning passenger.May 19, 1994 · N6504M · No damageNTSB 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.May 19, 1994 · N4016T · Substantial damage