NTSB investigations, 1976, 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\") = 1976
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") = 1976 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 DEN77FTM08Accident · Minor injuriesClosedCessna 210 · Brigham City, UTNTSB DEN77FA008Accident · 2 fatalClosedPiper PA-24 · Grantsville, UTNTSB DEN77FTM07Accident · 1 fatalClosedCessna P206B · Nephi, UTNTSB DEN77FTM06Accident · Minor injuriesClosedBell 47G · Beaver, UTNTSB DEN76FTM05Accident · Minor injuriesClosedCessna T210L · Bullfrog Basin, UTNTSB DEN77FTM04Accident · No injuriesClosedCessna 150J · Kamas, UTNTSB LAX77IA003Incident · Serious injuriesClosedBoeing 737 · Salt Lake City, UTNTSB DEN77DTM01Accident · No injuriesClosedCessna 172H · Parowan, UTNTSB DEN77FTM03Accident · No injuriesClosedCessna 150 · Salt Lake City, UTNTSB DEN76AD073Accident · 2 fatalClosedBell 47G3B2 · Mantua, UTNTSB DEN76FTM49Accident · No injuriesClosedNa Rockwell 112TC · Vernal, UTNTSB DEN76DTM48Accident · No injuriesClosedBeech 95-E55 · Tremonton, UTNTSB DEN76AD070Accident · 3 fatalClosedCessna 185 · Sunnyside, UTNTSB DEN76FTM47Accident · No injuriesClosedGrumman G-164A · Leland, UTNTSB DEN76DTM46Accident · Minor injuriesClosedPiper PA-22 · Bullfrog Basin, UTNTSB DEN76ATM45Accident · Serious injuriesClosedAmer Avco AA-1B · Escalante, UTNTSB DEN76AD066Accident · Minor injuriesClosedCessna TU206 · Ouray, UTNTSB DEN76FTM43Accident · No injuriesClosedCessna 172M · Cedar City, UTNTSB DEN76DTM44Accident · No injuriesClosedBensen B-8M · Lehi, UTNTSB DEN76AD061Accident · 1 fatalClosedPiper PA-30 · Kings Peak, UTNTSB DEN76FTM42Accident · No injuriesClosedCessna 182 · Salt Lake City, UTNTSB DEN77FTM41Accident · Minor injuriesClosedCessna 206P · Lasal Junction, UTNTSB DEN76FTM39Accident · Minor injuriesClosedBell 206B · Coalville, UTNTSB DEN76DTM40Accident · No injuriesClosedCessna 150H · Howell, UTNTSB DEN76AD055Accident · 1 fatalClosedSchweizer SGU222 · Heber City, UTNTSB DEN76AD056Accident · 4 fatalClosedStinson 108-2 · Kamas, UTNTSB DEN76FTM38Accident · Minor injuriesClosedCessna 172 · Cedar City, UTNTSB DEN76DTM37Accident · No injuriesClosedPiper PA-28 · Hatch, UTNTSB DEN76DTM36Accident · No injuriesClosedCessna 172F · Provo, UTNTSB DEN76FTM31Accident · Serious injuriesClosedGrumman G-164 · Morgan, UTNTSB DEN76FTM33Accident · No injuriesClosedPiper PA-34 · Bullfrog Basin, UTNTSB DEN76DTM32Accident · No injuriesClosedCessna T210L · Navajo Mtn, UTNTSB DEN76DTM34Accident · No injuriesClosedCessna 172M · Manila, UTNTSB DEN76FTM30Accident · No injuriesClosedCessna 177 · Ogden, UTNTSB DEN76DTM29Accident · No injuriesClosedCessna 195 · Hurricane, UTNTSB DEN76DTM35Accident · No injuriesClosedCessna 188B · New Castle, UTNTSB DEN76FTM27Accident · Serious injuriesClosedCessna 182P · Hanksville, UTNTSB DEN76FTM26Accident · Minor injuriesClosedCessna 182E · Salt Lake City, UTNTSB DEN76FTM28Accident · No injuriesClosedPiper PA-18 · Tooele, UTNTSB DEN76FTM12Accident · No injuriesClosedErco 415-C · Heber, UTNTSB DEN76FTM25Accident · No injuriesClosedHiller Acft UH-12D · Bountiful, UTNTSB DEN76DTM24Accident · No injuriesClosedCessna 180 · Moab, UTNTSB DEN76FTM23Accident · Minor injuriesClosedCessna T210L · Roosevelt, UTNTSB DEN76AD040Accident · Serious injuriesClosedHiller Acft UH-12E · Bluff, UTNTSB DEN76DTM22Accident · No injuriesClosedStinson 108-2 · Bryce Canyon, UTNTSB DEN76FTM21Accident · No injuriesClosedPiper PA-32 · Logan, UTNTSB DEN76FTM19Accident · No injuriesClosedCessna 180 · St.George, UTNTSB DEN76FTM20Accident · No injuriesClosedCessna 172M · Bryce Canyon, UTNTSB DEN76FTM18Accident · No injuriesClosedCessna 210A · Salt Lake City, UTNTSB DEN76AD033Accident · 4 fatalClosedGrum Amer AA-5 · Hyrum, UT