Skip to content

NTSB investigations, 1974, MT

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19632026

NTSB investigations, 1974, MT per year, 1963–2026: 2,224 cases
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

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") = 1974 AND c."eventStateOrRegion" = 'MT' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\") = 1974
    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") = 1974
  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 SEA75FTI16Accident · Serious injuriesClosedPiper PA-24 · Butte, MTDec 9, 1974 · N6916P · Substantial damage NTSB SEA75FTA14Accident · No injuriesClosedPiper PA-18 · Hardin, MTDec 4, 1974 · N8109Y · Substantial damage NTSB SEA75FTA11Accident · No injuriesClosedCessna 210F · Ballatine, MTDec 1, 1974 · N5812F · Substantial damage NTSB SEA75DTI14Accident · No injuriesClosedStinson 108-2 · Wisdom, MTOct 27, 1974 · N9815K · Substantial damage NTSB SEA75FTI13Accident · Minor injuriesClosedPiper PA-22 · Victor, MTOct 9, 1974 · N1218C · Substantial damage NTSB SEA75FTA10Accident · Serious injuriesClosedCallair A-9 · Glendive, MTOct 9, 1974 · N9650Z · Substantial damage NTSB SEA75FTI11Accident · No injuriesClosedCessna 182 · Harve, MTSep 24, 1974 · N182F · Substantial damage NTSB SEA75FTA09Accident · No injuriesClosedCessna 180D · Circle, MTSep 15, 1974 · N6421X · Substantial damage NTSB SEA75DTI10Accident · No injuriesClosedCessna 180 · Hingham, MTSep 6, 1974 · N42359 · Substantial damage NTSB SEA75FTA08Accident · No injuriesClosedChampion 7GCAA · Carlyle, MTSep 4, 1974 · N8319V · Substantial damage NTSB SEA75FTA07Accident · No injuriesClosedCallair A-9 · Pryor, MTSep 3, 1974 · N3566G · Substantial damage NTSB SEA75DTI08Accident · No injuriesClosedChampion 7GCB · Kalispell, MTSep 3, 1974 · N9822Y · Substantial damage NTSB SEA75DTI09Accident · No injuriesClosedTaylorcraft BC12-D · Kalispell, MTSep 2, 1974 · N44286 · Substantial damage NTSB SEA75AS012Accident · 2 fatalClosedChampion 7GC · Florence, MTAug 31, 1974 · N8092E · Destroyed NTSB SEA75FTA06Accident · Serious injuriesClosedPiper PA-11 · Hammond, MTAug 19, 1974 · N4992H · Substantial damage NTSB SEA75 TI05Accident · No injuriesClosedPiper PA-18 · Big Fork, MTAug 6, 1974 · N3920Z · Substantial damage NTSB SEA74DTI06Accident · No injuriesClosedCessna 180 · Ferndale, MTAug 4, 1974 · N5067E · Substantial damage NTSB SEA75DTI04Accident · No injuriesClosedCessna 182 · Chinook, MTJul 27, 1974 · N2506G · Destroyed NTSB SEA75FTI03Accident · Serious injuriesClosedBellanca 7GCBC · Hogeland, MTJul 26, 1974 · N9183L · Destroyed NTSB SEA75FTA05Accident · No injuriesClosedGrumman G-164 · Baker, MTJul 25, 1974 · N664U · Substantial damage NTSB SEA75FTI02Accident · Serious injuriesClosedMooney M20F · Meadow Creek, MTJul 23, 1974 · N6428Q · Substantial damage NTSB SEA75AS005Accident · No injuriesClosedCessna U206E · Darby, MTJul 22, 1974 · N9420G · Substantial damage NTSB SEA75FTA04Accident · No injuriesClosedCessna 150 · Crane, MTJul 19, 1974 · N6484G · Substantial damage NTSB SEA75DTA03Accident · No injuriesClosedPiper PA-18 · Ft.Peck, MTJul 18, 1974 · N5775D · Substantial damage NTSB SEA75FTA02Accident · No injuriesClosedMooney M20D · Glasgow, MTJul 15, 1974 · N6619U · Substantial damage NTSB SEA75DTI01Accident · No injuriesClosedHiller Acft FH1100 · Glacier Park, MTJul 15, 1974 · N711KH · Substantial damage NTSB SEA75FTA01Accident · No injuriesClosedPiper PA-18 · Malta, MTJul 5, 1974 · N2625A · Substantial damage NTSB SEA74DTA29Accident · No injuriesClosedAeronca 7AC · Alzada, MTJun 22, 1974 · N84439 · Substantial damage NTSB SEA74FTI28Accident · No injuriesClosedCessna 210 · Deer Lodge, MTJun 21, 1974 · N59027 · Substantial damage NTSB SEA74FTA28Accident · No injuriesClosedPiper PA-18 · Saco, MTJun 18, 1974 · N3803Z · Substantial damage NTSB SEA74DTI26Accident · No injuriesClosedCessna 172 · Swan Lake, MTJun 18, 1974 · N6282E · Substantial damage NTSB SEA74DTI29Accident · No injuriesClosedBell 47G3B1 · Lima, MTJun 16, 1974 · N7928S · Substantial damage NTSB SEA74DTI24Accident · No injuriesClosedLuscombe 8A · Wise River, MTJun 13, 1974 · N45831 · Substantial damage NTSB SEA74FTI25Accident · Serious injuriesClosedPiper PA-25 · Pablo, MTJun 11, 1974 · N7070Z · Destroyed NTSB SEA74DTI27Accident · No injuriesClosedCessna 140 · Townsend, MTJun 9, 1974 · N76001 · Substantial damage NTSB SEA74FTA27Accident · No injuriesClosedPiper PA-25 · Broadview, MTJun 7, 1974 · N7051Z · Substantial damage NTSB SEA74FTI23Accident · Serious injuriesClosedPiper PA-18A · Brady, MTJun 1, 1974 · N2696P · Substantial damage NTSB SEA74AS044Accident · 1 fatalClosedBeech 35 · Townsend, MTMay 14, 1974 · N2962V · Destroyed NTSB SEA74DTA26Accident · No injuriesClosedCessna 182 · Ekalaka, MTMay 5, 1974 · N6244A · Substantial damage NTSB SEA74FTA25Accident · No injuriesClosedPiper PA-18 · Richey, MTMay 3, 1974 · N2206A · Substantial damage NTSB SEA74DTI22Accident · No injuriesClosedPiper PA-25 · Power, MTMay 3, 1974 · N7006Z · Destroyed NTSB SEA74AS040Accident · 2 fatalClosedPiper PA-28 · Butte, MTApr 27, 1974 · CF-XCN · Destroyed NTSB SEA74FTA24Accident · No injuriesClosedPiper PA-25 · Wolf Point, MTApr 26, 1974 · N6507Z · Destroyed NTSB SEA74FTI21Accident · No injuriesClosedPiper PA-25 · Utica, MTApr 19, 1974 · N7323Z · Substantial damage NTSB SEA74DTA21Accident · No injuriesClosedPiper PA-22 · Melstone, MTApr 9, 1974 · N648A · Substantial damage NTSB SEA74FTA22Accident · No injuriesClosedTaylorcraft DCO-65 · Fishtail, MTApr 7, 1974 · N53762 · Substantial damage NTSB SEA74DTA23Accident · No injuriesClosedBellanca 7GCBC · Malta, MTApr 6, 1974 · N57476 · Substantial damage NTSB SEA74FTA20Accident · No injuriesClosedCessna 210 · Glendive, MTApr 5, 1974 · N35498 · Substantial damage NTSB SEA74FTI20Accident · No injuriesClosedCessna 172B · Livingston, MTMar 30, 1974 · N7972X · Substantial damage NTSB SEA74FTI19Accident · No injuriesClosedChampion 7GCAA · Philipsburg, MTMar 18, 1974 · N5134X · Substantial damage