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 DEN04CA111Accident · Minor injuriesData collectionFinal reportBell 206 L-1 · Escalante, UTthe pilot's failure to maintain aircraft control. Factors contributing to the accident were the high winds, the gusts, and the refueling truck.NTSB ATL04LA161Accident · No injuriesLimited investigationFinal reportLong Pitts Special S1S · New Bern, NCThe pilot's inadequate compensation for winds and his failure to maintain directional control during a crosswind landing, which resulted in an on-ground collision with an airport sign. A factor was the crosswind condition.NTSB ANC04CA083Accident · No injuriesData collectionFinal reportPiper J5A · Kotzebue, AKThe pilot's inadvertent use of the airplane's brakes during the takeoff roll, which resulted in the airplane nosing over. A factor contributing to the accident was the pilot's failure to maintain directional control.NTSB NYC04CA175Accident · No injuriesData collectionFinal reportCessna 182R · Mitchellville, MDThe private pilot's inadequate flare, and the CFI's delayed remedial action, which resulted in an inadvertent stall/mush and hard landing. A factor related to the accident was the night conditions.NTSB FTW04WA194Accident · No injuriesForeign investigationMcDonnell Douglas DC-9-14 · Mexico City, MexicoNTSB FTW04LA195Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Columbus, TXthe pilot's failure to maintain directional control during the takeoff roll and abort the attempted takeoff.NTSB DEN04CA121Accident · Minor injuriesData collectionFinal reportPiper PA-24-250 · Model, COthe pilot's improper in-flight planning and decision making resulting in a loss of engine power due to fuel exhaustion. A contributing factor was the trees.NTSB CHI04WA192Accident · 1 fatalForeign investigationPiper PA-28-181 · Hamm-Lippewiese, GermanyNTSB ANC04CA082Accident · Minor injuriesData collectionFinal reportPiper J3C · Palmer, AKThe pilot's inadequate evaluation of the wind conditions which resulted in an encounter with a downdraft during the takeoff/initial climb, and subsequent collision with trees and terrain. Factors contributing to the accident were the presence of a downdraft,…NTSB NYC04LA174Accident · Serious injuriesLimited investigationFinal reportBombardier CL-600 · Snow Hill, VAThe pilot's excessive maneuvering in response to a TCAS alert, which resulted in a serious injury to the flight attendant.NTSB LAX04LA274Accident · 1 fatalLimited investigationFinal reportFinke Rotorway Exec 162F · Cameron Park, CAThe owner-builder's improper main rotor blade (MRB) maintenance/installation by under torquing the blade retaining nut.NTSB FTW04LA197Accident · Minor injuriesLimited investigationFinal reportBell 206B · East Cameron 13The loss of engine power due to fuel exhaustion. Contributing factors were the fuel quantity gauge's improper fuel level indication, missing instrument placard, company maintenance personnel's improper maintenance records, disregard for company procedures,…NTSB DEN04LA112Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Rifle, COthe pilot's failure to maintain aircraft control during the aborted takeoff resulting in the airplane departing the runway and striking a runway light and two taxiway signs. Factors contributing to the accident were the broken sensor wire to the left engine's…NTSB DEN04LA108Accident · No injuriesLimited investigationFinal reportDavis-Zenair Stol CH 801 · Erie, COimpact with terrain during a forced landing following a loss of engine power for underdetermined reasons. A contributing factor was the lack of suitable terrain for a forced landing.NTSB CHI04CA189Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Merrill, WIThe dual student's failure to maintain directional control during the initial climb after takeoff and the flight instructor's delayed remedial action. A contributing factor was that all available runway was not used for takeoff due to the touch-and-go…NTSB FTW04CA192Accident · Minor injuriesData collectionFinal reportRotorway Exec · Conroe, TXThe loss of engine power due to the tripped fuel pump circuit breaker which resulted in the failure of the electric fuel pump.NTSB DEN04LA107Accident · No injuriesLimited investigationFinal reportCessna P210N · Douglas, WYthe failure of the engine's crankshaft due to the rotation of the engine's number two bearing, which resulted in the oil starvation of the crankshaft's number 2 main journal. Contributing factors include the engine's improper maintenance, and the in-flight…NTSB ATL04LA143Accident · No injuriesLimited investigationFinal reportCessna 172S · Winder, GAThe improper maintenance (over-pressurization) of the nose gear strut, which resulted in an overload failure of the nose gear upper torque link bolt. The airplane subsequently nosed over during an uncontrollable landing roll.NTSB ATL04CA160Accident · No injuriesData collectionFinal reportPiper PA 25 · Foley, ALThe pilot's failure to maintain airspeed during climbout which resulted in a stall while maneuvering to pick up a banner.NTSB SEA04LA137Accident · Serious injuriesLimited investigationFinal reportRoot RV-4 · Buckley, WAThe pilot's inadequate preflight planning/preparation which resulted in a loss of engine power due to fuel starvation during the initial climb after takeoff. The pilot's failure to select the proper fuel tank before takeoff and to maintain airspeed during the…NTSB NYC04FA170Accident · 5 fatalField investigationFinal reportPiper PA-32R-301T · Wheeling, WVThe pilot's failure to maintain terrain clearance while executing an instrument approach. A factor was the night instrument meteorological conditions.NTSB MIA04FA107Accident · No injuriesField investigationFinal reportLearjet 55 · Fort Lauderdale, FLThe flight crew's decision to continue the approach into known area of potentially severe weather (Thunderstorm), which resulted in the flight encountering a 30 knot cross wind, heavy rain, low-level wind shear, and hydroplaning on a ungrooved contaminated…NTSB LAX04LA273Accident · No injuriesLimited investigationFinal reportAgusta A119 · Big Bear City, CAthe pilot-passenger's failure to maintain an adequate airspeed above translational lift and to maintain adequate main rotor rpm while performing a maneuvering turn under high density altitude conditions and over high mountainous terrain, which resulted in an…NTSB DEN04LA106Accident · No injuriesLimited investigationFinal reportCessna 182J · Farmington, NMthe pilot's inadequate compensation for wind and his improper flare. Contributing factors include the wind shift, and gusty wind conditions.NTSB NYC04FA171Accident · 1 fatalField investigationFinal reportCessna 172M · Brookville, OHThe student pilot's control interference while the flight instructor was maneuvering to avoid a tree, which resulted in a failure to maintain airspeed and a stall/mush.NTSB MIA04WA108Accident · 1 fatalForeign investigationCessna 172 · Algarrobo, ChileNTSB LAX04CA270Accident · No injuriesData collectionFinal reportPdps Pzl-Bielsko SZD-50-3 · Lone Pine, CAthe pilot failed to maintain runway alignment, and misjudged the clearance between the tree and the wing resulting in a collision with the tree.NTSB FTW04LA189Accident · Serious injuriesLimited investigationFinal reportCalhoun RV-4 · Latexo, TXThe pilot's failure to maintain directional control and attain adequate airspeed resulting in a stall. Contributing factors were the pilot's diverted attention with closing the canopy, and the quartering crosswind.NTSB FTW04LA188Accident · No injuriesLimited investigationFinal reportMattie RV-4 · El Reno, OKThe pilot's improper recovery from a bounced landing and his failure to maintain control of the airplane during landing.NTSB FTW04CA234Accident · No injuriesData collectionFinal reportLindstrand Balloons 90A · Allen, TXThe pilot's failure to maintain clearance with the power lines. A contributing factor was the gusty wind conditions.NTSB DEN04LA105Accident · No injuriesLimited investigationFinal reportMooney M20C · Escalante, UTthe improper installation of an oil pan quick-drain fitting resulting in the loss of engine oil, failure of the engine, and subsequent impact with terrain following an attempted forced landing. A contributing factor was the lack of suitable terrain for a…NTSB ATL04FA159Accident · 4 fatalField investigationFinal reportBeech 36TC · Sylvester, GAThe pilot's inadequate in-flight planning/decision resulting in flight into thunderstorms resulting in an in-flight breakup of the airframe.NTSB ANC04LA081Accident · No injuriesLimited investigationFinal reportCessna 120 · Beluga, AKThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in airplane departing the landing surface into a ditch, and subsequently nosing over in tall bushes. A factor contributing to the accident was soft…NTSB NYC04LA169Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Erwinna, PAThe student pilot's failure to maintain airspeed and his failure to follow the go-around procedure which resulted in a stall.NTSB NYC04LA168Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A319 · Flat Rock, VAAn inadvertent encounter with turbulence in clouds during descent.NTSB MIA04LA136Accident · No injuriesLimited investigationFinal reportCessna 182 · Naples, FLThe dual student's improper landing flare and the pilot-in-command/CFI's inadequate supervision resulting in a hard landing.NTSB MIA04CA106Accident · No injuriesData collectionFinal reportPiper PA-28 · Okeechobee, FLStudent pilot's failure to maintain directional control of the airplane during landing roll, resulting in the airplane departing the runway and impacting a fence incurring substantial damage to the airplane.NTSB LAX04FA271Accident · 3 fatalField investigationFinal reportBeech 58 · Bishop, CAthe pilot's continued VFR flight into marginal weather conditions with lowering ceilings in a box canyon in mountainous terrain, and his subsequent inability to maintain an adequate airspeed while maneuvering to reverse direction, which led to an accelerated…NTSB FTW04LA190Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103A Twin II Acro · Caddo Mills, TXThe other pilot's inability to maintain directional control during landing roll as a result of the failure of the landing gear.NTSB FTW04LA187Accident · Serious injuriesLimited investigationFinal reportSaladino Searey · Lewisville, TXThe pilot's failure to maintain control of the airplane during final approach. A contributing factor was the gusty crosswind condition.NTSB FTW04FA186Accident · 1 fatalField investigationFinal reportBell 206 L-1 · Cameron, LAThe helicopter's in-flight collision with water for undetermined reasons.NTSB CHI04LA185Accident · Serious injuriesLimited investigationFinal reportVarga 2150A · Winterset, IAThe inadequate supervision by the certified flight instructor, fuel starvation, visual/aural detection precluded by the certified flight instructor's seat position, and the inadequate crew coordination of both pilots during the instructional flight. A…NTSB ATL04LA158Accident · 1 fatalLimited investigationFinal reportPitts S-1 · Durham, NCThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin and subsequent in-flight collision with terrain.NTSB ANC04FA080Accident · 4 fatalField investigationFinal reportCessna 170B · Willow, AKThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall while maneuvering, and a collision with trees and terrain during an uncontrolled descent.NTSB SEA04LA135Accident · No injuriesLimited investigationFinal reportCessna A185F · Boise, IDThe pilot's failure to maintain directional control during the landing roll resulting in an inadvertent ground loop.NTSB SEA04CA138Accident · No injuriesData collectionFinal reportCessna A185F · Cut Bank, MTThe pilot's failure to maintain directional control during the takeoff roll.NTSB SEA04CA136Accident · Minor injuriesData collectionFinal reportCessna 150L · La Center, WAThe private pilot receiving the flight review's failure to follow the Owner’s Manual's procedures for a go-around. Contributing factors were the flight instructor's delay in telling the private pilot to go-around, and the trees.NTSB LAX04LA269Accident · No injuriesLimited investigationFinal reportNewell RV-6A · San Jose, CAThe pilot's misjudgment of the airplane's distance/speed during a precautionary landing, which resulted in the airplane overrunning the runway. Contributing factors were failure of an oil line, and the fence.NTSB LAX04CA268Accident · No injuriesData collectionFinal reportMcDonnell Douglas 369FF · Lihue, HIThe pilot misjudging the clearance between the tree and the main rotor blades. Contributing factors to the accident were the high workload of the pilot and his lack of experience with bambi bucket operations.NTSB IAD04IA032Incident · No injuriesIncident investigationFinal reportAviat A-1A · Fryeburg, METhe pilot's improper use of carburetor heat, which resulted in a loss of engine power. A factor was the lack of suitable terrain for the forced landing.