NTSB investigations, 1965, UT
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 | 54 |
| 1965 | 54 |
| 1966 | 65 |
| 1967 | 52 |
| 1968 | 44 |
| 1969 | 45 |
| 1970 | 39 |
| 1971 | 27 |
| 1972 | 39 |
| 1973 | 44 |
| 1974 | 33 |
| 1975 | 38 |
| 1976 | 57 |
| 1977 | 42 |
| 1978 | 42 |
| 1979 | 41 |
| 1980 | 52 |
| 1981 | 58 |
| 1982 | 41 |
| 1983 | 45 |
| 1984 | 53 |
| 1985 | 41 |
| 1986 | 32 |
| 1987 | 37 |
| 1988 | 28 |
| 1989 | 40 |
| 1990 | 32 |
| 1991 | 31 |
| 1992 | 26 |
| 1993 | 36 |
| 1994 | 31 |
| 1995 | 24 |
| 1996 | 27 |
| 1997 | 36 |
| 1998 | 35 |
| 1999 | 29 |
| 2000 | 49 |
| 2001 | 33 |
| 2002 | 39 |
| 2003 | 40 |
| 2004 | 34 |
| 2005 | 25 |
| 2006 | 32 |
| 2007 | 44 |
| 2008 | 42 |
| 2009 | 37 |
| 2010 | 35 |
| 2011 | 31 |
| 2012 | 26 |
| 2013 | 20 |
| 2014 | 25 |
| 2015 | 25 |
| 2016 | 18 |
| 2017 | 27 |
| 2018 | 26 |
| 2019 | 29 |
| 2020 | 21 |
| 2021 | 23 |
| 2022 | 28 |
| 2023 | 35 |
| 2024 | 27 |
| 2025 | 22 |
| 2026 | 23 |
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\") = 1965
AND c.\"eventStateOrRegion\" = 'UT' 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") = 1965 AND c."eventStateOrRegion" = 'UT' 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 DEN66F0195Accident · No injuriesClosedCessna 310A · Salt Lake City, UTNTSB DEN66A0052Accident · 3 fatalClosedBeech C35 · Coalville, UTNTSB DEN66A0038Accident · 13 fatalClosedDouglas DC-3A · Salt Lake City, UTNTSB DEN66A0040Accident · 1 fatalClosedBeech T-34A · Kamas, UTNTSB DEN66F0172Accident · No injuriesClosedStinson 108 · Sandy, UTNTSB DEN66A0036Accident · 5 fatalClosedBeech B95A · Beaver, UTNTSB DEN66A0033Accident · 1 fatalClosedPiper PA-28 · New Harmony, UTNTSB DEN66F0165Accident · No injuriesClosedBeechcraft E35 · Woods Cross, UTNTSB DCA66A0004Accident · 43 fatalClosedBoeing B-727 · Salt Lke Cty, UTNTSB DEN66F0154Accident · No injuriesClosedPiper PA-23 · Duchesne, UTNTSB DEN66D0147Accident · No injuriesClosedBeechcraft 95-55 · Logan, UTNTSB DEN66A0029Accident · 1 fatalClosedBeechcraft B35 · Blanding, UTNTSB DEN66D0122Accident · No injuriesClosedPiper J-3 · Woodruff, UTNTSB DEN66A0025Accident · Minor injuriesClosedBell 47G3B1 · Salt Lake City, UTNTSB DEN66D0166Accident · No injuriesClosedCessna 210A · Mexican Hat, UTNTSB DEN66A0023Accident · 1 fatalClosedBell 47G3B1 · Monticello, UTNTSB DEN66D0110Accident · No injuriesClosedCessna 320 · Logan, UTNTSB DEN66D0109Accident · No injuriesClosedBeechcraft K-35 · Veyo, UTNTSB DEN66A0016Accident · Minor injuriesClosedBell 47G3B1 · Bountiful, UTNTSB DEN66F0064Accident · No injuriesClosedPiper PA-28 · Snowville, UTNTSB DEN66F0048Accident · No injuriesClosedCessna 175 · Salt Lake City, UTNTSB DEN66F0059Accident · No injuriesClosedCessna 172 · Salt Lake City, UTNTSB DEN66F0058Accident · No injuriesClosedPiper PA-28 · Salt Lake City, UTNTSB DEN66F0032Accident · No injuriesClosedPiper PA-22 · Eden, UTNTSB DEN66D0042Accident · No injuriesClosedPiper PA-24 · Panguitch, UTNTSB DEN66F0052Accident · No injuriesClosedBeechcraft G35 · Salt Lake City, UTNTSB DEN66F0033Accident · No injuriesClosedCessna 175 · Goldhill, UTNTSB DEN66D0016Accident · No injuriesClosedMooney M20A · Vernal, UTNTSB DEN66F0001Accident · No injuriesClosedLuscombe 8F · Green River, UTNTSB DEN65A0079Accident · 3 fatalClosedBellanca 14-133 · Panguitch, UTNTSB DEN66F0015Accident · No injuriesClosedGrasshopper D-8 · Heber, UTNTSB DEN65A0080Accident · 3 fatalClosedPiper PA-28 · Salina, UTNTSB DEN65F0103Accident · Minor injuriesClosedPiper PA-22 · Logan, UTNTSB DEN65D0106Accident · No injuriesClosedPiper PA-22 · Woodruff, UTNTSB DEN65F0105Accident · No injuriesClosedBeechcraft B-35 · Salt Lake City, UTNTSB DEN65D0104Accident · No injuriesClosedCessna 172 · Cedar City, UTNTSB DEN65D0073Accident · No injuriesClosedCessna 140 · Aneth, UTNTSB DEN65D0072Accident · No injuriesClosedCessna 170 · La Sal, UTNTSB DEN65F0057Accident · Minor injuriesClosedPiper PA-22 · Beryl Junction, UTNTSB DEN65F0047Accident · Minor injuriesClosedCessna 182 · St George, UTNTSB DEN65D0052Accident · Serious injuriesClosedCessna 210 · Orem, UTNTSB DEN65A0062Accident · 1 fatalClosedPiper PA-28 · Salt Lake City, UTNTSB DEN65F0033Accident · No injuriesClosedCougar 1 · Manti, UTNTSB DEN65A0060Accident · 4 fatalClosedCessna 170 · Ephraim, UTNTSB DEN65F0024Accident · Minor injuriesClosedCessna 170A · Huntington, UTNTSB DEN65D0031Accident · No injuriesClosedCessna 180 · Vernal, UTNTSB DEN65F0028Accident · No injuriesClosedForney F-1A · Spanish Fork, UTNTSB DEN65F0016Accident · No injuriesClosedLuscombe 8A · Bryce Canyon, UTNTSB DEN65F0023Accident · No injuriesClosedErcoupe 415C · Colton, UTNTSB DEN65A0053Accident · No injuriesClosedHughes 269B · Provo, UT