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 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.Apr 27, 2000 · N146TM · Substantial damageNTSB 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.Apr 27, 2000 · N622EH · DestroyedNTSB 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.Apr 27, 2000 · N1978Q · DestroyedNTSB NYC00WA123Accident · No injuriesForeign investigationRobinson R-44 · Cesis, LatviaApr 26, 2000 · LYHBH · DestroyedNTSB NYC00LA121Accident · No injuriesLimited investigationFinal reportCessna 150D · Waynesville, OHThe pilot's inadequate preflight, and the water that remained in the fuel system after the preflight.Apr 26, 2000 · N4182U · Substantial damageNTSB 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.Apr 26, 2000 · N76176 · Substantial damageNTSB 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.Apr 25, 2000 · N39081 · Substantial damageNTSB 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…Apr 25, 2000 · N67435 · DestroyedNTSB FTW00LA131Accident · Minor injuriesLimited investigationFinal reportBeech BE-35 · Lancaster, TXthe loss of engine power for undetermined reasons.Apr 25, 2000 · N5269C · Substantial damageNTSB CHI00LA124Accident · No injuriesLimited investigationFinal reportSaab-Scania SF-340B · Hancock, MIthe deer which ran onto the runway and were subsequently struck by the airplane.Apr 25, 2000 · N404XJ · Substantial damageNTSB 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…Apr 25, 2000 · N779AN · No damageNTSB 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.Apr 25, 2000 · N428MB · DestroyedNTSB 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.Apr 24, 2000 · N55PJ · Substantial damageNTSB 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.Apr 24, 2000 · N9177F · Substantial damageNTSB 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.Apr 23, 2000 · N66430 · Substantial damageNTSB CHI00LA122Accident · No injuriesLimited investigationFinal reportCunningham Pietenpol Aircamper · Boone, IAthe pilot not maintaining directional control. Factors were the gusts and the fence.Apr 23, 2000 · N899TC · Substantial damageNTSB 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.Apr 23, 2000 · N1200A · Substantial damageNTSB 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.Apr 22, 2000 · N82698 · Substantial damageNTSB 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…Apr 22, 2000 · N272AS · Substantial damageNTSB 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.Apr 22, 2000 · N1253Z · DestroyedNTSB LAX00WA205Accident · 6 fatalForeign investigationCessna U206F · Wanaka, New ZealandApr 22, 2000 · ZKJBJ · DestroyedNTSB LAX00FA170Accident · 2 fatalField investigationFinal reportEmigh Trojan A2 · Brentwood, CAthe pilot's failure to maintain control of the airplane.Apr 22, 2000 · N8324H · DestroyedNTSB 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…Apr 22, 2000 · N15466 · DestroyedNTSB 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.Apr 22, 2000 · N2086D · DestroyedNTSB DCA00WA041Incident · No injuriesForeign investigationBoeing 747-300 · Rome, ItalyApr 22, 2000 · VH-EBWNTSB 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.Apr 22, 2000 · N627RM · Substantial damageNTSB 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.Apr 22, 2000 · N6096P · Substantial damageNTSB 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.Apr 22, 2000 · N60763 · Substantial damageNTSB 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.Apr 21, 2000 · N3579V · Substantial damageNTSB 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.Apr 21, 2000 · N5632H · DestroyedNTSB 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…Apr 21, 2000 · N6094H · Substantial damageNTSB LAX00LA166Accident · No injuriesLimited investigationFinal reportPZL-Mielec M-18A · Williams, CAA momentary interruption in engine power for undetermined reasons.Apr 21, 2000 · N62587 · Substantial damageNTSB LAX00LA165Accident · No injuriesLimited investigationFinal reportCessna 152 · Fresno, CAFuel exhaustion during cruise flight due to the student pilot becoming disoriented and lost.Apr 21, 2000 · N152SC · Substantial damageNTSB FTW00LA130Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Gould, ARThe stall/mush encountered by the pilot. A factor was the crosswind.Apr 21, 2000 · N8699S · Substantial damageNTSB 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.Apr 21, 2000 · N305MM · Substantial damageNTSB CHI00LA118Accident · No injuriesLimited investigationFinal reportCessna 170A · St. Paul, MNthe broken landing gear axle.Apr 21, 2000 · N1233D · Substantial damageNTSB 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.Apr 20, 2000 · N9187V · Substantial damageNTSB 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.Apr 20, 2000 · N7528S · Substantial damageNTSB 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.Apr 20, 2000 · N61869 · Substantial damageNTSB 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.Apr 20, 2000 · N7260N · Substantial damageNTSB LAX00LA162Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Lodi, CAA loss of engine power for undetermined reasons.Apr 20, 2000 · N3629F · Substantial damageNTSB FTW00LA129Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-D · Lindsay, TXThe student pilot's inadequate compensation for wind conditions. A factor was the downdraft wind condition.Apr 20, 2000 · N99470 · Substantial damageNTSB ATL00LA044Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Colquitt, GAA loss of engine power for undetermined reasons.Apr 20, 2000 · N8899S · Substantial damageNTSB 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.Apr 20, 2000 · N9762C · Substantial damageNTSB MIA00WA188Accident · 3 fatalForeign investigationCessna 150J · Epping Essex, RussiaApr 19, 2000 · GINGR · 2 aircraft · Substantial damageNTSB LAX00LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Eureka, CAThe pilot's failure to compensate for a crosswind and to maintain directional control during landing.Apr 19, 2000 · N6251Q · Substantial damageNTSB FTW00LA127Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Tomball, TXEngine seizure due to the rupture of an oil cooler line.Apr 19, 2000 · N7038V · Substantial damageNTSB DCA00WA040Accident · 131 fatalForeign investigationBoeing 737-200 · Samal Island, PhilippinesApr 19, 2000 · RPC30 · DestroyedNTSB 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.Apr 19, 2000 · N9429Q · Substantial damageNTSB 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.Apr 19, 2000 · N41081 · Substantial damage