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 BFO94LA020Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Rockland, ME1) The pilot's failure to maintain adequate rotor RPM, 2) the pilot's failure to maintain directional control on landing, resulting in a dynamic rollover.NTSB SEA94LA037Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Sublimity, ORThe pilot's failure to maintain clearance from unmarked transmission wires. Factors include the pilot's inadequate visual lookout, and unmarked wires in the area of operation.NTSB MIA94WA032Accident · No injuriesForeign investigationMcDonnell Douglas DC10-30 · Buenos Aires, ArgentinaNTSB MIA94LA029Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Moore Haven, FLFailure of the pilot-in-command to maintain aircraft control following loss of engine power for undetermined reasons.NTSB LAX94LA060Accident · Serious injuriesLimited investigationFinal reportAlbrecht Polywagon · Vacaville, CAthe pilot's failure to maintain control of the aircraft during a go-around. Factors in the accident were the wind shear conditions and the pilot's failure to adequately balance the fuel load during the flight.NTSB LAX94LA057Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Buckeye, AZA loss of engine power due to fuel system contamination. A factor in the accident was the soft terrain in the landing area.NTSB LAX94FA058Accident · 3 fatalField investigationFinal reportSiai-Marchetti F-260 · Santa Monica, CAthe dual student pilot's failure to maintain minimum air speed in flight which resulted in an inadvertent stall/spin. Contributing to the accident was the improper weight and balance, inadequate altitude, and inadequate supervision.NTSB FTW94FA038Accident · 2 fatalField investigationFinal reportCessna T303 · Rogers, ARThe pilot's continued flight into known adverse weather conditions, and the ensuing inadvertent stall. Factors were the icing conditions, the fog, the drizzle, the dark night light conditions, and the pilot's disregard for the forecasted weather conditions.NTSB BFO94LA019Accident · Serious injuriesLimited investigationFinal reportMartin Streak Shadow · Mannington, WVThe pilot's failure to maintain clearance from the surrounding terrain.NTSB BFO94LA018Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Stowe, VTThe pilot did not follow the emergency procedure after loss of power in the right engine, by failing to feather the right engine and failing to maintain minimum single-engine control speed. A factor related to the accident was: failure of the pilot to adhere…NTSB ATL94FA023Accident · 1 fatalField investigationFinal reportCessna 172 · Gadsden, ALThe pilot's inadequate pre-flight preparation and his continued visual flight into instrument meteorological conditions. Factors were fog, low ceiling, and hilly terrain.NTSB MIA94LA028Accident · No injuriesLimited investigationFinal reportCessna 172P · Jacksonville, FLThe improper positioning of the fuel selector by the pilot-in- command resulting in fuel starvation.NTSB FTW94LA039Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Mancos, COFuel exhaustion induced power loss and the pilot's inadequate preflight inspection, during which he failed to insure that the airplane had been refueled to capacity. A factor was the lack of suitable terrain for a forced landing.NTSB MIA94LA027Accident · 1 fatalLimited investigationFinal reportThompson Bushby Mustang II · Madison, MSAn engine failure for undetermined reasons.NTSB BFO94FA017Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201 · Ravenna, OHThe pilot attempted to fly the airplane with known deficiencies in the attitude indicator and became spatially disoriented during the takeoff climb. Factors in the accident were the low ceiling, night conditions, and an inaccurate attitude indicator.NTSB FTW94WA073Accident · Minor injuriesForeign investigationPiper Aerostar 601P · Campeche, MexicoNTSB SEA94LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Brookings, ORThe pilot's inadequate preflight planning/preparation, and icing of the induction air filter/screen. Factors include weather conditions conducive to icing, and rough/uneven terrain in the area of attempted landing.NTSB SEA94FA034Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Mountain Home, IDThe pilot's intentional suicide and impairment from consumption of alcohol.NTSB LAX94FA056Accident · 2 fatalField investigationFinal reportCessna 172M · Julian, CAThe pilot's failure to maintain aircraft control. Factors in this accident were: 1) the dark night and lack of ambient light which resulted in the pilot inadvertently flying from visual meteorological conditions into instrument meteorological conditions; 2)…NTSB BFO94LA016Accident · No injuriesLimited investigationFinal reportTaylorcraft J-2 · Pittstown, NJThe pilot failed to maintain a proper glidepath. A factor in the accident was the presence of sunglare.NTSB MIA94WA025Accident · No injuriesForeign investigationBeech BE-80 · Guatemala City, GuatemalaNTSB MIA94LA026Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Labelle, FLThe pilot-in-command exceeding the structural limits of the airplane's design limits by in-flight over-stress that resulted in damage to the gear extension system, fuselage and control surfaces.NTSB LAX94LA055Accident · Minor injuriesLimited investigationFinal reportMooney M20B · Santa Paula, CAThe pilot's failure to follow proper procedures/directives prohibiting night operations at the airport and failure to maintain the proper glidepath. The pilot's diverted attention was a factor in this accident.NTSB CHI94FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 172I · Kalamazoo, MIUndetermined.NTSB BFO94FA015Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Northampton, MAFailure of the air traffic control (ATC) facility to identify and provide the required traffic information to the jump aircraft before release of the jumper(s). A factor related to the accident was: inadequate visual lookout by the pilot of the jump aircraft.NTSB ATL94LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Kinston, NCWas the student pilot's failure to maintain aircraft control during the go around. A factor was the wind gusts which occurred at the time of the accident.NTSB LAX94LA066Accident · No injuriesLimited investigationFinal reportYakovlev YAK-55M · Greenfield, CAUndetermined.NTSB LAX94LA054Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Salinas, CAa fatigue failure of the torsion-tension bar pin due to fretting corrosion. A factor in this accident was an inadequate quality of material utilized in the manufacture of the pin.NTSB BFO94FA013Accident · 3 fatalField investigationFinal reportBell 206L-1 · Portland, METhe pilot's continued VFR flight into instrument meteorological conditions, and his failure to assure that adequate fuel was available to complete the flight, resulting in a loss of engine power due to fuel exhaustion. Factors which contributed to the…NTSB ATL94LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Maryville, TNThe pilot's inadequate inflight planning, which resulted in fuel exhaustion prior to reaching the planned destination.NTSB ANC94LA019Accident · No injuriesLimited investigationFinal reportCessna 206 · Anchorage, AKThe frozen throttle cable due to moisture.NTSB MIA94LA024Accident · No injuriesLimited investigationFinal reportCessna U206F · Tampa, FLWas the improper overhaul and inspection of the engine by company maintenance personnel.NTSB LAX94T#A02Accident · No injuriesClass 3Final reportCessna C206 · Chinle, AZNTSB LAX94LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Compton, CAwere the noncertificated student pilot's misjudged flare altitude, improper recovery from a bounced landing, and improper use of the left brake. The student pilot's lack of total experience and panic were factors in this accident.NTSB LAX94LA051Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-1B-2 · Las Vegas, NVWere the fuel injection line contamination resulting in fuel starvation; the pilot's inadequate 100-hour inspection; the pilot's improper decision to return to the airport at a low altitude; and his failure to maintain the proper airspeed which resulted in a…NTSB CHI94GA038Accident · 1 fatalFinal reportHughes 369HS · Antonia, MOThe pilot's failure to maintain proper altitude. A factor was the dark night.NTSB SEA94LA036Accident · Minor injuriesLimited investigationFinal reportAero Commander S2R · Pasco, WAThe pilot in command's failure to maintain clearance with the irrigation sprinkler system.NTSB NYC94FA027Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Kinnelon, NJThe loss of engine power for undetermined reasons.NTSB LAX94LA050Accident · No injuriesLimited investigationFinal reportCessna 172RG · Santa Ana, CAwere the CFI's inadequate supervision of the flight and his delay in taking remedial action. The dual student's excessive taxi speed and the worn right brake lining were factors in this accident.NTSB FTW94FA036Accident · 2 fatalField investigationFinal reportCessna 152 · Guthrie, OKWas the pilot-in-command continued VFR flight into IMC. A factor was fog.NTSB SEA94LA033Accident · No injuriesLimited investigationFinal reportCessna C-172N · Idaho Falls, IDThe pilot's failure to attain the proper touchdown point. Factors include tailwind conditions and an airport perimeter fence.NTSB LAX94LA049Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fresno, CAwas the student pilot's improper use of the rudder. The student pilot's lack of total experience was a factor in this accident.NTSB FTW94IA035Incident · No injuriesIncident investigationFinal reportGrumman G159 · Pineville, LAAn encounter with a wet microburst, on final approach at 200 feet AGL, which exceeded the performance capability of the aircraft.NTSB BFO94LA012Accident · No injuriesLimited investigationFinal reportAngel Elbert S JR Quickie 200 · North Kingston, RILoss of engine power due to undetermined reasons.NTSB ATL94LA019Accident · Serious injuriesLimited investigationFinal reportBell-Carson 47G-SUPER C-4 · Eufaula, ALThe pilot's failure to maintain aircraft control. A factor was the pilot's limited helicopter flight experience.NTSB SEA94LA042Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Mesa, WAThe pilot's improper flare. Factors include excessive airspeed while approaching the flare.NTSB MIA94LA023Accident · No injuriesLimited investigationFinal reportPiper PA-60 · Orlando, FLThe failure of the pilot-in-command of the other aircraft to maintain a visual lookout and clearance between aircraft.NTSB LAX94LA045Accident · Serious injuriesLimited investigationFinal reportBeech A-36 · Florence, AZthe pilot's poor inflight planning and decision making by continuing the flight into adverse weather conditions. Factors contributing to this accident were: not obtaining a preflight weather briefing, not following the airplane flight manuals, and exceeding…NTSB LAX94FA047Accident · 1 fatalField investigationFinal reportPiper PA-30 · Brea, CAThe pilot's choice of an inadequate cruise altitude over rolling hill terrain which resulted in an in-flight collision with helium balloons and an in-flight loss of control for undetermined reasons. A factor in the accident was the pilot's inadequate visual…NTSB FTW94FA034Accident · Serious injuriesField investigationFinal reportCessna 172N · Fort Collins, COPower loss due to throttle linkage disconnect. Factors were missing cotter key, improper maintenance, and the lack of suitable terrain for the forced landing.