NTSB investigations, CO
615 cases where NTSB found Aircraft.
Cases per year
| 2008 | 47 |
|---|---|
| 2009 | 43 |
| 2010 | 29 |
| 2011 | 43 |
| 2012 | 42 |
| 2013 | 36 |
| 2014 | 41 |
| 2015 | 30 |
| 2016 | 25 |
| 2017 | 29 |
| 2018 | 24 |
| 2019 | 30 |
| 2020 | 37 |
| 2021 | 39 |
| 2022 | 22 |
| 2023 | 32 |
| 2024 | 23 |
| 2025 | 27 |
| 2026 | 16 |
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01'))
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", '01')) 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 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 WPR26LA259Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Monte Vista, COThe pilot’s failure to maintain directional control during takeoff in gusty crosswind conditions.NTSB WPR26LA243Accident · No injuriesClass 4 · LimitedFinal reportValerie Westedt Zenith Zodiac 650B · Colorado Springs, COThe pilot’s improper flare which resulted in a hard landing and their subsequent loss control of during a go-around. Contributing to the accident was the flight instructor’s inadequate remedial action.NTSB CEN26LA243Accident · Serious injuriesClass 4 · LimitedFinal reportEvolution Revolt · Peyton, COThe flight instructor’s inadequate supervision of the student pilot, which resulted in the loss of control during a rejected takeoff.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 CEN26LA183Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182P · Bennett, COThe pilot’s improper flare during landing that resulted in a hard landing.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 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 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 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 CEN26LA166Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 NG · Colorado Springs, COMaintenance personnel's installation of an oversized tire, which prevented the left main landing gear from extending resulting in a precautionary gear up landing.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 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 CEN26LA133Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Denver, COThe solo student pilot's improper landing flare and subsequent improper recovery from a bounced landing which resulted in substantial damage to the airplane.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 CEN26LA067Accident · No injuriesClass 4 · LimitedFinal reportMark O Treidel American Ranger AR-1 · Denver, COThe pilot’s failure to attain rotor RPM and maintain proper rotor disc angle during takeoff which resulted in a rotor strike with the rudder.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 CEN26LA004Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · North La Junta, COThe solo student pilot’s improper landing flare and subsequent improper recovery from a bounced landing.NTSB CEN25LA405Accident · Minor injuriesClass 4 · LimitedFinal reportSukhoi SU-26MX · Longmont, COThe pilot's failure to maintain directional control during takeoff.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 CEN25LA398Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-60-601P · Del Norte, COThe loss of directional control during landing roll due to a flat tire.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 CEN25LA334Accident · No injuriesClass 4 · LimitedFinal reportKaman Aerospace K-1200 · Eagle, COThe pilot’s failure to maintain helicopter control which resulted in an uncontrolled descent and impact with terrain.NTSB CEN25LA333Accident · No injuriesClass 4 · LimitedFinal reportParks Fokker D-VII Replica · Englewood, COA malfunction of the tailwheel which resulted in a runway excursion and ground loop.NTSB CEN25LA329Accident · No injuriesClass 4 · LimitedFinal reportJMB Aircraft S R O VL-3LSA-912 · Erie, COThe flight instructors inadequate supervision of the flight and delayed remedial action and the pilot’s improper landing flare during which resulted in a hard landing.NTSB CEN25LA328Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV14 · Parker, COSeparation of the right landing gear wheel assembly during landing.NTSB DCA25LA275Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737-8 · Denver, COThe failure of the airplane’s left main landing gear tires and wheels during the takeoff roll due to the thermal relief plugs melting and releasing tire pressure, which resulted in abnormal airplane handling characteristics and led the flight crew to reject…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 CEN25LA245Accident · No injuriesClass 4 · LimitedFinal reportFairchild 24R · Greeley, COThe pilot’s inability to maintain directional control during landing due to excessive wear in the tailwheel steering assembly.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 CEN25LA236Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Meeker, COThe student pilot’s failure to maintain directional control during landing. Contributing to the accident was the flight instructor’s delayed remedial action.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 CEN25LA168Accident · No injuriesClass 3 · LimitedFinal reportCessna 172N · Longmont, COThe disconnected throttle control that resulted in a loss of engine power due to improper maintenance.NTSB CEN25LA146Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Ault, COThe flight instructor’s failure to maintain terrain clearance during an attempted go-around, which resulted in a collision with a fence post.NTSB CEN25LA126Accident · No injuriesClass 3 · LimitedFinal reportBeech V35 · Englewood, COThe failure of the alternator drive shaft due to a maintenance error which led to the partially discharged battery. The landing gear system failed to achieve a down and locked configuration due to a partially discharged battery.NTSB CEN25LA129Accident · No injuriesClass 4 · LimitedFinal reportStemme S10-VT · Kiowa, COThe pilot’s inadequate preflight inspection and fuel planning which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN25LA118Accident · No injuriesClass 4 · LimitedFinal reportJust Superstol · Paonia, COThe pilot’s failure to maintain the airplane’s directional control during the takeoff roll.NTSB CEN25LA089Accident · Minor injuriesClass 4 · LimitedFinal reportLuscombe 8E · Brush, COThe failure of the left main landing gear forward strut.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 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 CEN25LA003Accident · Minor injuriesClass 3 · LimitedFinal reportSchweizer 269C · Montrose, COA loss of engine power during a demonstrated autorotation due to an improperly adjusted air-fuel mixture or idle setting. Contributing to the accident was the pilot’s failure to perform the required idle check during previous flights in higher elevation areas.NTSB CEN25LA001Accident · No injuriesClass 4 · LimitedFinal reportCessna TR182 · Englewood, COThe collapse of the right main landing gear during landing rollout.NTSB CEN24LA375Accident · No injuriesClass 4 · LimitedFinal reportBellanca 14 19 · Cortez, COThe pilot’s failure to extend the landing gear before landing.NTSB CEN24LA374Accident · Minor injuriesClass 4 · LimitedFinal reportCub Crafters CCX-2000 · Kremmling, COThe pilot’s failure to maintain directional control of the airplane during an aborted landing.NTSB CEN24LA359Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Italia S R L Virus SW · Boulder, COThe pilot’s improper landing flare, which resulted in a nose down attitude and subsequent porpoised landing.