NTSB investigations, 1973, 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\") = 1973
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") = 1973 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 DEN74FTM10Accident · No injuriesClosedCessna 205 · Bountiful, UTNTSB DEN74FTM09Accident · No injuriesClosedCessna 172D · West Jordan, UTNTSB DEN74AD030Accident · 1 fatalClosedCessna 320 · Spanish Fork, UTNTSB DEN74AD029Accident · 2 fatalClosedBeech A35 · Plain City, UTNTSB DEN74AD026Accident · 2 fatalClosedCessna 421A · Roosevelt, UTNTSB DEN74AD020Accident · 2 fatalClosedPiper PA-34 · Levan, UTNTSB DEN74AD019Accident · 1 fatalClosedPiper PA-28R · Salt Lake City, UTNTSB DEN74DTM08Accident · No injuriesClosedCessna U206D · St.George, UTNTSB DEN74AD017Accident · 2 fatalClosedCessna 177B · West Delta, UTNTSB DEN74FTM06Accident · Minor injuriesClosedWittman W-8 · Salt Lake City, UTNTSB DEN74FTM05Accident · No injuriesClosedHoward, Dee DGA15J · Richfield, UTNTSB DEN74DTM07Accident · No injuriesClosedCessna 172 · Green River, UTNTSB DEN74FTM04Accident · No injuriesClosedCessna 177A · Ogden, UTNTSB DEN74FTM03Accident · No injuriesClosedCessna 305A · Ogden, UTNTSB DEN74FTM02Accident · Serious injuriesClosedMooney M20C · Hurricane Mesa, UTNTSB DEN74FTM01Accident · Serious injuriesClosedPiper PA-28 · Cisco, UTNTSB DEN73AD056Accident · 5 fatalClosedCessna 310 · Provo, UTNTSB DEN73DTM34Accident · No injuriesClosedCessna 320C · Vernal, UTNTSB DEN73FTM33Accident · Serious injuriesClosedCessna 188 · Farmington, UTNTSB DEN73DTM31Accident · No injuriesClosedHiller Acft UH-12E · Richfield, UTNTSB DEN73DTM32Accident · Minor injuriesClosedPiper PA-28 · Beaver, UTNTSB DEN73DTM30Accident · Minor injuriesClosedBell 47G3B1 · Magna, UTNTSB DEN73AD054Accident · 1 fatalClosedChampion 7GCAA · Blanding, UTNTSB DEN73AD051Accident · No injuriesClosedCessna 185 · Vernal, UTNTSB DEN73AD050Accident · 4 fatalClosedCessna A185F · Moab, UTNTSB DEN73DTM29Accident · No injuriesClosedCessna 180 · Bryce Canyon, UTNTSB DEN73DTM28Accident · No injuriesClosedBeech V35B · Ogden, UTNTSB DEN73FTM27Accident · No injuriesClosedWaco UMF · Ogden, UTNTSB DEN73FTM26Accident · No injuriesClosedCessna 182 · Sandy, UTNTSB DEN73AD048Accident · 1 fatalClosedCessna 205A · Parowan, UTNTSB DEN73DTM25Accident · No injuriesClosedBeech V35-TC · Hanksville, UTNTSB DEN73DTM24Accident · No injuriesClosedCessna 172 · Navajo Mt, UTNTSB DEN73DTM23Accident · Minor injuriesClosedCessna 170B · Bryce Canyon, UTNTSB DEN73FTM21Accident · No injuriesClosedCessna 305A · Nephi, UTNTSB DEN73AD039Accident · No injuriesClosedBell 47G3B1 · Salt Lake City, UTNTSB DEN73FTM22Accident · No injuriesClosedCessna 320C · Ogden, UTNTSB DEN73DTM20Accident · No injuriesClosedCessna 182 · Brigham City, UTNTSB DEN73DTM19Accident · No injuriesClosedCessna 172 · Vernal, UTNTSB DEN73AD036Accident · 4 fatalClosedCessna 210 · Milford, UTNTSB DEN73AD075Accident · 1 fatalClosedBeech K35 · Salt Lake City, UTNTSB DEN73FTM18Accident · No injuriesClosedPiper PA-24 · Bountiful, UTNTSB DEN73DTM17Accident · No injuriesClosedPiper PA-18 · Tremonton, UTNTSB DEN73DTM16Accident · No injuriesClosedCessna 150G · Tooele, UTNTSB DEN73FTM15Accident · No injuriesClosedPiper PA-22 · Provo, UT