NTSB investigations, 1981, CO
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 1981
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") = 1981 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 DEN82FA014Accident · Minor injuriesClosedCessna 340A · Pueblo, CONTSB DCA82AA007Accident · 4 fatalClosedPiper PA-31 · Durango, CONTSB DEN82FA013Accident · Serious injuriesClosedCessna T210M · Gunnison, CONTSB DEN82FA012Accident · 3 fatalClosedBeech E55 · Hayden, CONTSB DEN82FTE14Accident · 1 fatalClosedPiper PA-32 · Buena Vista, CONTSB DEN82FTE13Accident · Minor injuriesClosedRand KR-2 · Watkins, CONTSB DEN82FTE12Accident · No injuriesClosedGulf-Amer AA-5A · Longmont, CONTSB DEN82FTE11Accident · Serious injuriesClosedHughes 369D · Leadville, CONTSB DEN82FA010Accident · 1 fatalClosedMooney M-21 · La Veta, CONTSB DEN82FTE10Accident · No injuriesClosedMome II · Longmont, CONTSB DEN82FA008Accident · 7 fatalClosedMitsubishi MU-2B · Eagle, CONTSB DEN81DTE08Accident · No injuriesClosedHiller UH12E · Craig, CONTSB DEN82FTE09Accident · 1 fatalClosedAeronca 7KCAB · Morrison, CONTSB DEN82FTE07Accident · No injuriesClosedAerospatial AS350B · Tarryall, CONTSB DEN82FTE06Accident · No injuriesClosedBell 206B · Colorado Spgs, CONTSB DEN82FTE05Accident · No injuriesClosedPiper PA-28 · Durango, CONTSB DEN82FTE04Accident · No injuriesClosedCessna 182P · Steamboat Spgs, CONTSB DEN81DTE03Accident · No injuriesClosedCessna 180 · Canon City, CONTSB DEN81FTE02Accident · No injuriesClosedBell 206L · Grand Junction, CONTSB DEN82FTE01Accident · No injuriesClosedPiper PA-32 · Akron, CONTSB DEN81FTE73Accident · No injuriesClosedPiper PA-24 · Parker, CONTSB DEN81FTE72Accident · No injuriesClosedCessna 210 · Rifle, CONTSB DEN81FA069Accident · 1 fatalClosedCessna 185 · Collbran, CONTSB DEN81DTE74Accident · No injuriesClosedErco 415-C · Aurora, CONTSB DEN81FTE71Accident · Serious injuriesClosedCaldwell Folker · Broomfield, CONTSB DEN81FTE70Accident · 1 fatalClosedChristen Eagle · Longmont, CONTSB DEN81FTE69Accident · Minor injuriesClosedMooney M20C · Delta, CONTSB DEN81FTE51Accident · No injuriesClosedHiller UHI2D · Craig, CONTSB DEN81FA063Accident · 3 fatalClosedCessna TR182 · 17nne Durango, CONTSB DEN81FTE68Accident · Serious injuriesClosedBell 206B · Rio Blanco, CONTSB DEN81FTE67Accident · Minor injuriesClosedCessna 172RG · Walden, CONTSB DEN81FTE63Accident · Minor injuriesClosedLuscombe 8A · Byers, CONTSB DEN81FTE66Accident · Serious injuriesClosedAeronca 7ECA · Akron, CONTSB DEN81DTE65Accident · Serious injuriesClosedRaven RX-6 · Golden, CONTSB DEN81FTE64Accident · Minor injuriesClosedBeech C24R · Broomfield, CONTSB DEN81FA053Accident · 2 fatalClosedLet Blanik · Aspen, CONTSB DEN81IA052Incident · No injuriesClosedRockwell 690B · Denver, CONTSB DEN81DTE62Accident · No injuriesClosedWeatherly 201B · Beulah, CONTSB DEN81DTE60Accident · No injuriesClosedCessna 172N · Durango, CONTSB DEN81FTE61Accident · No injuriesClosedRand KR-2 · Rocky Ford, CONTSB DEN81FA050Accident · 2 fatalClosedPiper 602P · Mead, CONTSB DEN81FTE58Accident · No injuriesClosedBeech 23 · Eaton, CONTSB DEN81FTE59Accident · No injuriesClosedCessna 177B · New Raymer, CONTSB DEN81FA049Accident · 4 fatalClosedGulf-Amer AA-5B · Crested Butte, CONTSB DEN81FA048Accident · 1 fatalClosedRyan Aero ST-A · Eaton, CONTSB DEN81FTE56Accident · Minor injuriesClosedPiper 601P · Crested Butte, CONTSB DEN81FTE55Accident · Minor injuriesClosedPiper PA-28R · Westcliffe, CONTSB DEN81FTE54Accident · No injuriesClosedPiper PA-31 · Walsenburg, CONTSB DEN81FTE53Accident · No injuriesClosedCessna T210N · Colorado Spgs, CONTSB DEN81FTE52Accident · No injuriesClosedCessna 150G · Hudson, CO