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 SEA70F0076Accident · No injuriesClosedCessna 195 · Three Forks, MTAug 30, 1969 · N9369A · Substantial damage NTSB DEN70A0013Accident · 1 fatalClosedCessna 182L · Bridger, MTAug 26, 1969 · N3147R · Destroyed NTSB SEA70D0059Accident · No injuriesClosedPiper PA-22 · Rapelje, MTAug 10, 1969 · N3455Z · Substantial damage NTSB SEA70F0056Accident · No injuriesClosedHiller Acft UH-12B · Billings, MTAug 5, 1969 · N3112G · Substantial damage NTSB SEA70A0008Accident · 3 fatalClosedBeech D95A · Livingston, MTAug 2, 1969 · N8920U · Destroyed NTSB SEA70D0058Accident · No injuriesClosedCessna 140A · Hingham, MTAug 1, 1969 · N9625A · Substantial damage NTSB SEA70F0027Accident · No injuriesClosedCessna 180 · Birney, MTJul 22, 1969 · N5194E · Substantial damage NTSB SEA70D0047Accident · No injuriesClosedBeech C35 · Belgrade, MTJul 20, 1969 · N1939D · Substantial damage NTSB SEA70F0042Accident · No injuriesClosedMaule M-4 · Kalispell, MTJul 18, 1969 · N4703T · Substantial damage NTSB SEA70F0018Accident · No injuriesClosedBrantly B-2 · Helena, MTJul 14, 1969 · N5987X · Substantial damage NTSB SEA70F0029Accident · No injuriesClosedWills BW-9 · Bigfork, MTJul 4, 1969 · N92883 · Substantial damage NTSB SEA70A0001Accident · 2 fatalClosedMooney M20E · Helena, MTJul 3, 1969 · N9054V · Substantial damage NTSB SEA70F0031Accident · Minor injuriesClosedTaylorcraft BC12-D · Kalispell, MTJul 1, 1969 · N95581 · Substantial damage NTSB SEA70D0021Accident · No injuriesClosedCessna 150 · Shonkin, MTJun 30, 1969 · N8164F · Substantial damage NTSB SEA70F0037Accident · No injuriesClosedPiper PA-22 · Forsyth, MTJun 28, 1969 · N3611P · Substantial damage NTSB DEN69A0053Accident · 4 fatalClosedCessna 182C · Great Falls, MTJun 25, 1969 · N8847T · Destroyed NTSB SEA70F0017Accident · Serious injuriesClosedBell 47G-3 · Deer Lodge, MTJun 4, 1969 · N8409E · Destroyed NTSB SEA70F0013Accident · Serious injuriesClosedCallair A-9 · Great Falls, MTJun 4, 1969 · N7204V · Destroyed NTSB SEA69D0263Accident · No injuriesClosedCessna 180 · Livingston, MTMay 27, 1969 · N9120C · Substantial damage NTSB SEA69F0254Accident · No injuriesClosedCessna 180A · Harrison, MTMay 9, 1969 · N180F · Substantial damage NTSB SEA69F0250Accident · No injuriesClosedCallair A-9 · St.Xavier, MTMay 5, 1969 · N7223V · Substantial damage NTSB SEA69F0253Accident · 1 fatalClosedPiper PA-24 · Plains, MTApr 29, 1969 · N7311P · Destroyed NTSB SEA69F0248Accident · No injuriesClosedCessna 150F · Malta, MTApr 26, 1969 · N8738S · Substantial damage NTSB SEA69F0237Accident · No injuriesClosedCessna 210 · Butte, MTApr 23, 1969 · N3797Y · Substantial damage NTSB SEA69F0217Accident · No injuriesClosedBrantly B-2B · Lodge Grass, MTApr 23, 1969 · N2186U · Substantial damage NTSB SEA69F0249Accident · 1 fatalClosedPiper PA-25 · Geraldine, MTApr 10, 1969 · N7291Z · Destroyed NTSB SEA69F0203Accident · No injuriesClosedHughes 269B · Missoula, MTApr 7, 1969 · N9355F · Substantial damage NTSB SEA69F0251Accident · Serious injuriesClosedMooney M20F · Melville, MTApr 6, 1969 · N2974L · Destroyed NTSB SEA69F0236Accident · No injuriesClosedErco 415-C · Kalispell, MTMar 29, 1969 · N93316 · Substantial damage NTSB SEA69F0204Incident · No injuriesClosedCessna 150 · W Yellwstone, MTMar 21, 1969 · CF-XVM · Minor damage NTSB SEA69A0049Accident · 3 fatalClosedCessna 175 · Four Buttes, MTMar 14, 1969 · N9499B · Destroyed NTSB SEA69D0209Accident · No injuriesClosedCessna 180 · Choteau, MTMar 2, 1969 · N2447F · Substantial damage NTSB SEA69D0211Accident · No injuriesClosedCessna 140A · Poplar, MTFeb 24, 1969 · N5600C · Substantial damage NTSB SEA69D0186Accident · No injuriesClosedPiper PA-28 · Chester, MTFeb 16, 1969 · N5342W · Substantial damage NTSB SEA69D0210Accident · No injuriesClosedPiper PA-23 · Great Falls, MTFeb 14, 1969 · N5121Y · Substantial damage NTSB SEA69D0252Accident · No injuriesClosedCessna 170B · Mosby, MTFeb 3, 1969 · N3162B · Substantial damage NTSB SEA69A0043Accident · 2 fatalClosedPiper PA-11 · Ingomar, MTJan 26, 1969 · N4648M · Destroyed NTSB SEA69D0243Accident · No injuriesClosedPiper PA-18 · Peerless, MTJan 21, 1969 · N4727A · Substantial damage NTSB SEA69D0174Accident · No injuriesClosedAero Comdr 500-B · Belgrade, MTJan 8, 1969 · N4918 · Substantial damage NTSB SEA69A0039Accident · 4 fatalClosedPiper PA-24 · Great Falls, MTJan 5, 1969 · N7556P · Destroyed NTSB SEA69A0040Accident · 3 fatalClosedCessna 172H · Ronan, MTJan 4, 1969 · N8086L · Destroyed NTSB SEA69D0153Accident · No injuriesClosedCessna 170 · St.Xavier, MTDec 20, 1968 · N2663V · Substantial damage NTSB SEA69A0035Accident · 1 fatalClosedAero Comdr 500 · Glendive, MTDec 18, 1968 · N6281X · Destroyed NTSB SEA69F0168Accident · No injuriesClosedBell 206A · Missoula, MTDec 17, 1968 · N4735R · Substantial damage NTSB SEA69D0170Accident · No injuriesClosedCessna 170B · Belgrade, MTDec 15, 1968 · N3185B · Substantial damage NTSB SEA69A0032Accident · 3 fatalClosedAero Comdr 560-F · Wolf Creek, MTDec 8, 1968 · N6257X · Destroyed NTSB SEA69F0148Accident · No injuriesClosedCessna 150 · Belgrade, MTNov 26, 1968 · N51149 · Substantial damage NTSB SEA69D0161Accident · No injuriesClosedAeronca 11CC · Frazer, MTOct 24, 1968 · N4301E · Substantial damage NTSB SEA69F0150Accident · No injuriesClosedPiper PA-24 · Butte, MTOct 23, 1968 · N5889P · Substantial damage NTSB SEA69F0142Accident · No injuriesClosedBeech F35 · Dillon, MTOct 13, 1968 · N3899B · Substantial damage