NTSB investigations, 1997, CO
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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
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\") = 1997
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") = 1997 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 FTW98LA079Accident · Minor injuriesLimited investigationFinal reportBeech 35-B33 · Englewood, COThe pilot's improper decision to land in wind conditions that exceeded the airplane's crosswind component, and his failure to divert to an alternate airport with runways more nearly aligned with the wind. Factors were the icy runway and crosswind.NTSB FTW98FA074Accident · 2 fatalField investigationFinal reportBeech A100 · Colo Springs, COFailure of the pilot to follow IFR Procedures and maintain the minimum descent altitude (MDA). A related factor was fog.NTSB FTW98FA073Accident · 1 fatalField investigationFinal reportSwearingen SA226-T · Byers, COThe pilot inadvertently stalling the airplane and his subsequent spatial disorientation which prevented him from maintaining airplane control. Factors were excessive workload on the pilot and the dark night light conditions.NTSB FTW98FA068Accident · 4 fatalField investigationFinal reportBell 407 · Littleton, COThe pilot's inability to maintain adequate visual lookout due to the lighting conditions and his failure to follow company procedures for departure from a landing zone. Factors were dark night conditions, bright lights in the landing zone which prevented…NTSB FTW98LA066Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Fruita, COThe total loss of engine power for undetermined reasons .NTSB FTW98LA061Accident · No injuriesLimited investigationFinal reportCessna 172N · Watkins, COloss of engine power for undertermined reason(s).NTSB FTW98LA046Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Broomfield, COthe pilot's failure to maintain directional control of the airplane during the takeoff roll, due to inadvertently stepping on the brake. A related factor was the pilot's excessive use of rudder for steering.NTSB DCA98MA002Accident · 9 fatalMajor investigationFinal reportCessna 208B · Montrose, COthe pilot's failure to maintain sufficient airspeed for undetermined reasons while maneuvering the airplane near the maximum gross weight and aft cg in or near instrument meteorological conditions, resulting in the loss of control and entry into a stall/spin.…NTSB FTW98LA003Accident · No injuriesLimited investigationFinal reportCessna 172A · Grand Junction, COEncounter with high gusting winds while standing with the engine runningNTSB FTW98FA001Accident · Serious injuriesField investigationFinal reportBoeing 727-51C · Denver, COFailure of the bus driver to yield the right of way to oncoming traffic due to his inadequate visual lookout. Factors were visibility restrictions, inadequate driver training by management, and the flight crew's inadequate visual lookout due to their…NTSB FTW97LA357Accident · No injuriesLimited investigationFinal reportMooney M20M · Broomfield, COThe pilot's flaring of the airplane prematurely at a low airspeed that resulted in a hard landing, and an inadvertent stall during the attempted go-around and subsequent loss of control.NTSB FTW97LA368Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Englewood, COfailure of the right main landing gear due to multiple fatigue cracks.NTSB FTW97FA348Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Telluride, COfailure of the pilot to maintain adequate airspeed, while climbing after takeoff, which resulted in an inadvertent stall/spin and collision with terrain. Factors relating to the accident included: the pilot allowing the maximum gross weight limit of the…NTSB FTW97FA340Accident · 3 fatalField investigationFinal reportCessna 182N · Montrose, COInadequate preflight and in-flight planning, preparation and decision making. A related factor was the improper use of flaps.NTSB FTW97LA338Accident · No injuriesLimited investigationFinal reportBeech V35B · Saguache, CO**This report was modified on 2/23/2016. Please see the public docket for this accident for additional information.** the loss of engine power during cruise for undetermined reasons and the unsuitable terrain encountered by the pilot during the forced…NTSB FTW97LA324Accident · No injuriesLimited investigationFinal reportCessna 182A · Delta, COFailure by the pilot to properly plan for the flight in that the fuel aboard was insufficient for the planned flight. Factors were: inaccurate fuel gauges and terrain condition for the forced landing.NTSB FTW97LA320Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Hayden, COThe pilot in command's inadequate visual lookout.NTSB FTW97LA319Accident · No injuriesLimited investigationFinal reportBell 47G-3B-2 · Montrose, COfailure of the flight instructor (CFI) to properly supervise the flight and ensure that adequate rotor rpm was maintainted during the autorotation/landing. The high density altitude was a related factor.NTSB FTW97LA312Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Longmont, COThe pilot in command's failure to maintain directional control of the aircraft, resulting in an inadvertent ground loop.NTSB FTW97LA308Accident · No injuriesLimited investigationFinal reportCessna 182P · Arriba, COfailure of the pilot to properly plan the flight and determine the field conditions before landing. The soft runway condition was a related factor.NTSB FTW97LA307Accident · Serious injuriesLimited investigationFinal reportCessna T210 · Eagle, COwater contamination of the fuel, which led to a total loss of engine power and a forced landing. Factors relating to the accident were: the delay in refueling the aircraft by the FBO, which allowed condensation to form in the fuel tanks, and inadequate…NTSB FTW97LA306Accident · No injuriesLimited investigationFinal reportCessna 305A (L-19) · Aspen, COFailure of the pilot to maintain direction control of the aircraft during landing roll, which resulted in a ground swerve and subsequent collapse of the right main landing gear. A related factor was the pilot's lack of experience in the make and model of…NTSB FTW97FA299Accident · 2 fatalField investigationFinal reportBeech 58P · Colorado Spring, COfailure of the pilot to follow IFR procedures; and his failure to maintain proper altitude, while executing a missed approach from an attempted ILS approach. Related factors included: low ceiling, rain, fog, the pilot's overconfidence in his personal ability,…NTSB FTW97LA298Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Castle Rock, COA partial loss of engine power due to a cylinder exhaust valve jammed in the open position from excessive carbon deposits. A factor was the lack of suitable terrain on which to make a forced landing.NTSB FTW97LA297Accident · Serious injuriesLimited investigationFinal reportBeech F33A · Creede, COThe pilot's intentional low altitude flight over mountainous terrain, inadequate altitude to clear surrounding obstacles, and his misjudging vertical clearance. A factor was the pilot's use of an inappropriate chart for navigation.NTSB FTW97FA295Accident · 2 fatalField investigationFinal reportLancair 320 · Dillon, COthe pilot's inadequate preflight planning/preparation, VFR flight into instrument meteorological conditions (IMC) conditions, and failure to maintain sufficient altitude/clearance from terrain. Factors relating to the accident were: low ceiling, rain, and…NTSB FTW97LA283Accident · No injuriesLimited investigationFinal reportWonder RV-6 · Franktown, COthe pilot's failure to maintain control of the aircraft during landing roll. A factor was the uneven runway surface.NTSB FTW97FA280Accident · Serious injuriesField investigationFinal reportCessna 150D · Fort Collins, COInadequate preflight planning by loading the aircraft over the maximum certificated gross weight, failure to follow procedures and directives by using flaps for takeoff and failing to properly lean the engine for optimum power, and stalling the aircraft.…NTSB FTW97LA273Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Englewood, COInaccurate compensation for wind conditions and improper recovery from a bounced landing by the CFI pilot in command. A factor was a crosswind.NTSB FTW97LA267Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Denver, COinadequate visual lookout by the bus driver. Factors relating to the accident were: darkness and bright background lighting.NTSB FTW97FA262Accident · 4 fatalField investigationFinal reportRyan Navion B · Garfield, COfailure of the pilot to maintain adequate airspeed, during a turn to reverse direction, which resulted in a stall and collision with a pole and a building. High density altiitude was a related factor.NTSB FTW97LA256Accident · Minor injuriesLimited investigationFinal reportLet Blanik L-13 · Pagosa Springs, COThe pilot's improper inflight planning in that he allowed the glider to descend to too low an altitude and stray too far from the airport, exceeding the aircraft's glide capabilities. A factor was his failure to utilize maximum braking action.NTSB FTW97LA239Accident · No injuriesLimited investigationFinal reportCessna 210 · Peyton, COFailure of both pilots to assure the landing gear was down and locked.NTSB FTW97LA238Accident · No injuriesLimited investigationFinal reportCessna 305A · Watkins, COThe pilot inadvertently stalling the airplane at an altitude insufficient for a safe recovery. A factor was the tailwind.NTSB FTW97LA237Accident · Serious injuriesLimited investigationFinal reportRans S-12 Airaile S-12 · Fort Collins, COAttempt by the pilot to fly the aircraft with the center of gravity out of limits. A factor was a disconnected lift strut support cable.NTSB FTW97LA236Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Leadville, COan attempt by the pilot to fly the aircraft over mountainous terrain in a regime that was beyond its climb performance limit. High density altitude was a related factor.NTSB FTW97FA229Accident · 1 fatalField investigationFinal reportAir Tractor AT-301 · Las Animas, COin-flight collision with terrain, while maneuvering, for undetermined reason(s).NTSB FTW97LA230Accident · No injuriesLimited investigationFinal reportPiper PA-32-300T · Del Norte, COThe pilot's failure to attain proper runway alignment. Factors were his attention being diverted by a rough running engine because the fuel injectors were partially blocked.NTSB FTW97LA217Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Weston, COthe pilot's improper in-flight planning/decision and failure to maintain adequate altitude and/or clearance from rising mountainous/hilly terrain. The unfavorable wind condition and low airspeed were related factors.NTSB FTW97LA210Accident · No injuriesLimited investigationFinal reportBeech 60 · Pueblo, COloss of power in the right engine and failure of the right propeller to feather for undetermined reasons. A factor relating to the accident was: the pilot's failure or inability to align the airplane with the runway during the forced landing.NTSB FTW97FA207Accident · 1 fatalField investigationFinal reportCanadair F-86E MK.6 · Broomfield, COInadequate planning and decision making by the pilot in starting the aerobatic maneuver at an insufficient altitude to successfully complete the maneuver.NTSB FTW97LA206Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Greeley, COunlatching of the left outboard engine cowling latches for undetermined reason(s), which allowed the left engine cowling to separate inflight and strike the vertical stabilizer.NTSB FTW97LA202Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Lamar, COFailure of the left magneto and crank shaft idler drive gears. Factors were failure to perform a 100 hour inspection and unsuitable terrain for a forced landing.NTSB FTW97LA205Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Englewood, COfailure of the pilot to maintain directional control of the airplane during the landing roll. The gusty crosswind condition was a related factor.NTSB FTW97LA192Accident · No injuriesLimited investigationFinal reportPiper PA-28R-210T · Fort Collins, COthe pilot's failure to know and follow the emergency procedure for extending the landing gear after loss of electrical power. Factors relating to the accident were: an inoperative alternator, inadequate maintenance by the operator, a depleted battery, and…NTSB FTW97LA189Accident · No injuriesLimited investigationFinal reportTownsend Kitfox · Greeley, COThe engine manufacturer's inadequate quality control by failing to install the harmonic balancer, causing the engine to fail catastrophically. A factor was the lack of suitable terrain on which to make a forced landing.NTSB FTW97LA188Accident · No injuriesLimited investigationFinal reportAeromot AMT-200 · Longmont, COthe dual student pilot's improper landing flare and the flight instructor's inadequate supervision of the flight.NTSB FTW97LA177Accident · Serious injuriesLimited investigationFinal reportBoeing 737-201 · Denver, COThe flight attendant's failure to assure that the jetway was placed in the proper position prior to opening the forward cabin entry door.NTSB FTW97FA174Accident · 2 fatalField investigationFinal reportBeech V35 · Lake George, COThe pilot-in-command's failure to maintain control of the airplane. A factor was the terrain-induced turbulence.NTSB FTW97LA172Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Canon City, COThe pilot's failure to maintain an adequate visual lookout. A factor was the pilot's attention being diverted.