NTSB investigations, 1980, 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\") = 1980
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") = 1980 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 DEN81FTM11Accident · No injuriesClosedPiper PA-28R · Ogden, UTNTSB DEN81FA012Accident · 1 fatalClosedBeech 76 · Morgan, UTNTSB DEN81FTM04Accident · Serious injuriesClosedPiper PA-28 · Woodland, UTNTSB DEN81FTM02Accident · Minor injuriesClosedEnstrom 280C · Salt Lake City, UTNTSB DEN81FA009Accident · No injuriesClosedHiller Acft 12E · Blanding, UTNTSB DEN81DTM03Accident · No injuriesClosedMitsubishi MU2-35 · Provo, UTNTSB DEN8UDA004Accident · No injuriesClosedCessna TU206G · Moab, UTNTSB DEN81FA003Accident · Serious injuriesClosedAerosatle SA315B · Panguitch, UTNTSB DEN80FTM01Accident · No injuriesClosedCessna 172N · West Jordan, UTNTSB DEN80FTM41Accident · Serious injuriesClosedCessna 172 · Heber, UTNTSB DEN80FTM40Accident · No injuriesClosedPiper PA-28 · Kamas, UTNTSB DEN80FTM39Accident · No injuriesClosedWeatherly 201 · Delta, UTNTSB DEN80FA060Accident · 1 fatalClosedBell UH-1B · Provo, UTNTSB DEN80FTM38Accident · Minor injuriesClosedCessna 210 · Parowan, UTNTSB DEN80FTM37Accident · Serious injuriesClosedGrum-Amer AA-5B · Heber City, UTNTSB DEN80DTM36Accident · Serious injuriesClosedHiller Acft UH-12D · Coalville, UTNTSB DEN80FTM35Accident · No injuriesClosedBeech A-36 · America Fork, UTNTSB DEN80FTM34Accident · Serious injuriesClosedPiper PA-28 · Callao, UTNTSB DEN80FTM33Accident · Serious injuriesClosedCourt Sport A · Richfield, UTNTSB DEN80FTM32Accident · No injuriesClosedPiper PA-28 · Strawberry Vly, UTNTSB DEN80FTM31Accident · No injuriesClosedCessna 182 · Hanksville, UTNTSB DEN80FTM30Accident · Minor injuriesClosedCessna TU206F · Bountiful, UTNTSB DEN80FTM29Accident · No injuriesClosedPiper PA-38 · Provo, UTNTSB DEN80FTM28Accident · No injuriesClosedCessna T337D · Ouray, UTNTSB DEN80FTM27Accident · No injuriesClosedCessna 190 · St George, UTNTSB DEN80FTM26Accident · 1 fatalClosedSkybolt Steen · Brigham City, UTNTSB DEN80FTM25Accident · No injuriesClosedPiper PA-28 · Cedar City, UTNTSB DEN80DTM24Accident · No injuriesClosedCessna 188 · Vernal, UTNTSB DEN80DTM23Accident · Minor injuriesClosedCessna 206T · Moab, UTNTSB DEN80FA037Accident · 1 fatalClosedGlobe GC-1B · Spanish Fork, UTNTSB DEN80DTM22Accident · No injuriesClosedPiper PA-18 · Santaquin, UTNTSB DEN80FTM21Accident · No injuriesClosedPiper PA-28 · Nephi, UTNTSB DEN80FTM19Accident · No injuriesClosedPiper PA-28 · Salt Lake City, UTNTSB DEN80FA034Accident · 1 fatalClosedHughes 500 · Vernal, UTNTSB DEN80DTM20Accident · No injuriesClosedCessna 172N · Tooele, UTNTSB DEN80DTM18Accident · Minor injuriesClosedCessna 182Q · Richfield, UTNTSB DEN80FA032Accident · No injuriesClosedBell 206B · Brighton, UTNTSB DEN80FTM17Accident · Minor injuriesClosedGrum-Amer AA-1B · Bullfrog Basin, UTNTSB DEN80FTM16Accident · No injuriesClosedBell 47G3B1 · Vernal, UTNTSB DEN80FTM15Accident · No injuriesClosedPiper PA-28 · Wendover, UTNTSB DEN80DTM14Accident · No injuriesClosedCessna 182 · Provo, UTNTSB DEN80FTM13Accident · No injuriesClosedCessna 180 · Roosevelt, UTNTSB DEN80DTM12Accident · No injuriesClosedCessna 182 · Cedar City, UTNTSB DEN80DTM11Accident · No injuriesClosedBeech A36 · Huntington, UTNTSB DEN80AA026Accident · Minor injuriesClosedPiper PA-31 · Moab, UTNTSB DEN80DTM10Accident · No injuriesClosedBell 47G3B1 · Heber, UTNTSB DEN80FA024Accident · 1 fatalClosedMooney M20C · Scipio, UTNTSB DEN80DTM09Accident · No injuriesClosedCessna 172N · Heber, UTNTSB DEN80FA021Accident · 2 fatalClosedMooney M20F · Grantsville, UTNTSB DEN80FA020Accident · 3 fatalClosedBeech H35 · Copperton, UT