NTSB investigations, 1973, 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\") = 1973
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") = 1973 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 SEA74FTA15Accident · No injuriesClosedCessna 150 · Belle Creek, MTNTSB SEA74DTI15Accident · No injuriesClosedPiper PA-22 · Hogeland, MTNTSB SEA74DTI14Accident · No injuriesClosedBell 47G-3 · Missoula, MTNTSB SEA74DTA14Accident · No injuriesClosedPiper J-3 · Culbertson, MTNTSB SEA74FTA13Accident · No injuriesClosedCessna 172H · Forsyth, MTNTSB SEA74DTI13Accident · No injuriesClosedStinson 108-2 · Plains, MTNTSB SEA74DTI12Accident · No injuriesClosedPiper PA-22 · Martinsdale, MTNTSB SEA74FTI11Accident · Minor injuriesClosedCessna 182 · Bozeman, MTNTSB SEA74FTI10Accident · No injuriesClosedCallair A-2 · Anaconda, MTNTSB SEA74FTA11Accident · No injuriesClosedCessna 185E · Custer, MTNTSB SEA74AS018Accident · 8 fatalClosedCessna 402B · Utica, MTNTSB SEA74DTA10Accident · No injuriesClosedBellanca 7GCA · Lodge Pole, MTNTSB SEA74DTA09Accident · No injuriesClosedCessna 170B · Glasgow, MTNTSB SEA74DTA08Accident · No injuriesClosedCessna 175A · Willard, MTNTSB SEA74AS015Accident · 2 fatalClosedAerostar M20F · St Xavier, MTNTSB SEA74FTA07Accident · Minor injuriesClosedBell 206B · Lewistown, MTNTSB SEA74DTI09Accident · No injuriesClosedCessna 182 · Missoula, MTNTSB SEA74FTI08Accident · No injuriesClosedBell 205-A1 · Thompson Fls, MTNTSB SEA74AS006Accident · Serious injuriesClosedBoeing 737 · Missoula, MTNTSB SEA74FTA06Accident · Serious injuriesClosedCessna 140 · Ekalaka, MTNTSB SEA74D7A05Accident · No injuriesClosedPiper PA-22 · Birney, MTNTSB SEA74FTA04Accident · No injuriesClosedCessna 185 · Billings, MTNTSB SEA74FTI07Accident · No injuriesClosedSchweizer 2-33 · Belgrade, MTNTSB SEA74DTI06Accident · No injuriesClosedCessna 195A · Heart Butte, MTNTSB SEA74FTA03Accident · No injuriesClosedPiper PA-24 · Harlowton, MTNTSB SEA74FTA02Accident · No injuriesClosedPiper PA-28 · Flaxville, MTNTSB SEA74DTI05Accident · No injuriesClosedCessna 180 · Kalispell, MTNTSB SEA74DTI04Accident · No injuriesClosedCessna 172 · Chester, MTNTSB SEA74FTA01Accident · No injuriesClosedPitts S1C · Miles City, MTNTSB SEA74DTI03Accident · No injuriesClosedCessna 172 · Libby, MTNTSB SEA74DTI02Accident · No injuriesClosedPiper PA-12 · Ennis, MTNTSB SEA74FTI01Accident · Serious injuriesClosedPiper PA-25 · Glen, MTNTSB DEN73AD057Accident · Serious injuriesClosedBoeing 737 · W.Yellowstne, MTNTSB SEA73FTI23Accident · Serious injuriesClosedPiper PA-25 · Belgrade, MTNTSB SEA73AS041Accident · 1 fatalClosedGlasflugel Libell · Choteau, MTNTSB SEA73FTI22Accident · No injuriesClosedPiper PA-25 · Belgrade, MTNTSB SEA73FTA09Accident · No injuriesClosedCessna 172 · Malta, MTNTSB SEA73FTA08Accident · No injuriesClosedCessna 210 · Ekalaka, MTNTSB SEA73FTI21Accident · 1 fatalClosedCessna 188 · Rudyard, MTNTSB SEA73FTA07Accident · 1 fatalClosedBell 47G-3 · Moore, MTNTSB SEA73FTI20Accident · No injuriesClosedBell 47G3B1 · Dayton, MTNTSB SEA73AS033Accident · 2 fatalClosedAmer Avco AA-1B · W.Yellowstne, MTNTSB SEA73FTA06Accident · No injuriesClosedBell 47G-3B · Billings, MTNTSB SEA73FTI19Accident · No injuriesClosedPiper PA-22 · Garrison, MTNTSB SEA73FTA05Accident · No injuriesClosedBellanca 7GCBC · Hammon, MTNTSB SEA73AS029Accident · 2 fatalClosedAeronca 15AC · Summit, MTNTSB SEA73DTI18Accident · No injuriesClosedPiper PA-18A · Cut Bank, MTNTSB SEA73DT117Accident · No injuriesClosedPiper PA-18 · Jackson, MTNTSB SEA73AS021Accident · 1 fatalClosedBellanca 7GCBC · Brockway, MT