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 WPR21LA096Accident · No injuriesClass 4 · LimitedFinal reportHeckel Super Sportsman · Spotted Bear, MTThe pilot’s failure to maintain aircraft control during the landing roll on an unimproved snow-covered runway which resulted in a nose-over.NTSB ERA21WA118Accident · 6 fatalClass 5 · ForeignBeech 95 · Porto Nacional, BrazilNTSB WPR21LA158Accident · 1 fatalClass 3 · LimitedFinal reportArbc Inc DBA Lindstrand 77A · Rio Rancho, NMThe pilot’s failure to maintain the proper descent rate during the balloon’s approach to landing, which resulted in a hard landing and fatal passenger injury when the passenger fell out of the basket.NTSB GAA21WA045Accident · No injuriesClass 5 · ForeignCanadair CL600 · Los Mochis, Sinaloa, MexicoNTSB ERA21LA114Accident · Minor injuriesClass 4 · LimitedFinal reportAviat A1 · Terrell, NCThe pilot’s failure to retract the landing gear on the amphibious airplane prior to a water landing, resulting in a nose over and structural damage to the airframe. The mechanic’s failure to remove electrical tape from the pitot tube, the pilot’s inadequate…NTSB ERA21LA113Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Rockingham, NCThe pilot’s improper recovery from a bounced landing, which resulted in a subsequent hard landing and a runway excursion.NTSB ERA21LA112Accident · No injuriesClass 3 · LimitedFinal reportCessna U206 · Denton, NCA partial loss of engine power for reasons that could not be determined based on available information.NTSB WPR21LA093Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Queen Creek, AZThe pilot's uncoordinated flight control inputs while entering a hover, which lead to a loss of aircraft control which resulted in the left skid making contact with the ground, causing the helicopter to roll on its side.NTSB GAA21WA015Accident · 1 fatalClass 5 · ForeignAir Tractor AT402 · Hoopstad, South AfricaNTSB ERA21LA123Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-301 · Homestead, FLA total loss of power for reasons that could not be determined, as the airplane was not recovered from the water following the ditching.NTSB CEN21LA116Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 600N · Mankato, MNThe pilot’s loss of situational awareness while landing, resulting in an impact with power lines.NTSB WPR21WA091Accident · 5 fatalClass 4 · ForeignBell 430 · Ladysmith Kwa Zulu Natal Province., South AfricaNTSB WPR21LA094Accident · Minor injuriesClass 3 · LimitedFinal reportRandy Wayne Maloney M1 · Eagle Point, ORA partial loss of engine power for reasons that could not be determined based on available evidence.NTSB ERA21WA110Accident · 4 fatalClass 5 · ForeignMD Helicopter 369E · Pena Larga, VenezuelaNTSB ERA21LA109Accident · Serious injuriesClass 3 · LimitedFinal reportPlante Challenger II · Minneola, FLFailure of the engine/propeller drive belt.NTSB GAA21WA029Accident · 1 fatalClass 5 · ForeignBell 206 · Wolseley, South AfricaNTSB GAA21WA019Accident · Serious injuriesClass 5 · ForeignCessna 401 · Tapachula, Chiapas, MexicoNTSB ERA21LA164Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Miami, FLThe pilot’s failure to maintain control of the airplane during takeoff, which resulted in an aerodynamic stall and impact with terrain. Also causal was the flight instructor’s inadequate remedial action.NTSB ERA21LA106Accident · No injuriesClass 3 · LimitedFinal reportAmerican AA5 · Leesburg, VAThe weakened structure of the left horizontal stabilizer, which resulted in elevator flutter and subsequent partial separation of the left elevator in flight. Contributing to the accident were the lack of elevator authority while landing due to the damaged…NTSB DCA21WA076IncidentClass 5 · ForeignBoeing 737 · Sao Paulo, BrazilNTSB DCA21WA068AccidentClass 5 · ForeignBoeing 737 · Exeter, United KingdomNTSB CEN21LA113Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT-802A · Newellton, LAThe pilot’s failure to maintain clearance from powerlines/poles and terrain while maneuvering for reasons that could not be determined based on available evidence.NTSB ERA21LA105Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Richmond Hill, GAThe pilot’s mismanagement of the fuel supply, which resulted in fuel starvation.NTSB ERA21LA104Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · St. Petersburg, FLA total loss of engine power as a result of the loose fuel line B-nut connected to the engine driven fuel pump.NTSB DCA21WA070Accident · Serious injuriesClass 5 · ForeignBoeing 777 · Dubai, United Arab EmiratesNTSB WPR21LA092Accident · Minor injuriesClass 4 · LimitedFinal reportCreek Michel W Bearhawk · Elko, NVThe pilot’s unstable approach to land, which resulted in a loss of directional control and subsequent nose over. Contributing to the accident was the pilot’s decision to continue an approach in sun glare conditions.NTSB ERA21LA103Accident · No injuriesClass 3 · LimitedFinal reportTL Ultralight Sro Stingsport · Hollywood, FLThe inadequate maintenance and inspection of the fuel system, which resulted in a partial loss of engine power. Contributing was the pilot's mismanagement of the emergency approach and landing, which resulted in a runway overrun.NTSB WPR21LA100Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Kelso, WAThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and subsequent nose over.NTSB ERA21LA115Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 300 · Myrtle Beach, SCAn encounter with severe turbulence, which resulted in serious injury to an unseated passenger.NTSB WPR21LA086Accident · No injuriesClass 3 · LimitedFinal reportHughes 269C · Spanish Fork, UTThe loss of engine power during a practice autorotation for an undetermined reason.NTSB ERA21LA107Accident · No injuriesClass 3 · LimitedFinal reportExtra Flugzeugbau EA 300/L · Pell City, ALThe pilot's mismanagement of the fuel supply, which resulted in fuel starvation. Contributing to the accident was the pilot’s failure to follow the manufacturer’s engine restart procedures after a total loss of engine power and his incomplete preflight…NTSB ERA21LA101Accident · 1 fatalClass 3 · LimitedFinal reportBeech F33 · Columbia, SCThe pilot's in-flight loss of airplane control due to spatial disorientation during a missed approach in instrument meteorological conditions.NTSB WPR21WA090Accident · Serious injuriesClass 5 · ForeignCessna 210 · Chibuya, ZimbabweNTSB GAA21WA160Accident · No injuriesClass 5 · ForeignSocata TB10 · Salamanca, SpainNTSB CEN21LA189Accident · No injuriesClass 4 · LimitedFinal reportBeech P35 · Poplar Grove, ILThe pilot's distraction and his failure to maintain a proper glidepath on the approach, which resulted in him landing short of the runway and impacting a snowbank.NTSB CEN21LA124Accident · No injuriesClass 4 · LimitedFinal reportHiller UH12C · Lafayette, INThe pilot’s failure to maintain control of the helicopter shortly after liftoff into a hover, which resulted in a dynamic rollover when the left landing skid contacted the ground.NTSB CEN21LA112Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32R-301 · Sparta, MIThe pilot’s failure to maintain the proper glideslope during final approach, which resulted in contact with a snowbank at the approach end of the runway.NTSB ERA21LA102Accident · 1 fatalClass 3 · LimitedFinal reportKolb Firestar · Vineland, NJA steep descent and impact with terrain during final approach for reasons that could not be determined.NTSB ERA21LA098Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 421B · Old Bethpage, NYThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a forced landing.NTSB WPR21WA099Accident · No injuriesClass 4 · ForeignCessna 152 · Rajshahi, BangladeshNTSB WPR21LA084Accident · No injuriesClass 4 · LimitedFinal reportHughes 369D · Winthrop, WAThe pilot’s failure to adequately monitor the environment which resulted in a collision with a snowbank and subsequent loss of control.NTSB WPR21LA082Accident · 1 fatalClass 3 · LimitedFinal reportCessna 560 · Warm Springs, ORA loss of airplane control due to pilot incapacitation for reasons that could not be determined.NTSB GAA21WA008Incident · No injuriesClass 5 · ForeignCessna U206 · Guainia, ColombiaNTSB DCA21WA066Accident · 62 fatalClass 5 · ForeignBoeing 737 · Jakarta, IndonesiaNTSB CEN21LA110Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Cushing, OKThe pilot’s decision to takeoff from unsuitable terrain which resulted in an aerodynamic stall and subsequent impact with terrain.NTSB CEN21LA109Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Albany, TXThe pilot’s inadequate pretakeoff checks which resulted in the magneto switch (key) remaining in the OFF position during the takeoff sequence and initial climb and the right magneto grounding intermittently.NTSB WPR21LA083Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170B · Palouse, WAThe student pilot’s improper landing flare and loss of directional control and the flight instructor’s delayed remedial action resulted in a runway excursion and nose over.NTSB GAA21WA007Accident · 1 fatalClass 4 · ForeignCessna T303 · Bojaca-Cundinamarca, ColombiaNTSB GAA21WA009Accident · 2 fatalClass 5 · ForeignRobinson R44 · Vila Velha, ES, BrazilNTSB DCA21WA081Incident · No injuriesClass 5 · ForeignBoeing 737 · Mexico City, Mexico