NTSB investigations, CO
100 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 7 |
|---|---|
| 1983 | 3 |
| 1984 | 5 |
| 1985 | 7 |
| 1986 | 6 |
| 1987 | 9 |
| 1988 | 2 |
| 1989 | 2 |
| 1990 | 7 |
| 1991 | 3 |
| 1992 | 5 |
| 1993 | 6 |
| 1994 | 3 |
| 1995 | 3 |
| 1996 | 4 |
| 1997 | 2 |
| 1998 | 2 |
| 2000 | 3 |
| 2001 | 7 |
| 2002 | 3 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 5 |
| 2006 | 2 |
| 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\" = 220)
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" = 220) 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 DEN08LA010Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2C10 · Denver, COthe in-flight collision with geese shortly after takeoff.NTSB DEN07CA073Accident · No injuriesData collectionFinal reportAerospatiale SA315B · Norwood, COThe inflight collision with a bird(s).NTSB DEN06FA111Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Salida, COthe pilot's inadequate preflight planning/preparation. Contributing factors in this accident were the pilot's lack of familiarity with the geographical area, his becoming lost/disoriented, his improper decision, the high density altitude, and the reduction in…NTSB DEN06FA043Accident · 3 fatalField investigationFinal reportCessna 182E · Austin, COthe pilot's failure to maintain clearance from the transmission wire resulting in the airplane's outboard wing portion to be severed, and the subsequent loss of control and ground impact. Factors contributing to the accident were the pilot's impairment from…NTSB DEN06FA010Accident · 2 fatalField investigationFinal reportLancair LC-40-550FG · Steamboat Spgns, COthe pilot's failure to maintain altitude/clearance from terrain. Contributing factors include the pilot's lack of recent experience, the pilot's improper in-flight planning and decision making, the dark night and the mountainous terrain.NTSB DEN05CA078Accident · No injuriesData collectionFinal reportBell 47G-5A · Brush, COThe pilot's failure to maintain clearance from the truck trailer during takeoff. A factor contributing to this accident was the truck trailer.NTSB DEN05LA075Accident · No injuriesLimited investigationFinal reportCessna T188C · Fowler, COthe pilot's failure to maintain visual lookout and clearance, resulting in an in-flight collision with transmission lines.NTSB DEN05CA073Accident · Minor injuriesData collectionFinal reportChampion 7ECA · Fort Collins, COthe pilot's inadequate preflight planning/preparation which failed to assure adequate takeoff performance to clear obstacles. Contributing factors included the miscalculated weight and balance and the high density altitude.NTSB DEN05FA124Accident · 2 fatalField investigationFinal reportPiper PA-22-135 · Kremmling, COthe pilot's failure to maintain clearance from terrain.NTSB DEN05IA027Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 · Denver, COthe first officer's failure to maintain proper glide slope during the landing approach, and the captain's failure to adequately monitor the approach and landing, and his failure to challenge and/or intervene when the first officer continued to descend below…NTSB DEN03FA137Accident · 1 fatalField investigationFinal reportCessna 182P · Antonito, COThe pilot's improper in-flight planning/decision and his failure to maintain clearance from the trees. Factors contributing to the accident were the low altitude, the trees, and the mountainous terrain.NTSB DEN03LA018Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28C · Morrison, COthe pilot not maintaining clearance from the telephone lines during landing. Factors contributing to the accident were the pilot not being able to see the telephone lines, the low altitude, and the dark night.NTSB DEN02LA101Accident · Serious injuriesLimited investigationFinal reportBell 206L-III · Canon City, COthe pilot's failure to maintain clearance of a static wire, and the subsequent loss of aircraft control due to the main rotor pitch change tubes being severed.NTSB FTW02LA063Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Durango, COthe pilot's failure to maintain clearance with the trees and mountainous terrain while maneuvering. A contributing factor was the pilot's delay in taking remedial action.NTSB DEN02LA009Accident · No injuriesLimited investigationFinal reportEsbenshade Starduster Too SA300 · Evans, COthe pilot's failure to maintain clearance of the wires. A contributing factor was the trees the airplane struck while the pilot was attempting to regain aircraft control.NTSB DEN02LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Paonia, COimpact with a deer during initial climb immediately following rotation, resulting in the separation of the left main landing gear assembly.NTSB DEN01FA161Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Pagosa Springs, COthe flight crews' intentional low altitude flight, and failure to maintain obstacle clearance.NTSB DEN01LA159Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Watkins, COthe pilot's failure to maintain clearance with the guy wire.NTSB DEN01LA146Accident · Serious injuriesLimited investigationFinal reportCommander 114-B · Snowmass Villag, COThe pilot's failure to maintain altitude/clearance from the rising terrain for undetermined reasons. Contributing factors include high density altitude conditions, and trees.NTSB DEN01FA096Accident · 2 fatalField investigationFinal reportBeech 76 · Gunnison, COintentional buzzing by both pilots and their failure to maintain clearance with transmission wires. A contributing factor was the sun glare.NTSB DEN01LA073Accident · No injuriesLimited investigationFinal reportCessna 340 · Alamosa, COThe in-flight collision with a large bird during downwind approach for landing.NTSB DEN00LA146Accident · Serious injuriesLimited investigationFinal reportAerostar S-77A · Steamboat Spgs, COThe pilot's failure to maintain clearance from a bush during the balloon landing.NTSB DEN00LA116Accident · No injuriesLimited investigationFinal reportCessna 310C · Erie, COA sudden and unexpected encounter with a downdraft while on final approach. A factor was the transmission wire.NTSB DEN00LA108Accident · No injuriesLimited investigationFinal reportPiper PA-44-180T · Englewood, COFailure of the instructor pilot-in-command and the pilot receiving instruction to maintain directional control. Factors were the pilot receiving instruction allowing the airplane to approach low and slow, and failure of the instructor to maintain adequate…NTSB DEN99FA009Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Montrose, COThe pilot's improper inflight planning/decision. Factors were a reduction in the airplane's climb and turn capabilities, the aft c.g. limit being exceeded, and the pilot's lack of familiarity with the geographic area and his lack of experience in the airplane…NTSB FTW98IA208Incident · No injuriesIncident investigationFinal reportBoeing 727-25C · Colorado Sprngs, COAn inadvertent inflight collision with a flock of large birds.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 FTW97LA085Accident · No injuriesLimited investigationFinal reportCessna 172N · Steamboat Spgs, COFailure of the flight instructor and the dual student to maintain an adequate visual lookout. Factors were the flight instructor's inadequate supervision of the flight, inadequate altitude in which to clear obstacles, and the dual student's lack of…NTSB FTW97LA034Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Mancos, COfailure of the pilot to maintain clearance from the windsock, during a hover/pedal-turn after lift-off.NTSB FTW96FA352Accident · 2 fatalField investigationFinal reportGrumman American AA-1B · Boulder, COThe pilot's poor judgment in attempting low altitude flight in mountainous terrain without adequate mountain flying training which led to low altitude maneuvering exceeding the climb capability of the airplane. Factors in the accident were: the pilot's…NTSB FTW96LA290Accident · No injuriesLimited investigationFinal reportCessna 172L · Johnstown, COfailure of the pilot to maintain proper altitude/clearance from obstructions, while buzzing.NTSB FTW96LA238Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Leadville, COInadequate preflight planning and preparation and failure to follow aircraft operating procedures and directives. Factors were high density altitude, inadequate training of the flight instructor and insufficient standards and requirements for flight…NTSB FTW96FA048Accident · 1 fatalField investigationFinal reportBeech A35 · Hudson, COThe pilot's failure to maintain clearance. A factor was improper in-flight planning.NTSB FTW96FA012Accident · 3 fatalField investigationFinal reportCessna 172RG · Bayfield, COThe pilot's failure to maintain adequate terrain clearance. A factor was the pilot diverting attention while looking for game.NTSB FTW95FA231Accident · 1 fatalField investigationFinal reportWeatherly 620B · Flagler, COFailure by the pilot to maintain clearance from the static line of a power transmission array during an aerial application flight.NTSB FTW94FA315Accident · 2 fatalField investigationFinal reportCessna 182K · Heeney, COThe pilot's failure to maintain terrain clearance. A factor was the rising terrain.NTSB FTW94LA142Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Lindon, COInaccurate preflight planning and preparation for the flight. A factor was soft terrain on the landing strip.NTSB FTW94LA092Accident · No injuriesLimited investigationFinal reportRockwell 690C · Hayden, COFailure by the pilot to maintain proper altitude. A factor was dark night conditions.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 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 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 DEN93LA037Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Eckert, COThe pilot-in-command's failure to maintain adequate clearance from the truck during the landing. Factors which contributed to the accident were: the pilot's poor judgement in attempting the operation, and the driver's poor judgement in not vacating all…NTSB DEN93LA035Accident · No injuriesLimited investigationFinal reportPitts S2B · Boulder, COThe pilot in command's failure to maintain a visual lookout. A factor was: the student pilot's restricted visual lookout.NTSB DEN93LA026Accident · No injuriesLimited investigationFinal reportRaven RX7 · Durango, COPartial failure of the balloon's burner for undetermined reasons. A factor was: unfavorable wind.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 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 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 DEN92LA066Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Glade Park, COThe pilot delayed initiation of the go around. A factor was: high density altitude.NTSB DEN92LA053Accident · No injuriesLimited investigationFinal reportCessna R172E · Colorado Spring, COThe pilot did not maintain clearance and the airplane collided with a fence post.NTSB DEN91LA100Accident · Minor injuriesLimited investigationFinal reportAerostar S57-A · Avon, COThe pilot's failure to maintain a visual lookout. A factor was: the pilot's attention being diverted.