NTSB investigations, IL
24 cases where the sequence of events included Aerodynamic stall/spin.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 3 |
| 2011 | 3 |
| 2012 | 1 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 2 |
| 2018 | 3 |
| 2020 | 2 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 2 |
| 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\" = 'IL' 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" = 'IL' 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 CEN25FA224Accident · 2 fatalClass 3 · FieldPreliminary reportVans RV-10 · Capron, ILOn June 28, 2025, about 0934 central daylight time, a Vans RV-10 airplane, N847CS, was substantially damaged during an accident near Capron, Illinois. The pilot and flight instructor were fatally injured. The airplane was operated as a Title 14 Code of…NTSB CEN23LA372Accident · No injuriesClass 3 · LimitedFinal reportPietenpol Aircamper · Hanover, ILThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall during an attempted forced landing at low altitude. Contributing to the accident was the loss of engine power for undetermined reasons.NTSB CEN23LA216Accident · No injuriesClass 4 · LimitedFinal reportRemos G-3/600 · Sugar Grove, ILThe student pilot’s improper flight control inputs and the flight instructor’s delayed remedial action during takeoff, which resulted in a runway excursion and impact with terrain.NTSB CEN22LA289Accident · Serious injuriesClass 3 · LimitedFinal reportGlasair II FT · Monee, ILThe pilot’s in-flight loss of control while practicing aerodynamic stall recoveries.NTSB CEN21LA332Accident · No injuriesClass 4 · LimitedFinal reportMadera RV-3 · Jacksonville, ILThe pilot’s improper flare during landing which resulted in an attempted go-around, loss of control, and aerodynamic stall.NTSB CEN21LA226Accident · Serious injuriesClass 4 · LimitedFinal reportI.C.A.-Brasov IS-28B2 · Hampshire, ILThe flight instructor’s failure to maintain aircraft control resulting in the exceedance of the glider’s critical angle of attack following the breakage of the weak/safety link during a winch launch, which resulted in an aerodynamic stall and spin, and…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 CEN20FA110Accident · 3 fatalClass 3 · FieldFinal reportCessna 172 · Lincoln, ILThe pilot's exceedance of the airplane's critical angle of attack during an aerial survey, which resulted in an aerodynamic stall at an altitude too low to recover.NTSB GAA18CA401Accident · No injuriesData collectionFinal reportGrumman G164 · Rochelle, ILThe pilot’s failure to move the power lever to the proper position before takeoff, which resulted in insufficient airspeed and a subsequent aerodynamic stall.NTSB CEN18LA228Accident · Minor injuriesLimited investigationFinal reportRGJ Johnson AIR CAM · Greenwood, ILThe pilot's decision to take off with insufficient runway available and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN18LA092Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172M · Centralia, ILThe pilot's exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall/spin.NTSB CEN16FA308Accident · 1 fatalField investigationFinal reportPzl-Bielsko SZD 55-1 · Channahon, ILThe glider pilot's failure to maintain adequate pitch control while being towed and his subsequent failure to maintain adequate airspeed control after releasing from the towline, which resulted in the glider exceeding its critical angle of attack and an…NTSB CEN16FA214Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Marion, ILThe pilots' failure to maintain adequate airspeed while executing a simulated engine failure and landing maneuver, which resulted in the wing's critical angle of attack being exceeded and a subsequent aerodynamic stall and loss of control.NTSB CEN15FA190Accident · 7 fatalField investigationFinal reportCessna 414A · Bloomington, ILThe pilot's failure to maintain control of the airplane during the instrument approach in night instrument meteorological conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin. Contributing to the…NTSB CEN15LA068Accident · Serious injuriesLimited investigationFinal reportRans S-14 · Kewanee, ILThe pilot’s failure to maintain airspeed during the final approach, which resulted in a stall/mush. Contributing to the accident was the pilot’s failure to obtain training in the pusher-type airplane.NTSB CEN15FA048Accident · 1 fatalField investigationFinal reportAero Commander 500 B · Chicago, ILThe pilot's failure to maintain airspeed while attempting to return to the airport after a reported engine problem, which resulted in an aerodynamic stall/spin.NTSB CEN12FA534Accident · 1 fatalField investigationFinal reportBeech G18 - S · Taylorville, ILThe pilot's failure to maintain adequate airspeed and use the appropriate flaps setting during sport-parachuting operations, which resulted in an aerodynamic stall/spin and a subsequent loss of control. Contributing to the accident was the pilot’s failure to…NTSB CEN12FA073Accident · 1 fatalField investigationFinal reportSkykits Savannah VGW · Plato Center, ILThe noncertificated pilot’s decision to fly the airplane without receiving any flight instruction in the airplane, which resulted in his failure to maintain sufficient airspeed during takeoff and the subsequent aerodynamic stall.NTSB CEN11LA373Accident · No injuriesLimited investigationFinal reportMooney M20R · Lake In The Hills, ILThe pilot's improper landing flare and recovery from a bounced landing, which resulted in a loss of control. Contributing to the accident was the certified flight instructor’s inadequate supervision.NTSB CEN11FA144Accident · Minor injuriesField investigationFinal reportGates Learjet 35A · Springfield, ILThe pilot’s decision to conduct an instrument approach in icing conditions without the anti-ice system activated, contrary to the airplane flight manual guidance, which resulted in an inadvertent aerodynamic stall due to an in-flight accumulation of airframe…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 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 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 CEN09FA111Accident · 2 fatalField investigationFinal reportLantzair Flyers Lancair 360 · Joliet, ILThe pilot’s failure to maintain adequate flying speed during the night takeoff for undetermined reasons, which resulted in an inadvertent aerodynamic stall and subsequent loss of control