NTSB investigations, 2000, CO
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 2000
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") = 2000 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 DEN01LA035Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Longmont, COthe pilot's failure to mantain directional control during landing roll.NTSB DEN01LA034Accident · No injuriesLimited investigationFinal reportBarackman Vans RV-6 · Springfield, COTotal failure of the right hand flap control rod due to construction procedures/directives not being followed by the builder.NTSB DEN01LA032Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-60 · Aspen, COA hard landing which exceeded the design stress limits of the aircraft.NTSB DEN01LA024Accident · No injuriesLimited investigationFinal reportCessna 172P · Leadville, COthe student pilot's failure to maintain directional control during landing roll. A contributing factor was the snow bank next to the runway.NTSB DEN01LA031Accident · No injuriesLimited investigationFinal reportCessna R182 · Broomfield, COthe flight instructor's inadequate supervision of the dual student, which resulted in a hard landing. Contributing factors were the dual student flaring the airplane prematurely, resulting in an inadvertent stall/mush.NTSB DEN01LA022Accident · No injuriesLimited investigationFinal reportCessna 210C · Boulder, COTotal loss of engine power due to fuel contamination (water), and failure of the pilot to have the airplane completely refueled. A factor was unsuitable terrain on which to make a forced landing.NTSB DEN01TA019Accident · No injuriesFinal reportHughes 369D · Montrose, COthe foreign object damage to a main rotor blade, while maneuvering.NTSB DEN01LA025Accident · No injuriesLimited investigationFinal reportCessna 320C · Englewood, COthe failure of the nose landing gear to fully extend due to a bent extension rod.NTSB DEN01LA017Accident · 1 fatalLimited investigationFinal report2000 McCoy Genesis · Fort Collins, COFailure of an airframe stringer due to improper construction by the builder/pilot which rendered the aircraft uncontrollable. A factor was failure by the builder pilot to follow procedures and secure the engine prior to deploying the aircraft recovery…NTSB DEN01LA014Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Longmont, COthe total failure of the left main gear strut during the landing roll. A contributing factor was the 6-foot high snow bank that the airplane impacted when it left the runway.NTSB DEN01LA012Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Mesa Verde, COThe manufacturer's use of improper materials, and inadequate quality control of the tail rotor blades during the manufacturing process, which resulted in fatigue failure of the blade.NTSB DEN01LA009Accident · No injuriesLimited investigationFinal reportGrumman American AA-1A · Greeley, COCarburetor ice formation due to the pilot's improper use of the carburetor heat control. Factors were the fence and fence post.NTSB DEN01LA007Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Fort Collins, COFailure by the pilot to follow instrument approach procedures and execute a missed approach when the runway environment was not in sight at decision height. A factor was low ceiling.NTSB DEN01LA023Accident · No injuriesLimited investigationFinal reportCessna 310N · Montrose, COthe pilot's inadequate airspeed on final approach which resulted in a hard landing. A contributing factor was wind shear.NTSB DEN00FA182Accident · 1 fatalField investigationFinal reportSukhoi SU-26MX · Telluride, COthe pilot's failure to maintain aircraft control while maneuvering, and the subsequent inadvertent stall/spin to the ground. A contributing factor was the high density altitude weather condition.NTSB DEN00LA180Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Erie, COInadequate supervision by the certified flight instructor. Factors were loss of control by the student pilot, the flight instructor's failure to properly monitor the student pilot's rate of descent on final approach, and the flight instructor's lack of recent…NTSB DEN01LA005Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Grand Junction, COTotal failure of the right forward inboard landing gear door hinge pin for undetermined reasons.NTSB DEN00LA178Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Broomfield, COThe pilot's failure to maintain adequate clearance from a vehicle parked beside the ramp while he was taxiing the aircraft from landing.NTSB DEN00LA177Accident · No injuriesLimited investigationFinal reportCessna 340 · Broomfield, COThe pilot landing the aircraft hard exceeding the design stress limits. Factors were: Low ceiling, freezing rain, dark night, excessive descent rate, and improper glide path.NTSB DEN00LA172Accident · No injuriesLimited investigationFinal reportBoeing Stearman D75N1 · Englewood, COthe flight instructor not maintaining supervision. Contributing factors were the student's hard landing due to excessive flare and subsequent inadvertent stall, and the student's failure to maintain directional control during landing roll.NTSB DEN00FA175Accident · 2 fatalField investigationFinal reportBeech S35 · Longmont, COThe pilot/passenger's failure to maintain aircraft control, and the pilot in command's inadequate supervision of the flight. A factor was the pilot/passenger's lack of experience in aircraft type.NTSB DEN00LA173Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Collbran, COThe pilot's failure to maintain directional control during the landing flare and roll. Factors were the tree and fences.NTSB DEN00FA169Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Englewood, COthe pilot's failure to maintain aircraft control, which resulted in a collision with terrain. A contributing factor was the high-density altitude weather condition.NTSB DEN00LA167Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Aurora, COThe unsuitable terrain for a forced landing. Contributing factors were the total loss of engine power due to the failure of the engine oil pump and the dark night light conditions.NTSB DEN00FA164Accident · 2 fatalField investigationFinal reportNorth American SNJ-5 · Steamboat Spg, COthe pilot's inadvertent entry into a spin while performing aerobatics.NTSB DEN00LA158Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Broomfield, COthe pilot's failure to maintain directional control during landing roll. A contributing factor was the crosswind.NTSB DEN00LA155Accident · Serious injuriesLimited investigationFinal reportTrammell Avid Flyer · Trinidad, COthe failure of wing lift strut attachment rod for an unknown reason, which resulted in a loss of aircraft control during initial takeoff climb.NTSB DEN01LA026Accident · No injuriesLimited investigationFinal reportSukhoi SU-29 · Longmont, COThe inadequate structural materials (American manufactured verses original Russian materials) used during a major repair.NTSB DEN00LA151Accident · No injuriesLimited investigationFinal reportCessna 310D · Watkins, COThe pilot's failure to follow procedures and lower the landing gear prior to landing. Factors were diverted attention and aural perception.NTSB DEN00LA150Accident · No injuriesLimited investigationFinal reportAerostar S-66A · Edwards, COLack of crew coordination when the ground crew failed to hold the balloon in position following landing as the pilot expected them to do. A factor was power lines.NTSB DEN00LA147Accident · Minor injuriesLimited investigationFinal reportFisher Glastar GS-1 · Berthoud, COThe pilot's failure to maintain obstacle clearance during takeoff. A factor was the irrigation equipment.NTSB DEN00LA146Accident · Serious injuriesLimited investigationFinal reportAerostar S-77A · Steamboat Spgs, COThe pilot's failure to maintain clearance from a bush during the balloon landing.NTSB DEN00LA142Accident · No injuriesLimited investigationFinal reportMooney M20E · Canon City, COThe pilot's failure to extend the landing gear, which resulted in a wheels up landing.NTSB DEN00LA139Accident · No injuriesLimited investigationFinal reportFudold Avid - Magnum · Walden, COThe pilot's inadvertent stall/mush during a go-around attempt. A contributing factor was the high density altitude weather condition.NTSB DEN00LA153Accident · No injuriesLimited investigationFinal reportMooney M20C · Erie, COFailure by the pilot to follow procedures and lower the landing gear.NTSB DEN00LA138Accident · No injuriesLimited investigationFinal reportCessna 182P · Broomfield, COThe pilot's inaccurate recovery from a bounced landing. Factors were lack of total pilot experience and lack of pilot experience in aircraft make and model.NTSB DEN00LA137Accident · No injuriesLimited investigationFinal reportMooney M20C · Longmont, COThe pilot's improper fuel tank selector position resulting in fuel starvation and the ditch impacted during the landing roll. A contributing factor was the pilot's failure to follow published procedures and directives.NTSB DEN00LA134Accident · Serious injuriesLimited investigationFinal reportCessna 310D · Pagosa Springs, COThe pilot inadvertently stalling the airplane. Factors were the pilot's failure to use the entire available runway, the high density altitude weather condition, and a partial loss of power on one engine due to a burned exhaust valve.NTSB DEN00LA126Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Erie, COAircraft control was not possible by the flight instructor due to the inadequate maintenance adjustment of the tail wheel steering system by maintenance personnel. Factors were the inadequate aircraft preflight by the second pilot who was receiving a…NTSB DEN00LA125Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Montrose, COAn inadvertent stall/mush. Factors were high density altitude, weight and balance exceeded, and pilot fatigue.NTSB DEN00FA127Accident · 4 fatalField investigationFinal reportCessna 195 · Aspen, COthe pilot's poor in-flight decision to fly up a valley with rapidly rising terrain, which resulted in the airplane colliding with the terrain due to its climb performance being exceeded. A contributing factors was the high, rapidly rising, mountainous terrain.NTSB DEN00LA122Accident · 1 fatalLimited investigationFinal reportRowley P-40F · Peyton, COthe pilot's inadequate decision to turn back (low altitude) towards the runway for a forced landing. A contributing factor was the total loss of engine power due to a reduction gear failure.NTSB DEN00LA129Accident · No injuriesLimited investigationFinal reportCessna 172N · Durango, COThe pilot prematurely flaring the airplane for landing, resulting in a hard landing, followed by an inadvertent pilot-induced porpoise and loss of directional control. A factor was the fence.NTSB DEN00FA118Accident · 1 fatalField investigationFinal reportCessna 152 · Karval, COthe pilot's failure to maintain aircraft control while maneuvering. Contributing factors were the pilot's inadvertent flight into the clouds, and his becoming spatially disorientated.NTSB DEN00LA116Accident · No injuriesLimited investigationFinal reportCessna 310C · Erie, COA sudden and unexpected encounter with a downdraft while on final approach. A factor was the transmission wire.NTSB DEN00LA115Accident · No injuriesLimited investigationFinal reportCessna 172K · Orchard, COThe pilot inadvertently stalling the airplane. A factor was his failure to maintain sufficient airspeed.NTSB DEN00LA112Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Loveland, COThe failure of the pilot to maintain directional control during takeoff roll. A factor was lack of recent experience.NTSB DEN00LA108Accident · No injuriesLimited investigationFinal reportPiper PA-44-180T · Englewood, COFailure of the instructor pilot-in-command and the pilot receiving instruction to maintain directional control. Factors were the pilot receiving instruction allowing the airplane to approach low and slow, and failure of the instructor to maintain adequate…NTSB DEN00FA104Accident · 2 fatalField investigationFinal reportCessna P206 · Howard, COThe pilot's failure to maintain aircraft control. A factor was a thunderstorm.NTSB DEN00FA102Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Kiowa, COthe flight instructor's failure to maintain aircraft control while practicing stall maneuvers, which resulted in an inadvertent spin.