NTSB investigations, 1980, MT
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 1980
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") = 1980 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 DEN81DTI01Accident · Minor injuriesClosedCessna 172 · Cut Bank, MTNTSB DEN81DTA03Accident · No injuriesClosedPiper PA-18 · Saco, MTNTSB DEN81FTA02Accident · No injuriesClosedBeech V35B · Billings, MTNTSB DEN81FA007Accident · 3 fatalClosedBeech 65 · Sula, MTNTSB DEN80FA005Accident · 1 fatalClosedTaylorcraft BC12-D · St.Ignatius, MTNTSB DEN81FTA01Accident · No injuriesClosedHelio Acft H-250 · Baker, MTNTSB DEN80FTA23Accident · No injuriesClosedPiper PA-28 · Billings, MTNTSB SEA80FA048Accident · 2 fatalClosedCessna T210L · Dillon, MTNTSB DEN80DTI15Accident · No injuriesClosedCessna 180 · Raynesford, MTNTSB DEN80FTA21Accident · No injuriesClosedBell UH-1B · Red Lodge, MTNTSB DEN80FA059Accident · 3 fatalClosedBell 206A/B · Red Lodge, MTNTSB DEN80FTA20Accident · No injuriesClosedCessna 182 · Winifred, MTNTSB DEN80FA057Accident · 5 fatalClosedPiper PA-32 · Choteau, MTNTSB DEN80FTA19Accident · No injuriesClosedBeech 95-B55 · Miles City, MTNTSB DEN80FTA18Accident · Serious injuriesClosedPiper PA-25 · Sidney, MTNTSB DEN80FA053Accident · Minor injuriesClosedAerospatle 315B · Dell, MTNTSB DEN80FA051Accident · 1 fatalClosedAerospatle 315B · Dell, MTNTSB DEN80FTA17Accident · No injuriesClosedCessna 150 · Sidney, MTNTSB DEN80DTI13Accident · No injuriesClosedCessna 172 · Turner, MTNTSB DEN80DTI12Accident · No injuriesClosedCallair B-1A · Valier, MTNTSB DEN80FA048Accident · Serious injuriesClosedHiller Acft OH-23G · Cutbank, MTNTSB DEN80DTI14Accident · No injuriesClosedCessna 150 · Cut Bank, MTNTSB DEN80FTA16Accident · Serious injuriesClosedCallair A-9B · Bridger, MTNTSB DEN80FTA15Accident · No injuriesClosedBeech B-35 · Billings, MTNTSB DEN80FTI10Accident · No injuriesClosedPiper PA-30 · Great Falls, MTNTSB DEN80FTI08Accident · No injuriesClosedPiper PA-25 · Oilmont, MTNTSB DEN80FTI09Accident · No injuriesClosedCessna 182 · Monarch, MTNTSB DEN80FTA14Accident · No injuriesClosedPiper PA-34 · Billings, MTNTSB DEN80FA042Accident · 2 fatalClosedPiper PA-30 · Saltese, MTNTSB DEN80FA041Accident · 1 fatalClosedBellanca 7GCBC · Joplin, MTNTSB DEN80FTA13Accident · 1 fatalClosedGrumman G-164A · Sand Springs, MTNTSB DEN80DTI11Accident · No injuriesClosedCessna 140 · Lost Prairie, MTNTSB DEN80FTA12Accident · No injuriesClosedCessna 150 · Winnett, MTNTSB DEN80FA035Accident · 3 fatalClosedMooney 20F · Raynesford, MTNTSB DEN80FTI07Accident · No injuriesClosedCessna 188B · Havre, MTNTSB DEN80FTA22Accident · No injuriesClosedPiper PA-18 · Alzada, MTNTSB SEA80DTA11Accident · No injuriesClosedCallair A-9 · Bloomfield, MTNTSB SEA80FTA10Accident · No injuriesClosedGrumman G-164B · Billings, MTNTSB SEA80FTA09Accident · Minor injuriesClosedPiper PA-18 · Winifred, MTNTSB DEN80FA031Accident · 2 fatalClosedCessna 441 · Butte, MTNTSB SEA80FTI06Accident · No injuriesClosedPiper PA-24 · Havre, MTNTSB SEA80DTI05Accident · No injuriesClosedCessna A185F · Condon, MTNTSB SEA80FTA08Accident · No injuriesClosedCessna 180 · Big Timber, MTNTSB SEA80DTI04Accident · No injuriesClosedBellanca 7GCBC · Browning, MTNTSB SEA80DTI03Accident · No injuriesClosedPiper PA-28 · Missoula, MTNTSB SEA80FA015Accident · 4 fatalClosedPiper PA-28R · Kalispell, MT