NTSB investigations, 1992, 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\") = 1992
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") = 1992 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 DEN93LA020Accident · No injuriesLimited investigationFinal reportBeech 58 · Ft Collins, COFailure by the pilot to follow IFR procedures in not executing a missed approach when he arrived at the runway threshold with improper alignment and improper descent rate for landing. A factor was: marginal weather conditions.NTSB DEN93FA021Accident · 3 fatalField investigationFinal reportCessna 210 · Aurora, COCollision with terrain when the pilot inadvertently flew into fog while conducting a visual approach. Factors were: inaccurate weather evaluation by the pilot and lack of familiarity with the geographic area.NTSB DEN93LA018Accident · No injuriesLimited investigationFinal reportCessna 172E · Ramah, COA total loss of engine power due to mechanical failure of the number one connecting rod. A factor was: a forced landing onto unsuitable terrain.NTSB DEN93FA017Accident · 1 fatalField investigationFinal reportRockwell 690C · Golden, COThe pilot flying the aircraft beyond the design maneuvering speed and exceeding the design stress limits. A factor was: clear air turbulence.NTSB DEN93LA016Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Boulder, COThe pilot's failure to evaluate changing weather conditions.NTSB DEN93FA015Accident · No injuriesField investigationFinal reportDouglas DC-8-52 · Denver, COAn encounter with severe clear air turbulence.NTSB DEN93LA014Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Boulder, COUndetermined.NTSB DEN93LA013Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-25 · Broomfield, COA failure by FBO personnel to properly connect the nose wheel torque link after towing the aircraft.NTSB DEN93FA012Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300T · Kersey, COInadvertent stall and loss of control due to structural icing. Factors were: icing conditions, and flight into known adverse weather.NTSB DEN93LA010Accident · No injuriesLimited investigationFinal reportCessna 310Q · Englewood, COUndetermined.NTSB DEN93LA011Accident · No injuriesLimited investigationFinal reportBeech 1900C · Denver, COThe ramp agent misjudging the clearance between the airplane and gpu. A factor was: unavailability of proper ground assistance.NTSB DEN93FA009Accident · 3 fatalField investigationFinal reportPiper PA-42 · Grand Junction, COImproper IFR procedure and resultant disorientation which resulted in a collision with terrain.NTSB DEN93LA007Accident · 1 fatalLimited investigationFinal reportMarcy Kitfox IV · Longmont, COAn inadvertent stall. A factor was: the pilot's lack of familiarity with the airplane.NTSB DEN93FA008Accident · 1 fatalField investigationFinal reportCessna 172P · Woody Creek, COAircraft climb performance exceeded. Factors were: the pilot's lack of experience in mountain flying, and the high density altitude conditions.NTSB DEN93LA019Accident · No injuriesLimited investigationFinal reportCessna 172 · Colorado Spring, COProper descent rate was not maintained by the pilot in command which resulted in a hard landing.NTSB DEN93LA006Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Grand Junction, COFatigue failure of the nose landing gear upper drag strut bracket due to fatigue cracking.NTSB DEN93IA005Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Denver, COAn inadvertent attempt, by unknown persons, to start the APU which had been placarded as inoperative. Factors were: inadequate procedures in rendering the APU incapable of being started when inoperative.NTSB DEN93LA002Accident · No injuriesLimited investigationFinal reportCessna 172N · Englewood, COFailure of the pilot in command to maintain directional control during landing roll. A factor was excessive airspeed during landing.NTSB DEN93LA001Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Steamboat Sprgs, COThe pilot's selection of an unsuitable landing area when a suitable forced landing area was available. A factor was: fuel starvation for unknown reasons.NTSB DEN92LA094Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Collins, COThe pilot's failure to maintain directional control of the airplane. A factor was: crosswind.NTSB DEN92LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Craig, COThe pilot's failure to maintain directional control.NTSB DEN92LA095Accident · Serious injuriesLimited investigationFinal reportCameron V-77 · Littleton, COUndetermined.NTSB DEN92LA092Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Greeley, COTotal loss of engine power due to a deteriorated carburetor float which resulted in engine flooding. A factor was: unsuitable terrain for a forced landing.NTSB DEN92FA091Accident · 2 fatalField investigationFinal reportBeech E-55 · Steamboat Sprin, COThe pilot becoming spatially disoriented and losing control of the airplane. Factors were: the pilot's disregard of the preflight weather briefing, his intentional VFR flight into instrument meteorological conditions, his lack of recent instrument time, and…NTSB DEN92LA090Accident · No injuriesLimited investigationFinal reportCessna A188 · Burlington, COFractured connecting rod. A factor was: the lack of suitable terrain for the forced landing.NTSB DEN92FA089Accident · Serious injuriesField investigationFinal reportBell 206L3 · Bayfield, COFailure of the pilot-in-command to properly use the helicopter's performance data. Factors which contributed to the accident were: the adverse terrain and high density altitude.NTSB DEN92FA088Accident · 4 fatalField investigationFinal reportCessna 175A · Pagosa Springs, COThe pilot experiencing spatial disorientation and his failure to maintain aircraft control. Factors were: the pilot's total lack of instrument experience and dark night conditions.NTSB DEN92LA086Accident · No injuriesLimited investigationFinal reportCessna 182Q · Crested Butte, COThe pilot's selection of the wrong runway for landing, and the use of a flap setting less than a landing flap configuration.NTSB DEN92FA085Accident · 3 fatalField investigationFinal reportPiper PA-32-301T · Kit Carson, COThe pilot becoming spatially disoriented and exceeding the design stress limits of the aircraft. Factors were: the pilot's failure to obtain a weather briefing, his attempted VFR flight into a level six thunderstorm, and his lack of instrument time.NTSB DEN92LA084Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Littleton, COInadvertent stall during final approach to landing.NTSB DEN92LA082Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Del Norte, COInadvertent stall while maneuvering during aerial application at an altitude insufficient for recovery.NTSB DEN92FA081Accident · No injuriesField investigationFinal reportCessna 402A · Holyoke, COFailure of the pilot to feather the failed engine propeller. A factor was: power loss for undetermined reasons.NTSB DEN92LA080Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Karval, COAn engine failure due to improper maintenance installation. A factor was: lack of suitable terrain for the forced landing.NTSB DEN92LA079Accident · No injuriesLimited investigationFinal reportRobert D. Waldron Kitfox III · Fort Collins, COLoss of control which resulted in dragging a wing tip during flare for landing which ended with a ground loop. A factor was: a tail wind.NTSB DEN92LA075Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200R · Nederland, COA partial loss of power for undetermined reasons. A factor was: no suitable terrain for a forced landing.NTSB DEN92FA077Accident · 1 fatalField investigationFinal reportCessna 172RG · Fairplay, COThe flight instructor's operation at an altitude insufficient to clear obstacles in rising mountainous terrain. Factors were: high density altitude, diversion of the instructor's attention, and the rising terrain.NTSB DEN92IA074Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120 RT · Denver, COOpen air ground circuit breakers that allowed the propellers to overspeed. A factor was: clear air turbulence.NTSB DEN92LA073Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Ft. Collins, COImproper rate of descent and lack of flare while conducting a forced landing. Factors were: partial power loss due to stuck exhaust valves caused by engine overheat from improper leaning.NTSB DEN92IA072Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Lamar, COFractured nose landing gear bolt due to fatigue.NTSB DEN92LA071Accident · No injuriesLimited investigationFinal reportCessna 170 · Franktown, COThe pilot misjudged initiation of the go-around following a balked landing. A factor was: high density altitude.NTSB DEN92LA068Accident · No injuriesLimited investigationFinal reportCessna 172P · Broomfield, COFailure by the pilot to maintain directional control.NTSB DEN92LA065Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300 · Leadville, COThe pilot's failure to compensate for wind conditions and maintain directional control. Factors included: the pilot allowing the airplane to lift off prematurely, and gusty crosswinds.NTSB DEN92LA066Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Glade Park, COThe pilot delayed initiation of the go around. A factor was: high density altitude.NTSB DEN92LA063Accident · No injuriesLimited investigationFinal reportFairchild 24W-46 · Brighton, COThe pilot's inadequate visual lookout.NTSB DEN92LA062Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Rocky Ford, COThe pilots failure to maintain altitude due to spatial disorientation. Factors were: low overcast skies and ground fog.NTSB DEN92LA061Accident · Serious injuriesLimited investigationFinal reportStinson 108-1 · Falcon, COInadvertent stall during initial climb following takeoff.NTSB DEN92LA059Accident · No injuriesLimited investigationFinal reportCessna 177RG · Gunnison, COThe pilot's failure to maintain directional control. Factor(s) included: fuel exhaustion and the misjudging of fuel consumption calculations.NTSB DEN92LA058Accident · No injuriesLimited investigationFinal reportCessna 185 · Durango, COImproper use of brakes. Factors were: poorly planned approach and excessive landing speed.NTSB DEN92LA057Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Englewood, COAirplane climb capability exceeded and an inadvertent pilot induced stall. Factors were: weight and balance exceeded, high density altitude, and improper use of the mixture control.NTSB DEN92LA056Accident · No injuriesLimited investigationFinal reportNorth American Harvard MK-II · Watkins, COThe pilot inadvertently stalling the airplane. Factors included: the pilot's failure to maintain directional control on takeoff, and inadequate airspeed.