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 LAX04CA107Accident · No injuriesData collectionFinal reportPiper PA-28-180C · Minden, NVThe student pilot's failure to maintain directional control during the landing roll.NTSB FTW04WA066Incident · No injuriesForeign investigationMcDonnell Douglas MD-11 · Mexico City, MexicoNTSB FTW04LA065Accident · No injuriesLimited investigationFinal reportCessna 120 · Lonoke, ARThe loss of engine power for undetermined reasons. A contributing factor was the dusk lighting conditions and unlit airfield.NTSB NYC04LA060Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Sanford, MEAn engine fire for undetermined reasons during start-up.NTSB IAD04LA008Accident · Minor injuriesLimited investigationFinal reportRockwell 112A · Bedford, MAFailure of the #2 piston connecting rod cap, which resulted in a hole in the engine crankcase and a loss of engine power. A factor was dark night lighting condition.NTSB FTW04WA074Accident · 1 fatalForeign investigationGarlick OH58A · La Laya, MexicoNTSB ANC04LA020Accident · No injuriesLimited investigationFinal reportCessna 172 · Girdwood, AKThe pilot's delay in aborting the takeoff, which resulted in an overrun and collision with a snowbank. A factor in the accident was an inoperative airspeed indicator.NTSB DCA04WA020Incident · No injuriesForeign investigationBoeing 757-236 · Copenhagen, DenmarkNTSB CHI04LA061Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Prairieville, MIThe pilot's failure to maintain altitude/clearance from the transmission wires during final approach. Factors to the accident were the unmarked transmission wires and their support poles.NTSB ATL04LA070Accident · No injuriesLimited investigationFinal reportEurocopter France EC120B · Jonesboro, GAThe instructor's inadequate supervision, and the dual-student's improper flare which resulted in a hard landing.NTSB MIA04WA054Accident · 5 fatalForeign investigationPiper PA-32-300RT · Capitan Miranda, ParaguayNTSB MIA04CA048Accident · No injuriesData collectionFinal reportRobinson R44 · Vero Beach, FLThe failure of the pilot to maintain clearance with bushed resulting in in-flight contact and susequent dynamic roll-over.NTSB LAX04LA106Accident · 1 fatalLimited investigationFinal reportCox Thorpe T-18 · Compton, CAboth pilots' failure to see and avoid one another that resulted in the airplane's encounter with downwash induced wake vortices from the helicopter, and the airplane pilot's subsequent loss of control.NTSB LAX04CA105Accident · No injuriesData collectionFinal reportBeech B36TC · San Diego, CAthe pilot's misjudged speed and altitude, which led to a failure to attain the proper touchdown point and a subsequent runway overrun. Also causal was the pilot's delayed decision to perform a go-around.NTSB DEN04LA040Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Farmington, NMthe pilot's improper in-flight planning/decision making and his failure to maintain adequate airspeed which resulted in fuel starvation/exhaustion and a stall spin.NTSB NYC04LA061Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · College Park, MDThe loss of hydraulic fluid due to chaffing of a brake line by a strut fairing rivet, resulting in the failure of the braking system.NTSB MIA04FA047Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Lake Worth, FLThe pilot's inadequate control of the aircraft by his use of an excessive bank angle, and his failure to maintain airspeed which resulted in a stall and a loss of control following a loss of power in one engine. The reason for the loss of the engine power was…NTSB LAX04WA114Accident · No injuriesForeign investigationAirbus A320-214 · Paris, FranceNTSB LAX04CA104Accident · Serious injuriesData collectionFinal reportBeech F33A · Shoshone, CAthe CFI's failure to verify the wind direction prior to takeoff, which resulted in his failure to attain an adequate airspeed and led to an inadvertent stall-mush. The short runway and variable winds were factors.NTSB FTW04LA064Accident · No injuriesLimited investigationFinal reportCessna 182R · Ringgold, TXThe pilots failure to maintain clearance from the support wire while on a pipeline patrol flight. A contributing factor was the haze restricting the pilots forward visibility, and low altitude flight.NTSB LAX04FA102Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Big Pine, CAfailure of the pilot to maintain clearance with mountainous terrain for undetermined reasons.NTSB DEN04FA041Accident · No injuriesField investigationFinal reportDassault DA-20 Falcon Jet · Pueblo, COthe pilot's improper in-flight planning/decision to land on the contaminated runway, the stuck thrust reverser solenoid resulting in partial deployment of the right engine thrust reverser, and the pilot's inability to maintain directional control of the…NTSB LAX04FA096Accident · 2 fatalField investigationFinal reportCessna 172K · Grass Valley, CAthe pilot's continued visual flight into instrument meteorological conditions and failure to maintain an adequate terrain/object clearance altitude. Also causal was the pilot's improper in-flight decision to return to the origin airport in the face of…NTSB LAX04CA098Accident · No injuriesData collectionFinal reportCessna 172P · Granada Hills, CAthe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply.NTSB LAX04CA097Accident · No injuriesData collectionFinal reportEurocopter AS350 B3 · Mesa, AZthe pilot's excessive flare and mistimed collective application during a practice autorotation, which resulted in a loss of main rotor rpm and a subsequent hard landing. Also causal, was the flight instructor's delayed remedial action and inadequate…NTSB SEA04IA035Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8 · Seattle, WAThe flight crew's misidentification of the parallel taxiway as the active runway, resulting in the flight crew executing a landing on the taxiway. Factors include sun glare and shadows around the runway/taxiway environment, and visual illusions created by the…NTSB NYC04LA059Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Nicholasville, KYA leak in the fuel system due to a loose fitting, which resulted in a loss of engine power, and the inadequate maintenance inspection, which failed to detect/correct the security of the fitting.NTSB MIA04FA045Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Fort Pierce, FLThe flight instructor's failure to comply with the instrument approach procedure in that he descended prematurely below decision height resulting in an in-flight collision with trees, power lines and the ground. Contributing factors were the dark night light…NTSB DCA04IA018Incident · No injuriesIncident investigationFinal reportEmbraer 135 · Bangor, MASevere wear of the internal threads of the rudder interconnection contol rod which led to disengagement.NTSB CHI04LA060Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Minneapolis, MNA loss of engine power for undetermined reasons.NTSB MIA04FA044Accident · 2 fatalField investigationFinal reportCessna 150M · Venice, FLThe spatial disorientation of the flightcrew during the dark night and their failure to maintain control of the airplane resulting in the uncontrolled descent and in-flight collision with trees and terrain.NTSB LAX04LA108Accident · No injuriesLimited investigationFinal reportCessna P210N · Tucson, AZthe failure of the electrical charging system and pilot's failure to verify that the gear was down-and-locked prior to the complete electrical system failure.NTSB LAX04LA101Accident · No injuriesLimited investigationFinal reportScott RV-8A · Lihue, HIthe engine lost partial power for undetermined reasons.NTSB DEN04LA039Accident · No injuriesLimited investigationFinal reportCessna 182Q · St. George, UTthe pilot's improper flare which resulted in a hard landing.NTSB CHI04LA059Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Marine City, MIThe pilot's failure to maintain directional control of the airplane during landing. Factors associated with the accident were the icy snow covered runway, the tailwind conditions, the snowbank, and the ditch which the airplane contacted.NTSB CHI04IA056Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Rapid City, SDThe copilot's failure to maintain control of the airplane during the landing and the captain's delay in initiating remedial action. Factors contributing to the accident were the low ceiling and low visibility due to fog, and the aircraft's deviation from…NTSB MIA04FA043Accident · 1 fatalField investigationFinal reportPiper PA-30 · Clearwater, FLThe failure of both pilots to maintain adequate visual lookout while entering the traffic pattern (downwind leg) at an uncontrolled airport resulting in a midair collision. inadvertent stall, and in-flight collision with terrain.NTSB LAX04LA109Accident · No injuriesLimited investigationFinal reportPiper PA 22-160 · Carefree, AZThe pilot's inadequate fuel management by his failure to switch the fuel tank selector position, which resulted in fuel starvation, a loss of engine power.NTSB LAX04LA100Accident · No injuriesLimited investigationFinal reportCessna 170B · Santa Rosa, CAthe failure of the number 2 cylinder barrel due to fatigue. The lack of suitable landing terrain was a factor in the accident.NTSB CHI04LA058Accident · No injuriesLimited investigationFinal reportCessna 310R · Port Huron, MIThe loss of directional control as a result of reduced braking performance due to a snow-covered runway. Also causal was the pilot's decision to land with a quartering tailwind. The snowbank was a contributing factor.NTSB CHI04LA057Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Corydon, INThe student pilot become lost during the cross country flight and the instructor's inadequate supervision of both the flight and preflight planning. This led to the in-flight loss of engine power due to fuel exhaustion, a forced landing, and impact with…NTSB ATL04FA069Accident · 1 fatalField investigationFinal reportCessna 182A · Traphill, NCThe loss of engine power due to carburetor ice. Contributing factors were conditions conducive for carburetor icing.NTSB NYC04LA058Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Kelleys Island, OHThe pilot's improper decision to unload passengers and leave the airplane unattended while the engine was running, and the passenger's inadequate visual lookout, which resulted in an inadvertent encounter with a rotating propeller. A factor related to the…NTSB LAX04FA095Accident · 1 fatalField investigationFinal reportCessna 180K · Tehachapi, CAThe pilot's inadequate visual lookout during climb, and the pilot of the other airplane's inadequate visual lookout during cruise.NTSB FTW04FA062Accident · 1 fatalField investigationFinal reportBeech B36TC · Willow Park, TXThe pilot's failure to maintain aircraft control while maneuvering. Contributing factors were the dark night and rain.NTSB FTW04CA061Accident · No injuriesData collectionFinal reportPiper PA-32R · Poynor, TXThe pilot's failure to maintain aircraft control while on final approach. A factor was the downdraft.NTSB SEA04LA034Accident · No injuriesLimited investigationFinal reportCessna 185F · Deer Park, WAThe dual student pilot's failure to maintain directional control during the landing roll and the failure of the flight instructor to provide remedial action. A factor was snowbank.NTSB NYC04LA067Accident · No injuriesLimited investigationFinal reportCessna 421 · Ravenna, OHThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall and subsequent hard landing. A factor in the accident was degraded aircraft performance due to the airframe ice accumulation.NTSB MIA04CA040Accident · No injuriesData collectionFinal reportCessna 210L · Fort Meade, FLThe failure of the pilot to abort the takeoff after encountering fog during the preflight and engine run-up, and also his failure to maintain proper alignment with the runway during the takeoff roll due to a fogged windshield resulting in the collision with a…NTSB LAX04LA094Accident · No injuriesLimited investigationFinal reportCessna 305A · Casa Grande, AZThe failure of a tail wheel steering component (spring), which resulted in a loss of directional control and a ground loop during the landing roll. A contributing factor was the soft terrain adjacent to the runway.