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 CHI89DEE04Accident · No injuriesFinal reportRenninger Mustang II · Kirkland, ILFuel starvation (possibly from vapor lock), which resulted in loss of engine power, and the pilot's misjudgement of ground clearance during a final turn to land.NTSB BFO89FA048Accident · 4 fatalField investigationFinal reportCessna 172P · Caesars Head, SCFailure of the pilot to maintain sufficient airspeed while flying over rising terrain, which resulted in an inadvertent stall and collision with wooded terrain. Factors related to the accident were: the terrain conditions and failure of the pilot to maintain…NTSB SEA89LA121Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Colfax, WAImproper installation of the cylinder assembly. The terrain was not suitable for a successful forced landing.NTSB SEA89LA120Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Centralia, WAThe pilot misjudged his clearance over trees, which resulted in an in-flight tail rotor strike with the trees and loss of tail rotor control. The trees were a related factor.NTSB SEA89LA119Accident · No injuriesLimited investigationFinal reportBeech B35 · Dallesport, WAThe premature rotatiion and liftoff by the pilot, which resulted in an inadvertent stall. A factor related to the accident was: the tailwind.NTSB MKC89LA140Accident · No injuriesLimited investigationFinal reportCessna 188B · Grygla, MNInadequate preflight planning and preparation by the pilot. Tall grass (high vegetation) at the end of the strip was a contributing factor.NTSB LAX89LA226Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Parker Dam, CAImproper planning/decision by the pilot and his failure to obtain wind information before landing. Factors relating to this accident were: the adverse weather conditions.NTSB FTW89LA119Accident · No injuriesLimited investigationFinal reportCessna A185F · Marksville, LAFailure of the pilot to maintain directional control during the landing roll, which resulted in an inadvertent ground loop and a subsequent nose over.NTSB FTW89LA116Accident · No injuriesLimited investigationFinal reportCessna 152 · Addison, TXImproper planning/decision by the solo student pilot and inadequate supervision by the student's instructor pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor related to the accident was: the instructor pilot's lack of…NTSB FTW89DPJ07Accident · 2 fatalFinal reportBeech T-34 · Haskell, OKFailure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall. Factors related to the accident were: a leak in the pitot system, failure of the pilot to obtain adequate maintenance/inspection of the pitot system, and his lack of…NTSB DEN89FA146Accident · 1 fatalField investigationFinal reportBeech 35 · Glenrock, WYProper altitude not maintained by the pilot. The weather/night conditions and pilot fatigue were considered to be contributing factors.NTSB CHI89LA120Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Middletown, OHFuel starvation from improper movement of the fuel selector by the pilot and his improper use of emergency procedures during the attempted engine restart. Contributing factors were the pilot's lack of experience in this type of aircraft and the terrain…NTSB ATL89LA169Accident · No injuriesLimited investigationFinal reportCessna 401 · Raleigh, NCImproper maintenance by other maintenance personnel and excessive fuel pressure to the right engine (rich mixture). A possible contributing factor was the worn/unserviceable internal lock nut in the fuel pump.NTSB ANC89LA103Accident · Serious injuriesLimited investigationFinal reportDe Havilland DHC-2 · Iliamna, AKInadequate annual inspection by maintenance personnel.NTSB SEA89FA118Accident · 1 fatalField investigationFinal reportColonial C-1 · Bremerton, WAMalfunction of both magnetos due to deterioration of the coils, which resulted in the loss of engine power. Factors related to the accident were: an inadequate airworthiness directive (no calendar time limits), and the lack of suitable terrain (rough/uneven)…NTSB SEA89FA117Accident · Serious injuriesField investigationFinal reportPiper PA-28-181 · Chiloquin, ORThe pilot's inadequate planning and preparation for the flight which resulted in inadequate airspeed and an inadvertent stall while attempting to clear trees off the end of the runway. Contributing factors were: the high density altitude, gusty crosswind,…NTSB MKC89LA142Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Waldenburg, ARThe total failure of the engine supercharger which resulted in a loss of engine power.NTSB FTW89LA115Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Waco, TXA deteriorated fuel cap, water contamination of the fuel, and the pilot's inadequate preflight of the aircraft. A factor related to the accident was: the dirt bank (berm).NTSB FTW89DRD09Accident · No injuriesFinal reportSchweizer G-164A · Bunkie, LAThe loss of the number five cylinder in flight, resulting in a loss of engine RPM. The pilot misjudged the landing flare height due to obscured vision from fire and smoke and the airplane stalled and impacted the ground nose first.NTSB CHI89FA122Accident · No injuriesField investigationFinal reportPiper PA-60-700P · Griffith, INFailure of the turbocharger exhaust tailpipe assembly retaining clamp.NTSB ATL89LA168Accident · No injuriesLimited investigationFinal reportCessna 172 · Centreville, ALThe student pilot's failure to remove all remaining water from the airplane fuel system during pre-flight inspection which led to a total loss of power.NTSB ANC89LA102Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Tuntutuliak, AKFailure of the engine crankshaft. A contributing factor to aircraft damage was a mud (dirt) bank which the aircraft hit during the emergency landing.NTSB SEA89LA116Accident · Minor injuriesLimited investigationFinal reportBell 47G3B2A · Dyer, NVThe pilots poor planning in attempting a hover in undesirable conditions which resulting in the inability to maintain rotor rom. Contributing to the accident was the mountainous terrain and high density alt.NTSB MKC89LA143Accident · No injuriesLimited investigationFinal reportCessna 172 · Sauk Rapids, MNFailure of the pilot to properly secure the oil cap when he serviced the aircraft and oil starvation. Contributing factors were the terrain conditions.NTSB LAX89FA225Accident · 4 fatalField investigationFinal reportAerospatiale TB-21 · Newhall, CAFuel contamination, due to the pilot's lack of familiarity with the aircraft fuel system, and inadequate maintenance. A related factor was: inadequate transition training.NTSB CHI89LA118Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Indianapolis, INFuel contamination from a deteriorating part in the carburetor. The trees and improper maintenance/servicing of the aircraft were probable contributing factors.NTSB ATL89FA167Accident · Serious injuriesField investigationFinal reportCessna 140 · Conyers, GACarburetor ice and the pilot's improper use of carburetor heat. Carburetor icing condition was a related factor.NTSB SEA89LA124Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Kassan, AKThe excessive taxi speed used by the pilot in the existing weather conditions. Contributing to the accident was the gusty tailwind.NTSB SEA89LA115Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Battle Mountain, NVThe loss of engine power in flight due to a broken number two rocker arm. Contributing to the accident was the vehicle on the road which resulted in the pilot flaring prematurely.NTSB MKC89LA141Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Bemidji, MNThe continued approach and landing by the pilot in known adverse weather. Contributing factors were the weather conditions and the ditch.NTSB DEN89LA145Accident · Serious injuriesLimited investigationFinal reportRaven S77A · Rio Rancho, NMA hard landing due to the pilots failure to accurately evaluate the weather conditions along with a delay in making a precautionary landing. Factors contributing to the accident were high winds and wind shear along with rough/uneven terrain.NTSB DEN89LA144Accident · No injuriesLimited investigationFinal reportBeauchesne/Wells Glasair TD · Moriarity, NMImproper installation of the propeller which resulted in severe vibration and failure of the propeller mounting bolts, & the separation of the propeller from the aircraft. Rough/uneven desert terrain contributed to the accident.NTSB CHI89FA117Accident · 1 fatalField investigationFinal reportPiper PA-24-180 · Delphi, INImproper planning/decision of the pilot, which resulted in fuel exhaustion from an inadequate supply of fuel, and his failure to maintain flying speed during a forced landing, which resulted in a stall and subsequent impact with the ground.NTSB ATL89FA166Accident · 3 fatalField investigationFinal reportPiper PA-60-601P · Lithia Springs, GAInflight engine/wing fire due to a failure of the right engine's left exhaust tailpipe. The exhaust tailpipe failed in fatigue as a result of fluctuating stresses induced by a deteriorated engine mount in conjunction with unevenly distributed clamping loads…NTSB ANC89FA100Accident · No injuriesField investigationFinal reportCessna U-206G · Anchorage, AKThe failure of the pilot to conduct a proper pre-flight inspection and remove the tail mooring from the float plane. Contributing to the accident was the pilot's over confidence in his personal ability.NTSB SEA89LA114Accident · 1 fatalLimited investigationFinal reportHughes Bensen B-8M · The Dalles, ORThe pilots poor judgement in attempting low level flight in a narrow valley during high wind conditions.NTSB SEA89FA113Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · Stanley, IDPilot continued VFR flight into IMC conditions in mountainous terrain. Factors were snow squalls and obscured mountainous terrain in the area.NTSB NYC89LA151Accident · No injuriesLimited investigationFinal reportErcoupe Ercoupe 415C · Canaan, CTAn off airport landing in unsuitable terrain due to a power loss, caused by loose parts in the fuel pump.NTSB LAX89LA224Accident · No injuriesLimited investigationFinal reportCessna 340 · Paso Robles, CAImproper use (mismanagement) of the fuel system by the pilot, which resulted in fuel starvation. Related factors were: the lack of fuel quantity indicators (not installed) in the aircraft, flight by the pilot with this known deficiency, and trees in the…NTSB FTW89LA114Accident · No injuriesLimited investigationFinal reportCessna 150J · Minden, LAThe loss of engine power due to improper maintenance performed during an annual inspection 1.6 flying hours prior to the accident which resulted in the mixture control becoming disconnected.NTSB DEN89LA143Accident · No injuriesLimited investigationFinal reportCessna 172M · Boulder, COInadequate compensation for wind conditions by the (private rated) dual student and his failure to maintain directional control, which resulted in an inadvertent ground swerve, and inadequate supervision by the instructor pilot (CFI). A factor related to the…NTSB DEN89LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA28-180 · Broomfield, COThe failure of the student to properly plan the flt resulting in fuel exhaustion.NTSB DEN89DTI01Accident · 1 fatalFinal reportPiper PA-25-235 · Conrad, MTThe pilot's failure to see the guy wire in time to avoid colliding with it.NTSB ATL89LA164Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Franklin, GAImproper planning/decision by the pilot by attempting to takeoff from an unsuitable field and his delay in aborting the takeoff. The terrain conditions and fence were contributing factors.NTSB ATL89FA165Accident · 4 fatalField investigationFinal reportBeech B-60 · Gaston, SCThe pilot exercised questionable judgement in initiating a flight into an area of known thunderstorms. Further, either deliberately or inadvertantly entered a thunderstorm and overstressed the airframe structure resulting in an inflight separation of the…NTSB ANC89LA098Accident · No injuriesLimited investigationFinal reportCessna 182A · Tyonek, AKSelection of unsuitable terrain by the pilot. Probable contributing factors were the soft sand and the pilot's delay in aborting the takeoff.NTSB ANC89LA095Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKLoss of directional control by the pilot & inadvertent ground loop/swerve of the aircraft during the landing.NTSB ANC89IA099Incident · No injuriesIncident investigationFinal reportDe Havilland DHC-3 · Palmer, AKInadequate lubrication which resulted in the failure of the horizontal stabilizer's trim actuator.NTSB MKC89LA139Accident · No injuriesLimited investigationFinal reportCessna A185F · Int'L Falls, MNThe pilot's inability to maintain aircraft control after encountering a strong gust of wind during the landing flare/touchdown.NTSB MKC89LA138Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Grain Valley, MOFailure of the student pilot to maintain proper runway alignment, while aborting a bounced landing. Factors related to the accident were: the pilot's improper flare and lack of experience in the make and model of aircraft, the right crosswind, and the…