NTSB investigations
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 DCA24WA145AccidentClass 5 · ForeignBoeing 787 · Tokyo, JapanNTSB GAA24WA126IncidentClass 5 · ForeignBeech A36 · Geraldton, AustraliaNTSB GAA24WA146AccidentClass 5 · ForeignCessna 182 · Manuel Urbano, BrazilNTSB GAA24WA121Accident · 1 fatalClass 5 · ForeignRans S12 · Tabacundo, EcuadorNTSB GAA24WA116Accident · No injuriesClass 5 · ForeignCessna U206 · Waramasen Indigenous Community, VenezuelaNTSB 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 GAA24WA117Accident · No injuriesClass 5 · ForeignBellanca Citabria · Farkashegy, HungaryNTSB GAA24WA114AccidentClass 5 · ForeignPiper 24 · Leicestershire, United KingdomNTSB 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 GAA24WA127Accident · Minor injuriesClass 5 · ForeignRobinson Helicopter 22 · Candoi, BrazilNTSB 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 DCA24WA125Accident · Serious injuriesClass 3 · ForeignBoeing 787 · Auckland, New ZealandNTSB 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 GAA24WA112AccidentClass 5 · ForeignAir Tractor AT502 · San Alberto, Costa RicaNTSB 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 GAA24WA136Accident · No injuriesClass 5 · ForeignBell 407 · Mwachon, KenyaNTSB 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 DCA24WA123Incident · No injuriesClass 5 · ForeignBoeing 777 · West Sussex, United KingdomNTSB 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 GAA24WA129Accident · Minor injuriesClass 5 · ForeignPiper PA28 · Genk/Zwartberg, BelgiumNTSB GAA24WA118AccidentClass 5 · ForeignAero Commander 500-S · Bathurst, AustraliaNTSB GAA24WA109Accident · Serious injuriesClass 5 · ForeignCessna 206 · Macas, Ecuador