NTSB investigations, 1966, MT
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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\") = 1966
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") = 1966 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 SEA67A0044Accident · 2 fatalClosedMooney M20E · Wolf Creek, MTNTSB SEA67D0272Accident · No injuriesClosedChampion 7GCB · Great Falls, MTNTSB SEA67D0266Accident · No injuriesClosedAeronca 7AC · Circle, MTNTSB SEA67A0043Accident · No injuriesClosedBrantly B-2B · Wyola, MTNTSB SEA67D0219Accident · No injuriesClosedBeech A23-19 · Billings, MTNTSB SEA67A0039Accident · 5 fatalClosedCessna 172G · Chinook, MTNTSB SEA67D0191Accident · No injuriesClosedPiper PA-18 · Rudyard, MTNTSB SEA67D0221Accident · Serious injuriesClosedAeronca 7AC · Capitol, MTNTSB SEA67F0193Accident · No injuriesClosedPiper PA-30 · Billings, MTNTSB CHI67A0064Accident · Serious injuriesClosedBoeing B-720 · Billings, MTNTSB SEA67D0194Accident · No injuriesClosedCessna 180 · Swan Lake, MTNTSB SEA67D0192Accident · No injuriesClosedBeech 35 · Thom Falls, MTNTSB SEA67D0195Accident · No injuriesClosedStinson 108-3 · Malta, MTNTSB SEA67D0186Accident · No injuriesClosedPiper PA-28 · Billings, MTNTSB SEA67D0165Accident · No injuriesClosedCessna 172 · Chinook, MTNTSB SEA67D0169Accident · No injuriesClosedPiper PA-22 · Square Butte, MTNTSB SEA67D0168Accident · No injuriesClosedMooney M20B · W S Springs, MTNTSB SEA67A0027Accident · 2 fatalClosedBell 47G3B1 · W.Yellowston, MTNTSB SEA67A0026Accident · 4 fatalClosedPiper PA-28 · Alberton, MTNTSB SEA67A0025Accident · No injuriesClosedBell 47G-3 · Noxon, MTNTSB SEA67D0144Accident · No injuriesClosedPiper PA-18 · Dillon, MTNTSB SEA67D0167Accident · No injuriesClosedCessna 185 · Great Falls, MTNTSB SEA67D0120Accident · No injuriesClosedCessna 140 · Great Falls, MTNTSB SEA67D0185Accident · No injuriesClosedStinson 108-2 · Laurel, MTNTSB SEA67F0129Accident · Minor injuriesClosedPiper PA-12 · Thomp. Falls, MTNTSB SEA67F0111Accident · No injuriesClosedCessna 182 · Dupuyer, MTNTSB SEA67D0120Accident · No injuriesClosedBeech 35 · Libby, MTNTSB SEA67D0138Accident · No injuriesClosedPiper PA-18 · Stevensville, MTNTSB SEA67D0132Accident · Minor injuriesClosedCessna 172 · Dutton, MTNTSB SEA67F0133Accident · No injuriesClosedStinson 108-3 · Hamilton, MTNTSB SEA67D0110Accident · No injuriesClosedCessna 150F · Belgrade, MTNTSB SEA67D0108Accident · No injuriesClosedCessna 180 · Conrad, MTNTSB SEA67F0107Accident · No injuriesClosedPiper PA-18 · Zortman, MTNTSB SEA67D0139Accident · No injuriesClosedStearman PT-17 · Big Horn, MTNTSB SEA67F0077Accident · No injuriesClosedPiper PA-24 · Laurel, MTNTSB SEA67D0102Accident · No injuriesClosedCessna 180 · W.Yellowstone, MTNTSB SEA67F0086Accident · Minor injuriesClosedPiper PA-22 · Eurek, MTNTSB SEA67D0100Accident · No injuriesClosedCessna 210 · Polson, MTNTSB SEA67F0078Accident · 1 fatalClosedLuscombe 8A · Chinook, MTNTSB SEA67F0054Accident · No injuriesClosedPiper PA-25 · Winifred, MTNTSB SEA67D0092Accident · No injuriesClosedGrumman TBM-3E · Potomac, MTNTSB SEA67D0081Accident · No injuriesClosedPiper PA-18 · Neihart, MTNTSB SEA67F0148Accident · No injuriesClosedPiper PA-18 · Molt, MTNTSB SEA67D0035Accident · No injuriesClosedPiper PA-28 · Butte, MTNTSB SEA67D0075Accident · No injuriesClosedMorrisey 2150 · Babb, MTNTSB SEA67A0002Accident · Serious injuriesClosedBell 47-G3B · Clinton, MTNTSB SEA67A0004Accident · 1 fatalClosedCessna 172B · Roy, MTNTSB SEA67D0055Accident · No injuriesClosedCessna 172 · Kalispell, MTNTSB SEA66A0072Accident · Minor injuriesClosedBell 47G3B1 · Livingston, MTNTSB SEA67D0142Accident · No injuriesClosedChampion 7ECA · Lewistown, MT