NTSB investigations, 2009, 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\") = 2009
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") = 2009 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 CEN10LA056Accident · Minor injuriesLimited investigationFinal reportNavion Navion G · Montrose, COA loss of engine power due to the pilot’s inadequate preflight planning.NTSB OPS10IA002Incident · No injuriesIncident investigationFinal reportAirbus A320 · Cortez, COThe failure of the ACA795 flight crew to monitor and/or switch to the appropriate air traffic control frequency.NTSB CEN10LA047Accident · No injuriesLimited investigationFinal reportCessna T182T · Loveland, COThe pilot's failure to attain the proper touchdown point during dusk light conditions, and his failure to execute a go-around.NTSB CEN10LA032Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Walsh, COA partial loss of engine power due to failure of the No. 2 cylinder as a result of the failure of the repair facility to properly torque the lower four nuts on the cylinder.NTSB CEN10FA021Accident · Minor injuriesField investigationFinal reportCessna P210N · Rifle, COThe pilot’s failure to properly identify the power lever and, instead, manipulating the propeller condition lever.NTSB CEN10CA020Accident · No injuriesData collectionFinal reportFranklin Pitts Special S-1 · Alamosa, COThe pilot’s failure to maintain directional control on takeoff.NTSB CEN09CA615Accident · No injuriesData collectionFinal reportCessna 175 · Rio Blanco, COThe pilot's failure to maintain directional control during landing and his failure to execute a go-around.NTSB CEN09CA553Accident · No injuriesData collectionFinal reportWarner Lewis Steen · Broomfield, COThe pilot's inability to maintain directional control due to an internal mechanical failure of the left wheel that caused the wheel to seize.NTSB CEN09LA541Accident · Serious injuriesLimited investigationFinal reportCessna CE-560 · Kremmling, COThe lineman’s inadvertent encounter with jet blast.NTSB CEN09LA546Accident · No injuriesLimited investigationFinal reportTaylorcraft BCS-65 · Boulder, COA partial loss of engine power during initial climb due to carburetor icing.NTSB CEN09CA530Accident · No injuriesData collectionFinal reportCessna 172 · Centennial, COThe pilot's failure to maintain directional control of the airplane during the landing flare in crosswind conditions.NTSB CEN09CA528Accident · No injuriesData collectionFinal reportMorse, Frank L. Kitfox · Crawford, COThe pilot's continued flight into a severe downdraft at low altitude after encountering tailwind over the area.NTSB CEN09CA520Accident · No injuriesData collectionFinal reportGrahn J/Grahn G Pitts S2S · Rifle, COThe pilot's excessive landing speed and subsequent excessive brake application which resulted in a loss of control and impact with an airport sign.NTSB CEN09CA544Accident · No injuriesData collectionFinal reportPiper PA-18 · Aspen, COThe pilot's failure to maintain adequate separation behind a preceding large business jet, which resulted in an encounter with wake turbulence.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 CEN09CA489Accident · Minor injuriesData collectionFinal reportCessna 182P · Gateway, COThe pilot's inability to maintain directional control due to soft runway conditions.NTSB CEN09CA465Accident · No injuriesData collectionFinal reportPiper PA32R · Colorado Springs, COThe pilot's low altitude encounter with windshear during takeoff.NTSB CEN09CA464Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Fort Collins, COThe pilot's failure to maintain directional control while landing in gusty, crosswind conditions.NTSB CEN09CA434Accident · Serious injuriesData collectionFinal reportPdps Pzl-Bielsko SZD-59 · Durango, COThe glider pilot's decision to perform a low-altitude 360-degree turn while on final approach to land.NTSB CEN09CA432Accident · No injuriesData collectionFinal reportRemos Remos G-3/ · Erie, COThe student pilot's improper recovery from a bounced landing and the flight instructor's delayed reaction to take control and recover.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.NTSB CEN09LA413Accident · Serious injuriesLimited investigationFinal reportBell Helicopter Textron 206L-1 · Breckenridge, COThe pilot's failure to maintain directional control while maneuvering due to a loss of tail rotor effectiveness. Contributing to the accident was the pilot's failure to monitor wind direction while operating in the "Critical Wind Azimuth Area."NTSB CEN09CA414Accident · No injuriesData collectionFinal reportMooney M20 · Steamboat Springs, COThe pilot's improper pitch control during the go-around, which resulted in an aerodynamic stall.NTSB CEN09CA459Accident · Minor injuriesData collectionFinal reportCessna 172P · Usafa, COThe pilot's failure to maintain a safe flying airspeed resulting in an inadvertent stall during the go-around.NTSB CEN09CA412Accident · Minor injuriesData collectionFinal reportQuicksilver Mxii Sport · Longmont, COThe loss of engine power for undetermined reasons.NTSB CEN09CA376Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Fort Collins, COThe pilot's failure to maintain control of the airplane during a crosswind landing. Contributing to the accident was the instructor's delayed action in regaining control of the airplane.NTSB CEN09CA368Accident · No injuriesData collectionFinal reportGrob G103 · Wellington, COThe pilot’s failure to maintain control of the glider during takeoff.NTSB CEN09CA367Accident · No injuriesData collectionFinal reportCessna 152 · Fort Collins, COThe pilot's failure to control the airplane after engine startup, resulting in a ground collision with a nearby airplane.NTSB ENG09IA007Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Denver, COThere was a malfunction of the electronic engine control (EEC) burner pressure (Pb) sensor that had an abnormally high indication that resulted in an excessive amount of fuel being pumped into the engine that was still at a sub-idle condition. Because the…NTSB CEN09CA343Accident · No injuriesData collectionFinal reportCessna 404 · Englewood, COThe failure of the landing gear to extend due to the failure of a hydraulic line.NTSB CEN09CA307Accident · No injuriesData collectionFinal reportBeech C35 · Englewood, COThe collapse of the landing gear due to the mechanic's failure to properly wire the landing gear squat switch.NTSB DCA09FA047Accident · Minor injuriesField investigationFinal reportAirbus A320 · Denver, COThe first officer’s excessive pitch-up of the airplane while landing with a tailwind, which resulted in a tailstrike following a bounced landing. Contributing to the bounced landing were a high descent rate and excessive thrust resulting from the first…NTSB CEN09LA278Accident · Serious injuriesLimited investigationFinal reportGlasflugel H201B · Meadow Lake Airport, COA programming anomaly within the winch's computer aided launch control system, which incorrectly limited the maximum winch speed during launch of the glider.NTSB CEN09CA264Accident · No injuriesData collectionFinal reportCessna 182T · Rangely, COThe pilot's failure to maintain directional control while landing with a crosswind.NTSB CEN09CA257Accident · No injuriesData collectionFinal reportEnstrom 280FX · Dacono, COA partial loss of engine power for undetermined reasons.NTSB CEN09CA249Accident · No injuriesData collectionFinal reportPiper J3C · Montrose, COThe pilot's failure to maintain directional control during the takeoff roll.NTSB CEN09LA214Accident · Minor injuriesLimited investigationFinal reportMarlman Stol CH 801 · Fort Morgan, COThe complete loss of engine power, as reported by the pilot, for undetermined reasons.NTSB CEN09CA218Accident · No injuriesData collectionFinal reportBell 222 · Milliken, COThe separation of the left engine cowling for undetermined reasons.NTSB CEN09CA213Accident · No injuriesData collectionFinal reportBeech 58 · Durango, COThe student pilot's improper landing flare and the flight instructor's delayed remedial action.NTSB CEN09CA181Accident · No injuriesData collectionFinal reportCessna 172N · Broomfield, COThe pilot and airplane's inability to compensate for the unforecasted gusting wind conditions.NTSB CEN09CA179Accident · No injuriesData collectionFinal reportAviat A-1C · Denver, COThe pilot's failure to maintain control during taxi. A contributing factor was the gusty winds.NTSB CEN09LA173Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Pueblo, COThe pilot's improper flare and recovery from a bounced landing.NTSB CEN09LA171Accident · No injuriesLimited investigationFinal reportPiper PA-28C-235 · Falcon, COA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management.NTSB CEN09LA165Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Steamboat Springs, COThe pilot's failure to apply brakes in a timely manner while landing on a snow-packed, ice-covered runway, and his delay in executing a go-around.NTSB CEN09IA153Incident · No injuriesIncident investigationFinal reportNew Piper PA-46-500T · Aspen, COThe pilot's inability to maintain directional control of the airplane during landing for undetermined reasons.NTSB 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.NTSB CEN09LA207Accident · No injuriesLimited investigationFinal reportHall Steven C Lancair LE · Longmont, COThe pilot's failure to maintain aircraft pitch control resulting in the airplane impacting the terrain. Contributing to the accident were the pilot's failure to ensure the canopy was fully locked prior to takeoff and the canopy oscillations in flight.NTSB CEN09CA159Accident · Serious injuriesData collectionFinal reportCameron Balloons US V-90 · La Junta, COThe pilot's failure to maintain a safe rate of descent during landing. Contributing to the accident was the strong surface winds.NTSB CEN09FA135Accident · 3 fatalField investigationFinal reportGulfstream Aerospace Commander · Wray, COThe pilot’s failure to maintain aircraft control during the approach resulting in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s improper preflight planning and conditions conducive for structural icing.NTSB CEN09FA126Accident · 2 fatalField investigationFinal reportPilatus PC-12/45 · Hayden, COThe pilot's loss of control due to snow/ice contamination on the airplane's lifting surfaces as a result of his decision not to deice the airplane before departure.