NTSB investigations
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 ERA25LA019Accident · 1 fatalClass 3 · LimitedFinal reportCessna 150 · Gainesville, GAThe pilot’s sudden incapacitation due to an in-flight cardiac arrest, which necessitated a landing by a non-pilot passenger and resulted in a hard landing and collapse of the nose landing gear.NTSB DCA25WA010AccidentClass 5 · ForeignAirbus A321 · Dublin, IrelandNTSB WPR25LA023Accident · No injuriesClass 4 · LimitedFinal reportCameron Balloons US A-275 · Wittmann, AZThe pilot’s failure to maintain clearance from a power line during an approach.NTSB ERA25LA034Accident · No injuriesClass 4 · LimitedFinal reportHunt Exec 162F · North East, PAThe pilot’s failure to maintain control of the helicopter during landing following an encounter with an unanticipated wind gust, which resulted in a dynamic rollover.NTSB ERA25LA030Accident · No injuriesClass 3 · LimitedFinal reportZenith Zodiac 601 HDS · Altoona, PAThe total loss of engine power due to fuel starvation as a result of a deteriorated gascolator gasket. Contributing was the failure of the mechanic to replace the gasket during the most recent condition inspection.NTSB ERA25LA022Accident · No injuriesClass 4 · LimitedFinal reportTextron T206H · Blountville, TNThe pilot’s failure to maintain directional control during takeoff and subsequent rejected takeoff, which resulted in a runway excursion. Contributing to the accident was the pilot’s failure to verify rudder trim setting prior to takeoff.NTSB ERA25LA021Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Sanford, METhe pilot’s failure to maintain directional control during the landing roll, resulting in a runway excursion and collision with terrain.NTSB CEN25LA021Accident · No injuriesClass 3 · LimitedFinal reportMooney M20K · Elizabeth, LAThe pilot’s failure to set the engine fuel mixture to the required setting, which resulted in reduced engine power during a go-around and subsequent impact with trees. Contributing to the accident, the failure of the mechanic to perform a current fuel…NTSB CEN25LA020Accident · No injuriesClass 4 · LimitedFinal reportStarship Enterprise · Addison, TXForeign object debris damage to the ventral stabilizer.NTSB CEN25LA018Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32R-301 · Van, TXThe mechanic’s improper maintenance of the engine’s air induction scat duct, which collapsed during the flight and resulted in a loss of engine power.NTSB GAA25WA012Accident · 2 fatalClass 5 · ForeignNorth American SNJ-3 · Räyskälä, FinlandNTSB ERA25LA017Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182 · East Ellijay, GAThe pilot’s inadequate compensation for winds during landing., which resulted in a loss of control and an aerodynamic stall.NTSB ERA25LA016Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Newnan, GAThe pilot’s inadequate use of carburetor heat during the engine run-up, which resulted in a partial loss of power due to carburetor icing during takeoff.NTSB DCA25WA011Incident · No injuriesClass 4 · ForeignBoeing 737 · Deli Serdang, IndonesiaNTSB CEN25LA017Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Shreveport, LAThe pilot’s inadvertent failure to lower the landing gear before touching down.NTSB CEN25LA015Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · New Orleans, LAThe failure of a landing gear torque arm which resulted in a landing gear collapse and runway excursion.NTSB ENG25WA007IncidentClass 5 · ForeignBombardier Global 7500 · Amsterdam, NetherlandsNTSB CEN25FA014Accident · 1 fatalClass 3 · FieldPreliminary reportRans S12 · Church Point, LAOn October 15, 2024, at 1514 central daylight time, a Rans S12S, N912RS, was involved in an accident near Church Point, Louisiana. The airline transport pilot sustained fatal injuries. The airplane was destroyed. The airplane was operated under Title 14 Code…NTSB ERA25FA008Accident · 1 fatalClass 3 · FieldFinal reportCessna 336 · Savannah, GAThe pilot’s inadequate fuel planning, which resulted in fuel exhaustion and a total loss of engine power to both engines.NTSB DCA25WA005IncidentClass 5 · ForeignBoeing 777 · Rawalpindi, PakistanNTSB WPR25LA036Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180 · Owinza, IDThe pilot’s failure to maintain clearance from the water during a low pass over a lake.NTSB WPR25LA019Accident · No injuriesClass 4 · LimitedFinal reportJared Baker Rans DSG INC S21 OUT · Springer, NMThe pilot's failure to maintain directional control during takeoff, which resulted in a collision with an obstacle.NTSB WPR25LA017Accident · No injuriesClass 4 · LimitedFinal reportCessna 177B · Creswell, ORThe pilot’s loss of aircraft control during the landing flare and subsequent aborted landing.NTSB WPR25LA016Accident · No injuriesClass 4 · LimitedFinal reportLindstrand 80E · Albuquerque, NMThe pilot’s loss of control during landing, which resulted in the balloon’s envelope contacting powerlines.NTSB WPR25LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna A185E · Seattle, WAThe pilot’s failure to maintain directional control during landing roll with a crosswind.NTSB GAA25WA014Accident · No injuriesClass 5 · ForeignCessna 525 · Rio de Janeiro, BrazilNTSB ERA25LA014Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182 · South Charleston, WVThe pilot’s decision to continue landing after encountering a strong tailwind, which resulted in a loss of control and subsequent runway excursion.NTSB ERA25LA013Accident · No injuriesClass 4 · LimitedFinal reportMaule M8 · Rowlesburg, WVThe pilot’s failure to maintain directional control during the landing.NTSB DCA25WA007IncidentClass 5 · ForeignBoeing 737 · Las Puntillas, SpainNTSB WPR25LA015Accident · No injuriesClass 4 · LimitedFinal reportGlasflugel Standard Libelle · Moriarty, NMThe pilot’s failure to maintain an adequate glidepath, which resulted in the glider landing on rough terrain short of the runway.NTSB GAA25WA013Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Ouro Preto - Minas Gerais, BrazilNTSB ERA25LA015Accident · No injuriesClass 4 · LimitedFinal reportAviat A1 · Rowlesburg, WVThe pilot’s failure to maintain directional control during the landing roll, resulting in the on-ground collision with trees.NTSB ERA25LA012Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Louisville, KYA total loss of engine power for undetermined reasons.NTSB ERA25LA011Accident · No injuriesClass 3 · LimitedFinal reportSaint Glasair II SFT · Forest, VAThe installation of a non-failsafe coupler that resulted in the separation of the throttle cable from the throttle arm and a subsequent partial loss of engine power.NTSB ERA25LA010Accident · No injuriesClass 4 · LimitedFinal reportDitsler Paul A Dakota Hawk · Nicklesville, GAThe pilot’s inadequate preflight inspection, fuel planning, and improper fuel management during flight, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent off-airport hard landing.NTSB CEN25LA013Accident · Minor injuriesClass 3 · LimitedFinal reportRotorway Exec · Plymouth, INA loss of control due to the failed forward tail rotor belt as a result of the owner’s failure to follow the helicopter manufacturer’s tail rotor belt replacement recommendations.NTSB DCA25WA246Incident · No injuriesForeign investigationEmbraer ERJ190 · Brisbane, AustraliaNTSB CEN25LA016Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Springfield, MOThe flight instructor’s inability to confirm landing gear position before landing due to the sun glare which resulted in gear up landing. Contributing to the accident was an undetected tripped circuit breaker for the landing gear and the inoperative gear…NTSB WPR25LA081Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons US ZL-70 · Rio Rancho, NMThe pilot’s inability to maintain clearance from a tree during the landing approach due to a gusting wind shift.NTSB WPR25LA010Accident · No injuriesClass 4 · LimitedFinal reportEnstrom Helicopter 280C · Vale, ORThe pilot’s failure to maintain engine and rotor rpm during takeoff, that resulted in a hard landing.NTSB WPR25FA007Accident · 5 fatalClass 3 · FieldPreliminary reportBeech 95-B55 · Avalon, CAOn October 8, 2024, at 2005 Pacific daylight time, a Beech 95-B55, N73WA, was destroyed when it was involved in an accident near Avalon, California. The pilot, two pilot rated passengers, and two student pilot passengers were fatally injured. The airplane was…NTSB GAA25WA281Accident · Serious injuriesClass 4 · ForeignAir Tractor AT-504 · Gizan, Saudi ArabiaNTSB GAA25WA011Accident · No injuriesClass 5 · ForeignBeech 200 · Qld, AustraliaNTSB CEN25LA010Accident · No injuriesClass 4 · LimitedFinal reportZodiac 601 · Augusta, KSThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR25LA011Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT502 · Corcoran, CAA total loss of engine power due to the pilot's improper manipulation of the condition lever during flight, which resulted in fuel starvation and a forced landing.NTSB WPR25LA008Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-36-285 · Marana, AZOn October 8, 2024, about 0745 mountain standard time, a Piper PA-36-285, N9928P, was substantially damaged when it was involved in an accident near Marana, Arizona. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR25LA006Accident · Minor injuriesClass 4 · LimitedFinal reportAgustawestland AW109SP · Kamas, UTThe pilot’s exceedance of the helicopter’s available power while landing in a confined area, which resulted in a loss of tail rotor effectiveness and a hard landing.NTSB GAA25WA009Accident · Minor injuriesClass 5 · ForeignCessna U206 · Barinas, VenezuelaNTSB ERA25LA031Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Louisville, KYThe pilot’s improper landing flare and control inputs, which resulted in a hard landing. Contributing was the flight instructor’s delayed remedial action.NTSB DCA25WA289IncidentClass 5 · ForeignBoeing 737 · Phuket, Thailand