NTSB investigations, 1964, 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\") = 1964
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") = 1964 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 UNK65X1176Accident · 2 fatalClosedPiper PA-28 · Terry, MTNTSB UNK65X1143Accident · No injuriesClosedPiper PA28 · Great Falls, MTNTSB UNK65X1107Accident · No injuriesClosedPiper PA18 · Alzada, MTNTSB UNK65X0758Accident · No injuriesClosedPiper PA-30 · Miles City, MTNTSB UNK65X0738Accident · No injuriesClosedPiper PA28 · Great Falls, MTNTSB UNK65X0737Accident · No injuriesClosedCessna 172 · Ashland, MTNTSB UNK65X0718Accident · No injuriesClosedPiper J3C · Billings, MTNTSB UNK65X0716Accident · No injuriesClosedCessna 172 · Saco, MTNTSB UNK65X0713Accident · No injuriesClosedMooney M21 · Plentywood, MTNTSB UNK65X0708Accident · Minor injuriesClosedCessna 182 · Belt, MTNTSB UNK65X0691Accident · 1 fatalClosedCessna 170B · Roberts, MTNTSB UNK65X0467Accident · 1 fatalClosedMaule M-4 · Townsend, MTNTSB UNK65X0464Accident · No injuriesClosedStinson 108-3 · Glacier, MTNTSB UNK65X0431Accident · No injuriesClosedCessna 172D · Broadus, MTNTSB UNK65X0344Accident · No injuriesClosedBell 47G3 · Stevensville, MTNTSB UNK65X0309Accident · 4 fatalClosedCessna 185B · Augusta, MTNTSB UNK65X0109Accident · No injuriesClosedCessna 175 · Great Falls, MTNTSB UNK64X4215Accident · No injuriesClosedCessna 172D · Helena, MTNTSB UNK64X4198Accident · No injuriesClosedPiper PA28 · Winfred, MTNTSB UNK64X4016Accident · No injuriesClosedCessna 190 · Ennis, MTNTSB UNK64X3938Accident · No injuriesClosedPiper PA22 · Kremlin, MTNTSB UNK64X3712Accident · No injuriesClosedPiper PA12 · Belgrade, MTNTSB UNK64X3611Accident · 4 fatalClosedPiper PA-30 · Choteau, MTNTSB UNK64X3483Accident · No injuriesClosedCessna 180 · Baker, MTNTSB UNK64X3464Accident · No injuriesClosedMaule M4 · Hysham, MTNTSB UNK64X3426Accident · No injuriesClosedBeechcraft 35 · Kalispell, MTNTSB UNK64X3380Accident · No injuriesClosedAeronca 7DC · Sand Springs, MTNTSB UNK64X3196Accident · No injuriesClosedCessna 140 · Medicine Lke, MTNTSB UNK64X3131Accident · No injuriesClosedErcoupe 415C · Fishtail, MTNTSB UNK64X3053Accident · No injuriesClosedCessna 170B · Billings, MTNTSB UNK64X2962AccidentClosedPiper PA12 · Yellowstone, MTNTSB UNK64X2905Accident · No injuriesClosedCessna 180 · Choteau, MTNTSB UNK64X2847Accident · Minor injuriesClosedLuscombe 8A · Lookout Pass, MTNTSB UNK64X2834Accident · 1 fatalClosedChampion 7CCM · Flaxville, MTNTSB UNK64X2781Accident · 1 fatalClosedPiper PA-24 · W Yellowstone, MTNTSB UNK64X2740Accident · Serious injuriesClosedCessna 182 · Roscoe, MTNTSB UNK64X2716Accident · No injuriesClosedPiper PA18 · Ryegate, MTNTSB UNK64X2598Accident · No injuriesClosedPiper PA22 · Baker, MTNTSB UNK64X2500Accident · No injuriesClosedBeechcraft D18S · Hardin, MTNTSB UNK64X2260Accident · No injuriesClosedCessna 170 · Red Lodge, MTNTSB UNK64X2246Accident · Minor injuriesClosedTaylorcraft BC12D · Poplar, MTNTSB UNK64X2210Accident · No injuriesClosedBell 47G3 · Yack Flats, MTNTSB UNK64X2200Accident · No injuriesClosedCessna 182D · Schafer, MTNTSB UNK64X2144Accident · No injuriesClosedBeechcraft D35 · Terry, MTNTSB UNK64X2105Accident · Minor injuriesClosedPiper PA18A · Geraldine, MTNTSB UNK64X2053Accident · No injuriesClosedStinson 108 · Anaconda, MTNTSB UNK64X2049Accident · No injuriesClosedCessna 170B · Poplar, MTNTSB UNK64X2036Accident · No injuriesClosedMaule M-4 · Culbertson, MTNTSB UNK64X2032Accident · No injuriesClosedPiper PA18 · Malta, MTNTSB UNK64X2004Accident · No injuriesClosedPiper J3 · Winifred, MT