Final NTSB investigations
830 cases where the defining event was Aerodynamic stall/spin.
Cases per year
| 2008 | 50 |
|---|---|
| 2009 | 69 |
| 2010 | 40 |
| 2011 | 73 |
| 2012 | 59 |
| 2013 | 50 |
| 2014 | 41 |
| 2015 | 42 |
| 2016 | 37 |
| 2017 | 53 |
| 2018 | 63 |
| 2019 | 52 |
| 2020 | 28 |
| 2021 | 33 |
| 2022 | 45 |
| 2023 | 37 |
| 2024 | 31 |
| 2025 | 17 |
| 2026 | 10 |
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 c.\"completionStatus\" = 'Completed'
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 c."completionStatus" = 'Completed' 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 ERA26LA277Accident · No injuriesClass 4 · LimitedFinal reportRans S-6-S · Morgan, VTThe pilot’s failure to maintain control of the airplane during takeoff, resulting in an aerodynamic stall and impact with water.NTSB WPR26LA273Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Boulder, COThe pilot’s improper landing flare which resulted in a stall and a hard bounced landing.NTSB WPR26LA252Accident · Serious injuriesClass 4 · LimitedFinal reportFairchild M-62A · Greenleaf, IDThe pilot’s failure to maintain proper airspeed during approach and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and impact with terrain.NTSB WPR26LA213Accident · Serious injuriesClass 4 · LimitedFinal reportMoose SR 2500 · Sonoma, CAThe pilot's failure to maintain airspeed during a go-around in shifting wind conditions, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB WPR26LA179Accident · No injuriesClass 4 · LimitedFinal reportCessna A150L · Superior, AZThe pilot's failure to retract the flaps during takeoff following a touch-and-go landing, which resulted in degraded climb performance and an impact with an object during an off-field landing.NTSB WPR26LA174Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Champion 7GCBC · Big Water, UTThe pilot’s failure to maintain adequate airspeed and exceedance of the airplanes critical angle of attack while maneuvering at a low altitude, which resulted in a subsequent stall and impact with trees during stall recovery.NTSB ANC26LA027Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Centennial, COThe student pilot’s failure to maintain adequate airspeed during the flare which resulted in the airplane exceeding its critical angle of attack and aerodynamic stall at a low altitude and loss of airplane control.NTSB CEN26LA146Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Madison, INThe pilot’s failure to maintain proper airspeed during takeoff and exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN26LA125Accident · No injuriesClass 4 · LimitedFinal reportVans RV-12IS · Appleton, WIThe pilot’s failure to maintain proper airspeed during landing and exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and impact with the runway. Contributing to the accident was the flight instructor’s delayed…NTSB CEN26LA077Accident · No injuriesClass 4 · LimitedFinal reportBeech B35 · La Casa, TXThe pilot’s exceedance of the airplane’s critical angle of attack during initial climb after takeoff, leading to an aerodynamic stall and impact with trees.NTSB ERA26LA062Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Pensacola, FLThe pilot’s exceedance of the critical angle of attack during initial climb which resulted in an aerodynamic stall.NTSB ERA26LA008Accident · No injuriesClass 4 · LimitedFinal reportChampion 7ECA · East Rockingham, NCThe pilot’s failure to maintain control of the airplane during initial climb, resulting in an aerodynamic stall and impact with terrain.NTSB CEN25LA387Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-32R-301 · Oxford, MSThe pilot’s exceedance of the airplane’s critical angle of attack during the initial takeoff climb, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN25LA382Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · South Bend, INThe pilot’s failure to maintain control of the airplane during a go around which resulted in an aerodynamic stall. Contributing to the accident was the loss of directional control during the landing roll.NTSB ERA25LA342Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer G-164B · Dover, DEThe pilot’s exceedance of the critical angle of attack which resulted in an aerodynamic stall at an altitude too low to recover.NTSB ERA25LA336Accident · Serious injuriesClass 4 · LimitedFinal reportLet L-23 Super Blanik · Ridgeland, SCThe pilot’s exceedance of the glider’s critical angle of attack which resulted in a loss of control while maneuvering to return for landing after a runway overshoot.NTSB ERA25LA320Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Livermore Falls, METhe pilot’s failure to maintain adequate airspeed during landing in gusting wind conditions, which resulted in an aerodynamic stall and impact with terrain.NTSB WPR25LA251Accident · No injuriesClass 4 · LimitedFinal reportSocata TBM 700 · Kalispell, MTThe pilot’s unstable approach to the runway, which resulted in an aerodynamic stall at low altitude and impact with terrain.NTSB WPR25LA221Accident · Minor injuriesClass 4 · LimitedFinal reportBeech B35 · Helena, MTThe pilot’s failure to properly configure the airplane during a go-around which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall at a low altitude.NTSB CEN25LA252Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 35 · Cedarcreek, MOThe student pilot’s failure to attain a proper airspeed and climb attitude during takeoff, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident were the student pilot’s lack of…NTSB CEN25LA196Accident · Minor injuriesClass 4 · LimitedFinal reportGallow Daniel A Kitfox Classic IV · Waupaca, WIThe pilot’s failure to maintain adequate air speed during final approach, which resulted in an aerodynamic stall and impact with terrain.NTSB WPR25LA144Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-26B · Ontario, ORThe pilot's exceedance of the airplane's critical angle of attack during the final approach to land, which resulted in an aerodynamic stall and impact with terrain.NTSB ERA25LA176Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150 · Kingston, OHThe pilot’s exceedance of the airplanes’ critical angle of attack resulting in a stall at an altitude too low to recover.NTSB ERA25LA164Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Hickory, NCThe student pilot’s failure to maintain airplane control during an attempted go-around, which resulted in an aerodynamic stall/spin and collision with terrain.NTSB WPR25LA115Accident · Minor injuriesClass 4 · LimitedFinal reportRotorsport UK Cavalon · Murrieta, CAThe student pilot’s failure to maintain adequate airspeed during an approach and subsequent descent into terrain. Contributing to the accident was the student pilot’s failure to perform a go-around maneuver.NTSB ERA25FA151Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22 · LaFayette, GAThe pilot’s exceedance of the airplane’s critical angle of attack while landing and the flight instructor’s inadequate remedial action, which resulted in an aerodynamic stall/spin at an altitude too low for recovery.NTSB ERA25LA149Accident · No injuriesClass 4 · LimitedFinal reportCessna 162 · Miami, FLThe student pilot’s failure to maintain control of the airplane during a go-around, which resulted in an aerodynamic stall.NTSB ERA25LA053Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Doylestown, PAThe pilot’s failure to maintain control of the airplane during an attempted go-around, which resulted in an aerodynamic stall and impact with terrain and a parked airplane.NTSB WPR25FA020Accident · 1 fatalClass 3 · FieldFinal reportExtra Flugzeugbau EA 300/L · Las Cruces, NMThe pilot’s entry into an aerobatic maneuver at an altitude that was insufficient to complete a successful recovery, which resulted in an accelerated stall and impact with terrain.NTSB CEN24LA367Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Lakeway, TXThe pilot’s failure to maintain adequate airspeed during landing, which resulted in an aerodynamic stall and loss of control during a go-around.NTSB CEN24LA363Accident · Minor injuriesClass 4 · LimitedFinal reportKitfox IV 1200 Spdst · Cleburne, TXThe pilot’s failure to maintain aircraft control, which resulted in an aerodynamic stall and impact with terrain.NTSB ANC24LA103Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · McKinley Village, AKThe pilot’s late decision to go-around, failure to maintain proper 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 ANC24LA098Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot’s failure to maintain a rate of climb sufficient to clear obstacles during takeoff, resulting in a collision with obstacles and a subsequent aerodynamic stall.NTSB ERA24FA371Accident · 4 fatalClass 3 · FieldFinal reportPiper PA28R · Vergennes, VTThe flight instructor’s failure to maintain control of the airplane, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall. Contributing to the accident was the flight instructor's failure to properly…NTSB WPR24FA298Accident · 1 fatalClass 3 · FieldFinal reportBoeing A75L3 · Yacolt, WAThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at a low altitude in mountainous terrain in moderately high density altitude conditions, resulting in an aerodynamic stall and subsequent impact with terrain.NTSB CEN24FA340Accident · 4 fatalClass 3 · FieldFinal reportPiper PA 46-350P · Anderson, INThe pilot’s inadequate airspeed management during the missed approach which resulted in an inadvertent aerodynamic stall and loss of control at low altitude.NTSB CEN24LA334Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177B · Shell Knob, MOThe pilot’s failure to maintain aircraft control and airspeed during final approach, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB CEN24LA331Accident · No injuriesClass 4 · LimitedFinal reportLet L 33 Solo · Kingman, KSThe pilot’s loss of control on short final.NTSB ANC24FA085Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-18-150 · McGrath, AKThe pilot's exceedance of the airplane’s critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and loss of control.NTSB CEN24FA305Accident · 1 fatalClass 3 · FieldFinal reportCessna 172F · Brazoria, TXThe pilot’s failure to attain adequate airspeed for takeoff, which led to the airplane exceeding its critical angle-of-attack and an aerodynamic stall. Contributing to the accident was the pilot’s failure to abort the takeoff after not maintaining directional…NTSB CEN24LA292Accident · Minor injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Lewisville, TXThe pilot’s failure to maintain sufficient airspeed during a go-around, which resulted in an aerodynamic stall and impact with water. Contributing to the accident were crosswind gusts.NTSB WPR24LA273Accident · No injuriesClass 4 · LimitedFinal reportGlasflugel Standard Libelle · Fields, ORThe glider’s encounter with a gusting wind and downdraft conditions, which resulted in exceedance of the glider’s critical angle of attack, an aerodynamic stall, and a hard landing.NTSB WPR24FA225Accident · 1 fatalClass 3 · FieldFinal reportGame Composites GB1 Gamebird · Irwin, IDThe pilot’s decision to perform a spin maneuver at an altitude that was insufficient to complete a successful recovery and subsequent failure to properly arrest the spin, which resulted in a secondary stall and an impact with terrain.NTSB CEN24LA246Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-402 · Helm, MSThe pilot’s failure to maintain control, which resulted in an aerodynamic stall and impact with terrain.NTSB WPR24FA196Accident · 2 fatalClass 3 · FieldFinal reportLockheed 12A · Chino, CAThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall at an altitude insufficient for recovery. Contributing to the accident was the pilot’s failure to ensure that the airplane was…NTSB ERA24FA261Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28 · Siler City, NCThe flight instructor’s failure to maintain airplane control during a low-speed, low-altitude left turn after encountering an undetermined issue during takeoff, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB WPR24LA181Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172P · Santa Ynez, CAThe pilot’s failure to maintain airspeed which resulted in exceedance of the critical angle of attack and an aerodynamic stall/spin, with insufficient altitude for recovery. The student pilot’s exceedance of the critical angle of attack which resulted in a…NTSB ANC24LA043Accident · No injuriesClass 3 · LimitedFinal reportCessna 207A · Bethel, AKThe pilot’s improper short-field takeoff procedure, which resulted in an aerodynamic stall and subsequent hard landing.NTSB ERA24LA229Accident · Serious injuriesClass 3 · LimitedFinal reportGreat Lakes 2T-1(Menasco Special) · Salisbury, MDThe pilot’s exceedance of the airplane’s critical angle of attack, resulting in an aerodynamic stall and loss of control.NTSB WPR24FA150Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-18-150 · Thurlow, MTThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, resulting in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s distraction by his cell phone use while…