NTSB investigations, 1972, MT
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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\") = 1972
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") = 1972 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 SEA73DTA04Accident · No injuriesClosedPiper PA-18 · Outlook, MTNTSB SEA73FTI16Accident · No injuriesClosedCessna 175B · Great Falls, MTNTSB SEA73AS014Accident · 2 fatalClosedBeech H35 · Lolo, MTNTSB SEA73FTA03Accident · No injuriesClosedPiper PA-18 · Sand Springs, MTNTSB SEA73FT115Accident · Minor injuriesClosedPiper PA-18 · Augusta, MTNTSB SEA73AS011Accident · 2 fatalClosedCessna 182A · Ennis, MTNTSB SEA73AS010Accident · 3 fatalClosedCessna 182P · Corwin Spgs, MTNTSB SEA73FTI14Accident · Minor injuriesClosedMooney M20F · Lincoln, MTNTSB SEA73FTI13Accident · No injuriesClosedCessna 421 · Kalispell, MTNTSB SEA73FTA02Accident · No injuriesClosedCessna 150F · Miles City, MTNTSB SEA73FT112Accident · No injuriesClosedCessna 170A · Livingston, MTNTSB SEA73DTI11Accident · No injuriesClosedCessna 172 · Saco, MTNTSB SEA73FTI09Accident · No injuriesClosedMooney M20C · Harlem, MTNTSB SEA73FTI08Accident · Minor injuriesClosedTaylorcraft BC12-D · Whitefish, MTNTSB SEA73FTI07Accident · No injuriesClosedMooney M20E · Anaconda, MTNTSB SEA73FTI05Accident · Minor injuriesClosedPiper PA-18 · Deer Lodge, MTNTSB SEA73FTI04Accident · No injuriesClosedPiper PA-20 · Great Falls, MTNTSB SEA73DTI10Accident · No injuriesClosedCessna 182 · Eureka, MTNTSB SEA73FTI03Accident · No injuriesClosedPiper PA-28 · Twin Bridges, MTNTSB SEA73DTI02Accident · No injuriesClosedCessna 172 · Rudyard, MTNTSB SEA73FTA01Accident · No injuriesClosedRobertson 180H · Wyola, MTNTSB SEA73FTI01Accident · Minor injuriesClosedBell 206A · Paradise, MTNTSB SEA72FTA18Accident · No injuriesClosedPiper PA-18 · Laurel, MTNTSB SEA72DTI24Accident · No injuriesClosedPiper PA-18 · Virginia Cty, MTNTSB SEA72FTI23Accident · No injuriesClosedCessna 180 · Anaconda, MTNTSB SEA72FTI22Accident · No injuriesClosedBellanca 7GCBC · Hogeland, MTNTSB SEA72FTI20Accident · No injuriesClosedCessna 180 · Shelby, MTNTSB SEA72FTI21Accident · No injuriesClosedTailwind Dower · Butte, MTNTSB SEA72FTI19Accident · No injuriesClosedCessna 172H · Drummond, MTNTSB SEA72FTI18Accident · No injuriesClosedPiper PA-30 · Thmpson Flls, MTNTSB SEA72DT117Accident · No injuriesClosedPiper PA-18 · Plains, MTNTSB SEA72FTA17Accident · No injuriesClosedBell 47G-3B · Harlowton, MTNTSB SEA72FTA16Accident · Minor injuriesClosedCessna 172 · Roberts, MTNTSB SEA72AS046Accident · 2 fatalClosedAero Comdr 500 · Noxon, MTNTSB SEA72AS042Accident · 2 fatalClosedPiper PA-24 · Ronan, MTNTSB SEA72DTA14Accident · Minor injuriesClosedPiper PA-25 · Brusett, MTNTSB SEA72FTI16Accident · No injuriesClosedCessna 206 · Conner, MTNTSB SEA72FTI15Accident · No injuriesClosedCessna 310G · Great Falls, MTNTSB SEA72FTA15Accident · No injuriesClosedCessna 150J · Ashland, MTNTSB SEA72FTA13Accident · Minor injuriesClosedStinson 108-3 · Red Lodge, MTNTSB SEA72DTI14Accident · No injuriesClosedPiper PA-18A · Conrad, MTNTSB SEA72DTA12Accident · No injuriesClosedCessna 140 · Glendive, MTNTSB SEA72FTA11Accident · No injuriesClosedCessna 140 · Hardin, MTNTSB SEA72DTI13Accident · No injuriesClosedMooney M20E · Great Falls, MTNTSB SEA72DTI10Accident · No injuriesClosedAeronca 7EC · Malta, MTNTSB SEA72FTI11Accident · No injuriesClosedCessna 172 · Kalispell, MT