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 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.Jun 25, 1989 · N11WR · DestroyedNTSB 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…Jun 25, 1989 · N53667 · DestroyedNTSB 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.Jun 24, 1989 · N8974H · Substantial damageNTSB 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.Jun 24, 1989 · N1161N · DestroyedNTSB 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.Jun 24, 1989 · N5028C · Substantial damageNTSB 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.Jun 24, 1989 · N4724R · Substantial damageNTSB 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.Jun 24, 1989 · N1982K · Substantial damageNTSB 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.Jun 24, 1989 · N5486R · Substantial damageNTSB 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…Jun 24, 1989 · N45955 · Substantial damageNTSB 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…Jun 24, 1989 · N34CJ · DestroyedNTSB 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.Jun 24, 1989 · N1887D · Substantial damageNTSB 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…Jun 24, 1989 · N1961P · Substantial damageNTSB 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.Jun 24, 1989 · N8271F · Substantial damageNTSB ANC89LA103Accident · Serious injuriesLimited investigationFinal reportDe Havilland DHC-2 · Iliamna, AKInadequate annual inspection by maintenance personnel.Jun 24, 1989 · N5595M · Substantial damageNTSB 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)…Jun 23, 1989 · N260B · DestroyedNTSB 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,…Jun 23, 1989 · N43708 · DestroyedNTSB MKC89LA142Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Waldenburg, ARThe total failure of the engine supercharger which resulted in a loss of engine power.Jun 23, 1989 · N9725 · Substantial damageNTSB 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).Jun 23, 1989 · N761RF · Substantial damageNTSB 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.Jun 23, 1989 · N602Y · Substantial damageNTSB CHI89FA122Accident · No injuriesField investigationFinal reportPiper PA-60-700P · Griffith, INFailure of the turbocharger exhaust tailpipe assembly retaining clamp.Jun 23, 1989 · N6907C · Substantial damageNTSB 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.Jun 23, 1989 · N70RS · Substantial damageNTSB 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.Jun 23, 1989 · N15306 · Substantial damageNTSB 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.Jun 22, 1989 · N59414 · DestroyedNTSB 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.Jun 22, 1989 · N3814S · Substantial damageNTSB 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.Jun 22, 1989 · N28LR · DestroyedNTSB 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.Jun 22, 1989 · N13652 · Substantial damageNTSB 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.Jun 22, 1989 · N1875V · Substantial damageNTSB 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.Jun 21, 1989 · N46DG · Substantial damageNTSB 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.Jun 21, 1989 · N9830 · Substantial damageNTSB 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.Jun 21, 1989 · N6513Y · Substantial damageNTSB 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.Jun 21, 1989 · N4207U · No damageNTSB 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.Jun 21, 1989 · N544BM · Substantial damageNTSB 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.Jun 21, 1989 · N30BS · DestroyedNTSB 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…Jun 21, 1989 · N83AT · DestroyedNTSB 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.Jun 21, 1989 · N8773Q · Substantial damageNTSB 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.Jun 20, 1989 · N3196 · DestroyedNTSB 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.Jun 20, 1989 · N6471Y · DestroyedNTSB 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.Jun 20, 1989 · N93765 · Substantial damageNTSB 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…Jun 20, 1989 · N69549 · Substantial damageNTSB 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.Jun 20, 1989 · N60625 · DestroyedNTSB 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…Jun 20, 1989 · N80893 · Substantial damageNTSB DEN89LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA28-180 · Broomfield, COThe failure of the student to properly plan the flt resulting in fuel exhaustion.Jun 20, 1989 · N8419W · Substantial damageNTSB DEN89DTI01Accident · 1 fatalFinal reportPiper PA-25-235 · Conrad, MTThe pilot's failure to see the guy wire in time to avoid colliding with it.Jun 20, 1989 · N7001Z · DestroyedNTSB 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.Jun 20, 1989 · N1434Y · Substantial damageNTSB 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…Jun 20, 1989 · N78TW · DestroyedNTSB 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.Jun 20, 1989 · N9926B · Substantial damageNTSB ANC89LA095Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKLoss of directional control by the pilot & inadvertent ground loop/swerve of the aircraft during the landing.Jun 20, 1989 · N180SR · Substantial damageNTSB ANC89IA099Incident · No injuriesIncident investigationFinal reportDe Havilland DHC-3 · Palmer, AKInadequate lubrication which resulted in the failure of the horizontal stabilizer's trim actuator.Jun 20, 1989 · N41755 · No damageNTSB 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.Jun 19, 1989 · N7310H · Substantial damageNTSB 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…Jun 19, 1989 · N3148V · Substantial damage