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 SEA68D0240Accident · No injuriesClosedStinson 108-3 · Denton, MTJan 7, 1968 · N6659C · Substantial damage NTSB SEA68D0234Accident · No injuriesClosedCessna 150H · Hamilton, MTJan 4, 1968 · N6550S · Substantial damage NTSB SEA68D0210Accident · No injuriesClosedPiper PA-18 · Ovando, MTNov 24, 1967 · N4268Z · Substantial damage NTSB SEA68D0218Accident · No injuriesClosedAero Comdr 520 · Bozeman, MTNov 22, 1967 · N2625B · Substantial damage NTSB SEA68D0209Accident · No injuriesClosedCessna 172 · Wolf Point, MTNov 11, 1967 · N3910F · Substantial damage NTSB SEA68A0039Accident · Minor injuriesClosedConvair 340T · Great Falls, MTNov 1, 1967 · N73120 · Substantial damage NTSB SEA68F0208Accident · No injuriesClosedPiper PA-24 · Pryor, MTOct 27, 1967 · N8551P · Substantial damage NTSB SEA68D0194Accident · No injuriesClosedPiper PA-30 · Laurel, MTOct 26, 1967 · N7840Y · Substantial damage NTSB SEA68F0159Accident · No injuriesClosedPiper PA-18 · Billings, MTOct 13, 1967 · N1734A · Substantial damage NTSB SEA68D0165Accident · No injuriesClosedPiper J3C-65 · Richland, MTOct 11, 1967 · N70234 · Substantial damage NTSB SEA68A0032Accident · 2 fatalClosedChampion 7GCBC · Lothair, MTOct 8, 1967 · N9601S · Destroyed NTSB SEA68D0178Accident · No injuriesClosedTaylorcraft BC12 · Malta, MTOct 7, 1967 · N34032 · Destroyed NTSB SEA68D0213Accident · No injuriesClosedPiper PA-22 · Great Falls, MTOct 3, 1967 · N3455A · Substantial damage NTSB SEA68A0042Accident · No injuriesClosedCessna 320A · Missoula, MTSep 30, 1967 · N3016R · Substantial damage NTSB SEA68F0185Accident · No injuriesClosedBoeing B75N1 · Brady, MTSep 29, 1967 · N4685N · Substantial damage NTSB SEA68F0138Accident · No injuriesClosedPiper PA-22 · Helena, MTSep 27, 1967 · N3763P · Substantial damage NTSB SEA68F0199Accident · Serious injuriesClosedCessna 140 · Hardin, MTSep 25, 1967 · N76931 · Destroyed NTSB SEA68D0144Accident · Minor injuriesClosedTaylorcraft BC12-D · Harrison, MTSep 20, 1967 · N95731 · Substantial damage NTSB SEA68F0139Accident · No injuriesClosedLuscombe 8A · Missoula, MTSep 16, 1967 · N45564 · Substantial damage NTSB SEA68D0127Accident · No injuriesClosedCessna 180 · Babb, MTSep 5, 1967 · N6494X · Substantial damage NTSB SEA68A0020Accident · Serious injuriesClosedBoeing B-17 · Kalispell, MTAug 29, 1967 · N7228C · Destroyed NTSB SEA68F0116Accident · No injuriesClosedChampion 7FC · Billings, MTAug 28, 1967 · N9886B · Substantial damage NTSB SEA68D0156Accident · No injuriesClosedMaule M-4 · Moore, MTAug 24, 1967 · N12010 · Substantial damage NTSB SEA68F0069Accident · No injuriesClosedBeech 23 · Broadview Mont, MTAug 17, 1967 · CF-OYJ · Substantial damage NTSB SEA68D0132Accident · No injuriesClosedPiper PA-24 · Libby, MTAug 16, 1967 · N5864P · Substantial damage NTSB SEA68F0142Accident · No injuriesClosedPiper PA-24 · Columbus, MTAug 14, 1967 · N5384P · Destroyed NTSB SEA68D0155Accident · Minor injuriesClosedPiper PA-18 · Mildred, MTAug 14, 1967 · N5756D · Substantial damage NTSB SEA68D0143Accident · No injuriesClosedForney F-1 · Jordan, MTAug 14, 1967 · N7551C · Substantial damage NTSB SEA68D0093Accident · No injuriesClosedChampion 7EC · Wolf Point, MTAug 14, 1967 · N4301C · Substantial damage NTSB SEA68D0111Accident · Minor injuriesClosedPiper PA-25 · Carter, MTAug 11, 1967 · N7668Z · Substantial damage NTSB SEA68D0180Accident · No injuriesClosedCessna 140A · Worden, MTAug 10, 1967 · N3785V · Substantial damage NTSB SEA68A0015Accident · No injuriesClosedBell 47G-3 · Livingston, MTAug 10, 1967 · N8416F · Substantial damage NTSB SEA68A0012Accident · No injuriesClosedBell 47G-3B · Augusta, MTAug 7, 1967 · N1357X · Substantial damage NTSB SEA68D0121Accident · Minor injuriesClosedPiper PA-28 · Swan Lake, MTJul 29, 1967 · N9456J · Destroyed NTSB SEA68A0021Accident · No injuriesClosedBell 47G3B1 · West Glacier, MTJul 29, 1967 · N73916 · Substantial damage NTSB SEA68D0051Accident · No injuriesClosedCessna 182G · Helena, MTJul 22, 1967 · N2082R · Substantial damage NTSB SEA68D0054Accident · No injuriesClosedCessna 150 · Missoula, MTJul 21, 1967 · N3130J · Substantial damage NTSB SEA68F0089Accident · No injuriesClosedCessna 185 · Billings, MTJul 14, 1967 · N4001Y · Substantial damage NTSB SEA68F0059Accident · No injuriesClosedBellanca 14-19 · Fort Shaw, MTJul 13, 1967 · N9832B · Substantial damage NTSB SEA68A0006Accident · No injuriesClosedBell 47G-3 · Fairfield, MTJul 10, 1967 · N8414E · Substantial damage NTSB SEA68D0140Accident · No injuriesClosedMooney M20E · Huntley, MTJul 9, 1967 · N5753Q · Substantial damage NTSB SEA68A0004Accident · 4 fatalClosedBeech K35 · Fort Peck, MTJul 4, 1967 · N6024E · Destroyed NTSB SEA68D0109Accident · No injuriesClosedAeronca 7AC · Wh.Sulph.Spg, MTJul 3, 1967 · N82901 · Substantial damage NTSB SEA68A0001Accident · 1 fatalClosedCallair A-9 · Power, MTJul 1, 1967 · N7225V · Destroyed NTSB SEA68D0061Accident · No injuriesClosedPiper PA-18 · Tampico, MTJun 30, 1967 · N2883Z · Substantial damage NTSB SEA68F0078Accident · No injuriesClosedPiper PA-23 · Billings, MTJun 26, 1967 · N4986P · Substantial damage NTSB MKC68D0108Accident · No injuriesClosedCessna 210 · Glasgow, MTJun 25, 1967 · N2311F · Substantial damage NTSB SEA68D0062Accident · No injuriesClosedPiper PA-18 · St.Xavier, MTJun 16, 1967 · N3831Z · Substantial damage NTSB SEA68D0048Accident · No injuriesClosedPiper PA-25 · Dutton, MTJun 14, 1967 · N7006Z · Substantial damage NTSB SEA68D0002Accident · No injuriesClosedPiper PA-18 · Lincoln, MTJun 11, 1967 · N3981Z · Substantial damage