Skip to content

NTSB investigations, 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

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 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 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 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 SEA76FTA09Accident · No injuriesClosedBell 206B · Miles City, MTDec 14, 1975 · N59495 · Substantial damage NTSB SEA76DTA08Accident · No injuriesClosedChampion 7GCB · Wagner, MTDec 13, 1975 · N9803Y · Substantial damage NTSB SEA76FTI17Accident · Minor injuriesClosedCallair A-9B · Hamilton, MTNov 4, 1975 · N7261V · Destroyed NTSB SEA76FTA07Accident · No injuriesClosedCessna 140 · Miles City, MTNov 2, 1975 · N2611N · Destroyed NTSB SEA76AS025Accident · 2 fatalClosedBeech B19 · E.Glacier Park, MTNov 1, 1975 · N9791L · Destroyed NTSB SEA76FTA18Accident · No injuriesClosedPiper PA-24 · Ekalaka, MTOct 18, 1975 · N11CG · Substantial damage NTSB SEA76AS022Accident · 3 fatalClosedPiper PA-11 · Turner, MTOct 17, 1975 · N4575M · Destroyed NTSB SEA76DTI16Accident · No injuriesClosedAeronca 11AC · Havre, MTOct 11, 1975 · N4114E · Substantial damage NTSB SEA76AS018Accident · 2 fatalClosedCessna 182N · Baker, MTOct 11, 1975 · N9165G · Destroyed NTSB SEA76FTI15Accident · Minor injuriesClosedAeronca 7AC · Bozeman, MTOct 5, 1975 · N84885 · Destroyed NTSB SEA76FTI14Accident · Minor injuriesClosedMaule M5210C · Bozeman, MTOct 2, 1975 · N51598 · Substantial damage NTSB SEA76FTA06Accident · Minor injuriesClosedPiper PA-18 · Powderville, MTSep 30, 1975 · N9381D · Substantial damage NTSB SEA76DTI13Accident · Minor injuriesClosedPiper PA-18A · Fairfield, MTSep 29, 1975 · N9488D · Substantial damage NTSB SEA76FTI12Accident · No injuriesClosedTaylorcraft BC12-D · Hamilton, MTSep 28, 1975 · N43725 · Substantial damage NTSB SEA76FTA05Accident · No injuriesClosedCessna 177 · Broadus, MTSep 13, 1975 · N29350 · Substantial damage NTSB SEA76FTI11Accident · 2 fatalClosedBede 4 · Seely Lake, MTAug 31, 1975 · N24872 · Destroyed NTSB SEA76FTA04Accident · No injuriesClosedPiper PA-24 · Lewiston, MTAug 28, 1975 · N8881P · Substantial damage NTSB SEA76FTI10Accident · Minor injuriesClosedCallair A-9 · Conrad, MTAug 26, 1975 · N8282H · Substantial damage NTSB SEA76FTA03Accident · No injuriesClosedCessna 172 · Red Lodge, MTAug 24, 1975 · N4138F · Substantial damage NTSB SEA76DTI09Accident · No injuriesClosedMaule M-5 · Thompson Falls, MTAug 24, 1975 · N62048 · Substantial damage NTSB SEA76DTI08Accident · Minor injuriesClosedCessna 180H · Manchester, MTAug 16, 1975 · N91226 · Destroyed NTSB SEA7LFTI05Accident · Serious injuriesClosedAmer Avco AA1-B · Butte, MTAug 6, 1975 · N9618L · Destroyed NTSB SEA76DTI07Accident · No injuriesClosedBoeing A75N1 · Chester, MTAug 5, 1975 · N5600 · Substantial damage NTSB SEA76DTI06Accident · No injuriesClosedCessna A185F · Geraldine, MTAug 4, 1975 · N2525S · Substantial damage NTSB SEA76DTI04Accident · No injuriesClosedCessna 172M · Hoagland, MTJul 25, 1975 · N20880 · Substantial damage NTSB SEA76DTI03Accident · Minor injuriesClosedPiper PA-25 · Big Sandy, MTJul 24, 1975 · N7391Z · Destroyed NTSB SEA76FTA01Accident · No injuriesClosedErco 415-D · Sidney, MTJul 12, 1975 · N2850H · Substantial damage NTSB SEA76FTA02Accident · No injuriesClosedBellanca 7GCBC · Sand Springs, MTJul 11, 1975 · N62972 · Substantial damage NTSB SEA76FTI02Accident · No injuriesClosedBell 47G3B1 · Elliston, MTJul 9, 1975 · N1170W · Substantial damage NTSB SEA7LFTI01Accident · No injuriesClosedCessna 150G · Wise River, MTJul 3, 1975 · N3094S · Substantial damage NTSB SEA75FTA22Accident · Minor injuriesClosedDouglas B-26 · Billings, MTJun 28, 1975 · N4818E · Substantial damage NTSB SEA75DTI36Accident · No injuriesClosedCessna 182 · Livingston, MTJun 25, 1975 · N6294A · Substantial damage NTSB SEA75FTA21Accident · No injuriesClosedCessna 182 · Billings, MTJun 23, 1975 · N52843 · Substantial damage NTSB SEA75FTI35Accident · Serious injuriesClosedCessna 182F · Townsend, MTJun 22, 1975 · N3319U · Substantial damage NTSB SEA75FTI34Accident · Minor injuriesClosedBell 47G-3 · Great Falls, MTJun 10, 1975 · N6782D · Destroyed NTSB SEA75DTI32Accident · No injuriesClosedBoeing E75 · Brady, MTMay 31, 1975 · N5183N · Substantial damage NTSB SEA75DTI31Accident · No injuriesClosedPiper PA-34 · Missoula, MTMay 30, 1975 · N55258 · Substantial damage NTSB SEA75FTA19Accident · Minor injuriesClosedCessna 210F · Pompeys Pillar, MTMay 27, 1975 · N5812F · Substantial damage NTSB SEA75FTA20Accident · No injuriesClosedPiper PA-11 · Nashua, MTMay 18, 1975 · N4752M · Substantial damage NTSB SEA7KDTI30Accident · Minor injuriesClosedCessna 180J · Dillon, MTMay 16, 1975 · N46069 · Substantial damage NTSB SEA75FTA18Accident · No injuriesClosedCessna A188 · Denton, MTMay 16, 1975 · N5683J · Substantial damage NTSB SEA75DTI29Accident · No injuriesClosedAeronca 7BCM · Choteau, MTMay 14, 1975 · N1127N · Destroyed NTSB SEA75FTI28Accident · No injuriesClosedPiper PA-24 · Boseman, MTMay 1, 1975 · N7487P · Substantial damage NTSB SEA75FTI27Accident · Serious injuriesClosedPiper PA-22 · Lolo, MTApr 30, 1975 · N9201D · Substantial damage NTSB SEA75DTI26Accident · No injuriesClosedCessna 140 · Deer Lodge, MTApr 28, 1975 · N76295 · Substantial damage NTSB SEA75FTA17Accident · Serious injuriesClosedPiper J-3 · Cohagen, MTApr 26, 1975 · N33451 · Substantial damage NTSB SEA75FTA15Accident · No injuriesClosedPiper PA-18 · Billings, MTApr 12, 1975 · N4250Z · Substantial damage NTSB SEA75FTA16Accident · No injuriesClosedBellanca 7GCBC · White Water, MTApr 11, 1975 · N88465 · Substantial damage NTSB SEA75DTI25Accident · No injuriesClosedPiper PA-28 · Kalispell, MTMar 21, 1975 · N2698T · Substantial damage NTSB SEA75AS036Accident · No injuriesClosedCessna A185F · Havre, MTMar 20, 1975 · N4948C · Substantial damage