NTSB investigations, 2008, CO
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1963 | 1 |
|---|---|
| 1964 | 117 |
| 1965 | 112 |
| 1966 | 149 |
| 1967 | 145 |
| 1968 | 130 |
| 1969 | 123 |
| 1970 | 100 |
| 1971 | 118 |
| 1972 | 91 |
| 1973 | 107 |
| 1974 | 130 |
| 1975 | 104 |
| 1976 | 100 |
| 1977 | 121 |
| 1978 | 118 |
| 1979 | 120 |
| 1980 | 98 |
| 1981 | 94 |
| 1982 | 105 |
| 1983 | 106 |
| 1984 | 94 |
| 1985 | 88 |
| 1986 | 71 |
| 1987 | 95 |
| 1988 | 86 |
| 1989 | 80 |
| 1990 | 78 |
| 1991 | 89 |
| 1992 | 90 |
| 1993 | 71 |
| 1994 | 63 |
| 1995 | 74 |
| 1996 | 85 |
| 1997 | 69 |
| 1998 | 66 |
| 1999 | 86 |
| 2000 | 74 |
| 2001 | 70 |
| 2002 | 73 |
| 2003 | 65 |
| 2004 | 73 |
| 2005 | 75 |
| 2006 | 54 |
| 2007 | 63 |
| 2008 | 60 |
| 2009 | 51 |
| 2010 | 47 |
| 2011 | 54 |
| 2012 | 57 |
| 2013 | 48 |
| 2014 | 49 |
| 2015 | 39 |
| 2016 | 31 |
| 2017 | 34 |
| 2018 | 33 |
| 2019 | 35 |
| 2020 | 44 |
| 2021 | 47 |
| 2022 | 34 |
| 2023 | 38 |
| 2024 | 31 |
| 2025 | 43 |
| 2026 | 43 |
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 year(c.\"eventDate\") = 2008
AND c.\"eventStateOrRegion\" = 'CO' AND c.\"eventCountry\" = 'USA'
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 year(c."eventDate") = 2008 AND c."eventStateOrRegion" = 'CO' AND c."eventCountry" = 'USA' 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 CEN09CA123Accident · No injuriesData collectionFinal reportCessna T210M · Fort Collins, COA total loss of engine power due to fuel starvation as a result of the pilot's failure to select the fullest tank before landing.NTSB CEN09FA098Accident · 2 fatalField investigationFinal reportPiper PA-46 · Hayden, COThe pilot's loss of situational awareness while maneuvering in adverse weather conditions, resulting in spatial disorientation.NTSB DCA09MA021Accident · Serious injuriesClass 1 · MajorFinal reportBoeing 737-524 · Denver, COThe captain’s cessation of right rudder input, which was needed to maintain directional control of the airplane, about 4 seconds before the excursion, when the airplane encountered a strong and gusty crosswind that exceeded the captain’s training and…NTSB CEN09FA097Accident · 2 fatalField investigationFinal reportHawker Beechcraft 58P · Stonewall, COThe pilot's inadvertent flight into mountain wave activity resulting in a loss of control and subsequent impact with mountainous terrain.NTSB CEN09LA075Accident · Minor injuriesLimited investigationFinal reportHauser U/Hauser J KIT FOX CL · Boulder, COA loss of engine thrust due to the pilot's inadvertent activation of the propeller controls. Contributing to the accident were the non-standard propeller controls and the pilot's lack of experience in the airplane.NTSB CEN09CA067Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta II · Erie, COthe pilot's improper flare during the practice autorotation which resulted in a hard landing. Contributing factors were the flight instructor's delayed remedial action and inadequate supervision.NTSB CEN09CA069Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Colorado Springs, COFailure of the pilot to maintain directional control and his failure to compensate for wind conditions. Contributing to the accident were gusting winds with a wind shear warning in effect.NTSB CEN09CA085Accident · No injuriesData collectionFinal reportDavis Daniel T Cozy · Monte Vista, COThe flight instructor's failure to maintain control of the airplane during landing.NTSB CEN09LA056Accident · 1 fatalLimited investigationFinal reportCessna 182M · Basalt, COThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in his loss of control of the airplane in flight.NTSB CEN09CA079Accident · No injuriesData collectionFinal reportPiper PA18-150 · Colorado Springs, COLoss of directional control due to an encounter with a weather phenomena at rotation.NTSB CEN09CA047Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Lamar, COThe student pilot's failure to maintain directional control during landing.NTSB CEN09CA045Accident · No injuriesData collectionFinal reportHartter Lenny J Bearhawk · Mack, COThe collapse of the left main landing gear which resulted in the pilot's failure to maintain directional control.NTSB CEN09LA035Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Broomfield, COThe pilot's failure to maintain control of the airplane, resulting in an inadvertent stall, during a landing attempt. Contributing to the accident was the gusty crosswinds.NTSB CEN09LA031Accident · No injuriesLimited investigationFinal reportCessna 180 · Whitewater, COBoth pilots' failure to see and avoid the other airplane. Contributing factors in this accident were the Cessna 180 pilot's attention being diverted and the Cessna 210 pilot's vision being affected by the sun glare.NTSB CEN09CA001Accident · No injuriesData collectionFinal reportLuscombe 8A · Greeley, COThe pilot's failure to maintain directional control during the landing roll resulting in a ground loop. Contributing to the accident was the lack of remedial action from the flight instructor.NTSB DFW08LA238Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Leadville, COThe flight instructor's failure to maintain control of the airplane while maneuvering at low altitude.NTSB 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.NTSB DEN08CA157Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Boulder, COThe pilot's failure to use the dive brake during landing resulting in a long landing and collision.NTSB DFW08TA225Accident · Serious injuriesFinal reportDiamond Aircraft Industries DA-20-C-1 · Pueblo, COThe student pilot's inability to maintain aircraft control due to an encounter with wake turbulence from a preceding larger aircraft. Contributing to the accident was the instructor pilot's failure to intervene.NTSB DEN08LA153Accident · No injuriesLimited investigationFinal reportCessna 210 · Pagosa Springs, COThe failure of the landing gear to extend for undetermined reasons.NTSB 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.NTSB DEN08CA154Accident · No injuriesData collectionFinal reportNorth American SNJ-5 · Leadville, COThe pilot's failure to maintain aircraft control during takeoff.NTSB DFW08CA221Accident · No injuriesData collectionFinal reportCessna 560 · Telluride, COThe pilot's failure to maintain control during landing. A factor was the reported wind shear.NTSB DEN08CA146Accident · No injuriesData collectionFinal reportHelie RV-6 · Denver, COThe pilot failed to maintain directional control during landing. Contributing to the accident was the crosswind.NTSB DFW08TA224Accident · Minor injuriesFinal reportAir Tractor AT-802A · Meeker, COThe pilot's improper decision to continue an aerial application following an uncommanded opening of the cabin door in flight, and his subsequent failure to maintain control of the airplane.NTSB DFW08FA212Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Yuma, COThe pilot's failure to maintain control of the airplane after an encounter with instrument meteorological conditions.NTSB DEN08FA141Accident · 4 fatalField investigationFinal reportCessna 182T · Georgia Pass, COThe pilot's failure to maintain aircraft control after inadvertantly encountering instrument meteorological conditions. Contributing to the accident were the pilot's failure to obtain a weather brief and the severe weather conditions.NTSB DEN08CA142Accident · No injuriesData collectionFinal reportAerotek Pitts Special S-1S · Crawford, COthe pilot's failure to maintain directional control during takeoff. Contributing to the accident were wind gusts and rough terrain.NTSB DEN08CA135Accident · No injuriesData collectionFinal reportGrumman G-164A · Walsh, COThe total failure of a cylinder head assembly. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB DEN08CA134Accident · No injuriesData collectionFinal reportEnstrom 280FX · Aurora, COThe pilot's improper planning and decision making resulting in the loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's premature application of collective resulting in a hard landing and substantial damage.NTSB DEN08LA131Accident · Serious injuriesLimited investigationFinal reportFlynn Van Munk · Erie, COA loss of engine power due to carburetor icing. The reason for the loss of aircraft control was not determined.NTSB DEN08IA130Incident · No injuriesIncident investigationFinal reportRaytheon Cobra · Colorado Springs, COThe flight team's failure to program the UAS with flight-tested parameters that could tolerate the high density altitude and tailwind conditions encounted during the flight, which resulted in two undershoot approaches, and the existence of an undiscovered…NTSB DFW08CA200Accident · No injuriesData collectionFinal reportCurtiss-Wright 12Q · Erie, COFailure of the tail wheel control cable during landing roll out, which resulted in a loss of control.NTSB DEN08IA123Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-114 · Denver, COTotal failure of the right inboard tire. Contributing to this incident were the low pressure of the tire, and the high tire heat generated by the previous rejected takeoff.NTSB DEN08LA128Accident · No injuriesLimited investigationFinal reportBeech 35-C33A · Longmont, COA total loss of engine power for reasons undetermined. Contributing to the accident was the unsuitable terrain on which to make a forced landing.NTSB DFW08CA181Accident · No injuriesData collectionFinal reportPiper PA-22/20 · Peyton, COLanding gear collapse during the landing roll for undetermined reasons.NTSB DEN08LA118Accident · No injuriesLimited investigationFinal reportMooney M20M · Elbert, COThe pilot's failure to maintain aircraft control during a go-around, resulting in an aerodynamic stall. Contributing to the accident was the high density altitude.NTSB LAX08CA209Accident · Minor injuriesData collectionFinal reportAerostar International S-77A · Boulder, COAn encounter with a sudden gust of wind, which rendered the balloon uncontrollable and led to a collision with a tree.NTSB DFW08CA175Accident · No injuriesData collectionFinal reportChristen Industries A-1 · Pueblo, COThe pilot's failure to maintain directional control during landing. Contributing to the accident were the wind gust and tailwind.NTSB DFW08FA153Accident · 2 fatalField investigationFinal reportCessna 310Q · Steamboat, COThe pilot's failure to maintain clearance from mountainous terrain in day visual conditions. Contributing to the accident was the pilot's impairment due to marijuana and inadequate medical oversight of the pilot by the Federal Aviation Administration.NTSB DFW08CA147Accident · No injuriesData collectionFinal reportDowell Vaughn Exec 90 · Lafayette, COThe pilot's improper in-flight decision to continue flight after experiencing a loss of rotor RPM. Contributing to the accident were the pilot's low level of experience in helicopters and the leaking oil from the engine oil filler cap.NTSB DEN08LA090Accident · No injuriesLimited investigationFinal reportDeHavilland DH112 Venom · Hudson, COThe loss of engine power for reasons undetermined. Contributing to the damage of the airplane were the three ditches and the lack of suitable terrain for a forced landing.NTSB DFW08FA131Accident · 1 fatalField investigationFinal reportCessna 182 · Black Hawk, COThe loss of engine power due to induction icing. A contributing factor was the pilot's decision to continue flight in conditions favorable for structural and induction-system icing.NTSB DEN08LA085Accident · Minor injuriesLimited investigationFinal reportNorth American SNJ-5 · Wolcott, COThe failure of the engine driven fuel pump flange due to oil starvation, resulting in the loss of engine power due to fuel starvation. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB DEN08CA086Accident · No injuriesData collectionFinal reportMooney M20E · Erie, COThe pilot failed to maintain directional control of the airplane during the touch and go landing.NTSB DFW08LA115Accident · No injuriesLimited investigationFinal reportCessna 421C · Sterling, COFailure and separation of the upper and lower right main gear torque links links, which resulted in a loss of directional control on landing roll-out.NTSB DFW08CA124Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Rifle, COThe pilot's failure to maintain control of the airplane on landing. A factor was the crosswind and wind gusts.NTSB DEN08GA076Accident · 1 fatalFinal reportAir Tractor AT-602 · Fort Carson, COThe pilot's failure to maintain aircraft control following the jettison of the load during an aerial fire flighting mission, which resulted in an inadvertent stall and impact with terrain. Contributing to the accident were the improperly configured aircraft…NTSB DEN08IA080Incident · No injuriesIncident investigationFinal reportHill Hatz CB-1 · Erie, COthe pilot's failure to maintain directional control during landing. A contributing factor was the gusty wind conditions.NTSB DEN08FA072Accident · No injuriesField investigationFinal reportBombardier CL-600-2B16 · Colorado Spring, COthe impact with a bird during initial takeoff climb.