NTSB investigations, 2020
28 cases where the defining event was Aerodynamic stall/spin.
Cases per year
| 2008 | 50 |
|---|---|
| 2009 | 70 |
| 2010 | 40 |
| 2011 | 73 |
| 2012 | 59 |
| 2013 | 51 |
| 2014 | 42 |
| 2015 | 42 |
| 2016 | 38 |
| 2017 | 55 |
| 2018 | 64 |
| 2019 | 52 |
| 2020 | 28 |
| 2021 | 34 |
| 2022 | 47 |
| 2023 | 37 |
| 2024 | 35 |
| 2025 | 29 |
| 2026 | 20 |
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '241')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '241') 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 WPR21LA067Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Dillon, MTThe student pilot’s exceedance of the airplane’s critical angle attack during an attempted go-around, which resulted in an aerodynamic stall.NTSB WPR21LA080Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Palm Springs, CAThe student pilot’s failure to maintain aircraft control during an attempted go-around, which resulted in an exceedance of the airplane’s critical angle of attack, aerodynamic stall, and subsequent impact with terrain.NTSB WPR21LA035Accident · Minor injuriesClass 4 · LimitedFinal reportCarbon Cub · Camano, WAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall while maneuvering to final approach.NTSB WPR21LA023Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Carefree, AZThe pilot’s exceedance of the airplane’s critical angle of attack while landing, which resulted in an aerodynamic stall.NTSB WPR21LA011Accident · 1 fatalClass 3 · LimitedFinal reportRans S-7 · Spirit Lake, IDThe pilot’s exceedance of the airplane's critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall.NTSB CEN20LA357Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT802 · Dell, ARThe pilot’s failure to maintain airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall and collision with terrain.NTSB WPR20CA274Accident · Minor injuriesClass 4 · Data collectionFinal reportUskoski Ridge Runner IV · Vancouver, WAThe pilot’s failure to maintain airplane control while maneuvering to land which resulted in an aerodynamic stall at a low altitude, which the pilot was unable to recover from.NTSB CEN20LA339Accident · Serious injuriesClass 3 · LimitedFinal reportCzech Sport Sportcruiser · Gober, TXThe student pilot’s improper recovery from a power-off stall. Contributing to the accident was the flight instructor’s failure to properly monitor the student pilot during the stall recovery.NTSB WPR20CA266Accident · Serious injuriesClass 4 · Data collectionFinal reportAviat A-1C-200 · Grover, WYThe pilot’s inability to regain airplane control after a pilot-induced spin conducted during a flight test, which resulted in a collision with terrain.NTSB WPR20LA257Accident · 1 fatalClass 3 · LimitedFinal reportSportine Aviacija LAK17 · Lake Port, CAThe pilot’s exceedance of the glider’s critical angle of attack during flight, which resulted in an aerodynamic stall and subsequent impact with terrain.NTSB CEN20LA309Accident · 1 fatalClass 3 · LimitedFinal reportCessna A188 · Corsica, SDThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and loss of control.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 WPR20LA215Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Port Orchard, WAThe pilot's delayed decision to go around from an unstable approach, which resulted in insufficient airplane performance to climb above rising terrain and a subsequent aerodynamic stall.NTSB CEN20CA253Accident · Minor injuriesClass 4 · Data collectionFinal reportBeech 23 · Davenport, IAThe pilot's failure to properly configure the airplane for takeoff, which resulted in the exceedance of the airplane's critical angle of attack, an aerodynamic stall, and subsequent impact with terrain.NTSB WPR20LA196Accident · 2 fatalClass 3 · LimitedFinal reportKostrazewa Andre Sonex Light Sport · Centerville, UTThe pilot flying’s exceedance of the airplane’s critical angle of attack during an attempted forced landing, which resulted in an aerodynamic stall and impact with terrain. The reason for the attempted forced landing could not be determined.NTSB CEN20CA244Accident · Serious injuriesClass 4 · Data collectionFinal reportCoyote S-6ES · Pisgah, IAThe uncertificated pilot's failure to attain/maintain a proper angle-of-attack during an initial climb that resulted in an aerodynamic stall and subsequent impact with terrain.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 WPR20LA152Accident · 1 fatalClass 3 · LimitedFinal reportCirrus SR20 · Santa Maria, CAThe pilot’s exceedance of the airplane’s critical angle of attack during a steep and descending turn to final approach, which resulted in an aerodynamic stall and loss of control.NTSB ANC20LA043Accident · Serious injuriesClass 3 · LimitedFinal reportCessna A185E · Eagle River, AKThe pilot’s failure to ensure adequate fuel onboard prior to the planned flight, resulting in a total loss of engine power due to fuel exhaustion and an aerodynamic stall during the subsequent emergency landing. Contributing to the accident was the pilot’s…NTSB ERA20LA149Accident · 1 fatalClass 3 · LimitedFinal reportPipistrel Italia Sinus 912 LSA · Marathon, FLThe pilot’s loss of control of the motorized glider, which resulted in an aerodynamic stall and collision with a residential home and postimpact fire. The reason for the loss of control could not be determined due to the condition of the wreckage.NTSB ERA20LA145Accident · 1 fatalClass 3 · LimitedFinal reportSchempp Hirth Standard Cirrus · Groveland, FLThe pilot’s exceedance of the glider’s critical angle of attack following his premature termination of the tow for reasons that could not be determined, which resulted in an aerodynamic stall/spin during a turn back to the departure airport.NTSB ERA20CA146Accident · No injuriesData collectionFinal reportCessna 172 · Hollywood, FLThe pilot’s failure to apply full engine power during the initiation of a go-around in gusting wind conditions and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at low altitude, and the flight instructor's…NTSB CEN20CA106Accident · No injuriesData collectionFinal reportKitfox 57 Super Sport · Kosciusko, MSThe pilot's lifting off with the airplane at a high of angle of attack, which resulted in aerodynamic stall.NTSB CEN20CA100Accident · Minor injuriesData collectionFinal reportCommander 114 · Coldwater, MIThe flight instructor’s inadequate communication with the pilot under review about his intention to simulate a single-engine failure and his subsequent exceedance of the airplane’s critical angle of attack when the pilot did not respond as expected, which…NTSB CEN20CA086Accident · No injuriesData collectionFinal reportCessna 182 · Huron, SDThe pilot's failure to maintain adequate airspeed during final approach, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall at too low of an altitude to recover.NTSB WPR20CA102Accident · No injuriesData collectionFinal reportMooney M20K · Minden, NVThe pilot’s failure to complete a before landing checklist, which resulted in his delayed extension of the landing gear, and his subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN20FA076Accident · 1 fatalClass 3 · FieldFinal reportBeech 33 · Granbury, TXThe pilot's exceedance of the airplane's critical angle of attack while maneuvering in the airport traffic pattern, which resulted in an aerodynamic stall and loss of control.NTSB ERA20FA085Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32 · Lake City, FLThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and subsequent loss of control at low altitude.