NTSB investigations, 1966, 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\") = 1966
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") = 1966 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 DEN67D0186Accident · Minor injuriesClosedAeronca 7AC · Layton, UTNTSB DEN67I0036Incident · No injuriesClosedConvair 580 · Salt Lake City, UTNTSB DEN67A0035Accident · 2 fatalClosedBeech 65-88 · Woods Cross, UTNTSB DEN67F0170Accident · No injuriesClosedCessna 210 · Ogden, UTNTSB DEN67F0171Accident · No injuriesClosedBeech C35 · Salt Lake City, UTNTSB DEN67D0172Accident · No injuriesClosedPiper PA-28 · Tooele, UTNTSB DEN67D0145Accident · No injuriesClosedCessna 310B · Bluff, UTNTSB DEN67F0169Accident · No injuriesClosedCessna 172 · Panguitch, UTNTSB DEN67A0026Accident · 1 fatalClosedCessna 150F · Tooele, UTNTSB DEN67D0109Accident · No injuriesClosedCessna 172 · Vernon, UTNTSB DEN67A0028Accident · 4 fatalClosedPiper PA-24 · Alton, UTNTSB DEN67F0116Accident · Serious injuriesClosedBeech B35 · Salt Lake City, UTNTSB DEN6MD0107Accident · No injuriesClosedCessna 150D · Salt Lake City, UTNTSB DEN67A0023Accident · No injuriesClosedCessna 182B · Green River, UTNTSB DEN67D0117Accident · No injuriesClosedCessna 150 · Salt Lake City, UTNTSB DEN67D0119Accident · Minor injuriesClosedCessna 180E · Hanksville, UTNTSB DEN67F0100Accident · No injuriesClosedHelio H-295 · Salt Lake City, UTNTSB DEN67F0108Accident · No injuriesClosedCessna 320D · Vernal, UTNTSB DEN67D0118Accident · No injuriesClosedCessna 170B · Midvale, UTNTSB DEN67F0093Accident · 1 fatalClosedChampion 7GC · Heber, UTNTSB DEN67A0017Accident · 2 fatalClosedAeronca 11AC · Sandy, UTNTSB DEN67D0077Accident · No injuriesClosedCessna 182 · Green River, UTNTSB DEN67A0014Accident · 5 fatalClosedPiper PA-28 · Vernal, UTNTSB DEN67D0053Accident · No injuriesClosedCessna 150 · Roosevelt, UTNTSB DEN67A0008Accident · Serious injuriesClosedHiller UH-12E · Escalante, UTNTSB DEN67D0043Accident · No injuriesClosedCessna 170 · Moab, UTNTSB DEN67D0042Accident · No injuriesClosedBellanca 14-13 · Panguitch, UTNTSB DEN66F0044Accident · No injuriesClosedCessna 182 · Sandy, UTNTSB DEN67D0052Accident · No injuriesClosedPiper PA-12 · Blanding, UTNTSB DEN67A0001Accident · 2 fatalClosedCessna T210F · Cisco, UTNTSB DEN67F0024Accident · No injuriesClosedN American AT-6 · Delta, UTNTSB DEN67F0029Accident · No injuriesClosedBeech B35 · Salt Lake City, UTNTSB DEN67D0028Accident · No injuriesClosedPiper PA-24 · Coalville, UTNTSB DEN67F0011Accident · Serious injuriesClosedBeec 23 · Bountiful, UTNTSB DEN66F0360Accident · No injuriesClosedPiper PA24 · Salt Lake City, UTNTSB DEN67F0004Accident · Minor injuriesClosedCessna 205 · Erron, UTNTSB DEN67D0014Accident · Minor injuriesClosedCessna 182A · Dutch John, UTNTSB DEN66A0088Accident · Minor injuriesClosedBell 47G3B1 · Ogden, UTNTSB DEN67D0002Accident · No injuriesClosedCessna 150 · Provo, UTNTSB DEN67F0003Accident · Minor injuriesClosedCessna 182 · Salt Lake City, UTNTSB DEN66D0333Accident · No injuriesClosedPiper PA-22 · Hanksville, UTNTSB DEN66F0342Accident · No injuriesClosedCessna 182 · Salt Lake City, UTNTSB DEN66D0340Accident · No injuriesClosedCessna 210 · Logan, UTNTSB DEN66F0341Accident · No injuriesClosedPiper PA-25 · St.George, UTNTSB DEN66F0332Accident · No injuriesClosedBellanca 14-13 · Mexican Hat, UTNTSB DEN66F0339Accident · No injuriesClosedCessna 170 · Oljato, UTNTSB DEN66D0294Accident · No injuriesClosedBeech T-34A · Provo, UTNTSB DEN66F0295Accident · No injuriesClosedBeech G35 · Salt Lake City, UTNTSB DEN66D0309Accident · No injuriesClosedCessna 210A · Riverton, UTNTSB DEN66D0285Accident · No injuriesClosedCessna 120 · Tremonton, UT