NTSB investigations, 1974, CO
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 | 45 |
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\") = 1974
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") = 1974 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 DEN75DTE44Accident · No injuriesClosedCessna 150 · Salida, CONTSB DEN75FTE42Accident · Minor injuriesClosedAmer Avco AA5 · Ward, CONTSB DEN75AD035Accident · 1 fatalClosedCessna 182B · Naturita, CONTSB DEN75AD030Accident · No injuriesClosedBeech 18 · Denver, CONTSB DEN75DTE38Accident · No injuriesClosedCessna 150 · Greeley, CONTSB MKC75FCJ42Accident · Minor injuriesClosedBellanca 7GCBC · Wray, CONTSB DEN75DTE37Accident · No injuriesClosedPiper PA-24 · Limon, CONTSB DEN75FTE36Accident · No injuriesClosedPiper PA-28R · Longmont, CONTSB DEN75DTE39Accident · No injuriesClosedCessna 150 · Ellicott, CONTSB DEN75DTE35Accident · No injuriesClosedCessna 172 · Englewood, CONTSB DEN75AD029Accident · 2 fatalClosedCessna 180 · Sedalia, CONTSB DEN75AD028Accident · 2 fatalClosedCessna 182G · Delta, CONTSB DEN75AD026Accident · 1 fatalClosedPiper PA-22 · Craig, CONTSB DEN75AD024Accident · 2 fatalClosedCessna 182A · Springfield, CONTSB DEN75FTE33Accident · Serious injuriesClosedCessna 150F · Durango, CONTSB DEN75AD023Accident · 2 fatalClosedBeech 95-B55 · Pagosa Spgs, CONTSB DEN75AD021Accident · 1 fatalClosedCessna 182 · Burlington, CONTSB DEN75DTE34Accident · No injuriesClosedCessna 180 · Leadville, CONTSB DEN75DTE32Accident · No injuriesClosedCessna 150 · Greeley, CONTSB DEN75FTE25Accident · Serious injuriesClosedCessna 210-5 · Louviers, CONTSB DEN75ATE28Accident · No injuriesClosedCessna 150J · Kim, CONTSB DEN75ATE22Accident · No injuriesClosedCessna 150 · Greeley, CONTSB DEN75FTE27Accident · No injuriesClosedPiper PA-34 · Englewood, CONTSB DEN75AD020Accident · 2 fatalClosedPiper PA-28 · Aurora, CONTSB DEN75FTE31Accident · 1 fatalClosedN.American T-28A · Aurora, CONTSB DEN75AD018Accident · 1 fatalClosedBellanca 14-19 · Vail, CONTSB DEN75AD017Accident · 5 fatalClosedCessna 182J · Springfield, CONTSB DEN75FTE30Accident · Minor injuriesClosedCessna 182P · Center, CONTSB DEN75AD016Accident · 2 fatalClosedCessna 150L · Parker, CONTSB DEN75FTE26Accident · No injuriesClosedCessna 310D · Englewood, CONTSB DEN75DTE29Accident · No injuriesClosedCessna 177 · Colorado Spg, CONTSB DEN75AD013Accident · 2 fatalClosedPiper PA-28 · Eldora, CONTSB DEN75AD012Accident · 1 fatalClosedCessna 140 · Virginia Dle, CONTSB DEN75AD010Accident · Minor injuriesClosedCessna 402 · Littleton, CONTSB DEN75FTE24Accident · No injuriesClosedHughes 269B · Ft.Collins, CONTSB DEN75FTE21Accident · No injuriesClosedBell 47G3B1 · Grand Valley, CONTSB DEN75DTE23Accident · No injuriesClosedCessna A188B · Center, CONTSB DEN75AD007Accident · 4 fatalClosedGates Lear 25B · Briggsdale, CONTSB DEN75DTE20Accident · No injuriesClosedStinson 108 · Montrose, CONTSB DEN75FTE19Accident · Serious injuriesClosedChampion 7ECA · Englewood, CONTSB DEN75FTE17Accident · No injuriesClosedCessna 172 · Colo Springs, CONTSB DEN75DTE14Accident · Serious injuriesClosedPiper PA-18 · Kit Carson, CONTSB DEN75AD004Accident · 1 fatalClosedBell 206B · Berthoud Fls, CONTSB DEN75FTE18Accident · No injuriesClosedAero Comdr 680E · Longmont, CONTSB DEN75FTE15Accident · Minor injuriesClosedPiper PA-28 · Antonito, CONTSB DEN75DTE13Accident · No injuriesClosedCessna 310H · Denver, CONTSB DEN75FTE10Accident · Minor injuriesClosedNaval Fcty N3N-3 · La Salle, CONTSB DEN75DTE11Accident · Minor injuriesClosedBeech H35 · Hugo, CONTSB DEN75FTE12Accident · No injuriesClosedPiper PA-23 · Grand Jctn, CONTSB DEN75DTE09Accident · No injuriesClosedLuscombe 8F · Del Norte, CO