NTSB investigations, 1993, CO
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 | 45 |
Where
Latest 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\") = 1993
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") = 1993 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 FTW94FA052Accident · Serious injuriesField investigationFinal reportPiper PA-23-160 · Franktown, COWas the pilot's disregard of forecast icing conditions and delayed application of carburetor heat, resulting in structural and induction icing. Factors were the icing conditions and unsuitable terrain for a forced landing.NTSB FTW94LA049Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Westcliffe, COWas failure of the number two connecting rod bearing. A factor was unsuitable terrain for a forced landing.NTSB FTW94LA055Accident · No injuriesLimited investigationFinal reportEbershoff Steen Skybolt · Erie, COWas flutter of the flight controls.NTSB FTW94LA040Accident · No injuriesLimited investigationFinal reportCessna A185F · Maybell, COThe pilot's failure to ascertain the condition of the landing area. The snow covered condition of the runway was a factor.NTSB FTW94LA039Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Mancos, COFuel exhaustion induced power loss and the pilot's inadequate preflight inspection, during which he failed to insure that the airplane had been refueled to capacity. A factor was the lack of suitable terrain for a forced landing.NTSB FTW94FA034Accident · Serious injuriesField investigationFinal reportCessna 172N · Fort Collins, COPower loss due to throttle linkage disconnect. Factors were missing cotter key, improper maintenance, and the lack of suitable terrain for the forced landing.NTSB FTW94LA024Accident · No injuriesLimited investigationFinal reportBellanca BL17-31ATC · Pagosa Springs, COFailure by the pilot in command to maintain control of the aircraft during landing roll.NTSB FTW94LA029Accident · No injuriesLimited investigationFinal reportCessna 210 · Monte Vista, COFailure by the pilot in command to follow procedures and directives to lower the landing gear prior to landing.NTSB FTW94LA015Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Pueblo, COA complete, non mechanical failure of the power plant for unknown reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA011Accident · No injuriesLimited investigationFinal reportCessna 172F · Co. Springs, COAn encounter with wake turbulence during the landing flare. A factor was lack of total pilot experience.NTSB FTW94LA002Accident · No injuriesLimited investigationFinal reportMaule M-5-200C · Watkins, COThe pilot's loss of directional control resulting in the inadvertent ground loop. A factor was the instructor's failure to take remedial action on a timely manner.NTSB FTW93LA258Accident · No injuriesLimited investigationFinal reportCessna 180 · Watkins, COThe pilot's improper compensation for shifting winds.NTSB FTW93LA272Accident · 1 fatalLimited investigationFinal reportCoen Benson B8 · Aurora, COFatigue failure of the center engine mount that altered the thrust and lift vectors.NTSB DEN93LA106Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Palisade, COPartial power loss during approach for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB DEN93LA104Accident · No injuriesLimited investigationFinal reportCessna 152 · Carr, COFailure of the pilot in command to maintain directional control of the aircraft during landing roll. Factors were the pilot disregarding the tailwind, and rough and uneven terrain off the side of the runway.NTSB DEN93FA101Accident · Serious injuriesField investigationFinal reportThunder and Colt 240A · Woody Creek, COAn inflight encounter with high winds which required a precautionary landing.NTSB DEN93FA100Accident · 6 fatalField investigationFinal reportCameron N-145 · Woody Creek, COFailure by the pilot in command to maintain proper altitude and visual lookout. A factor was high wind.NTSB FTW93LA231Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Salida, COThe climb capability of the airplane being exceeded and the pilot's decision to turn into the rising terrain. A factor was the high density altitude.NTSB DEN93LA098Accident · No injuriesLimited investigationFinal reportBoeing 757-222 · Denver, COThe first officer's improper recovery from a bounced landing. Factors were: the first officer's delayed initiation of the flare, and the captain's improper supervision of the flight.NTSB DEN93LA095Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Pagosa Springs, COThe decision by the pilot in command to fly at an altitude insufficient for the surrounding terrain. Factors were: the pilot's attention being momentarily diverted and the airplane's climb performance being exceeded.NTSB DEN93FA090Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Elk Springs, COThe performance of a stall/spin at an altitude inadequate for recovery and level off.NTSB DEN93LA088Accident · Serious injuriesLimited investigationFinal reportPiper J3C-90 · Meeker, COFailure of the pilot to maintain adequate terrain clearance. A factor was the intentional low pass performed by the pilot in command.NTSB DEN93LA087Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Wray, COThe pilot's inadequate compensation for the wind conditions and improper recovery from a bounced landing. The gusty crosswind was a factor.NTSB DEN93FA089Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Durango, COThe pilot's entry into a box canyon at an altitude insufficient to clear mountainous terrain.NTSB DEN93LA086Accident · Serious injuriesLimited investigationFinal reportBalloon Works 7B-15 · Colorado Sprgs, COThe passenger's failure to assume the proper landing position as instructed by the pilot in command. A factor was: the high wind.NTSB DEN93LA085Accident · Minor injuriesLimited investigationFinal reportLet L-13 · Durango, COThe failure of the tow plane pilot to warn the glider pilot that he was releasing the tow line. A factor was: an inadvertent stall by the pilot in command.NTSB DEN93LA083Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Eagle, COThe pilot's failure to maintain directional control.NTSB DEN93LA080Accident · Minor injuriesLimited investigationFinal reportGlasflugel Standard Libell · Boulder, COImproper rigging of the spoiler system by maintenance personnel, which caused an uncommanded spoiler deployment and prevented spoiler retraction by the pilot. A factor was unsuitable terrain for a forced landingNTSB DEN93LA074Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Grand Junction, COFailure of the pilot in command to follow manual gear extension procedures. A factor was a total electrical failure.NTSB DEN93LA073Accident · No injuriesLimited investigationFinal reportCessna 177 · Akron, COThe pilot's inadequate compensation for wind conditions. Factors were: the pilot's failure to initiate a go around in a more timely manner, and gusty crosswinds.NTSB DEN93LA072Accident · No injuriesLimited investigationFinal reportCessna 150M · Haswell, COFailure of the student pilot to maintain control of the aircraft during landing roll. Factors were: alternator failure, failure of the student pilot to follow procedures and directives, and failure of the student pilot to perform fuel consumption calculations.NTSB DEN93LA070Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Boulder, COA failure by the pilot flying to adequately compensate for wind conditions which led to a loss of tail rotor control. A factor was: inadequate supervision by the pilot in command.NTSB DEN93LA069Accident · 1 fatalLimited investigationFinal reportIrving Siewert Osprey GP-4 · Canon City, COFailure by the pilot/builder to follow construction specifications and the use of improper materials during construction of the aircraft.NTSB DEN93LA071Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Watkins, COTotal loss of power resulting from a blocked carburetor fuel filter. A factor was: soft terrain encountered during the forced landing.NTSB DEN93LA068Accident · No injuriesLimited investigationFinal reportCessna 172N · Livermore, COA partial power loss when the rocker box for one cylinder disengaged. A factor was: unsuitable terrain for a forced landing.NTSB DEN93LA067Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5 · Watkins, COSpatial disorientation which prevented the pilot from maintaining control. A factor was: low ceiling.NTSB DEN93FA066Accident · Minor injuriesField investigationFinal reportCessna 310J · Broomfield, COFriction of escaping oxygen under high pressure igniting a lubricant in the nosewheel well area, and improper aircraft servicing by maintenance personnel.NTSB DEN93LA065Accident · No injuriesLimited investigationFinal reportCessna 182A · Stratton, COThe selection of unsuitable terrain for a precautionary landing by the pilot in command. A factor was: misjudging the deteriorating weather.NTSB DEN93LA064Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Nimbus II · Buena Vista, COFailure to follow procedures and directives when operating the flaps.NTSB DEN93FA063Accident · 2 fatalField investigationFinal reportMooney M20E · Westcliffe, COThe pilot's loss of aircraft control as he attempted to turn away from a line of thunderstorms. Factors were thunderstorms and associated turbulence.NTSB DEN93LA061Accident · No injuriesLimited investigationFinal reportCessna 172N · Buena Vista, COA downdraft and the pilot's failure to maintain directional control of the airplane. Factors were: a crosswind and the inadvertent selection of additional flaps.NTSB DEN93LA060Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Mead, COA failure by the pilot in command to compensate for wind conditions and maintain control of the helicopter. A factor was: unfavorable wind conditions.NTSB DEN93LA062Accident · No injuriesLimited investigationFinal reportSchleicher ASH 25 E · Peyton, COThe encounter with a downdraft.NTSB DEN93LA059Accident · No injuriesLimited investigationFinal reportCessna 305A · Fort Collins, COAn excessive rate of descent resulting in a hard landing.NTSB DEN93LA058Accident · Serious injuriesLimited investigationFinal reportSukhoi SU-29 · Fountain, COFailure of both the pilot in command and the safety pilot to relinquish control of the airplane. A factor was the pilot in command's failure to communicate with the safety pilot.NTSB DEN93LA057Accident · Serious injuriesLimited investigationFinal reportCessna 182N · Durango, COAn inadvertent stall. A factor was: downdrafts and the pilot's continued flight into known adverse weather.NTSB DEN93LA055Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Watkins, COThe student's failure to maintain proper touchdown alignment, and the instructor pilot's inadequate supervision.NTSB DEN93FA054Accident · 1 fatalField investigationFinal reportWitts & Church Worloch · Lucerne, COLoss of control in flight. A factor was: the pilot's lack of experience in the airplane.NTSB DEN93FA052Accident · 2 fatalField investigationFinal reportBeech 58 · Telluride, COFailure of the pilot-in-command to plan and/or assure selection of an altitude/course combination that would provide terrain clearance, and failure of the other (second) pilot to adequately monitor the situation. Darkness, high (mountainous) terrain, and…NTSB DEN93FA049Accident · Minor injuriesField investigationFinal reportMcdonnell Douglas DC-9-82 · Denver, COA vibration in the right main landing gear, for undetermined reasons, which resulted in collapse of the right main gear. A factor was failure of the pilot in command to ensure deployment of the ground spoilers.