NTSB investigations, 1981, UT
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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\") = 1981
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") = 1981 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 DEN82FTM07Accident · No injuriesClosedHughes 269B · West Jordon, UTNTSB DEN82DTM06Accident · No injuriesClosedBell 206B · Fruitland, UTNTSB DEN82FA011Accident · 4 fatalClosedBeech 95 · Cedar City, UTNTSB DEN82FTM05Accident · Minor injuriesClosedAerospatle 315B · Cedar City, UTNTSB DEN82FTM04Accident · Minor injuriesClosedHiller UH12C · Logan, UTNTSB DEN82FTM03Accident · No injuriesClosedCessna 150 · Stockton, UTNTSB DEN82FTM02Accident · No injuriesClosedSoloy 47 · Fruitland, UTNTSB DEN82FTM01Accident · No injuriesClosedCessna 140 · Ogden, UTNTSB DEN82FA005Accident · 3 fatalClosedPiper PA-28 · Provo, UTNTSB DEN82FA003Accident · Minor injuriesClosedAerospatial SA315B · Springville, UTNTSB DEN82FA002Accident · 3 fatalClosedCessna 310 · Eureka, UTNTSB DEN82FA001Accident · 1 fatalClosedCessna 182RG · La Sal, UTNTSB DEN81FTM42Accident · No injuriesClosedCessna 340A · Vernal, UTNTSB DEN81FA065Accident · 1 fatalClosedDouglas DC-10 · Salt Lake City, UTNTSB DEN81DTM41Accident · No injuriesClosedPiper PA-38 · Promontory Pt, UTNTSB DEN81FTM37Accident · Minor injuriesClosedRotorway 133 · Price, UTNTSB DEN81FA058Accident · Minor injuriesClosedBell 206B · Escalante, UTNTSB DEN81FTM38Accident · Minor injuriesClosedCessna 172 · Spring City, UTNTSB DEN81FTM39Accident · 1 fatalClosedPiper PA-28 · Ferron, UTNTSB DEN81FA054Accident · 1 fatalClosedPiper PA-34 · Price, UTNTSB DEN81DTM36Accident · No injuriesClosedBeech F35 · Laketown, UTNTSB DEN81DTM40Accident · No injuriesClosedGrumman AG-CAT · Park Valley, UTNTSB DEN81FTM35Accident · No injuriesClosedCessna 172N · Moab, UTNTSB DEN81FTM34Accident · No injuriesClosedGrum Amer AA-5B · Provo, UTNTSB DEN81DTM33Accident · No injuriesClosedCessna 170B · St George, UTNTSB DEN81FA047Accident · 2 fatalClosedTaylorcraft BL-65 · Rosette, UTNTSB DEN81FA045Accident · 2 fatalClosedBeech C35 · Spanish Forks, UTNTSB DEN81FTM32Accident · Minor injuriesClosedCessna A188B · Layton, UTNTSB DEN81FA044Accident · 2 fatalClosedCessna 172 · Price, UTNTSB DEN81FTM30Accident · No injuriesClosedPiper PA-28 · Roosevelt, UTNTSB DEN81FTM31Accident · No injuriesClosedNavion A · West Jordan, UTNTSB DEN81FA042Accident · No injuriesClosedCessna TU206G · Cisco, UTNTSB DEN81FTM28Accident · Minor injuriesClosedCessna 210 · Kanab, UTNTSB DEN81FTM26Accident · No injuriesClosedPiper PA-28 · Thistle, UTNTSB DEN81FTM29Accident · No injuriesClosedAeronca 7AC · Provo, UTNTSB DEN81FTM25Accident · Serious injuriesClosedRex Johnson AL-CAT · Salt Lake City, UTNTSB DEN81FA037Accident · 2 fatalClosedBeech A-35R · Beaver, UTNTSB DEN81DTM24Accident · No injuriesClosedPiper PA-18 · Moab, UTNTSB DEN81FTM27Accident · Serious injuriesClosedPiper PA-28 · Tooele, UTNTSB DEN81DTM23Accident · No injuriesClosedCessna 182P · Monument Vly, UTNTSB DEN81DTM21Accident · No injuriesClosedCessna 180 · Price, UTNTSB DEN81DTM19Accident · No injuriesClosedSkypower GBN-41 · Delta, UTNTSB DEN81FA028Accident · 2 fatalClosedCessna 172 · Tropic, UTNTSB DEN81FTM18Accident · Minor injuriesClosedCessna R182 · Eureka, UTNTSB DEN81FTM17Accident · No injuriesClosedCessna T210 · Hanksville, UTNTSB DEN81FTM16Accident · No injuriesClosedCessna 152 · Cedar City, UTNTSB DEN81FTM15Accident · 1 fatalClosedLockheed P-38 · Salt Lake City, UTNTSB DEN81FTM13Accident · Minor injuriesClosedPiper PA-28 · Alton, UTNTSB DEN81FTM14Accident · No injuriesClosedQuickie · Provo, UTNTSB DEN81FTM12Accident · No injuriesClosedAerospatle SA315B · Heber City, UT