NTSB investigations, 1969, 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\") = 1969
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") = 1969 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 SEA70D0141Accident · No injuriesClosedCessna 175 · Ryegate, MTNTSB SEA70A0026Accident · 4 fatalClosedCessna 180 · Conrad, MTNTSB SEA70F0126Accident · No injuriesClosedBeech J35 · Billings, MTNTSB SEA70D0124Accident · No injuriesClosedMaule M-4 · Great Falls, MTNTSB SEA70D0153Accident · No injuriesClosedCessna 172D · Malta, MTNTSB SEA70D0113Accident · No injuriesClosedCessna 182 · Broadus, MTNTSB SEA70A0014Accident · 1 fatalClosedCessna 320A · Conner, MTNTSB DEN70A0024Accident · 1 fatalClosedCessna 175 · Eureka, MTNTSB SEA70D0103Accident · No injuriesClosedCessna 150 · Broadus, MTNTSB SEA70D0088Accident · Minor injuriesClosedCessna 182J · Neihart, MTNTSB SEA70F0094Accident · Serious injuriesClosedCessna 185 · Helena, MTNTSB SEA70D0092Accident · No injuriesClosedCessna 150J · Augusta, MTNTSB SEA70D0079Accident · No injuriesClosedBell 47G-3 · Circle, MTNTSB SEA70F0066Accident · No injuriesClosedCessna 120 · Helena, MTNTSB SEA70F0078Accident · No injuriesClosedBeech A23-24 · Belgrade, MTNTSB SEA70F0076Accident · No injuriesClosedCessna 195 · Three Forks, MTNTSB DEN70A0013Accident · 1 fatalClosedCessna 182L · Bridger, MTNTSB SEA70D0059Accident · No injuriesClosedPiper PA-22 · Rapelje, MTNTSB SEA70F0056Accident · No injuriesClosedHiller Acft UH-12B · Billings, MTNTSB SEA70A0008Accident · 3 fatalClosedBeech D95A · Livingston, MTNTSB SEA70D0058Accident · No injuriesClosedCessna 140A · Hingham, MTNTSB SEA70F0027Accident · No injuriesClosedCessna 180 · Birney, MTNTSB SEA70D0047Accident · No injuriesClosedBeech C35 · Belgrade, MTNTSB SEA70F0042Accident · No injuriesClosedMaule M-4 · Kalispell, MTNTSB SEA70F0018Accident · No injuriesClosedBrantly B-2 · Helena, MTNTSB SEA70F0029Accident · No injuriesClosedWills BW-9 · Bigfork, MTNTSB SEA70A0001Accident · 2 fatalClosedMooney M20E · Helena, MTNTSB SEA70F0031Accident · Minor injuriesClosedTaylorcraft BC12-D · Kalispell, MTNTSB SEA70D0021Accident · No injuriesClosedCessna 150 · Shonkin, MTNTSB SEA70F0037Accident · No injuriesClosedPiper PA-22 · Forsyth, MTNTSB DEN69A0053Accident · 4 fatalClosedCessna 182C · Great Falls, MTNTSB SEA70F0017Accident · Serious injuriesClosedBell 47G-3 · Deer Lodge, MTNTSB SEA70F0013Accident · Serious injuriesClosedCallair A-9 · Great Falls, MTNTSB SEA69D0263Accident · No injuriesClosedCessna 180 · Livingston, MTNTSB SEA69F0254Accident · No injuriesClosedCessna 180A · Harrison, MTNTSB SEA69F0250Accident · No injuriesClosedCallair A-9 · St.Xavier, MTNTSB SEA69F0253Accident · 1 fatalClosedPiper PA-24 · Plains, MTNTSB SEA69F0248Accident · No injuriesClosedCessna 150F · Malta, MTNTSB SEA69F0237Accident · No injuriesClosedCessna 210 · Butte, MTNTSB SEA69F0217Accident · No injuriesClosedBrantly B-2B · Lodge Grass, MTNTSB SEA69F0249Accident · 1 fatalClosedPiper PA-25 · Geraldine, MTNTSB SEA69F0203Accident · No injuriesClosedHughes 269B · Missoula, MTNTSB SEA69F0251Accident · Serious injuriesClosedMooney M20F · Melville, MTNTSB SEA69F0236Accident · No injuriesClosedErco 415-C · Kalispell, MTNTSB SEA69F0204Incident · No injuriesClosedCessna 150 · W Yellwstone, MTNTSB SEA69A0049Accident · 3 fatalClosedCessna 175 · Four Buttes, MTNTSB SEA69D0209Accident · No injuriesClosedCessna 180 · Choteau, MTNTSB SEA69D0211Accident · No injuriesClosedCessna 140A · Poplar, MTNTSB SEA69D0186Accident · No injuriesClosedPiper PA-28 · Chester, MTNTSB SEA69D0210Accident · No injuriesClosedPiper PA-23 · Great Falls, MT