Final 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 WHERE c.\"completionStatus\" = 'Completed' 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 WHERE c."completionStatus" = 'Completed' 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 ERA24LA148Accident · Serious injuriesClass 3 · LimitedFinal reportHughes 369D · Belleville, WVThe ingestion of foreign object debris into the engine, which resulted in a sudden loss of engine power and a subsequent collision with trees and terrain during the forced landing.NTSB CEN24LA138Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Aitkin, MNThe student pilot’s failure to maintain directional control during the takeoff in crosswind conditions.NTSB ANC24LA019Accident · No injuriesClass 4 · LimitedFinal reportMichael G Darby Dard 1 · Anchorage, AKThe pilot’s loss of directional control while landing in soft snow, resulting in a nose over.NTSB WPR24FA112Accident · 1 fatalClass 3 · FieldFinal reportHolmes William B AIR Creation Twin · Gila Bend, AZThe pilot’s loss of control and subsequent collision with a mesquite tree on approach to land.NTSB ERA24LA143Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Blackshear, GAA catastrophic engine failure due to oil starvation, which resulted in a total loss of engine power.NTSB WPR24LA114Accident · No injuriesClass 4 · LimitedFinal reportMooney M20K · Farmington, CAThe pilot’s improper preflight fuel planning that resulted in the loss of engine power due to fuel exhaustion.NTSB WPR24LA113Accident · Minor injuriesClass 4 · LimitedFinal reportKitfox S7 Super Sport · Asotin, WAPilot’s failure to maintain clearance from powerlines during low altitude flying.NTSB ERA24LA146Accident · No injuriesClass 4 · LimitedFinal reportBeech A23 24 · Somerset, PAThe student pilot’s failure to maintain directional control, and the flight instructor’s lack of remedial action during a landing attempt in a gusty wind, which resulted in a loss of directional control and runway excursion.NTSB ERA24LA141Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Winokur, GAA total loss of engine power due to the unseating and subsequent failure of the No. 4 piston connection rod bushing.NTSB CEN24LA137Accident · No injuriesClass 3 · LimitedFinal reportEnstrom Helicopter 280C · Port Lavaca, TXThe pilot’s improper manual engine mixture management which resulted in a loss of power. Contributing to the accident was the mechanic’s improper setting of the idle mixture adjustment and the pilot’s decision to take off with a known mechanical deficiency.NTSB WPR24LA115Accident · Minor injuriesClass 4 · LimitedFinal reportZenith Zodiac CH601 · Rawlins, WYThe student pilot’s failure to see and avoid powerlines during an unstabilized approach, which resulted the airplane landing short of the runway and coming to rest inverted.NTSB ERA24LA145Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Melbourne, FLThe student pilot’s failure to maintain directional control while landing in a crosswind.NTSB ERA24LA140Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · Logan, WVThe pilot’s delayed decision to perform a go-around while attempting to land on a wet runway with a tailwind, which resulted in a runway overrun and collision with trees.NTSB DCA24LA130Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-800 · Paris, TNAn encounter with convective turbulence.NTSB ANC24LA020Accident · Minor injuriesClass 4 · LimitedFinal reportStinson 108 · Houston, AKA total loss of engine power due to fuel starvation and the pilot's mismanagement of the available fuel.NTSB WPR24LA111Accident · Minor injuriesClass 4 · LimitedFinal reportPiper Aerostar 601P · Grass Valley, CAThe pilot’s failure to maintain directional control in a gusting wind condition.NTSB ERA24LA173Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Pembroke Pines, FLAn inflight collision with a bird while approaching the destination airport.NTSB ERA24LA144Accident · No injuriesClass 3 · LimitedFinal reportGlasair Sportsman 2+2 · Fort Meade, FLThe pilot’s inadequate inspection of the airplane following an inflight smoke event, which result in separation of the exhaust pipe and hot exhaust igniting the engine cowling, and a subsequent loss of engine power.NTSB ERA24LA142Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Homosassa Springs, FLThe pilot’s failure to confirm the throttle position before attempting to start the airplane’s engine by manually rotating the propeller, which resulted in a loss of airplane control.NTSB CEN24LA136Accident · No injuriesClass 4 · LimitedFinal reportBellanca 8GCBC · Grind Stone City, MIThe pilot's failure to maintain directional control during the landing roll on a wet turf runway with a quartering tailwind.NTSB CEN24LA135Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Knox City, TXThe pilot’s failure to maintain directional control during takeoff, which resulted in a rollover and an impact with terrain.NTSB WPR24LA109Accident · No injuriesClass 3 · LimitedFinal reportRaytheon B200 · Billings, MTThe pilot's improper engine start, resulting in the engine starters remaining engaged and the generators not being activated, which led to the discharge of the airplane’s battery and subsequent total electrical failure after takeoff. Contributing to the…NTSB ERA24LA139Accident · No injuriesClass 3 · LimitedFinal reportBeech K35 · Front Royal, VAA total loss of engine power due to fuel starvation as a result of the pilot’s mismanagement of the airplane’s fuel supply.NTSB CEN24LA134Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T182T · Lapeer, MIThe pilot’s failure to maintain aircraft control while landing in a gusting crosswind condition.NTSB CEN24LA133Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Falcon, COThe flight instructor’s failure to maintain control during takeoff which resulted in an aerodynamic stall and an impact with terrain.NTSB WPR24LA110Accident · No injuriesClass 3 · LimitedFinal reportBeech 60 · Chino, CACorrosion on a landing gear retract rod assembly which precluded an extension of the gear and resulted in a gear-up landing.NTSB ERA24LA226Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Griffin, GAThe pilot’s failure to extend the airplane’s landing gear before landing.NTSB WPR24FA105Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Madras, ORThe pilot’s continued visual flight rules flight into instrument meteorological conditions, which resulted in an encounter with turbulence and structural icing conditions, loss of control, and subsequent impact with terrain.NTSB ERA24FA136Accident · 5 fatalClass 3 · FieldFinal reportIsrael Aircraft Industries 1125 Westwind Astra · Hot Springs, VAThe PIC’s continuation of an unstabilized approach in gusting wind conditions and his failure to monitor the airplane’s altitude during the approach, which led to a descent into terrain short of the runway. Contributing was the flight crew’s failure to set…NTSB ANC24LA018Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Skwentna, AKThe pilot’s failure to maintain directional control while taxiing, which resulted in a collision with trees.NTSB WPR24LA107Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-11 · Death Valley, CAThe pilot’s failure to maintain directional control during the landing rollout, resulting in a ground loop and runway excursion.NTSB ERA24LA135Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Homestead, FLA loss of engine power due to carburetor ice as a result of the pilot’s failure to use carburetor heat in conditions conducive to the formation of carburetor ice.NTSB ERA24LA134Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Clay, KYThe pilot’s decision to attempt a VFR flight in instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s impairment due to alcohol consumption.NTSB DCA24LA124Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Aylett, VAAn encounter with clear air turbulence during descent.NTSB WPR24LA106Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Whitethorn, CAA total loss of engine power due to water-contaminated fuel.NTSB ERA24LA133Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Greensboro, NCThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB ERA24LA132Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28RT-201 · Allentown, PAThe pilot’s failure to maintain a proper descent rate during the final approach, resulting in a hard landing and collision with a runway edge light.NTSB DCA24FA120Accident · No injuriesClass 2 · FieldFinal reportBoeing 737-8 · Houston, TXThe captain's decision not to establish and maintain deceleration devices in accordance with company training and standard operating procedures.NTSB WPR24FA104Accident · 1 fatalClass 3 · FieldFinal reportKolb Firestar KXP · Cave Junction, ORThe pilot's exceedance of the airplane's critical angle of attack during a turn, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's use of potentially impairing substances with bipolar disorder, which resulted in a decreased…NTSB ERA24LA138Accident · No injuriesClass 4 · LimitedFinal reportPiper PA24 · Stafford, VAAn overloading of the landing gear push/pull cable rod ends, which resulted in the landing gear being seized in an intermediate position during the subsequent landing.NTSB CEN24LA128Accident · No injuriesClass 3 · LimitedFinal reportEurocopter Deutschland MBB-BK 117 C-2 · West Lafayette, INThe failure of maintenance personnel to properly install the tail rotor pitch change slider attachment hardware (T-bolt), which led to the disconnection of the pitch change slider, a loss of tail rotor control, and subsequent hard landing. Contributing to the…NTSB WPR24LA108Accident · No injuriesClass 4 · LimitedFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Maricopa, AZThe pilot’s failure to maintain pitch control, which resulted in abnormal contact with the runway.NTSB WPR24FA103Incident · No injuriesClass 3 · FieldFinal reportCirrus Design SR22T · Bellevue, WAA total loss of engine power due to a fatigue fracture of the crankshaft.NTSB CEN24LA132Accident · No injuriesClass 4 · LimitedFinal reportPietenpol Aircamper · Lockhart, TXThe pilot’s failure to maintain control during after takeoff.NTSB ERA24FA127Accident · 5 fatalClass 3 · FieldFinal reportPiper PA32RT · Nashville, TNThe pilot’s failure to ensure the proper placement of the fuel selector during the approach and landing, which resulted in fuel starvation and a subsequent total loss of engine power.NTSB CEN24LA131Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Lubbock, TXThe student pilot’s failure to maintain directional control during a touch-and-go.NTSB CEN24LA129Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Eurocopter AS350B3 · Fort Morgan, COAn inflight collision with birds while on approach.NTSB WPR24LA101Accident · Minor injuriesClass 4 · LimitedFinal reportUtah County Sheriff CCX-2000 · Spanish Fork, UTThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB ERA24LA151Accident · No injuriesClass 3 · LimitedFinal reportPalmetto Electronics X-AIR H · Ellenboro, NCA total loss of engine power due to an inoperative ignition system.NTSB ERA24LA131Accident · No injuriesClass 4 · LimitedFinal reportFairchild SA227-AT · Smyrna, TNThe airplane encountered a sink hole while taxiing.