NTSB investigations, 1971, 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\") = 1971
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") = 1971 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 SEA72DTI12Accident · No injuriesClosedCessna 172G · Loma, MTNTSB SEA72AS021Accident · 2 fatalClosedMooney M20C · Broadus, MTNTSB SEA72AS019Accident · 1 fatalClosedCessna 150L · Ulm, MTNTSB SEA72DTA10Accident · No injuriesClosedLuscombe 8E · Volborg, MTNTSB SEA72FTI09Accident · Serious injuriesClosedCessna 150 · Chinook, MTNTSB SEA72FTA09Accident · No injuriesClosedCessna 170B · Billings, MTNTSB SEA72DTI08Accident · Serious injuriesClosedMooney M20C · Great Falls, MTNTSB SEA72DTI07Accident · No injuriesClosedCessna 320 · Philipsburg, MTNTSB SEA72FTA07Accident · No injuriesClosedPiper PA-23 · Harlowton, MTNTSB SEA72DTI05Accident · No injuriesClosedDehavilland DH 104 · Chester, MTNTSB SEA72DTI06Accident · No injuriesClosedCessna 337E · Livingston, MTNTSB SEA72DTA08Accident · No injuriesClosedHughes 369HS · Mosby, MTNTSB SEA72DTI04Accident · No injuriesClosedCessna 177 · Drummond, MTNTSB SEA72FTA05Accident · No injuriesClosedCessna 150 · Sand Springs, MTNTSB SEA72FTI03Accident · No injuriesClosedCessna 180 · Helena, MTNTSB SEA72FTA02Accident · No injuriesClosedCallair A-9 · Laurel, MTNTSB SEA72FTA04Accident · No injuriesClosedMaule M-4 · Wolf Point, MTNTSB SEA72FTA03Accident · No injuriesClosedCessna 172 · Miles City, MTNTSB SEA72DTI02Accident · No injuriesClosedAeronca 7AC · Conrad, MTNTSB SEA72FTA01Accident · No injuriesClosedCessna 180D · Lodge Grass, MTNTSB SEA72FTI01Accident · No injuriesClosedCessna 421B · Ennis, MTNTSB SEA71FTA23Accident · No injuriesClosedCallair A-9 · Opheim, MTNTSB SEA71DTA24Accident · No injuriesClosedPiper PA-11 · Alzada, MTNTSB SEA71FTI38Accident · 1 fatalClosedPiper PA-18 · Turner, MTNTSB SEA71DTI39Accident · No injuriesClosedLuscombe T-8F · Chinook, MTNTSB SEA71FTI37Accident · No injuriesClosedCessna A188A · Havre, MTNTSB SEA71FTI36Accident · Minor injuriesClosedCallair A-5 · Havre, MTNTSB SEA71FTI35Accident · No injuriesClosedChampion 7AC · Belgrade, MTNTSB SEA71DTI34Accident · No injuriesClosedCessna 182F · Shelby, MTNTSB SEA71FTA22Accident · No injuriesClosedBeech A23-19 · Terry, MTNTSB SEA71FTI33Accident · Minor injuriesClosedCessna 140 · Butte, MTNTSB SEA71DTI32Accident · No injuriesClosedPiper PA-28 · Belgrade, MTNTSB SEA71DTI31Accident · No injuriesClosedPiper PA-18 · Gallatin Gwy, MTNTSB SEA71FTA21Accident · No injuriesClosedCessna 150J · Sidney, MTNTSB SEA71FTA19Accident · 1 fatalClosedPitts Spec SC-1 · Lewiston, MTNTSB SEA71DTI30Accident · No injuriesClosedCessna 175 · Havre, MTNTSB SEA71FTI29Accident · No injuriesClosedCessna 150F · Libby, MTNTSB SEA71FTA20Accident · No injuriesClosedCessna 170B · Brusett, MTNTSB SEA71FDG28Accident · No injuriesClosedPiper PA-18 · Hamilton, MTNTSB SEA71FDA18Accident · No injuriesClosedCessna A188 · Joliet, MTNTSB SEA71AS040Accident · 4 fatalClosedLear Jet 24D · Butte, MTNTSB SEA71FDG27Accident · No injuriesClosedMooney M20C · Santa Rita, MTNTSB SEA71FDG26Accident · No injuriesClosedCessna 150 · Plains, MTNTSB SEA71FTA06Accident · No injuriesClosedTaylorcraft BC12-D · Baker, MTNTSB SEA71FDG25Accident · No injuriesClosedBellanca 14-19 · Butte, MTNTSB SEA71FDA16Accident · No injuriesClosedCessna 182N · Hysham, MTNTSB SEA71FDA15Accident · No injuriesClosedStinson 108-2 · Alzada, MTNTSB SEA71FDA17Accident · No injuriesClosedPiper PA-11 · Alzada, MTNTSB SEA71FDA14Accident · No injuriesClosedCessna 310C · Miles City, MTNTSB SEA71DDG24Accident · No injuriesClosedCessna 177 · Great Falls, MT