NTSB investigations, CO
386 cases where NTSB found Environmental issues.
Cases per year
| 2008 | 40 |
|---|---|
| 2009 | 24 |
| 2010 | 16 |
| 2011 | 21 |
| 2012 | 30 |
| 2013 | 20 |
| 2014 | 27 |
| 2015 | 23 |
| 2016 | 19 |
| 2017 | 18 |
| 2018 | 19 |
| 2019 | 18 |
| 2020 | 17 |
| 2021 | 21 |
| 2022 | 18 |
| 2023 | 17 |
| 2024 | 16 |
| 2025 | 10 |
| 2026 | 12 |
Where
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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03')) 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 CEN26LA300Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T206H · Marble, COThe pilot's failure to maintain directional control during the final approach in variable and gusting wind conditions. Contributing to the accident were localized wind effects associated with mountainous terrain and with nearby convective activity.NTSB WPR26LA266Accident · No injuriesClass 4 · LimitedFinal reportMaule M-4-180V · Creede, COThe pilot’s exceedance of the airplane’s performance capabilities in mountainous terrain, which resulted in a forced landing.NTSB WPR26LA259Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Monte Vista, COThe pilot’s failure to maintain directional control during takeoff in gusty crosswind conditions.NTSB CEN26LA210Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Colorado Springs, COThe student pilot’s failure to maintain directional control of the airplane during the takeoff, which resulted in a runway excursion and collision with runway signs.NTSB CEN26LA181Accident · No injuriesClass 4 · LimitedFinal reportHughes 369HS · Durango, COThe flight instructor’s inadequate supervision of the pilot receiving the instruction and the pilot’s improper recovery from a practice autorotation in shifting wind conditions, which resulted in a hard landing.NTSB CEN26LA272Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-236 · Glenwood Springs, COThe pilot’s failure to maintain clearance from a fuel farm fence while taxiing.NTSB CEN26LA169Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8E · Meeker, COThe pilot’s inability to maintain climb performance and clearance from terrain due to the airplane’s encounter with windshear during takeoff.NTSB CEN26LA165Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Alpha Trainer · Peyton, COThe pilots’ inadequate preflight fuel planning and improper in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion and subsequent forced landing to a field.NTSB CEN26LA152Accident · No injuriesClass 4 · LimitedFinal reportEla ELA10 · Boulder, COThe pilot’s failure to maintain directional control during the takeoff in gusting wind conditions.NTSB CEN26LA151Accident · No injuriesClass 4 · LimitedFinal reportChampion 7GCB · Colorado Springs, COThe pilot’s failure to maintain directional control of the airplane during takeoff in gusty wind conditions, which resulted in a hard landing.NTSB DCA26LA151Accident · No injuriesClass 4 · LimitedFinal reportFairchild SA227-AC · Denver, COThe overstress failure of the left main landing gear lower drag brace links during takeoff which resulted in a runway excursion during landing due to the left main landing gear collapsing.NTSB CEN26LA127Accident · No injuriesClass 4 · LimitedFinal reportRaytheon B36TC · Durango, COThe pilot’s improper landing flare and subsequent loss of directional control while attempting to land during high crosswind conditions.NTSB CEN26LA068Accident · No injuriesClass 4 · LimitedFinal reportKitfox Clasc IV-1200 · Hudson, COThe pilot’s failure to maintain control of the airplane during the landing roll.NTSB CEN26LA053Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-108 · Colorado Springs, COThe pilot’s failure to maintain directional control during the landing.NTSB CEN26LA017Accident · No injuriesClass 4 · LimitedFinal reportRans S20 · Springfield, COThe pilot's failure to maintain directional control during the takeoff with a right crosswind.NTSB CEN25LA403Accident · No injuriesClass 4 · LimitedFinal reportAeronca 11AC · Longmont, COThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and the pilot’s improper landing flare which resulted in a hard landing.NTSB DCA25LA308Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Canada BD500 · Denver, COUnidentified burned debris in an aft galley oven, which generated smoke and odor in the cabin and led to an air turnback and subsequent evacuation, during which a serious injury occurred.NTSB CEN25LA251Accident · Minor injuriesClass 4 · LimitedFinal reportScott Vincin Just Acft Highlander · Mancos, COThe airplane’s reduced climb performance during takeoff in mountainous terrain, which resulted in the airplane’s inability to climb and impact with terrain.NTSB CEN25LA240Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CCK-1865 · La Garita, COThe pilot’s failure to maintain clearance from terrain while maneuvering at low altitude in mountainous terrain. Contributing was the pilot’s inadequate preflight planning and aeronautical decision making.NTSB CEN25LA235Accident · No injuriesClass 4 · LimitedFinal reportPiper PA12 · Brush, COThe pilot’s failure to maintain directional control while performing a touch and go landing.NTSB CEN25LA210Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Fort Morgan, COThe pilot’s failure to maintain directional control of the tailwheel-equipped airplane during a gusty crosswind landing.NTSB CEN25LA088Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Air Force Academy, COThe pilot’s failure to maintain airplane control during final approach after encountering an unexpected windshear.NTSB CEN25LA074Accident · No injuriesClass 3 · LimitedFinal reportCessna 560 · Pagosa Springs, COThe pilot’s inadequate preflight planning and poor preflight inspection and decision-making, which led to a takeoff attempt above the airplane’s certified maximum takeoff weight with snow-contaminated wings, resulting in a rejected takeoff at an airspeed…NTSB CEN25FA047Accident · 2 fatalClass 3 · FieldFinal reportCessna 182T · Drake, COThe pilot’s failure to maintain airplane control while maneuvering in mountainous terrain. Contributing was mountain wave turbulence in the area.NTSB CEN25LA027Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Falcon, COThe student pilot’s failure to maintain aircraft control and the flight instructor’s delayed remedial action during takeoff, which resulted in a collision with a taxiway sign.NTSB CEN24LA362Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172N · Arboles, COA loss of engine power due to carburetor ice.NTSB CEN24FA338Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-602 · Camden, COThe pilot’s failure to maintain adequate clearance from a power transformer that was mounted to a power pole during an aerial application flight.NTSB CEN24LA328Accident · No injuriesClass 3 · LimitedFinal reportHawker Beechcraft Hawker 900XP · Telluride, COThe flight crew’s failure to properly configure the airplane for takeoff in a high-density altitude environment, which resulted in a loss of control and a subsequent runway excursion. Contributing to the accident was the flight crew’s failure to use…NTSB CEN24LA244Accident · Minor injuriesClass 4 · LimitedFinal reportDesert Fox 1 · Ellicott, COThe pilot's decision to takeoff with a quartering tailwind and high density altitude which resulted in a runway overrun. Contributing to the accident was the failure of the right main axle mount due to the poor weld.NTSB CEN24LA226Accident · Serious injuriesClass 3 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2006T · Larkspur, COThe flight instructor’s failure to apply carburetor heat, which resulted in a loss of left engine power due to carburetor icing.NTSB CEN24LA224Accident · No injuriesClass 4 · LimitedFinal reportJonker Sailplanes JS3 RES · Elbert, COThe pilot’s failure to maintain directional control during the landing with a right crosswind.NTSB CEN24LA227Accident · Minor injuriesClass 4 · LimitedFinal reportBeech D55 · Colorado Springs, COThe deflated right main landing gear tire due to a sidewall puncture made by an unknown object, which led to the pilot’s loss of directional control and the landing gear collapse during landing roll.NTSB CEN24LA210Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Gypsum, COThe failure of the flight instructor and the pilot to visually confirm the airplane’s fuel quantity during preflight, which resulted in a loss of engine power due to fuel exhaustion and an off-airport forced landing in rough terrain.NTSB CEN24LA206Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Colorado Springs, COThe pilot’s failure to use the carburetor heat during a descent that resulted in the loss of engine power due to carburetor icing.NTSB CEN24LA198Accident · No injuriesClass 4 · LimitedFinal reportBrant T Phillips Super Cub EXP · Franktown, COThe pilot’s failure to maintain aircraft control during final approach and attempted go-around after encountering a sudden windshear.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 CEN24LA129Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Eurocopter AS350B3 · Fort Morgan, COAn inflight collision with birds while on approach.NTSB CEN24FA083Accident · 2 fatalClass 3 · FieldFinal reportJust Highlander · Dolores, COThe pilot’s collision with a fence while taking off from a snow-covered dirt airstrip.NTSB CEN24LA030Accident · No injuriesClass 4 · LimitedFinal reportMooney M20K · Lamar, COThe pilot's inadequate fuel planning and improper in-flight decision making, which resulted in a total loss of engine power due to fuel exhaustion.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 CEN23LA416Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Montrose, COThe pilot’s failure to maintain directional control during the landing roll with a gusting quartering headwind.NTSB CEN23LA397Accident · Serious injuriesClass 4 · LimitedFinal reportTitanium Auto Gyro Titanium Explorer · Falcon, COThe pilot’s failure to establish a proper airspeed before becoming airborne, which resulted in an inability to climb out of ground effect and subsequent hard landing. Contributing to the accident was high-density altitude.NTSB CEN23LA394Accident · Minor injuriesClass 4 · LimitedFinal reportTextron 172S · Englewood, COAn in-flight collision with multiple geese during initial climb.NTSB CEN23LA325Accident · Serious injuriesClass 4 · LimitedFinal reportUltramagic N-210 · Erie, COA hard landing due to the high wind conditions which resulted in two passengers sustaining serious injuries.NTSB CEN23LA305Accident · Serious injuriesClass 4 · LimitedFinal reportAdams Balloon AB · Lafayette, COAn inadvertent hard landing in high wind conditions resulting in serious injury of two passengers. Contributing to the accident was the increase in prevailing winds prior to the forecast.NTSB CEN23FA285Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-60-601P · Burlington, COThe pilot’s visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control in flight and subsequent impact with terrain.NTSB CEN23LA277Accident · Minor injuriesClass 4 · LimitedFinal reportPiper J3C-50 · Elbert, COThe pilot's loss of directional control during takeoff and subsequent excessive use of brakes which resulted in a nose-over. Contributing to the accident was his decision to takeoff downwind.NTSB CEN23LA203Accident · No injuriesClass 4 · LimitedFinal reportNanchang CJ6 · Windsor, COAn inflight collision with a bird while on initial climb.NTSB CEN23LA189Accident · No injuriesClass 4 · LimitedFinal reportCessna A185f · Grand Junction, COThe pilot’s failure to maintain directional control during the landing roll with gusting wind.NTSB CEN23FA174Accident · 4 fatalClass 3 · FieldFinal reportPool Cessna R172 · Victor, COThe pilot’s failure to follow established mountain flying guidance, which resulted in a loss of control and impact with trees and mountainous terrain. Contributing to the accident was the airplane’s reduced climb performance at the elevated density altitude…