NTSB investigations, 1979, MT
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 | 2 |
|---|---|
| 1964 | 78 |
| 1965 | 73 |
| 1966 | 87 |
| 1967 | 82 |
| 1968 | 61 |
| 1969 | 56 |
| 1970 | 67 |
| 1971 | 55 |
| 1972 | 46 |
| 1973 | 49 |
| 1974 | 59 |
| 1975 | 61 |
| 1976 | 60 |
| 1977 | 61 |
| 1978 | 57 |
| 1979 | 50 |
| 1980 | 46 |
| 1981 | 52 |
| 1982 | 57 |
| 1983 | 37 |
| 1984 | 38 |
| 1985 | 42 |
| 1986 | 34 |
| 1987 | 27 |
| 1988 | 31 |
| 1989 | 26 |
| 1990 | 32 |
| 1991 | 28 |
| 1992 | 29 |
| 1993 | 25 |
| 1994 | 29 |
| 1995 | 26 |
| 1996 | 23 |
| 1997 | 29 |
| 1998 | 38 |
| 1999 | 24 |
| 2000 | 28 |
| 2001 | 18 |
| 2002 | 25 |
| 2003 | 23 |
| 2004 | 29 |
| 2005 | 21 |
| 2006 | 33 |
| 2007 | 28 |
| 2008 | 20 |
| 2009 | 16 |
| 2010 | 14 |
| 2011 | 21 |
| 2012 | 17 |
| 2013 | 29 |
| 2014 | 21 |
| 2015 | 20 |
| 2016 | 18 |
| 2017 | 12 |
| 2018 | 14 |
| 2019 | 15 |
| 2020 | 19 |
| 2021 | 18 |
| 2022 | 14 |
| 2023 | 16 |
| 2024 | 18 |
| 2025 | 24 |
| 2026 | 15 |
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\") = 1979
AND c.\"eventStateOrRegion\" = 'MT' 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") = 1979 AND c."eventStateOrRegion" = 'MT' 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 SEA80FTA07Accident · 1 fatalClosedScorpion 133 · Nashua, MTNTSB SEA80FTA06Accident · No injuriesClosedCessna 210M · Glendive, MTNTSB SEA80FTA05Accident · No injuriesClosedPiper PA-22 · Laurel, MTNTSB SEA80FTI02Accident · Serious injuriesClosedPiper PA-32R · Chester, MTNTSB SEA80FTA03Accident · No injuriesClosedCessna 182E · Red Lodge, MTNTSB SEA80FTA04Accident · No injuriesClosedCessna 140 · Malta, MTNTSB SEA80FTA02Accident · No injuriesClosedCessna 210 · Billings, MTNTSB SEA80FTA01Accident · No injuriesClosedCessna 150 · Billings, MTNTSB SEA80FTI01Accident · 2 fatalClosedCessna A185F · Dillon, MTNTSB SEA79FTI27Accident · Serious injuriesClosedCessna 182C · Whitefish, MTNTSB SEA79FTI26Accident · No injuriesClosedCessna 172K · Three Forks, MTNTSB SEA79FTA21Accident · No injuriesClosedPiper PA-18 · Winnett, MTNTSB SEA79FA060Accident · 2 fatalClosedCessna 150 · Sula, MTNTSB SEA79FTA20Accident · Minor injuriesClosedCessna 182G · Billings, MTNTSB SEA79DTI25Accident · No injuriesClosedCessna 172 · Conrad, MTNTSB SEA79FT124Accident · Serious injuriesClosedPiper PA-24 · Big Sandy, MTNTSB SEA79FTA19Accident · No injuriesClosedBell 206B · Absarokee, MTNTSB SEA79FT123Accident · Minor injuriesClosedKaman HH-43F · Hamilton, MTNTSB SEA79FA050Accident · 4 fatalClosedBeech B23 · Neihart, MTNTSB SEA79FTA18Accident · No injuriesClosedGrum Amer AA-5 · Laurel, MTNTSB SEA79FTA17Accident · No injuriesClosedErco 415-C · Billings, MTNTSB SEA79FA048Accident · 2 fatalClosedGrum Amer AA-5A · Augusta, MTNTSB SEA79DTI22Accident · Minor injuriesClosedCessna 182 · Schafer, MTNTSB SEA79DTI20Accident · No injuriesClosedCessna 170B · Cut Bank, MTNTSB SEA79FTA16Accident · No injuriesClosedCessna 180 · Landusky, MTNTSB SEA79FA041Accident · 2 fatalClosedBellanca 7GCBC · Big Sky, MTNTSB SEA79FTI19Accident · No injuriesClosedBell 47G3B1 · Emigrant, MTNTSB SEA79FA040Accident · 1 fatalClosedBellanca 7KCAB · Laurel, MTNTSB SEA79FTI16Accident · Serious injuriesClosedCessna TU206F · Sula, MTNTSB SEA79FTI18Accident · No injuriesClosedCessna 188 · Toston, MTNTSB SEA79FTI17Accident · No injuriesClosedCessna 140 · Brady, MTNTSB SEA79FTA15Accident · No injuriesClosedPiper PA-18 · Circle, MTNTSB SEA79FTI15Accident · No injuriesClosedScorpion II · Belgrade, MTNTSB SEA79FTA14Accident · No injuriesClosedCessna 150 · Billings, MTNTSB SEA79FTA13Accident · No injuriesClosedGrumman G-164B · Billings, MTNTSB SEA79DTI13Accident · Serious injuriesClosedPiper PA-24 · Sula, MTNTSB SEA79FA031Accident · 2 fatalClosedBell 214B-1 · Darby, MTNTSB SEA79FTA12Accident · No injuriesClosedStinson 108-2 · Sidney, MTNTSB SEA79DTI12Accident · No injuriesClosedCessna 172 · Valier, MTNTSB SEA79DTI10Accident · No injuriesClosedCessna 188 · Carter, MTNTSB SEA79DTI09Accident · No injuriesClosedPiper PA-22 · Turner, MTNTSB SEA79FTA10Accident · No injuriesClosedPiper PA-18 · Terry, MTNTSB SEA79FA021Accident · 1 fatalClosedCessna T210P · Lavina, MTNTSB SEA79FTI08Accident · No injuriesClosedCessna 180K · Missoula, MTNTSB SEA79FTA09Accident · Serious injuriesClosedCessna 180 · Miles City, MTNTSB SEA79DTI07Accident · No injuriesClosedCessna 185E · Cut Bank, MTNTSB SEA79FTI06Accident · No injuriesClosedCessna 150L · Stevensville, MTNTSB SEA79DTA07Accident · No injuriesClosedCessna 150 · Scobey, MTNTSB SEA79FTA08Accident · No injuriesClosedBellanca 7GCBC · Sand Springs, MTNTSB SEA79FA018Accident · No injuriesClosedHandly-Page HP-137 · Missoula, MT