NTSB investigations, CO
35 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 1 |
| 1984 | 3 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1996 | 7 |
| 1997 | 2 |
| 1998 | 1 |
| 2000 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 3 |
| 2007 | 2 |
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 c.\"eventStateOrRegion\" = 'CO' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 430)
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 c."eventStateOrRegion" = 'CO' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 430) 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 DEN07CA139Accident · No injuriesData collectionFinal reportCessna A185F · Lake City, COThe pilot's improper preflight planning, his inability to attain short field takeoff performance, and his intentional maneuvering of the airplane into bushes and a fence during the aborted takeoff. Factors contributing to the accident were the high density…NTSB DEN07IA058Incident · No injuriesIncident investigationFinal reportBoeing 737-522 · Denver, COThe snowplow driver's failure to follow procedures/directives by crossing an active runway without clearance, resulting in a runway incursion and near collision with an airplane during its landing roll.NTSB DEN05LA048Accident · Minor injuriesLimited investigationFinal reportBoeing 737-724 · Gunnison, COthe snowplow driver's failure to see the airplane during plowing operations. Factors contributing to the accident were the snowplow driver's excessive speed and the snow.NTSB DEN05IA049Incident · No injuriesIncident investigationFinal reportGulfstream American G-1159A · Englewood, COthe flight crew's misidentification of the parallel taxiway as an active runway, resulting in the flight crew executing a landing on the taxiway. Contributing factors include the airport's inadequate snow removal, the snow-covered runway, the visual illusions…NTSB DEN05IA046Incident · Minor injuriesIncident investigationFinal reportBeech 1900D · Denver, COthe tug driver's failure to maintain operational control of the tug, resulting in impact with an airplane. Contributing factors include the tug driver's improper procedure, the tug driver's inadequate initial ground equipment training, and the…NTSB DEN04IA124Incident · No injuriesIncident investigationFinal reportBoeing 737-500 · Denver, COthe inaccurate radar information due to the failure of the Airport Movement Area Surveillance radar resulting in the tower calling for the airplane to abort the takeoff, subsequently causing tire and brake damage to the airplane.NTSB DEN03IA147Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver, COthe first officer's improper preflight preparation in failing to ensure the cabin airstair door was fully locked and secure. Factors relating to the incident were the cabin airstair door handle not being fully secure and the forward cabin door warning light…NTSB DEN00LA088Accident · No injuriesLimited investigationFinal reportBeech V35B · Erie, COInadvertent cut off of the mixture by the pilot. Factors were: The passenger door opening, the pilot's inexperience in make and model, and rough, uneven terrain in the landing area.NTSB DEN99LA028Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G103 Twin Astir · Canon City, COThe glider pilot's failure to follow proper preflight procedures, and his failure to control the aircraft when the latch opened during flight. A factor was his failure to properly latch the canopy, and to utilize all available runway during the forced landing.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 FTW97LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Hartsel, COThe pilot's misjudging the proper touchdown point on the dirt road due to excessive airspeed and his failure to deploy flaps. Factors were the partial loss of engine lubricating oil due to the oil filler cap separating because some unknown person failed to…NTSB FTW97LA047Accident · No injuriesLimited investigationFinal reportCessna 182E · Alamosa, COaircraft damage for undetermined rteasons.NTSB FTW97LA021Accident · No injuriesLimited investigationFinal reportHughes 369D · Watkins, COThe flight instructor's improper decision to attempt a hovering autorotation during gusty wind conditions. A factor was the gusty wind.NTSB FTW97LA005Accident · No injuriesLimited investigationFinal reportCessna 152 · Colorado Spgs, COthe student pilot attempting to exit the runway onto a taxiway at excessive speed. A factor was the pilot's failure to land the aircraft in the proper touchdown zone.NTSB FTW97IA003Incident · No injuriesIncident investigationFinal reportBeech 1900D · Pueblo, COPartial incapacitation of the flightcrew for unknown reasons.NTSB FTW96IA240Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385-1 · Denver, COphysical impairment of the captain due to a probable cardiac event.NTSB FTW96LA212Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B-15 · Ft. Lupton, COthe pasenger's failure to follow the instructions given by the pilot during a briefing.NTSB FTW96LA172Accident · No injuriesLimited investigationFinal reportCessna 305A · Erie, COentanglement of the tow banner during banner pickup, and subsequent failure or inability to jettison the banner. A factor relating to the accident was: high gusty wind condition.NTSB DEN93IA025Incident · No injuriesIncident investigationFinal reportBoeing 767-222 · Denver, COMedical incapacitation of the first officer.NTSB DEN92IA050Incident · 1 fatalIncident investigationFinal reportBoeing 757-222 · Denver, COThe captain suffered a fatal heart attack.NTSB DEN89LA120Accident · Minor injuriesLimited investigationFinal reportEnstrom 280C · Colorado Spgs, COInadequate compensation for the wind conditions by the pilot. The high density altitude and wind conditions were contributing factors.NTSB DEN88LA201Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Fort Morgan, COThe plt reported that at the time of takeoff, the winds were 'light to moderate from 015 deg at 5 KTS or less.' Shortly after takeoff, the winds increased to 10-15 KTS and the plt decided to land on 'grassy, relatively smooth terrain.' The plt said he…NTSB DEN88IA072Incident · No injuriesIncident investigationFinal reportDe Havilland DH-7 · Denver, COAs rocky mtn airway flt 2129 (De Havilland DH-7, N9058P) & Cessna 441, N1WB, were arriving, there was moderate to hvy traffic & a rwy change was in progress. N1WB & flt 2129 were provided initial sequencing by feeder ctlrs (AR-1 & AR-4). Both flts were handed…NTSB DEN87IA058Incident · 1 fatalIncident investigationFinal reportBeech 58 · Colorado Spring, COThe PIC became unconscious while at the controls during cruise. The co-owner of the acft, a rated pilot who was in the right front seat, took control and diverted to a nearby apt. The PIC was transported to a hospital where he was pronounced doa. An autopsy…NTSB DEN87DTE01Accident · No injuriesFinal reportCassutt Sport Racer · Brighton, COThe plt rprtd that he did not properly lock the canopy & it came open drg flt at 7000 ft MSL. He reduced the speed & attempted to close the canopy, but was not successful. He diverted & attempted to land at the van aire arpt while holding the canopy with his…NTSB DEN85FTM04Accident · No injuriesFinal reportKokes Scorpion 133 · Grand Junction, COA group of plts were preparing for an airshow flyby. As a formation of airplanes were being taxied to rwy 29, the plt of a home built scorpion 133 helicopter, N45877, was cleared to air taxi across rwy 29 & proceed to rwy 22. As the helicopter plt was…NTSB DEN85IA068Incident · No injuriesIncident investigationFinal reportBoeing 737-291 · Steamboat Sprin, COShortly after departure from oakland, capt indicated he did not feel well. During the descent into den, the capt passed out for several minutes. He was revived with oxygen administered by a flt attendant. F/o made landing and capt taxied to the gate. Capt was…NTSB DEN84LA289Accident · Serious injuriesLimited investigationFinal reportRaven AX-8 · Clark, CODuring a normal high wind landing a pax received two fractures of the fibula bone. Another pax reported that the injured pax was standing on one leg with the other knee bent resting on a propane tank during the landing. Pax were reportedly briefed on the…NTSB DEN84LA273Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Littleton, COPlt stated that the entire flt was uneventful. The female passenger had her knees bent in preparation for landing but her body was twisted in a direction that was opposite to her feet when the balloon made ground contact.NTSB DEN84IA116Incident · No injuriesIncident investigationFinal reportBoeing 727-224 · Denver, COPrior to taxiing at chicago, the plt had the ramp agent(r/a) check the rear airstair as the aft airstair light on the second officer's panel was 'on'. The r/a recycled the airstair & reported that it appeared closed. The light remained onso the plt referred…NTSB DEN84IA023Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-32 · Denver, COApproaching from the east there are 4 parallel 'strips' at the arpt. From l to r they are rwy 26L, taxiway 'charlie' rwy 26R & rwy 25. Rwy 26L & taxiway charlie are the same length. All 4 are concrete covered. The flt was cleared to landon rwy 26R. Rwy 26L…NTSB DEN83LA043Accident · Minor injuriesLimited investigationFinal reportBell 206B · 11mi. So.Oftell, COPilot tried to land at 12,500 foot level. In the rotorwash whiteout he lost visual cues and rotor struck the slope because the right landing gear made snow contact.NTSB DEN83LA026Accident · No injuriesLimited investigationFinal reportBoeing 737-291 · Denver, CODuring a "power-back" operation from the terminal gate, a ground signal person and two wing walker were used in accordance with procedures. After reverse thrust was applied and the aircraft was rolling backwards. The signal person communicated an emergency…NTSB DEN83LA031Accident · No injuriesLimited investigationFinal reportPiper PA28-180 · Leadville, COThe aircraft was taking off in snow with wheel pants installed. The pants filled with snow and plane pulled to left. In attempt to recover directional control and get back on the runway the aircraft hit the asphalt ridge on the edge of the runway separating…NTSB DEN82IA049Incident · No injuriesIncident investigationFinal reportGulfstream G159-C · Denver, COOn final approach after a normal flight, the copilot became incapacitated while reading the final approach checklist. The captain continued the approach and made an uneventful landing. After the passengers had deplaned, the copilot suffered a seizure while he…