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 SEA67D0168Accident · No injuriesClosedMooney M20B · W S Springs, MTOct 9, 1966 · N74785 · Substantial damage NTSB SEA67A0027Accident · 2 fatalClosedBell 47G3B1 · W.Yellowston, MTSep 21, 1966 · N1169W · Destroyed NTSB SEA67A0026Accident · 4 fatalClosedPiper PA-28 · Alberton, MTSep 20, 1966 · N5182W · Destroyed NTSB SEA67A0025Accident · No injuriesClosedBell 47G-3 · Noxon, MTSep 19, 1966 · N6782D · Destroyed NTSB SEA67D0144Accident · No injuriesClosedPiper PA-18 · Dillon, MTSep 16, 1966 · N3952Z · Substantial damage NTSB SEA67D0167Accident · No injuriesClosedCessna 185 · Great Falls, MTSep 15, 1966 · N4145Y · Substantial damage NTSB SEA67D0120Accident · No injuriesClosedCessna 140 · Great Falls, MTSep 15, 1966 · N72308 · Substantial damage NTSB SEA67D0185Accident · No injuriesClosedStinson 108-2 · Laurel, MTSep 11, 1966 · N967D · Substantial damage NTSB SEA67F0129Accident · Minor injuriesClosedPiper PA-12 · Thomp. Falls, MTSep 10, 1966 · N78576 · Substantial damage NTSB SEA67F0111Accident · No injuriesClosedCessna 182 · Dupuyer, MTSep 9, 1966 · N3175S · Substantial damage NTSB SEA67D0120Accident · No injuriesClosedBeech 35 · Libby, MTSep 9, 1966 · N3172V · Substantial damage NTSB SEA67D0138Accident · No injuriesClosedPiper PA-18 · Stevensville, MTSep 4, 1966 · N3973P · Substantial damage NTSB SEA67D0132Accident · Minor injuriesClosedCessna 172 · Dutton, MTSep 4, 1966 · N2328U · Destroyed NTSB SEA67F0133Accident · No injuriesClosedStinson 108-3 · Hamilton, MTAug 22, 1966 · N6669M · Substantial damage NTSB SEA67D0110Accident · No injuriesClosedCessna 150F · Belgrade, MTAug 16, 1966 · N8024S · Substantial damage NTSB SEA67D0108Accident · No injuriesClosedCessna 180 · Conrad, MTAug 16, 1966 · N4603U · Substantial damage NTSB SEA67F0107Accident · No injuriesClosedPiper PA-18 · Zortman, MTAug 14, 1966 · N1197C · Substantial damage NTSB SEA67D0139Accident · No injuriesClosedStearman PT-17 · Big Horn, MTAug 12, 1966 · N51132 · Substantial damage NTSB SEA67F0077Accident · No injuriesClosedPiper PA-24 · Laurel, MTAug 7, 1966 · N6593P · Substantial damage NTSB SEA67D0102Accident · No injuriesClosedCessna 180 · W.Yellowstone, MTAug 3, 1966 · N5156E · Substantial damage NTSB SEA67F0086Accident · Minor injuriesClosedPiper PA-22 · Eurek, MTJul 30, 1966 · N6063D · Substantial damage NTSB SEA67D0100Accident · No injuriesClosedCessna 210 · Polson, MTJul 30, 1966 · N9454X · Substantial damage NTSB SEA67F0078Accident · 1 fatalClosedLuscombe 8A · Chinook, MTJul 27, 1966 · N2978K · Destroyed NTSB SEA67F0054Accident · No injuriesClosedPiper PA-25 · Winifred, MTJul 25, 1966 · N6880Z · Substantial damage NTSB SEA67D0092Accident · No injuriesClosedGrumman TBM-3E · Potomac, MTJul 25, 1966 · N3969A · Substantial damage NTSB SEA67D0081Accident · No injuriesClosedPiper PA-18 · Neihart, MTJul 25, 1966 · N7699Y · Substantial damage NTSB SEA67F0148Accident · No injuriesClosedPiper PA-18 · Molt, MTJul 15, 1966 · N3839Z · Substantial damage NTSB SEA67D0035Accident · No injuriesClosedPiper PA-28 · Butte, MTJul 15, 1966 · N7392W · Substantial damage NTSB SEA67D0075Accident · No injuriesClosedMorrisey 2150 · Babb, MTJul 14, 1966 · N5107V · Substantial damage NTSB SEA67A0002Accident · Serious injuriesClosedBell 47-G3B · Clinton, MTJul 14, 1966 · N8509F · Destroyed NTSB SEA67A0004Accident · 1 fatalClosedCessna 172B · Roy, MTJul 8, 1966 · N7834X · Destroyed NTSB SEA67D0055Accident · No injuriesClosedCessna 172 · Kalispell, MTJul 1, 1966 · N3733L · Substantial damage NTSB SEA66A0072Accident · Minor injuriesClosedBell 47G3B1 · Livingston, MTJun 30, 1966 · N73916 · Destroyed NTSB SEA67D0142Accident · No injuriesClosedChampion 7ECA · Lewistown, MTJun 28, 1966 · N8306V · Substantial damage NTSB SEA67F0053Accident · No injuriesClosedPiper PA-18 · Joliet, MTJun 25, 1966 · N2412P · Destroyed NTSB SEA67D0029Accident · Minor injuriesClosedCessna 182 · Three Forks, MTJun 19, 1966 · N6235A · Substantial damage NTSB SEA67F0137Accident · Serious injuriesClosedCallair A-4 · Lavina, MTJun 18, 1966 · N6166C · Substantial damage NTSB SEA66A0068Accident · No injuriesClosedBell 47G3B1 · Lincoln, MTJun 17, 1966 · N8505F · Substantial damage NTSB SEA67F0020Accident · No injuriesClosedAeronca 15AC · Fort Benton, MTJun 16, 1966 · N1164H · Substantial damage NTSB SEA67D0028Accident · No injuriesClosedMooney M20C · Polson, MTJun 15, 1966 · N5704Q · Substantial damage NTSB SEA67D0059Accident · No injuriesClosedNavion A · Columbus, MTJun 14, 1966 · N91642 · Substantial damage NTSB SEA67D0019Accident · No injuriesClosedChampion 7EC · Issoula, MTJun 6, 1966 · N4317C · Substantial damage NTSB SEA66D0290Accident · No injuriesClosedCessna 172 · Camas Prairi, MTJun 5, 1966 · N5008A · Substantial damage NTSB SEA66F0301Accident · Serious injuriesClosedPiper PA-18 · Ekalaka, MTMay 29, 1966 · N8182C · Destroyed NTSB SEA66A0063Accident · No injuriesClosedGrumman G-164 · Chester, MTMay 29, 1966 · N517Y · No damage NTSB SEA67D0076Accident · No injuriesClosedPiper PA-18 · Billings, MTMay 27, 1966 · N3684Z · Substantial damage NTSB SEA67D0021Accident · No injuriesClosedPiper PA-18 · Columbus, MTMay 26, 1966 · N1300A · Substantial damage NTSB SEA67D0051Accident · No injuriesClosedGlobe GC-1B · Hardin, MTMay 24, 1966 · N78263 · Substantial damage NTSB SEA66D0288Accident · No injuriesClosedBellanca 14-13 · Boulder, MTMay 21, 1966 · N86916 · Substantial damage NTSB SEA66D0280Accident · No injuriesClosedN American T-6G · Hogeland, MTMay 21, 1966 · N3172G · Substantial damage