NTSB investigations, KS
29 cases where the sequence of events included Aerodynamic stall/spin.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 2 |
| 2010 | 2 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 3 |
| 2016 | 2 |
| 2017 | 2 |
| 2019 | 3 |
| 2021 | 1 |
| 2022 | 4 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 1 |
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.\"eventStateOrRegion\" = 'KS' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '241' 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 c."eventStateOrRegion" = 'KS' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '241' 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 CEN25FA339Accident · 1 fatalClass 3 · FieldPreliminary reportRans S-12 Airaile · Concordia, KSOn August 24, 2025, about 1926 central daylight time, a Rans S-12 Airaile airplane, N2757A, was substantially damaged when it was involved in an accident near Concordia, Kansas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB CEN24LA331Accident · No injuriesClass 4 · LimitedFinal reportLet L 33 Solo · Kingman, KSThe pilot’s loss of control on short final.NTSB CEN23LA184Accident · Serious injuriesClass 4 · LimitedFinal reportRans S7 · Gardner, KSThe pilot’s exceedance of the airplane’s critical angle of attack during the takeoff, which resulted in an aerodynamic stall and loss of airplane control at too low of an altitude to recover.NTSB CEN23LA012Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Paola, KSThe pilot’s improper positioning of the fuel selector, which resulted in fuel starvation and a loss of engine power during a departure climb.NTSB ERA22FA320Accident · 1 fatalClass 3 · FieldFinal reportKnight AA Nieuport 28 · Basehor, KSThe pilot’s incorrect installation of the left-wing strut, which resulted in a loss of airplane control during takeoff and a subsequent aerodynamic stall and spin from which the pilot could not recover.NTSB CEN22LA279Accident · Serious injuriesClass 4 · LimitedFinal reportLet L-23 Super Blanik · Yoder, KSThe pilot's encounter with sinking air conditions that resulted in a loss of lift and a subsequent loss of control.NTSB CEN22LA185Accident · 1 fatalClass 3 · LimitedFinal reportSuperior Culver LFA · Syracuse, KSThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an inadvertent aerodynamic stall while returning to the airport following a partial loss of engine power for reasons that could not be determined.NTSB CEN21LA208Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 23 · Hutchinson, KSThe pilot’s failure to abort the takeoff and his high pitch attitude after takeoff, which resulted in an exceedance of the critical angle of attack and a subsequent aerodynamic stall.NTSB GAA20CA015Accident · No injuriesData collectionFinal reportTaylorcraft BC12 · Goddard, KSThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN19FA278Accident · 1 fatalField investigationFinal reportGrumman G164 · Hays, KSThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.NTSB GAA19CA332Accident · Minor injuriesData collectionFinal reportBeech 35 · Rose Hill, KSThe pilot's improper trim configuration during the takeoff roll, which resulted in the airplane becoming prematurely airborne, and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB GAA17CA489Accident · No injuriesData collectionFinal reportCessna 170 · Axtell, KSThe pilot's exceedance of the airplane's critical angle of attack during a go-around. Contributing to the accident was the pilot's decision to attempt to close a passenger door during a critical phase of flight.NTSB GAA17CA273Accident · No injuriesData collectionFinal reportAdrian George W Europa Classic · Wellington, KSThe pilot’s improper landing flare and exceedance of the airplane’s critical angle of attack during landing, which resulted in an aerodynamic stall.NTSB GAA16CA331Accident · No injuriesData collectionFinal reportBeech F33 · Salina, KSThe flight instructor's exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall and a collision with terrain.NTSB CEN16LA230Accident · No injuriesLimited investigationFinal reportGlaeser Nieuport 11 · Gardner, KSThe pilot's diverted attention during the approach for the precautionary landing, which resulted in low airspeed, an exceedance of the airplane’s critical angle of attack, and a subsequent aerodynamic stall. Contributing to the accident was the control system…NTSB CEN15LA431Accident · Serious injuriesLimited investigationFinal reportEdward M Van Morlan Rans S-12 · Gardner, KSThe pilot's inadequate airspeed control and the airplane’s exceedance of its critical angle-of-attack during the forced landing, which resulted in an aerodynamic stall. Contributing to the accident was the loss of engine power due to fuel starvation caused by…NTSB GAA15CA136Accident · No injuriesData collectionFinal reportCessna 172H · Cottonwood Falls, KSThe pilot's failure to attain adequate airspeed to climb the airplane out of ground effect, which resulted in an aerodynamic stall and a collision with terrain.NTSB CEN15FA240Accident · 1 fatalField investigationFinal reportYakovlev YAK 52 · Syracuse, KSThe pilot’s failure to maintain airplane control while maneuvering at low altitude, which resulted in the airplane’s wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall .NTSB CEN14CA323Accident · No injuriesData collectionFinal reportCessna E162 · Wichita, KSThe student pilot's failure to maintain adequate airspeed during the landing approach which resulted in an inadvertent stall and impact with the runway.NTSB CEN13CA153Accident · No injuriesData collectionFinal reportCessna 177RG · Herington, KSThe pilot’s failure to maintain adequate airspeed during the approach, which resulted in an aerodynamic stall.NTSB CEN12LA236Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T15 · Lakin, KSThe pilot did not maintain sufficient airspeed while maneuvering, which resulted in an aerodynamic stall at a low altitude.NTSB CEN11CA551Accident · Serious injuriesData collectionFinal reportQuicksilver Sprint II · Douglas, KSThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN11LA466Accident · Serious injuriesLimited investigationFinal reportDehavilland DHC-1 · Benton, KSThe pilot did not maintain sufficient airspeed while maneuvering at low altitude, which resulted in an inadvertent stall and spin.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 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 CEN10LA068Accident · No injuriesLimited investigationFinal reportBeech V35 · Dodge City, KSThe failure of the pitot heat system in icing conditions resulting in an inoperative airspeed indicator which led to an inadvertant stall while on final approach. Contributing to the accident was the pilot's decision to fly into known icing conditions.NTSB CEN09FA220Accident · No injuriesField investigationFinal reportCessna E162 · El Dorado, KSThe failure of the Ballistic Recovery System to disconnect due to twisted attachment straps.NTSB DFW08FA234Accident · No injuriesField investigationFinal reportCessna E162 · Douglas, KSThe airplane's inability to recover from an intentional spin, despite proper control inputs by the flight test pilot. Contributing to the accident was the failure of the airplane's ballistic parachute system to properly deploy.NTSB DEN08LA053Accident · Serious injuriesLimited investigationFinal reportPhillips Flite Bike · Valley Center, KSThe pilot's failure to maintain airspeed during an emergency descent resulting in an inadvertent stall/mush. Contributing to the accident was the pilot's failure to turn on the fuel tank valve resulting in fuel starvation and the loss of engine power.