NTSB investigations, 1964, 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\") = 1964
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") = 1964 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 UNK65X1171Accident · No injuriesClosedCessna 182F · Duchesne, UTNTSB UNK65X1170Accident · No injuriesClosedNavion A · Spanish Fork, UTNTSB UNK65X1067Accident · No injuriesClosedPiper PA28 · Moab, UTNTSB UNK65X1059Accident · 1 fatalClosedPiper PA-24 · Ogden, UTNTSB UNK65X1005Accident · 2 fatalClosedPiper PA-18 · Carrington Isl., UTNTSB UNK65X0630Accident · No injuriesClosedPiper PA22 · Cedar City, UTNTSB UNK65X0482Accident · Minor injuriesClosedPiper PA15 · Soldier Summit, UTNTSB UNK65X0470Accident · No injuriesClosedPiper PA18 · Promontory Pt, UTNTSB UNK65X0396Accident · No injuriesClosedCessna 170B · Rainbow Bridge, UTNTSB UNK65X0365Accident · 2 fatalClosedPiper PA-18 · Dugway, UTNTSB UNK65X0308Accident · No injuriesClosedCessna 172 · Ouray, UTNTSB UNK65X0193Accident · No injuriesClosedPiper PA20 · Woods Cross, UTNTSB UNK65X0160Accident · No injuriesClosedSwift GC1B · Salt Lake City, UTNTSB UNK64X4167Accident · No injuriesClosedCessna 182 · Hite, UTNTSB UNK64X4137Accident · No injuriesClosedPiper PA20 · Woods Cross, UTNTSB UNK64X4095Accident · No injuriesClosedCessna 172 · Carrington Is, UTNTSB DEN65D0048Accident · No injuriesClosedBeechcraft 35 · Panguitch, UTNTSB UNK64X3736Accident · No injuriesClosedCessna 210 · Salt Lake City, UTNTSB UNK64X3666Accident · No injuriesClosedPiper PA22 · Camp Williams, UTNTSB UNK64X3565Accident · No injuriesClosedCessna 182 · Bullfrog Basin, UTNTSB UNK64X3192Accident · No injuriesClosedCessna 182 · Green River, UTNTSB UNK64X3078Accident · Minor injuriesClosedBell 47G3B1 · Kamas, UTNTSB UNK64X3065Accident · No injuriesClosedBellanca 14192 · Salt Lake City, UTNTSB UNK64X2977Accident · No injuriesClosedAeronca 7AC · Woods Cross, UTNTSB UNK64X2852Accident · No injuriesClosedCessna 172 · Salt Lake City, UTNTSB UNK64X2845Accident · No injuriesClosedPiper PA24 · Vernon, UTNTSB UNK64X2837Accident · No injuriesClosedBeechcraft 35 · Grantsville, UTNTSB UNK64X2773Accident · No injuriesClosedPiper PA18 · Manila, UTNTSB UNK64X2636Accident · No injuriesClosedPiper PA22 · Green River, UTNTSB UNK64X2560Accident · 1 fatalClosedBell 47G · Ogden, UTNTSB UNK64X1684Accident · No injuriesClosedCessna 140 · Moab, UTNTSB UNK64X1653Accident · No injuriesClosedCessna 180 · West Jordan, UTNTSB UNK64X1647Incident · No injuriesClosedConvair 340 · Salt Lake City, UTNTSB UNK64X1607Accident · Minor injuriesClosedCessna 120 · Coalville, UTNTSB UNK64X1212Accident · 2 fatalClosedStinson 108-2 · St John, UTNTSB UNK64X1123Accident · No injuriesClosedCessna 175 · Salt Lake City, UTNTSB UNK64X1070Accident · No injuriesClosedPiper PA18 · Salt Lake City, UTNTSB UNK64X0902Accident · No injuriesClosedCessna 180 · Hot Springs, UTNTSB UNK64X0849Accident · No injuriesClosedTaylorcraft BC12D · Moab, UTNTSB UNK64X0832Accident · No injuriesClosedLuscombe 8F · Park Valley, UTNTSB UNK64X0812Accident · 1 fatalClosedBeechcraft E18S · Delta, UTNTSB UNK64X0759Accident · Minor injuriesClosedPiper PA18 · Hanksville, UTNTSB UNK64X0734Accident · No injuriesClosedPiper PA28 · Ogden, UTNTSB UNK64X0614Accident · No injuriesClosedCessna 210B · Price, UTNTSB UNK64X0604Accident · No injuriesClosedBell 47G-3 · Moab, UTNTSB UNK64X0553Accident · 2 fatalClosedCessna 172D · Provo, UTNTSB UNK64X0430Accident · No injuriesClosedCessna 172 · Sandy, UTNTSB UNK64X0388Accident · No injuriesClosedLuscombe 8A · Tremonton, UTNTSB UNK64X0367Accident · No injuriesClosedPiper PA18 · Provo, UTNTSB UNK64X0352Accident · No injuriesClosedBeechcraft 35 · Provo, UT