NTSB investigations, 1977, MT
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 | 16 |
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\") = 1977
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") = 1977 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 SEA78FA015Accident · 2 fatalClosedGrum Amer AA-5A · Anaconda, MTNTSB SEA78DTI04Accident · No injuriesClosedPiper PA-18 · Livingston, MTNTSB SEA78FTA08Accident · Minor injuriesClosedBell 47G3B1 · Billings, MTNTSB SEA78DTI03Accident · No injuriesClosedCessna 170 · Browning, MTNTSB SEA78FTA09Accident · No injuriesClosedCessna 150 · Peerless, MTNTSB SEA78FTA07Accident · No injuriesClosedCessna TU206 · Zortman, MTNTSB SEA78DTA06Accident · No injuriesClosedCessna 182 · Baker, MTNTSB SEA78DTI01Accident · No injuriesClosedLuscombe 8AC · Boulder, MTNTSB SEA78FTA05Accident · No injuriesClosedGrum Amer AA5A · Billings, MTNTSB SEA77FTA04Accident · No injuriesClosedPiper PA-22 · Glendive, MTNTSB SEA78FTA03Accident · No injuriesClosedCessna 185 · Bay Horse, MTNTSB SEA78DTI02Accident · No injuriesClosedCessna 310G · Belgrade, MTNTSB SEA78FTA02Accident · Minor injuriesClosedCessna 210-5 · Lewistown, MTNTSB SEA77FTA01Accident · No injuriesClosedBellanca 8KCAB · Forsyth, MTNTSB SEA77DTI24Accident · No injuriesClosedCessna 120 · Chester, MTNTSB SEA77DTI23Accident · No injuriesClosedCessna 182G · Ledger, MTNTSB SEA77FTI22Accident · No injuriesClosedCessna 210D · W.Sulphur Spgs, MTNTSB SEA77DTI20Accident · Minor injuriesClosedCessna 170 · Ft.Benton, MTNTSB SEA77FTI19Accident · No injuriesClosedBell 47G3B2 · Missoula, MTNTSB SEA77FTA29Accident · Serious injuriesClosedPiper PA-18 · Wyola, MTNTSB SEA77FTA30Accident · No injuriesClosedPiper PA-28 · Miles City, MTNTSB SEA77DTI18Accident · No injuriesClosedCessna 180 · Cut Bank, MTNTSB SEA77FTA28Accident · No injuriesClosedMaule M4 · Hardin, MTNTSB SEA77FTI21Accident · No injuriesClosedCessna 150G · Helena, MTNTSB SEA77FTI17Accident · Serious injuriesClosedPiper PA-28 · St.Regis, MTNTSB SEA77FTA23Accident · No injuriesClosedBellanca 7CE · Baker, MTNTSB SEA77FTA27Accident · No injuriesClosedCessna 180 · Biddle, MTNTSB SEA77FTI16Accident · 2 fatalClosedCessna 150M · Helena, MTNTSB SEA77FTI15Accident · No injuriesClosedEnstrom 280C · Dillon, MTNTSB SEA77FTA26Accident · No injuriesClosedPiper PA-28 · Billings, MTNTSB SEA77FTA24Accident · No injuriesClosedCessna 140 · Jordan, MTNTSB SEA77FA041Accident · 1 fatalClosedPiper PA-18 · Glasgow, MTNTSB SEA77FTA25Accident · No injuriesClosedCessna T210M · Malta, MTNTSB SEA77FTA21Accident · No injuriesClosedPiper J3C-65 · Scobey, MTNTSB SEA77FA038Accident · 3 fatalClosedPiper PA-28 · Lavina, MTNTSB SEA77FTI14Accident · Minor injuriesClosedCessna 140 · Stevensville, MTNTSB SEA77FTA20Accident · No injuriesClosedCessna 206 · Billings, MTNTSB SEA77FTA19Accident · Minor injuriesClosedCessna 188 · Billings, MTNTSB SEA77FTA18Accident · No injuriesClosedPiper PA-25 · Brockway, MTNTSB SEA77FTA17Accident · No injuriesClosedBellanca 7GCBC · Opheim, MTNTSB SEA77DTI13Accident · Minor injuriesClosedPiper PA-18 · Chester, MTNTSB SEA77FTA22Accident · No injuriesClosedPiper PA-20 · Ismay, MTNTSB SEA77DTI12Accident · No injuriesClosedCessna 182A · Browning, MTNTSB SEA77FTA16Accident · No injuriesClosedPiper J3 · Otter, MTNTSB SEA78DA046Accident · 2 fatalClosedBeech 23 · Lewiston, MTNTSB SEA77FTI11Accident · Serious injuriesClosedBell 47G3B1 · Polson, MTNTSB SEA77FTA15Accident · No injuriesClosedBeech C-45H · Plentywood, MTNTSB SEA77FTI10Accident · No injuriesClosedPiper PA-28 · Gardiner, MTNTSB SEA77FTA14Accident · No injuriesClosedPiper PA-18 · Boyes, MTNTSB SEA77FTA13Accident · No injuriesClosedPiper PA-28 · Plentywood, MT