NTSB investigations, 1968, MT
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 1968
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") = 1968 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 SEA69D0153Accident · No injuriesClosedCessna 170 · St.Xavier, MTNTSB SEA69A0035Accident · 1 fatalClosedAero Comdr 500 · Glendive, MTNTSB SEA69F0168Accident · No injuriesClosedBell 206A · Missoula, MTNTSB SEA69D0170Accident · No injuriesClosedCessna 170B · Belgrade, MTNTSB SEA69A0032Accident · 3 fatalClosedAero Comdr 560-F · Wolf Creek, MTNTSB SEA69F0148Accident · No injuriesClosedCessna 150 · Belgrade, MTNTSB SEA69D0161Accident · No injuriesClosedAeronca 11CC · Frazer, MTNTSB SEA69F0150Accident · No injuriesClosedPiper PA-24 · Butte, MTNTSB SEA69F0142Accident · No injuriesClosedBeech F35 · Dillon, MTNTSB SEA69D0122Accident · Minor injuriesClosedBell 47G3B1 · Anaconda, MTNTSB SEA69F0104Accident · Minor injuriesClosedCessna 310B · W-Yellowstne, MTNTSB SEA69D0135Accident · No injuriesClosedCessna 180 · Miles City, MTNTSB SEA69F0121Accident · No injuriesClosedPiper J3C-65 · Chinook, MTNTSB SEA69A0014Accident · 1 fatalClosedCessna 140 · Busby, MTNTSB SEA69D0101Accident · No injuriesClosedCessna 180H · Boyes, MTNTSB SEA69F0098Accident · 2 fatalClosedTaylorcraft BC12-D · Winnett, MTNTSB SEA69F0094Accident · No injuriesClosedCessna 175 · Hamilton, MTNTSB SEA69D0123Accident · Minor injuriesClosedPiper PA-18 · Melville, MTNTSB SEA69F0053Accident · No injuriesClosedBeech A23-19 · Butte, MTNTSB SEA69D0108Accident · No injuriesClosedCessna 180 · Glendive, MTNTSB SEA68D0082Accident · No injuriesClosedCessna 182 · Kalispell, MTNTSB SEA69A0006Accident · Serious injuriesClosedLockheed 188C · Billings, MTNTSB SEA69A0005Accident · 5 fatalClosedBeech C35 · Tarkio, MTNTSB SEA69D0039Accident · No injuriesClosedPiaggio P-136 · Missoula, MTNTSB SEA69F0035Accident · 1 fatalClosedBoeing A75 · Boyd, MTNTSB SEA69D0026Accident · No injuriesClosedPiper PA-28 · Chinook, MTNTSB SEA69F0041Accident · No injuriesClosedMaule M4-210 · Kalispel, MTNTSB SEA69D0034Accident · No injuriesClosedBoeing A75N1 · Wilsall, MTNTSB SEA69F0059Accident · No injuriesClosedCessna 182A · Anaconda, MTNTSB SEA69D0029Accident · No injuriesClosedPiper PA-11 · Fairview, MTNTSB SEA69F0003Accident · No injuriesClosedPiper PA-11 · Zurich, MTNTSB SEA69F0006Accident · No injuriesClosedPiper PA-22 · Belgrade, MTNTSB SEA68F0315Accident · No injuriesClosedPiper PA-25 · Cut Bank, MTNTSB SEA68I0070Incident · No injuriesClosedCessna 402 · Libby, MTNTSB SEA68F0319Accident · No injuriesClosedPiper PA-25 · Santa Rita, MTNTSB SEA68D0313Accident · Minor injuriesClosedPiper PA-11 · Wolf Point, MTNTSB SEA68F0314Accident · No injuriesClosedPiper PA-25 · Townsend, MTNTSB SEA68A0067Accident · 1 fatalClosedCessna 120 · Monida, MTNTSB SEA68D0310Accident · No injuriesClosedBell 47G3B1 · Jackson, MTNTSB SEA68F0321Accident · No injuriesClosedBeech P35 · Great Falls, MTNTSB SEA68F0312Accident · No injuriesClosedSnow S2A · Billings, MTNTSB SEA68F0300Accident · Serious injuriesClosedAlon A-2 · Billings, MTNTSB SEA68F0298Accident · No injuriesClosedCessna 180 · Billings, MTNTSB SEA68A0066Accident · 3 fatalClosedCessna 175 · Cascade, MTNTSB SEA68D0306Accident · No injuriesClosedCessna 206 · Livingston, MTNTSB SEA68D0275Accident · No injuriesClosedPiper PA-22 · Miles City, MTNTSB SEA68F0301Accident · No injuriesClosedCessna 172 · Hammond, MTNTSB SEA68D0291Accident · Minor injuriesClosedPiper PA-18 · Great Falls, MTNTSB SEA68D0265Accident · No injuriesClosedChampion 7GCBC · Maxville, MTNTSB SEA68A0061Accident · 2 fatalClosedCessna 182 · Polson, MT