NTSB investigations, 1978, 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
Open the mapLatest 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\") = 1978
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") = 1978 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 DEN79DTM07Accident · No injuriesClosedPiper PA28R · Ruby'S Inn, UTNTSB DEN79FTM08Accident · Serious injuriesClosedCessna 172 · Cedar Fort, UTNTSB DEN79FA013Accident · 1 fatalClosedCessna U206 · Ogden, UTNTSB DEN79FA012Accident · 1 fatalClosedCessna 172A · Park Valley, UTNTSB DEN79FTM06Accident · Minor injuriesClosedAerospatial SA315B · Magna, UTNTSB DEN79FTM05Accident · No injuriesClosedCessna 182 · Duchesne, UTNTSB DEN79FTM03Accident · Serious injuriesClosedCessna R182 · Bullfrog, UTNTSB DEN79FA011Accident · Serious injuriesClosedAerospatial SA316B · Ogden, UTNTSB DEN79FTM04Accident · Minor injuriesClosedCessna 421A · Salt Lake City, UTNTSB DEN79DTM02Accident · Minor injuriesClosedCessna 150 · Price, UTNTSB DEN79FA004Accident · 1 fatalClosedCessna 172 · Provo, UTNTSB DEN79FTM01Accident · No injuriesClosedCessna P210N · Ogden, UTNTSB DEN78DTM23Accident · No injuriesClosedCessna 180 · Hite, UTNTSB DEN79FTC02Accident · No injuriesClosedPiper PA-28 · Bountiful, UTNTSB DEN78FTM32Accident · Minor injuriesClosedCessna 150 · Heber, UTNTSB DEN78FA061Accident · Serious injuriesClosedCessna 206 · Salina, UTNTSB DEN78FA059Accident · 6 fatalClosedBeech 55 · Fairfield, UTNTSB DEN78FTM31Accident · Minor injuriesClosedSchweizer SGS2 · Heber, UTNTSB DEN78DTM29Accident · No injuriesClosedCessna 185 · Green River, UTNTSB DEN78FTM28Accident · 1 fatalClosedClark Focke 190A3 · Cedar City, UTNTSB DEN78DTM27Accident · Serious injuriesClosedPiper PA-28 · Oljato, UTNTSB DEN78FTM26Accident · No injuriesClosedPiper J-3 · Provo, UTNTSB DEN78FTM24Accident · Serious injuriesClosedErco 415-C · Eureka, UTNTSB DEN78FTM23Accident · No injuriesClosedBeech B19 · Ogden, UTNTSB DEN78FTM21Accident · 1 fatalClosedBede BD5 · Wendover, UTNTSB DEN78FTM22Accident · No injuriesClosedBeech B23 · Nephi, UTNTSB DEN78FA041Accident · No injuriesClosedBell 206B3 · Westwater, UTNTSB DEN78FTM20Accident · No injuriesClosedChampion 7ECA · Logan, UTNTSB DEN78DTM19Accident · Minor injuriesClosedMooney M20C · Kanab, UTNTSB DEN78FTM18Accident · No injuriesClosedCessna 150 · Fairview, UTNTSB DEN78FTM13Accident · No injuriesClosedBellanca 14-19 · Provo, UTNTSB DEN78FA038Accident · No injuriesClosedBeech BE-65 · Salt Lake City, UTNTSB DEN78FTM17Accident · Minor injuriesClosedStinson 108-2 · Vernal, UTNTSB DEN78FA036Accident · 1 fatalClosedCessna TP206C · Angle, UTNTSB DEN78FA035Accident · 1 fatalClosedPiper PA-38 · Park City, UTNTSB DEN78DTM16Accident · No injuriesClosedAerospatial SA315B · Nmanila, UTNTSB DEN78FTM15Accident · No injuriesClosedGrumman G164A · Park City, UTNTSB DEN78FTM14Accident · Serious injuriesClosedPiper PA-28 · Brigham City, UTNTSB DEN78FA025Accident · 2 fatalClosedBeech 35 · Ogden, UTNTSB DEN78FTM12Accident · No injuriesClosedPiper PA-28 · Provo, UTNTSB DEN78FTM11Accident · 1 fatalClosedTurner T-40 · Ogden, UTNTSB DEN78FA021Accident · 4 fatalClosedCessna 177B · Salt Lake City, UT