Fatal NTSB investigations, CO

22 cases where the sequence of events included Aerodynamic stall/spin.

Cases per year

20082026
Fatal NTSB investigations, CO per year, 2008–2026: 22 cases
20082
20092
20111
20122
20132
20144
20162
20171
20201
20221
20232
20241
20251

Latest 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.\"highestInjuryLevel\" = 'Fatal'
    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.

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…May 17, 2025 · N4321Z · DestroyedNTSB 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.Jun 17, 2024 · N245T · DestroyedNTSB 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.Aug 31, 2023 · N50FU · Substantial damageNTSB 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.Aug 5, 2023 · N4184G · Substantial damageNTSB 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.Aug 9, 2022 · N727PC · DestroyedNTSB 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…Nov 26, 2020 · N87LW · Substantial damageNTSB 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.Feb 27, 2017 · N2461N · Substantial damageNTSB 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.Aug 19, 2016 · N8870Q · DestroyedNTSB 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…May 18, 2016 · N6609P · Substantial damageNTSB 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…Aug 31, 2014 · N228LL · DestroyedNTSB 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.May 31, 2014 · N6275G · Substantial damageNTSB 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.Mar 29, 2014 · N63917 · DestroyedNTSB 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.Mar 22, 2014 · N702H · Substantial damageNTSB 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.Dec 12, 2013 · N8037P · Substantial damageNTSB 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.Jun 8, 2013 · N7147R · Substantial damageNTSB 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.Jul 21, 2012 · N96YK · Substantial damageNTSB 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.Feb 19, 2012 · N4772A · Substantial damageNTSB 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.Apr 23, 2011 · N143FJ · Substantial damageNTSB 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.Jul 9, 2009 · N212TC · DestroyedNTSB CEN09FA147Accident · 1 fatalField investigationFinal reportMooney M20C · Elbert, COThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and subsequent loss of control.Feb 1, 2009 · N7774M · Substantial damageNTSB DFW08FA233Accident · 2 fatalField investigationFinal reportPiper Aerostar PA-60-602P · Kremmling, COThe pilot’s failure to maintain aircraft control, resulting in an aerodynamic stall and spin.Sep 19, 2008 · N97TS · DestroyedNTSB DEN08FA152Accident · 2 fatalField investigationFinal reportGulfstream American AA-5A · Baxter Pass, COThe pilot's failure to maintain adequate airspeed during a turn, resulting in an unrecoverable aerodynamic stall.Sep 7, 2008 · N26930 · Destroyed