NTSB investigations, CO
58 cases where the sequence of events included Aerodynamic stall/spin.
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 6 |
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 4 |
| 2013 | 2 |
| 2014 | 6 |
| 2015 | 2 |
| 2016 | 5 |
| 2017 | 3 |
| 2018 | 4 |
| 2019 | 2 |
| 2020 | 2 |
| 2021 | 2 |
| 2022 | 2 |
| 2023 | 5 |
| 2024 | 2 |
| 2025 | 2 |
| 2026 | 2 |
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\" = 'CO' 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" = 'CO' 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 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 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 CEN26LA001Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-28R-200 · Colorado Springs, COOn October 1, 2025, about 0412 mountain daylight time, a Piper PA-28R-200 airplane, N999AD, was substantially damaged during an accident near Colorado Springs, Colorado. The pilot sustained minor injuries, and the 2 passengers were not injured. The airplane…NTSB CEN25FA178Accident · 2 fatalClass 3 · FieldPreliminary reportBeech 95-B55 (T42A) · Broomfield, COOn May 17, 2025, about 1003 mountain daylight time, a Beechcraft 95-B55, was destroyed when it was involved in an accident near Broomfield, Colorado. The pilot and pilot-rated passenger sustained fatal injuries. The flight was being operated as a Title 14…NTSB CEN24FA228Accident · 2 fatalClass 3 · FieldFinal reportCessna 421 · Steamboat Springs, COThe pilot’s failure to maintain sufficient airspeed following a loss of engine power, which resulted in an inadvertent aerodynamic stall/spin at low altitude.NTSB CEN24LA133Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Falcon, COThe flight instructor’s failure to maintain control during takeoff which resulted in an aerodynamic stall and an impact with terrain.NTSB CEN24LA015Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Tiger Moth DH 82A · Greeley, COThe pilot’s decision to turn out early during the initial climb and failure to maintain adequate airspeed/angle-of-attack, which resulted in an aerodynamic stall and impact with airport hangars. Contributing to the accident was the variable wind conditions…NTSB CEN23FA391Accident · 1 fatalClass 3 · FieldFinal reportSchleicher Alexander ASH 26 E · Wellington, COThe pilot’s loss of glider control during approach for reasons that could not be determined, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB CEN23FA349Accident · 1 fatalClass 3 · FieldFinal reportNanchang China CJ-6A · Peyton, COThe pilot’s exceedance of the airplane’s critical angle of attack while intentionally maneuvering in a steep bank at low altitude, which resulted in an accelerated aerodynamic stall/spin and subsequent loss of airplane control.NTSB CEN23LA263Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182G · Gunnison, COThe pilot’s improper decision to fly into an area of unsuitable terrain which the airplane was unable to exit, resulting in an aerodynamic stall and subsequent impact with terrain.NTSB CEN23LA128Accident · Minor injuriesClass 3 · LimitedFinal reportZenith Zodiac 601XL · La Veta, COThe pilot’s decision to fly the airplane in which he had no experience in strong, gusting wind, which resulted his failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack and a subsequent aerodynamic stall.NTSB CEN23LA013Accident · Serious injuriesClass 4 · LimitedFinal reportPober Pixie · Sterling, COThe pilot’s failure to maintain control during the takeoff with strong gusty surface wind.NTSB CEN22FA376Accident · 1 fatalClass 3 · FieldFinal reportCessna 182Q · Centennial, COThe loss of engine power during a departure climb for undetermined reasons and the aerodynamic stall, which resulted in an uncontrolled descent and impact with terrain.NTSB CEN21LA425Accident · Serious injuriesClass 3 · LimitedFinal reportKolb Mark III · Steamboat Springs, COThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN21LA190Accident · No injuriesClass 3 · LimitedFinal reportGates Learjet 35A · Colorado Springs, COThe flight crew’s improper decision to continue the unstabilized approach, which resulted in an aerodynamic stall and impact with the runway during landing.NTSB CEN21LA067Accident · 2 fatalClass 3 · LimitedFinal reportVans RV4 · Telluride, COThe pilot’s failure to maintain adequate airspeed during the turn from the base leg to final approach, which resulted in the airplane exceeding its critical angle of attack and entering an inadvertent aerodynamic stall/spin at a low altitude over mountainous…NTSB CEN21LA001Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 210 · Cedaredge, COA partial loss of engine power for reasons that could not be determined based on available evidence.NTSB GAA20CA075Accident · No injuriesData collectionFinal reportCessna 182 · Broomfield, COThe pilot’s inadvertent flight into icing conditions, which resulted in the accumulation of structural icing and an aerodynamic stall.NTSB CEN19TA330Accident · No injuriesClass 3Final reportCirrus SR22 · Glenwood Springs, COThe pilot’s failure to maintain control of the airplane while landing with a tail wind, which resulted in an aerodynamic stall and a subsequent hard landing..NTSB GAA19CA023Accident · No injuriesData collectionFinal reportSkystar Kitfox SER 5 Safari · Monte Vista, COThe pilot's improper landing flare in gusting crosswind conditions, which resulted in a hard, bounced landing and his subsequent failure to maintain directional control.NTSB CEN18LA348Accident · No injuriesLimited investigationFinal reportPiper PA32R · Falcon, COThe pilot's decision to depart with an inoperative left magneto, which resulted in degraded climb performance in high-density altitude conditions and a subsequent emergency landing.NTSB CEN18CA323Accident · No injuriesData collectionFinal reportCessna 172 · Greeley, COThe pilot’s and safety pilot's conflicting control inputs during landing, which resulted in their failure to maintain a proper airspeed and resulted in an aerodynamic stall. Contributing to the accident was the lack of communication between the pilot and…NTSB GAA18CA473Accident · Serious injuriesData collectionFinal reportVans RV6 · Greeley, COThe pilot’s exceedance of the airplane’s critical angle of attack during approach, which resulted in an aerodynamic stall.NTSB CEN17FA111Accident · 2 fatalField investigationFinal reportCessna 172S · Berthoud, COThe failure of the pilots to apply prompt and/or correct flight control inputs to adequately recover from the intentional aerodynamic spin.NTSB CEN17LA122Accident · Serious injuriesLimited investigationFinal reportPiper PA 28R-200 · Centennial, COThe loss of airplane control during takeoff for reasons that could not be determined based on the available information, which resulted in an aerodynamic stall and impact with terrain.NTSB GAA17CA131Accident · Minor injuriesData collectionFinal reportCessna T210 · Loveland, COThe pilot's exceedance of the airplane’s critical angle of attack during an attempted go-around, which resulted in an aerodynamic stall.NTSB CEN16FA328Accident · 1 fatalField investigationFinal reportAero Commander S2R · Center, COThe pilot's failure to maintain airplane control during a low-level maneuver, which resulted in an aerodynamic stall.NTSB GAA16CA394Accident · No injuriesData collectionFinal reportAlon A2 · Alamosa, COThe pilot's failure to maintain aircraft control during takeoff on an uneven runway surface, which resulted in it becoming airborne prematurely, an aerodynamic stall, and impact with terrain.NTSB GAA16CA336Accident · No injuriesData collectionFinal reportCessna 152 · Delta, COThe pilot exceeded the critical angle of attack during the initial climb in tailwind conditions, which resulted in an aerodynamic stall.NTSB CEN16FA188Accident · 1 fatalField investigationFinal reportCessna P210N · Sheridan Lake, COThe pilot's severe impairment from the combined effects of high levels of ingested alcohol as well as three impairing medications (zolpidem, lorazepam, and diphenhydramine), which resulted in his decision to attempt an aerobatic maneuver that the airplane was…NTSB GAA16CA150Accident · No injuriesData collectionFinal reportCessna 172 · La Junta, COThe pilot's decision to take off with a tailwind, and exceed the critical angle of attack, which resulted in an aerodynamic stall and impact with the ground.NTSB GAA15CA292Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Lake City, COThe pilot's failure during takeoff to attain sufficient airspeed for conditions, and to maintain yaw control and a positive rate of climb, resulting in a loss of directional control, an uncontrolled descent, and collision with trees and terrain.NTSB GAA15CA053Accident · Minor injuriesData collectionFinal reportAero SP Z O O AT 4 LSA · Colorado Springs, COThe pilot's decision to perform aerobatic maneuvers in an airplane not certified for aerobatic flight, which resulted in a loss of control and collision with terrain.NTSB CEN14LA476Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-350P · Cortez, COThe flight instructor’s delayed decision to abort the simulated engine out maneuver, his failure to unfeather the propeller before restoring engine power, and his inadequate airspeed management, which led to an aerodynamic stall at low altitude.NTSB CEN14FA467Accident · 5 fatalField investigationFinal reportPiper PA 46 350P · Erie, COThe pilot's failure to maintain adequate airspeed and exceedance of the critical angle of attack during a go-around with a tailwind condition, which resulted in an aerodynamic stall. A contributing factor to the accident was the pilot's decision to continue…NTSB CEN14FA265Accident · 2 fatalField investigationFinal reportCessna 150 · Watkins, COThe pilot’s loss of control and subsequent aerodynamic stall due to spatial disorientation in night instrument meteorological conditions. Contributing to the accident was the pilot’s distraction due to his cell phone use while maneuvering at low-altitude.NTSB CEN14FA230Accident · No injuriesField investigationFinal reportPiper PA 25-235 · Northglenn, COThe pilot's decision to operate the banner-tow flight below the minimum safe altitude specified by federal regulation, which likely limited his ability to recover from a potential loss of airspeed due to a gusting wind condition. Also causal was the pilot’s…NTSB CEN14FA173Accident · 1 fatalField investigationFinal reportWorthington Donald Wayne Sonerai II LT · Highlands Ranch, COThe pilot’s loss of control during a forced landing following a loss of engine power for reasons that could not be determined due to postimpact fire damage.NTSB CEN14FA167Accident · 5 fatalField investigationFinal reportSocata TBM 700 · Ridgway, COThe pilot's loss of airplane control during an instrument approach procedure, which resulted in the airplane exceeding its critical angle of attack and entering an inadvertent aerodynamic stall and spin.NTSB CEN14FA084Accident · 3 fatalField investigationFinal reportPiper PA 24-250 · Collbran, COThe pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in an aerodynamic stall/spin and subsequent impact with terrain.NTSB CEN13FA327Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Mosca, COThe pilot's failure to maintain airplane control while attempting to clear a mountain pass in turbulent conditions at a high density altitude, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB CEN12FA462Accident · 2 fatalField investigationFinal reportNanchang China CJ-6A · Walsenburg, COThe pilot's failure to maintain airplane control while turning from base to final leg in the traffic pattern.NTSB CEN12LA345Accident · No injuriesLimited investigationFinal reportLearjet 60 · Aspen, COThe first officer’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during the final approach in known low-level windshear conditions, which resulted in an aerodynamic stall. Contributing to the accident…NTSB CEN12CA263Accident · No injuriesData collectionFinal reportCampbell David Legacy · Durango, COThe pilot’s improper flare and subsequent aerodynamic stall, which resulted in a hard landing.NTSB CEN12FA161Accident · 2 fatalField investigationFinal reportCessna 414A · Hayden, COThe pilot’s inadvertent stall during a missed approach. Contributing to the accident was the pilot’s operation of the airplane in forecasted icing conditions without using all of its anti-ice systems.NTSB CEN11FA304Accident · 2 fatalField investigationFinal reportCubcrafters CC11-160 · Parker, COThe pilot’s excessive and unsafe maneuvering during gusty wind conditions, which resulted in an inadvertent stall-spin.NTSB CEN11CA289Accident · Minor injuriesData collectionFinal reportRans S12 · Fort Collins, COThe pilot's inadvertent application of full right rudder during landing, which resulted in an aerodynamic stall and impact with terrain.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 CEN09CA505Accident · Serious injuriesData collectionFinal reportFairchild PT-19A · Colorado Springs, COThe pilot's failure to maintain adequate airspeed to avoid an aerodynamic stall during a high-density altitude takeoff.NTSB CEN09FA425Accident · 1 fatalField investigationFinal reportNorth American SNJ-5 · Simla, COThe pilot’s failure to maintain control of the airplane while practicing aerobatic maneuvers and his subsequent failure to recover from an inadvertent spin.