NTSB investigations, 1976, MT
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 | 16 |
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\" = '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") = 1976 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 SEA77FTA05Accident · No injuriesClosedCessna 170A · Ashland, MTNTSB SEA77DTI05Accident · No injuriesClosedPiper PA-22 · Seeley Lake, MTNTSB SEA77FTA04Accident · No injuriesClosedPiper PA-18A · Malta, MTNTSB SEA77DTA03Accident · No injuriesClosedLuscombe 8E · Hinsdale, MTNTSB SEA77DTI04Accident · No injuriesClosedCessna 170B · W.Sulphur Spgs, MTNTSB SEA77FA006Accident · 1 fatalClosedBellanca 7GCBC · Geyser, MTNTSB SEA77FTA02Accident · No injuriesClosedCessna 172B · Circle, MTNTSB SEA77FTI03Accident · No injuriesClosedCessna 180H · Dillon, MTNTSB SEA77FTI02Accident · No injuriesClosedCessna 172 · Whitefish, MTNTSB SEA77FTI01Accident · No injuriesClosedBell 47J-2 · Quake Lake, MTNTSB SEA77FA004Accident · 1 fatalClosedBeech A36 · Chester, MTNTSB SEA77FA003Accident · 1 fatalClosedBellanca 8KCAB · Billings, MTNTSB SEA76AS078Accident · 1 fatalClosedPiper PA-18 · Zurich, MTNTSB SEA76AS077Accident · 2 fatalClosedCessna A185F · Geraldine, MTNTSB SEA76FTI38Accident · 1 fatalClosedPiper PA-18A · Helena, MTNTSB SEA76FTA29Accident · Minor injuriesClosedCessna 185 · Ekalaka, MTNTSB SEA76DTI37Accident · Minor injuriesClosedPiper PA-28 · Turner, MTNTSB SEA76DTI36Accident · Minor injuriesClosedPiper PA-18 · Condon, MTNTSB SEA76DTA28Accident · No injuriesClosedPiper PA-28 · Powderville, MTNTSB SEA76AS067Accident · No injuriesClosedDehavilland DHC-6 · Havre, MTNTSB SEA76AS065Accident · 3 fatalClosedBeech S35 · Billings, MTNTSB SEA76FTA27Accident · Serious injuriesClosedCessna 170 · Fishtail, MTNTSB SEA76FTA26Accident · Serious injuriesClosedCessna 150L · Miles City, MTNTSB SEA76DTI34Accident · Serious injuriesClosedBellanca 7ECA · Alder, MTNTSB SEA76FTI33Accident · No injuriesClosedCessna 182 · Seeley Lake, MTNTSB SEA76AS064Accident · 1 fatalClosedPiper PA-28 · Butte, MTNTSB SEA76FTI35Accident · No injuriesClosedBeech 95-55 · Ennis, MTNTSB SEA76FTI32Accident · No injuriesClosedCessna 150D · Lincoln, MTNTSB SEA76AS062Accident · 4 fatalClosedCessna 182H · Kalispell, MTNTSB SEA76FTI31Accident · 2 fatalClosedPiper PA-18 · Helena, MTNTSB SEA76FTI30Accident · Minor injuriesClosedBellanca 7GCBC · Inverness, MTNTSB SEA76DTI29Accident · No injuriesClosedCallair A-9 · Pendroy, MTNTSB SEA77FTA01Accident · No injuriesClosedCessna 185 · Glasgow, MTNTSB SEA76DTA24Accident · No injuriesClosedAero Comdr 600S2R · Scobey, MTNTSB SEA76FTA25Accident · No injuriesClosedPiper PA-25 · Forsyth, MTNTSB SEA76FTA23Accident · No injuriesClosedCessna 205 · Fishtail, MTNTSB SEA76FTA22Accident · No injuriesClosedCessna 177 · Hardin, MTNTSB SEA76AS055Accident · 1 fatalClosedPiper PA-23 · Hamilton, MTNTSB SEA76DTA21Accident · No injuriesClosedCessna 172 · Harlowtown, MTNTSB SEA76AS052Accident · 2 fatalClosedPiper J3C-65 · Rock Springs, MTNTSB SEA76FTI27Accident · No injuriesClosedCessna 188B · Three Forks, MTNTSB SEA76IS046Incident · 1 fatalClosedDouglas DC-10 · Billings, MTNTSB SEA76FTI26Accident · Minor injuriesClosedCessna U206F · Deer Lodge, MTNTSB SEA76DTI25Accident · No injuriesClosedCessna 150 · Three Forks, MTNTSB SEA76DTI24Accident · No injuriesClosedCessna 210 · Stevensville, MTNTSB SEA76FTA20Accident · No injuriesClosedCessna 185 · Glendive, MTNTSB SEA76DTI28Accident · No injuriesClosedCessna A188B · Shelby, MTNTSB SEA76DTI23Accident · No injuriesClosedGrumman G-164A · Chester, MTNTSB SEA76FTA19Accident · Serious injuriesClosedCessna 150 · Shawmut, MTNTSB SEA76FTI22Accident · Minor injuriesClosedPiper PA-24 · Thompson Falls, MT