NTSB investigations, 1987, CO
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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 | 44 |
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\") = 1987
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") = 1987 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 DEN88FA044Accident · Serious injuriesField investigationFinal reportSwearingen SA-26AT · Telluride, CODuring a visual apch, the plt said he encountered 2000 fpm downdrafts. The plt stated he added power and executed a normal apch at 120 KTS, compensating for downdrafts/crosswinds. After touchdown, the plt said he did not get a beta light on the right eng. He…NTSB DEN88IA043Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-80 · Denver, CODuring landing roll the acft struck a taxiway marker. Visibility was reported by RVR to be 2200. Actual visibility was near zero due to blowing snow. Plt stated he did not lose cntrl but finite cntrl not possible due to lack of visibility and cross winds of…NTSB DEN88LA032Accident · No injuriesLimited investigationFinal reportCessna 180 · Telluride, CODuring a downwind landing, the plt experienced difficulty in controlling his acft. Approximately 2,500 feet from the west end of the rwy the acft ground looped into some rocks and was substantially damaged. The plt stated that he was landing downwind and…NTSB DEN88LA027Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Broomfield, COThe private pilot was flying to build time. After an hour of flight, the plt returned to the home airport and attempted to land. Landing gear would not extend properly and manual gear extension did not help. All gear was partially extended and would not…NTSB DEN88LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260B · Akron, COBfr tkof, snow was melted off the acft in a heated hangar. The flt was bgn in blowing snow with a forecast of ocnl mod icing to 20,000'. The plt said the snow lasted only 5 to 10 min & only a trace of ice (less 1/16 inch) accumulated drg the 1st 15 min of…NTSB DCA88MA004Accident · 28 fatalMajor investigationFinal reportMcdonnell Douglas DC-9-14 · Denver, COThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-88/09. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm…NTSB DEN88DTE02Accident · 1 fatalFinal reportBoeing A75N1 · Keenesburg, COThe commercial ag plt was starting a spray run on a new field. During the first pass, the aircraft struck power line wires. The aircraft rolled left and impacted the terrain in a wings level, nose low attitude. An immediate post crash fire destroyed the…NTSB DEN88LA019Accident · No injuriesLimited investigationFinal reportCessna 152 · Greeley, COThe recently certificated private plt was taxiing his acft to rwy 9 for a night takeoff. Another acft began its takeoff roll on rwy 9. As a courtesy, the taxiing plt switched off his taxi light so as not to blind the other plt. The taxiing plt used the glow…NTSB DEN88FA021Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Durango, COThe two pax had chartered N8266U for a sightseeing flight of the local area. The charter plt, a CFI found that one of the pax was a plt and permitted him to fly the acft. The pax expressed an interest in spotting elk and flew the acft into a canyon, below the…NTSB DEN88LA020Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Monte Vista, COThe plt attempted to take off on a frost-covered, pvt airstrip. Witnesses observed the aircraft become airborne before it settled back down to the ground. Control of the acft was lost and the acft nosed over.NTSB DEN88DTE01Accident · No injuriesFinal reportQuickie Q-200 · Watkins, COThe plt rprtd he failed to lock the aileron reflexers tight for landing. During the landing roll, the lock slipped & the tail lifted off the rwy. Subsequently, the acft veered to the right, went off the rwy & hit a mudhole, then flipped over.NTSB DEN88LA018Accident · No injuriesLimited investigationFinal reportCessna 210 · Greeley, COThe CFI was instructing the private rated plt in simulated forced landings. The plt reported that after a full stop landing, the aircraft would not turn properly to the right, and she suspected brake system failure. The CFI took control and attempted to taxi…NTSB DEN88FA014Accident · 1 fatalField investigationFinal reportCessna 340A · Bailey, COThe aircraft crashed on the side of a mountain during visual meteorological conditions. The pilot had been in voice and radar contact with air traffic control until the aircraft disappeared from radar. The pilot reported severe turbulence and a rough running…NTSB DEN88LA011Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Aspen, COThe plt rprtd that the flt was headed northeast toward mt yeckel when the acft encountered wind shear & downdrafts & was forced into trees. Rprtdly, the acft was flying over rising terrain in a canyon area at an elev of about 11,000' when the acdnt occurred.…NTSB DEN88FA002Accident · Serious injuriesField investigationFinal reportBellanca 7ECA · Fowler, CODuring a pleasure flight the pilot flew too low over the Arkansas river, collided with powerlines and crashed into the river. The pilot stated he could not see well due to the setting sun in his eyes. The pilot and his passenger received serious injuries and…NTSB DEN87LA248Accident · Serious injuriesLimited investigationFinal reportCessna 182F · Colorado City, COThe plt made several circling approaches before landing. When he did land his acft, he said that he landed fast and long. He applied the brakes but went off the end of the rwy, hit an embankment, and nosed over.NTSB DEN87LA249Accident · No injuriesLimited investigationFinal reportCessna 172P · Rangley, COThe student pilot was on his second supervised solo flight and was attempting a second landing on runway 24. The plt stated that the approach was normal and that the acft bounced on touchdown. The plt attempted to correct and the acft banked left. Power was…NTSB DEN87LA247Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B1 · Grand Junction, COThe plt was practicing some helicopter maneuvers in preparation for taking an FAA flt examination. During one of his maneuvers the helicopter's main rotor blades struck the ground causing the acft to crash. A post accident fire errupted and destroyed the…NTSB DEN87LA246Accident · No injuriesLimited investigationFinal reportCessna 150K · Aurora, COThe student plt was flying a long cross country instructional flight. The pilot stated he became disoriented at the first check point and followed highways for the remainder of the four hour flight. The engine quit and the pilot landed in a weed filled field.…NTSB DEN87LA239Accident · Minor injuriesLimited investigationFinal reportCessna 195 · Colorado Sprgs, COThe plt stated that after he lndd to pick up a pax, he engaged the control lock fm habit, but did not shut dwn the eng. He got clnc to taxi back to the rwy & takeoff, but 'forgot to release control lock.' The Cessna 195 has a combination control lock and…NTSB DEN87LA242Accident · No injuriesLimited investigationFinal reportMooney M20K · Aspen, COWhile on a cross country pleasure flt the acft engine failed apx four miles short of the dest aprt. A forced landing was made in a field.NTSB DEN87LA240Accident · No injuriesLimited investigationFinal reportCessna 177B · Fort Collins, CODuring the approach to Fort Collins downtown airport, the pilot reported encountering moderate turbulence. At touchdown on runway 11, a crosswind gust pushed the aircraft off the left side of the runway into the grass. The aircraft bounced and came to a stop…NTSB DEN87LA236Accident · No injuriesLimited investigationFinal reportLet L-13 · Buena Vista, COThe plt was ferrying the glider to Buena Vista, Colorado & had previously obtained permission to land on a closed rwy. After being towed to the Buena Vista area, he released the glider from the tow plane & flew in the local area for about 40 min. He then…NTSB DEN87LA233Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-210 · Yuma, COThe plt said that during his final approach for landing he thought his airspeed was too high for touchdown and he attempted to go around. During the go around his acft struck an arpt sign and a bldg.NTSB DEN87LA232Accident · No injuriesLimited investigationFinal reportNational Balloon 858 · Colorado Spring, COThe commercial balloon plt was competing in a balloon race. While landing, with the basket on the ground, the balloon drifted into power lines. A large hole was burned in the envelope, and the basket was damaged. The plt and two passengers jumped from the…NTSB DEN87DTE05Accident · No injuriesFinal reportPiper PA-25-235 · Center, COThe plt reported that the eng lost power while the acft was en route to spray a field. There was no suitable terrain for a forced landing and the plt landed the aircraft in a soft, cultivated field and nosed over. Examination of the eng revealed burned and…NTSB DEN87DTE04Accident · No injuriesFinal reportCessna A188B · Stonington, COThe plt reported that he had completed an aerial application flt and landed on a road to visit with a customer. He said that the left MLG tire blew out during landing and the acft ground looped. The left MLG collapsed during the ground loop and both wings…NTSB DEN87LA223Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Longmont, COThe plt was attempting to land his rented acft on runway 29 at Longmont municipal airport when the acft touched down, bounced, veered off of the runway, struck a VASI light, and nosed over.NTSB DEN87LA221Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Steamboat Sprin, CON7494J took off from a high alt arpt and climbed in the vic of the arpt to 9500 feet before proceeding on course. Upon approaching high terrain the plt realized he did not have enough alt to clear the terrain and was in a valley too narrow to turn around. He…NTSB DEN87FA219Accident · 3 fatalField investigationFinal reportCessna 182P · Milner, COThe plt was on a flt fm green bay, WI to steamboat spgs (sbs), CO, with stops at sioux city & cheyenne (cys). At 2245, he contacted denver fss, stated he was on final apch to sbs & said the rwy lgts had gone out. He then asked for the freqfor 'putting them…NTSB DEN87FA220Accident · Serious injuriesField investigationFinal reportFairchild PT-23 · Englewood, COThe plt & pax were flying to cheyenne, WY to put N64038 on static display. The plt stated the eng lost pwr drg climb- out at aprx 300' AGL. He was unable to restore pwr & maneuvered for an off arpt landing. A witness stated that after takeoff, N64038 lvld off…NTSB DEN87LA222Accident · No injuriesLimited investigationFinal reportNorth American AT-6C · Colorado Spring, COThe plt reports that he accepted a tailwind for his landing and ground-looped during the roll out.NTSB DEN87LA214Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Greeley, CON8433D was being flown by the plt/owner with an instructor aboard for the purpose of up-dating the owner's flying proficiency. Several successful landings were made, then a wheel landing was initiated. After touchdown, the acft swerved to the left, departed…NTSB DEN87FA213Accident · 1 fatalField investigationFinal reportPiper PA28-140 · Last Chance, COWhile on a cross country flt the plt encountered IFR conditions and was neither trained nor qualified to fly IFR. Attempts by ATC to assist the plt and route the flt to an arpt were unsuccessful. The plt lost control of the acft and crashed in a field, the…NTSB DEN87LA211Accident · No injuriesLimited investigationFinal reportNorth American AT-6A · Englewood, COThe plt does not possess a single engine airplane rating. The plt had a total of 18 hours in the AT-6A. Pilot was departing on a pleasure flt. Witnesses stated that the aircraft appeared to rotate prematurely, climbing at a slow airspeed and a high angle of…NTSB DEN87LA208Accident · No injuriesLimited investigationFinal reportCessna 180 · Broomfield, COPlt was conducting test flt following maint on tailwheel due to shimmy. On final landing acft control was lost at apx 20 KTS due to tailwheel jam. Acft departed side of rwy and left main gear collapsed causing substantial damage to airframe. Tailwheel jam was…NTSB DEN87DTE03Accident · No injuriesFinal reportGrumman-Schweizer G-164A · Springfield, COThe plt rprtd the eng lost pwr drg an aerial application flt & the acft nosed over drg a forced lndg in a soft, wet, terraced fld. There had been hvy rain on the previous day. An investigation revealed the acft had been refueled from a fuel tank mounted on a…NTSB DEN87IA207Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300-B4-203 · Denver, COAs coplt accelerated acft through 128 KTS for takeoff, electrical malfunction occurred resulting in unreliable instrument indications. Capt rejected takeoff. Acft went off end of 12000-FT rwy. Post-incident examination disclosed no. 1 constant speed drive…NTSB DEN87DTE02Accident · No injuriesFinal reportNord Stampe SV4C · Englewood, COThe plt reported that the eng lost power at about 100 ft AGL after takeoff and the forced landing resulted in substantial damage. Examination of the aircraft and engine after the accident did not reveal any evidence of pre-impact failure or deficiency.NTSB DEN87LA204Accident · No injuriesLimited investigationFinal reportBell 47J-2 · Canon City, COThe ATP plt was flying sightseeing rides. There were two adults and two children in the four passenger helicopter. Density altitude was 10000 feet. The acft lost pwr and the plt aborted takeoff and landed. After an eng runup the plt took off again and the…NTSB DEN87LA201Accident · No injuriesLimited investigationFinal reportCessna 152 · Lafayette, COCFI was demonstrating eng out emerg landing and allowed acft to descend into tall weeds before adding power which was insufficient to overcome drag of weeds on gear. Acft struck bank and fence separating prop and right main gear. Hull and cowling were buckled…NTSB DEN87LA197Accident · No injuriesLimited investigationFinal reportCessna 172RG · Aspen, COThe plt said that because of thunderstorm activity in the local area he was distracted from concentrating on his flying. During his landing approach, he failed to extend the landing gear and landed the aircraft wheels up.NTSB DEN87LA198Accident · No injuriesLimited investigationFinal reportCessna 152 · Watkins, COThe plt was practicing touch-and-go landings on rwy 26. He estimated the wind to be 180 deg at 8 KTS. The plt said that on the third landing attempt, a 15 kt gust of wind caused the acft to drift to the right. He attempted to correct with left aileron and…NTSB DEN87LA192Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Romeo, COThe plt reports that the acft encountered a downdraft during the turn around following a swath run. The aircraft began to settle and collided with the ground, bounced, hit a second time and nosed over. The aircraft was loaded with 280 gals of amine and 70…NTSB DEN87LA187Accident · No injuriesLimited investigationFinal reportBeech 58 · Pagosa Springs, COThe plt attempted to land his acft at night at an airport with inoperative runway lights and using a ground vehicle's headlights to aid him in landing. He stated that he touched down his aircraft to the left of the center of the runway and the left landing…NTSB DEN87FA188Accident · 1 fatalField investigationFinal reportCessna 210 · Coaldale, COThe ATP rated pilot was an airline captain on a Boeing 727 aircraft. However, the pilot had accumulated a total of only 140 hours in single engine aircraft with 20 hours in the Cessna 210. Moderate to severe turbulence had been forecast and reported in the…NTSB DEN87FA186Accident · 2 fatalField investigationFinal reportMooney M20E · Vail, COThe pilot proceeded up a box canyon while on a cross-country flight. When unable to out climb terrain, the pilot attempted to reverse direction. During the turn, the aircraft stalled and crashed into trees. The pilot had not received instruction in mountain…NTSB DEN87FA178Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Hayden, COThe plt and two pax were participating in the denver, CO to jackpot, NV air classic. The acft departed, destined for rock springs, WY. The plt was believed by a friend to have been navigating with the use of a recently installed RNAV system. The plt radioed a…NTSB DEN87FA177Accident · Serious injuriesField investigationFinal reportCessna 152II · Parker, COThe instructor plt and his new student were on a local training flt when they encountered adverse wx. The instructor said that he attempted to turn back to the arpt but the winds forced the acft down until it impacted the ground.NTSB DEN87LA171Accident · Minor injuriesLimited investigationFinal reportSocata TB-10 · Cripple Creek, COThis acdt occurred when the plt attempted to takeoff on a 2600 ft long rwy when the density altitude was about 13,500 ft. the acft overran the rwy and collided with a highway. The plt said that the field was too high and too short and it was too hot.