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 LAX00LA174Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Healdsburg, CAFailure of the flight review pilot to compensate for the crosswind and maintain flying speed during takeoff.NTSB LAX00LA172Accident · 1 fatalLimited investigationFinal reportRobinson R22 Beta · San Diego, CAThe failure of the flight instructor to maintain control of the helicopter, resulting in skid contact with an obstacle and dynamic roll over.NTSB CHI00FA123Accident · 1 fatalField investigationFinal reportCessna 177RG · Watertown, SDthe pilot failed to maintain aircraft control due to spatial disorientation. Factors relating to the accident were the dark night, clouds, and rain.NTSB NYC00WA123Accident · No injuriesForeign investigationRobinson R-44 · Cesis, LatviaNTSB NYC00LA121Accident · No injuriesLimited investigationFinal reportCessna 150D · Waynesville, OHThe pilot's inadequate preflight, and the water that remained in the fuel system after the preflight.NTSB FTW00LA132Accident · No injuriesLimited investigationFinal reportCessna 140 · Hunter, OKThe pilot's inadequate preflight resulting in the loss of the oil cap and subsequent loss of engine oil. A factor was the lack of suitable terrain for the landing.NTSB NYC00FA122Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-10-30 · Newark, NJStress rupture of the 2nd-stage low pressure turbine anti-rotation nozzle locks, resulting from inadequate nozzle lock design.NTSB LAX00FA171Accident · 2 fatalField investigationFinal reportCessna 152 · Austin, NVThe pilot's decision to attempt flight in an area of high rising mountainous terrain at an inadequate altitude, which resulted in an impact during a turn to reverse direction. A contributing factor was the pilot's lack of total experience in mountain flying…NTSB FTW00LA131Accident · Minor injuriesLimited investigationFinal reportBeech BE-35 · Lancaster, TXthe loss of engine power for undetermined reasons.NTSB CHI00LA124Accident · No injuriesLimited investigationFinal reportSaab-Scania SF-340B · Hancock, MIthe deer which ran onto the runway and were subsequently struck by the airplane.NTSB CHI00IA125Incident · No injuriesIncident investigationFinal reportBoeing 777-223ER · Chicago, ILthe flightcrew not detecting the runway closure NOTAM and the Air Traffic Control personnel on the metering, ground, and local positions giving an improper clearance to taxi to a closed runway. Factors were the closed runway, ATIS information not issued by…NTSB ATL00FA048Accident · 3 fatalField investigationFinal reportEurocopter BK117-A3 · St. Petersburg, FLThe pilot's failure to maintain clearance that resulted in the in-flight collision with a tower.NTSB SEA00LA075Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Ashland, ORThe pilot's failure to refuel the airplane, which resulted in a loss of engine power due to fuel exhaustion. Unsuitable terrain for a landing was a contributing factor.NTSB CHI00LA121Accident · No injuriesLimited investigationFinal reportHughes 500C · Salina, KSthe loss of tail rotor effectiveness and the autorotation performed by the pilot. The unfavorable wind was a contributing factor.NTSB NYC00LA120Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Lancaster, OHThe pilot's improper recovery from a bounced landing. A factor in the accident was the pilot's decision to operate the airplane over the maximum gross weight and his improper landing flare.NTSB CHI00LA122Accident · No injuriesLimited investigationFinal reportCunningham Pietenpol Aircamper · Boone, IAthe pilot not maintaining directional control. Factors were the gusts and the fence.NTSB ANC00LA049Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mccarthy, AKThe pilot's inadequate compensation for the gusty wind conditions. A factor associated with the accident was the wind gusts.NTSB SEA00LA078Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Lexington, ORThe pilot's failure to adequately compensate for wind conditions upon encountering a wind shift on takeoff. A factor was variable winds.NTSB SEA00LA077Accident · No injuriesLimited investigationFinal reportPZL-Bielsko Jantar 2A · Hood River, ORThe pilot's failure to maintain directional control of the glider after its wing came in contact with long grass growing on the runway surface. Factors include the pilot's improper decision to attempt a landing on a runway with known directional control…NTSB NYC00FA119Accident · 2 fatalField investigationFinal reportBeech N35 · Conicville, VAThe pilot's in-flight decision to continue flight into IMC conditions, and his failure to maintain control of the airplane. Factors related to the accident were the failure of the vacuum pump and the pilot's lack of recent instrument time.NTSB LAX00WA205Accident · 6 fatalForeign investigationCessna U206F · Wanaka, New ZealandNTSB LAX00FA170Accident · 2 fatalField investigationFinal reportEmigh Trojan A2 · Brentwood, CAthe pilot's failure to maintain control of the airplane.NTSB LAX00FA169Accident · 1 fatalField investigationFinal reportAir Tractor 502A · Queen Creek, AZThe fatigue failure and in-flight separation of the left wing due to the manufacturer's underestimation during the aircraft design process of the time interval from fatigue crack initiation to failure, and, the manufacturer's subsequent specification of an…NTSB LAX00FA168Accident · 1 fatalField investigationFinal reportBeech D35 · Agua Dulce, CAThe pilot's failure to maintain terrain clearance while cruising up a mountain pass, on a dark night, in IMC conditions, and his improper in-flight decision to perform a VFR flight in the inclement weather.NTSB DCA00WA041Incident · No injuriesForeign investigationBoeing 747-300 · Rome, ItalyNTSB CHI00LA119Accident · No injuriesLimited investigationFinal reportBrice Rotorway Exec 162F · Kimberling, MOaircraft control not being maintained by the pilot. Factors to the accident were the encountered dynamic rollover and the uneven terrain.NTSB ATL00LA046Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401-B · Lawrenceburg, TNThe loss of engine power due to a stuck exhaust valve that resulted in the collision with a tree while maneuvering for the forced landing.NTSB ATL00LA045Accident · No injuriesLimited investigationFinal reportCessna 150 · Waycross, GAThe student pilot's inaccurate fuel consumption calculation that resulted in the total loss of engine power due to fuel exhaustion and the subsequent collision with a utility pole.NTSB SEA00LA076Accident · No injuriesLimited investigationFinal reportCessna 140 · Red Lodge, MTA high density altitude and inadequate preflight planning/preparation. Not attaining a proper climb rate, not maintaining a proper runway alignment, and gusting wind conditions were factors.NTSB NYC00FA118Accident · 5 fatalField investigationFinal reportMooney M20J · Norton, VAThe pilot's improper weather evaluation, which resulted in a loss of aircraft control. Factors in this accident were icing conditions, and aircraft loading which exceed the airplane's weight and balance limitations.NTSB LAX00LA167Accident · No injuriesLimited investigationFinal reportEurocopter AS-350 BA · Kahului, HIFailure of the manufacturer to ensure proper quality control of the ignition solenoid housing chamfer area, which allowed for insufficient clamping forces between the ignition solenoid housing and T-fitting, and the eventual separation of the T-fitting, loss…NTSB LAX00LA166Accident · No injuriesLimited investigationFinal reportPZL-Mielec M-18A · Williams, CAA momentary interruption in engine power for undetermined reasons.NTSB LAX00LA165Accident · No injuriesLimited investigationFinal reportCessna 152 · Fresno, CAFuel exhaustion during cruise flight due to the student pilot becoming disoriented and lost.NTSB FTW00LA130Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Gould, ARThe stall/mush encountered by the pilot. A factor was the crosswind.NTSB DEN00LA077Accident · No injuriesLimited investigationFinal reportBeech A36TC · Monument Valley, UTFailure by the pilot to maintain control of the aircraft during landing roll. Factors were a dust devil/whirlwind and the pilot's lack of landing currency.NTSB CHI00LA118Accident · No injuriesLimited investigationFinal reportCessna 170A · St. Paul, MNthe broken landing gear axle.NTSB NYC00LA117Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Middletown, RIan inadequate preflight inspection by the pilot which did not detect the water in the fuel tanks prior to departure.NTSB MIA00LA140Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Vieques, PRThe pilot's improper compensation for wind conditions during approach to landing resulting in the aircraft touching down hard, short of the runway, and receiving substantial damage.NTSB LAX00TA163Accident · Minor injuriesFinal reportHughes OH-6A · Green Valley, AZCompany maintenance personnel's failure to secure an attachment nut to a control link. While maneuvering, the parts separated and resulted in the total cyclic control system failure and impact into rough terrain.NTSB LAX00LA164Accident · No injuriesLimited investigationFinal reportCessna U206G · Parker, AZThe failure of the pilot to obtain the proper airspeed during landing, which resulted in a hard landing and subsequent porpoise down the runway.NTSB LAX00LA162Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Lodi, CAA loss of engine power for undetermined reasons.NTSB FTW00LA129Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-D · Lindsay, TXThe student pilot's inadequate compensation for wind conditions. A factor was the downdraft wind condition.NTSB ATL00LA044Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Colquitt, GAA loss of engine power for undetermined reasons.NTSB ATL00LA043Accident · No injuriesLimited investigationFinal reportHiller UH-12ET · Stonesboro, SCThe pilot's improper inflight decision not to refuel which resulted in fuel exhaustion and a total loss of engine power.NTSB MIA00WA188Accident · 3 fatalForeign investigationCessna 150J · Epping Essex, RussiaNTSB LAX00LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Eureka, CAThe pilot's failure to compensate for a crosswind and to maintain directional control during landing.NTSB FTW00LA127Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Tomball, TXEngine seizure due to the rupture of an oil cooler line.NTSB DCA00WA040Accident · 131 fatalForeign investigationBoeing 737-200 · Samal Island, PhilippinesNTSB CHI00LA116Accident · No injuriesLimited investigationFinal reportBeech 58 · Decatur, ILthe failure of the pilot to extend the landing gear which resulted in the gear-up landing. A factor to the accident was the pilot's failure to complete the landing checklist.NTSB ATL00LA042Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Rock Hill, SCThe maintenance personnel's failure to re-torque the engine driven fuel pump in accordance with an Airworthiness Directive that resulted in a fuel leak and a subsequent engine fire.