NTSB investigations, 2020
89 cases where the sequence of events included Attempted remediation/recovery.
Cases per year
| 2008 | 22 |
|---|---|
| 2009 | 36 |
| 2010 | 33 |
| 2011 | 24 |
| 2012 | 41 |
| 2013 | 41 |
| 2014 | 36 |
| 2015 | 88 |
| 2016 | 115 |
| 2017 | 163 |
| 2018 | 208 |
| 2019 | 148 |
| 2020 | 89 |
| 2021 | 49 |
| 2022 | 61 |
| 2023 | 71 |
| 2024 | 89 |
| 2025 | 67 |
| 2026 | 48 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 2020
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '060' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 year(c."eventDate") = 2020 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '060' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN21LA100Accident · Serious injuriesClass 3 · LimitedFinal reportWalton Daniel J Sonex · Pecatonica, ILA total loss of engine power for reasons that could not be determined based on the available information, and the pilot’s exceedance of the airplane’s critical angle of attack following the loss of engine power, which resulted in an aerodynamic stall/spin and…NTSB CEN21LA097Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Albion, NEThe pilot’s failure to maintain directional control during the landing with a tailwind.NTSB CEN21LA047Accident · Serious injuriesClass 3 · LimitedFinal reportErcoupe 415 · Ardmore, OKThe pilot’s improper decision to takeoff with 3 persons in a 2-place airplane and over maximum gross weight, and his failure to apply carburetor heat when the airplane’s engine experienced carburetor ice and a partial loss of power.NTSB CEN21LA051Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · Denver, COThe student pilot’s failure to maintain control of the airplane during landing with a gusting crosswind and his failure to go around and relinquish control of the airplane when directed by the instructor pilot.NTSB WPR21LA034Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Legend AL-3 Cub · Minden, NVThe pilot's failure to maintain directional control during landing, which resulted in the airplane nosing over.NTSB ERA21LA015Accident · No injuriesClass 4 · LimitedFinal reportPiper PA24 · Friendly, MDThe pilot’s failure to maintain control of the airplane during an aborted landing and the flight instructor’s inadequate remedial action.NTSB ERA21LA014Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Alpha Trainer · Rural Hall, NCThe pilot’s failure to maintain airplane control and improper recovery from an unusual attitude, which resulted in an in-flight breakup.NTSB CEN20CA416Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172RG · Lafayette, INThe separation failure of a landing gear system hydraulic line and its compression fitting during cruise flight, which resulted in a partial gear up landing.NTSB WPR20LA310Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV4 · Clovis, NMThe pilot’s failure to maintain lateral control during initial climb due to distraction, which resulted in an in-flight upset and impact with terrain.NTSB CEN20CA394Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA46 · Englewood, COThe pilot's failure to maintain directional control during landing in gusting winds.NTSB WPR20CA305Accident · No injuriesClass 4 · Data collectionFinal reportDiamond DA20 · Fillmore, UTThe student pilot's improper landing flare and delayed remedial action to abort the landing, which resulted in a loss of aircraft control, runway excursion and impact with terrain.NTSB WPR20CA286Accident · No injuriesClass 4 · Data collectionFinal reportNorthrop F5 · Reno, NVThe pilot's failure to complete the pre-landing checklist due to a distraction which resulted in a gear-up landing.NTSB CEN20CA362Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Lebanon, MOThe pilot's failure to maintain directional control during landing.NTSB ANC20CA088Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Kotzebue, AKThe pilot's failure to maintain an airspeed conducive to flight during takeoff.NTSB CEN20CA356Accident · No injuriesClass 4 · Data collectionFinal reportMaule M5 · Olathe, KSThe pilot's loss of directional control during landing.NTSB WPR20CA271Accident · No injuriesClass 4 · Data collectionFinal reportRyan ST3KR · Port Townsend, WAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with vegetation.NTSB WPR20CA265Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Stanley, IDThe pilot's failure to maintain directional control during takeoff in crosswind conditions, which resulted in a ground loop.NTSB CEN20LA329Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · Burlington, WIA partial loss of engine power due to the formation of carburetor ice while on the ground, which resulted in reduced climb capability and impact with trees during the initial climb.NTSB WPR20CA261Accident · Serious injuriesClass 4 · Data collectionFinal reportAviat A1 · Kernville, CAThe pilot's failure to maintain clearance from trees during a go-around, which resulted in an impact with terrain.NTSB CEN20LA330Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R44 · Logan, IAThe failure of the lower actuator bearing support brackets, which resulted in the misalignment of the clutch actuator, a loss of belt tension on the main rotor drive system, and a subsequent forced landing.NTSB ERA20CA293Accident · Minor injuriesClass 4 · Data collectionFinal reportWag Aero Cubby · Pell City, ALThe flight instructor’s inadequate remedial action following the student pilot’s loss of directional control during landing, which resulted in a runway excursion and subsequent nose over.NTSB CEN20CA326Accident · No injuriesClass 4 · Data collectionFinal reportHughes 369A · St Louis, MOThe flight instructor's failure to maintain helicopter control which resulted in a hard landing while preforming a practice autorotation.NTSB WPR20CA275Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · Susanville, CAThe pilot's failure to maintain directional control during takeoff with a tailwind, which resulted in a subsequent collapse of the right main landing gear.NTSB WPR20LA238Accident · 5 fatalClass 3 · LimitedFinal reportPiper PA32R · West Jordan, UTThe pilot's failure to maintain the airplane’s speed during takeoff near the airplane’s maximum gross weight in high-density altitude conditions, which resulted in the exceedance of the airplane's critical angle of attack and led to an aerodynamic stall, loss…NTSB CEN20CA310Accident · Minor injuriesClass 4 · Data collectionFinal reportChampion 7GCBC · Angola, INThe pilot's failure to maintain control of the airplane during a low-level pass, resulting in the airplane exceeding its critical angle of attack that caused an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot's…NTSB WPR20LA237Accident · 1 fatalClass 3 · LimitedFinal reportVans Vans RV-8 · Tehachapi, CAThe pilot’s failure to maintain airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at too low of an altitude to recover.NTSB ANC20CA071Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · Palmer, AKThe pilot's loss of control during landing, which resulted in a ground loop and left main landing gear collapse.NTSB ERA20CA248Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA22 · Culpeper, VAThe pilot’s failure to maintain directional control on landing resulting in a runway excursion and subsequent ground loop. Contributing to the outcome were the flight instructor’s inadequate remedial actions.NTSB WPR20CA255Accident · Minor injuriesClass 4 · Data collectionFinal reportAir Creation/Sides Rick A Manta 503 · Ramona, CAThe solo student pilot's improper landing flare, which resulted in a bounced landing and subsequent nose over.NTSB WPR20CA217Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Absarokee, MTThe pilot's failure to maintain airplane control during a go-around that resulted in the airplane exceeding its critical angle of attack and aerodynamically stalling which resulted in a collision with the ground.NTSB CEN20LA261Accident · Minor injuriesClass 3 · LimitedFinal reportEnstrom 280 · Des Moines, IAThe partial loss of rotor and engine speed during approach for landing, which resulted in an autorotation and impact with terrain. The reason for the partial loss of rotor and engine speed could not be determined based on the available evidence. Contributing…NTSB ANC20LA064Accident · No injuriesClass 3 · LimitedFinal reportPiper PA22 · Soldotna, AKThe delamination of the fabric material from the fuselage above the windscreen due to failed adhesive, which resulted in disrupted airflow and a subsequent hard landing.NTSB WPR20CA185Accident · No injuriesClass 4 · Data collectionFinal reportVans RV 6 · Clovis, NMThe pilot's improper landing flare which resulted in a hard, bounced landing, and subsequent runway excursion. Contributing to the accident was the airplane’s aft center of gravity at the time of the accident.NTSB CEN20CA229Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna T188 · McCurtain, OKThe pilot's failure to maintain the proper airspeed during a low altitude aerial application maneuver and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodymanic stall at too low of an altiutde to recover.NTSB WPR20CA164Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 182 · Sandia, TXThe pilot's failure to maintain airplane control during takeoff from a soft airstrip that resulted in a collision with objects.NTSB WPR20CA159Accident · No injuriesClass 4 · Data collectionFinal reportGrumman G164 · Maxwell, CAThe pilot's delayed decision to abort the takeoff when the airplane was not attaining sufficient airspeed for takeoff and subsequently departed the end of the runway and collided with terrain. Contributing to the accident was the pilot's inadequate preflight…NTSB ANC20CA057Accident · No injuriesClass 4 · Data collectionFinal reportChampion 7GCBC · Palmer, AKThe pilot's loss of directional control during landing, which resulted in a runway excursion.NTSB CEN20CA193Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Ionia, MIThe pilot's failure to maintain directional control during landing. Contributing was the pilot getting his shoe caught in the rudder pedal.NTSB ERA20CA178Accident · Minor injuriesClass 4 · Data collectionFinal reportSchempp Hirth Ventus 2CT · Stuarts Draft, VAA loss of thermal lift during a motor glider flight, which resulted in an off-airport landing. Contributing to the accident was the pilot's delayed attempted engine start.NTSB CEN20CA161Accident · No injuriesData collectionFinal reportPiper PA 20 · Colorado Springs, COThe flight instructor's improper landing flare, which resulted in a bounced landing, and his subsequent loss of directional control.NTSB CEN20CA155Accident · No injuriesData collectionFinal reportVans RV 3 · Independence, IAThe pilot's failure to maintain directional control during a high-speed taxi with a quartering tailwind, which resulted in a runway excursion and impact with a fence and terrain.NTSB WPR20CA140Accident · No injuriesData collectionFinal reportRobinson R22 · Caldwell, IDThe flight instructor's failure to set the proper rotor rpm during a practice autorotation, which led to his failure to maintain a proper descent rate and resulted in a hard, bounced landing.NTSB ERA20CA158Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Athens, GAThe pilot's failure to maintain airplane control after an aborted landing, which resulted in collision with trees.NTSB CEN20CA154Accident · No injuriesData collectionFinal reportCessna 172 · Ft Worth, TXThe student pilot’s failure to maintain a stabilized approach and the flight instructor's delayed remedial action to initiate a go-around, which resulted in a runway overrun and impact with runway lights and fences.NTSB CEN20CA158Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · El Campo, TXThe pilot's misjudgment of a ground spray rig’s position and his incorrect belief that a runway incursion might occur, which resulted in the pilot attempting and then aborting a go-around, which resulted in a runway excursion and collision with a fence.NTSB WPR20CA124Accident · No injuriesData collectionFinal reportCessna 180 · Marion, MTThe pilot's loss of directional control and subsequent improper brake application during the landing roll in gusting wind conditions, which resulted in a nose-over.NTSB ERA20CA151Accident · No injuriesData collectionFinal reportPipistrel Sinus · Townsend, TNThe motor glider's encounter with atmospheric lift conditions that were not sufficient to maintain flight, which necessitated a forced landing and resulted in impact with vegetation. Contributing to the accident was the pilot's delayed decision to restart the…NTSB ANC20CA042Accident · No injuriesData collectionFinal reportPiper PA18 · Homer, AKThe pilot's overapplication of the brakes during landing and the subsequent loss of directional control and nose-over.NTSB CEN20CA138Accident · No injuriesData collectionFinal reportChampion Aeronca 7FC · Hessel, MIThe pilot's loss of directional control during landing in gusting crosswind conditions, which resulted in a runway excursion and impact with a snowbank.NTSB ERA20CA143Accident · No injuriesData collectionFinal reportDiamond DA42 · Palm Coast, FLThe pilot receiving instruction’s failure to maintain airplane control during a simulated engine failure landing and subsequent attempted go-around in gusting crosswind conditions and the flight instructor's delayed remedial action.