NTSB investigations, 2010
40 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\") = 2010
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") = 2010 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 CEN11LA082Accident · 1 fatalLimited investigationFinal reportCessna 172M · Velma, OKThe pilot’s failure to maintain control of the airplane while maneuvering, which resulted in an inadvertent stall and subsequent impact with terrain. Contributing to the accident was the pilot's relative inexperience in pipeline patrols.NTSB CEN11LA078Accident · No injuriesLimited investigationFinal reportSwiezy Glasair SHA · North Little Rock, ARThe pilot's failure to maintain adequate airspeed, resulting in an aerodynamic stall and hard landing.NTSB ERA11LA056Accident · 1 fatalLimited investigationFinal reportCarlo Robert Quicksilver SPT 2S · Lajas, PRThe pilot’s failure to maintain adequate airspeed, which resulted in an aerodynamic stall and entry into a spin.NTSB CEN11LA049Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Schaumburg, ILThe pilot did not maintain airspeed following a loss of engine power during takeoff climb, which resulted in an aerodynamic stall. Contributing to the accident was the loss of engine power due to the unlocked engine primer.NTSB ERA11CA024Accident · Minor injuriesData collectionFinal reportCessna 180 · Summner, METhe pilot's failure to maintain adequate airspeed while on final approach resulting in an aerodynamic stall and a subsequent hard landing.NTSB ERA11CA045Accident · No injuriesData collectionFinal reportEvolution Revo · Gransonville, MDThe pilot's improper recovery from a bounced landing and the certificated flight instructor's inadequate remedial action, which resulted in an aerodynamic stall during a go-around.NTSB ERA10CA465Accident · No injuriesData collectionFinal reportStearman E75 · Jackson, GAThe pilot's diverted attention toward an unsecured engine cowl door after takeoff which resulted in his failure to maintain airspeed and altitude. Contributing to the accident was the pilot’s inadequate preflight inspection of the airplane.NTSB CEN10LA514Accident · 1 fatalLimited investigationFinal reportCessna 150L · Boone, IAThe pilot’s failure to maintain airplane control while performing low-level banner towing operations with a gusting wind.NTSB ANC10FA076Accident · 2 fatalField investigationFinal reportPiper PA-11 · Willow, AKThe pilot’s failure to maintain adequate airspeed, which resulted in an aerodynamic stall/spin and impact with the ground.NTSB WPR10LA417Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Mammoth Lakes, CAThe pilot’s failure to maintain adequate airspeed and airplane control during takeoff in high density altitude conditions, which resulted in an aerodynamic stall.NTSB ANC10CA070Accident · No injuriesData collectionFinal reportChampion 7EC · Soldotna, AKThe pilot’s failure to maintain adequate airspeed during the initial climb.NTSB ERA10LA391Accident · 1 fatalLimited investigationFinal reportTurck G L/Duflo J T SEA REY · Winter Haven, FLThe pilot's failure to maintain adequate airspeed on approach for landing, resulting in an inadvertent stall/spin and collision with water.NTSB WPR10LA377Accident · 1 fatalLimited investigationFinal reportGlaser Dirks DG300 · Morgan, UTThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in a stall/spin and ground impact.NTSB ERA10LA385Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Canton, MSThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall and spin.NTSB CEN10CA434Accident · No injuriesData collectionFinal reportAir Tractor 502B · Whittemore, IAThe pilot's failure to abort the takeoff, which resulted in an aerodynamic stall.NTSB CEN10FA385Accident · 3 fatalField investigationFinal reportCessna 177B · Owasso, OKThe pilot’s failure to maintain adequate airspeed during an engine-out approach to the runway, resulting in an aerodynamic stall and spin. Contributing to the accident was the pilot’s inadequate preflight planning, which resulted in a loss of engine power due…NTSB CEN10LA381Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Goddard, KSThe pilot did not maintain airspeed during takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s poor preflight planning.NTSB ERA10FA342Accident · 2 fatalField investigationFinal reportNorth American AT-6 · Destin, FLThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and spin. Contributing to the accident was the pilot's improper decision to perform the maneuvers at a low altitude and over water.NTSB CEN10CA373Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · Bloomington, ILThe pilot's failure to maintain adequate airspeed during landing, which resulted in a stall.NTSB WPR10FA330Accident · 4 fatalField investigationFinal reportPiper PA-28R-180 · Dixon, MTThe pilot’s failure to maintain adequate airspeed and aircraft control while maneuvering, resulting in an aerodynamic stall and collision with mountainous terrain.NTSB CEN10LA334Accident · 1 fatalLimited investigationFinal reportDrone Paul E Pulsar III · Carmi, ILThe pilot's failure to maintain adequate airspeed after an aborted landing, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN10FA324Accident · 5 fatalField investigationFinal reportCessna T310R · Ruidoso, NMThe pilot did not maintain proper airspeed on final approach for landing, which resulted in an aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s limited experience in the airplane make and model.NTSB ERA10CA300Accident · Minor injuriesData collectionFinal reportPiper PA-18-135 · North Myrtle Beach, SCThe pilot’s failure to maintain adequate airspeed during a climbing turn, which resulted in an aerodynamic stall.NTSB WPR10LA268Accident · Serious injuriesLimited investigationFinal reportPiper PA-20 · Nelson, CAThe pilot's loss of aircraft control during an undetermined phase of flight, which resulted in an aerodynamic stall/spin and subsequent collision with terrain.NTSB CEN10CA284Accident · No injuriesData collectionFinal reportPiper J3C-65 · Mount Pleasant, TXThe pilot's failure to maintain adequate airspeed while turning resulting in a stall.NTSB CEN10LA255Accident · Minor injuriesLimited investigationFinal reportSupinski Mark R Supinski Mustang II · Peyton, COThe pilot’s failure to maintain control of the airplane during landing. Contributing to the accident was the pilot’s lack of experience flying tailwheel configured airplanes.NTSB ERA10FA259Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Tuscaloosa, ALThe pilot's failure to maintain adequate airspeed while maneuvering to land, which resulted in an aerodynamic stall/spin and collision with the ground.NTSB CEN10FA233Accident · 2 fatalField investigationFinal reportJetProp DLX Piper PA46 · New Albany, INThe pilot’s failure to maintain airspeed in instrument meteorological conditions, which resulted in an aerodynamic stall.NTSB CEN10LA234Accident · 1 fatalLimited investigationFinal reportCGS Hawk · Haysville, KSThe pilot’s failure to maintain adequate airspeed, which resulted in an aerodynamic stall and loss of control of the airplane, for undetermined reasons.NTSB CEN10CA225Accident · Minor injuriesData collectionFinal reportSchweizer SGS1-34 · Waynesville, OHThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall.NTSB ERA10FA232Accident · 1 fatalField investigationFinal reportMaule M5-235C · Zellwood, FLThe pilot's failure to maintain airspeed while maneuvering after takeoff, which resulted in an aerodynamic stall, loss of aircraft control, and collision with trees.NTSB ERA10LA233Accident · 1 fatalLimited investigationFinal reportCessna 172H · Archer, FLThe pilot's failure to maintain adequate airspeed for undetermined reasons while maneuvering in the vicinity of an airport, which resulted in an aerodynamic stall and hard landing.NTSB CEN10LA208Accident · Serious injuriesLimited investigationFinal reportReed William A Kitfox 4 · Baraboo, WIThe pilot's failure to compensate for wind gusts and maintain sufficient airspeed, which resulted in a stall.NTSB ERA10LA205Accident · 1 fatalLimited investigationFinal reportCupaiole RV-6A · West Palm Beach, FLThe total loss of engine power and the pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and spin. The reason for the loss of power could not be determined.NTSB ERA10LA199Accident · 1 fatalLimited investigationFinal reportRatcliffe John A Kolb MARK3X · Charleston, SCThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was the pilot's lack of experience in the make and model airplane.NTSB CEN10FA182Accident · 1 fatalField investigationFinal reportCzech Aircraft Works Spol Sro Mermaid · Algonac, MIThe pilot’s loss of control resulting from an aerodynamic stall/spin while maneuvering at low altitude.NTSB ERA10LA164Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Savannah, GAThe pilot's failure to maintain airspeed and inadvertent stall after takeoff.NTSB CEN10FA107Accident · 2 fatalField investigationFinal reportCostruzioni Aeronautiche Tecna P2002 · Waxahachie, TXA loss of aircraft control while maneuvering for undetermined reasons.NTSB CEN10FA097Accident · 4 fatalField investigationFinal reportMitsubishi MU-2B-60 · Elyria, OHThe pilot's failure to maintain adequate airspeed during the instrument approach, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN10LA090Accident · No injuriesLimited investigationFinal reportBeech C-99 · Kearney, NEThe failure of the pilot to maintain adequate airspeed during the approach resulting in a stall. Contributing to the accident was the accumulation of structural icing during the flight.