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 SEA68D0064Accident · No injuriesClosedBeech 35-B33 · Westby, MTJun 3, 1967 · N8946M · Substantial damage NTSB SEA68F0058Accident · No injuriesClosedMaule M-4 · Polson, MTJun 2, 1967 · N4602T · Substantial damage NTSB SEA68D0046Accident · No injuriesClosedCallair A-9 · Ulm, MTJun 2, 1967 · N8279H · Substantial damage NTSB SEA67D0341Accident · No injuriesClosedBeech 23 · Butte, MTJun 1, 1967 · N4707J · Substantial damage NTSB SEA68F0040Accident · No injuriesClosedCallair A-9 · Dutton, MTMay 30, 1967 · N8294H · Substantial damage NTSB SEA67A0068Accident · 2 fatalClosedCessna 172 · Helmville, MTMay 27, 1967 · N6995A · Substantial damage NTSB SEA68D0047Accident · No injuriesClosedCessna 210 · Drummond, MTMay 25, 1967 · N8496Z · Substantial damage NTSB SEA67A0067Accident · 1 fatalClosedTaylorcraft BC12-D · Havre, MTMay 24, 1967 · N96684 · Destroyed NTSB SEA67A0066Accident · 1 fatalClosedPiper PA-18A · Absarokee, MTMay 22, 1967 · N9446D · Destroyed NTSB SEA67D0337Accident · No injuriesClosedCessna 182J · Superior, MTMay 20, 1967 · N3367F · Substantial damage NTSB SEA68D0110Accident · No injuriesClosedN.American AT-6G · Chester, MTMay 19, 1967 · N3746G · Substantial damage NTSB SEA68D0001Accident · No injuriesClosedCessna 210E · Missoula, MTMay 19, 1967 · N2339F · Substantial damage NTSB SEA67A0065Accident · 5 fatalClosedCessna 182J · Bozeman, MTMay 15, 1967 · N3598F · Destroyed NTSB SEA67D0323Accident · No injuriesClosedCessna 180H · Great Falls, MTMay 9, 1967 · CF-VUF · Substantial damage NTSB SEA67F0320Accident · No injuriesClosedBeech S35 · Helena, MTMay 6, 1967 · N8951M · Substantial damage NTSB SEA67F0312Accident · No injuriesClosedCallair A-9 · Froid, MTMay 5, 1967 · N7239V · Substantial damage NTSB MKC68D0105Accident · No injuriesClosedCessna 172E · Baker, MTMay 3, 1967 · N4487L · Substantial damage NTSB SEA67D0319Accident · No injuriesClosedPiper PA-28 · Polson, MTApr 30, 1967 · N5227W · Substantial damage NTSB SEA67F0296Accident · No injuriesClosedMaule M-4 · Helena, MTApr 24, 1967 · N4703T · Substantial damage NTSB SEA67D0295Accident · No injuriesClosedCessna 150 · Chester, MTApr 10, 1967 · N8746S · Substantial damage NTSB SEA67D0276Accident · Minor injuriesClosedPiper PA-28 · Stevensville, MTApr 9, 1967 · N6152W · Substantial damage NTSB SEA67D0325Accident · No injuriesClosedCessna 172 · Cut Bank, MTApr 3, 1967 · N6830X · Substantial damage NTSB SEA67D0306Accident · No injuriesClosedPiper J-3 · Haugan, MTMar 27, 1967 · CF-VTD · Substantial damage NTSB SEA67F0271Accident · Serious injuriesClosedCessna 172 · Bridger, MTMar 23, 1967 · N5045A · Destroyed NTSB FTW67F0522Accident · No injuriesClosedBoeing A75N1 · Billings, MTMar 21, 1967 · N59137 · Substantial damage NTSB SEA67A0051Accident · 2 fatalClosedPiper PA-28 · Acton, MTMar 18, 1967 · N6789W · Destroyed NTSB SEA67D0277Accident · No injuriesClosedCessna 182J · Missoula, MTMar 14, 1967 · N3445F · Substantial damage NTSB SEA67D0275Accident · No injuriesClosedCessna 180 · Belgrade, MTMar 5, 1967 · N1627C · Substantial damage NTSB SEA67D0278Accident · No injuriesClosedPiper PA-18 · Butte, MTFeb 22, 1967 · N7686D · Substantial damage NTSB SEA67D0273Accident · No injuriesClosedPiper PA-22 · Hamilton, MTFeb 9, 1967 · N9500D · Substantial damage NTSB SEA67F0255Accident · No injuriesClosedCessna 182 · Helena, MTJan 31, 1967 · N9384X · Substantial damage NTSB SEA67D0265Accident · No injuriesClosedBeech A23 · Butte, MTJan 27, 1967 · N4714J · Substantial damage NTSB SEA67D0254Accident · No injuriesClosedCessna 180F · Lima, MTJan 15, 1967 · N2110Z · Substantial damage NTSB SEA67D0286Accident · No injuriesClosedCessna 150 · Broadus, MTJan 11, 1967 · N4190U · Substantial damage NTSB SEA67A0044Accident · 2 fatalClosedMooney M20E · Wolf Creek, MTDec 26, 1966 · N2747W · Destroyed NTSB SEA67D0272Accident · No injuriesClosedChampion 7GCB · Great Falls, MTDec 25, 1966 · N9601S · Substantial damage NTSB SEA67D0266Accident · No injuriesClosedAeronca 7AC · Circle, MTDec 20, 1966 · N2849E · Substantial damage NTSB SEA67A0043Accident · No injuriesClosedBrantly B-2B · Wyola, MTDec 18, 1966 · N2183U · Substantial damage NTSB SEA67D0219Accident · No injuriesClosedBeech A23-19 · Billings, MTNov 26, 1966 · N5775V · Substantial damage NTSB SEA67A0039Accident · 5 fatalClosedCessna 172G · Chinook, MTNov 25, 1966 · N6068R · Destroyed NTSB SEA67D0191Accident · No injuriesClosedPiper PA-18 · Rudyard, MTNov 20, 1966 · N9136D · Substantial damage NTSB SEA67D0221Accident · Serious injuriesClosedAeronca 7AC · Capitol, MTNov 13, 1966 · N82708 · Destroyed NTSB SEA67F0193Accident · No injuriesClosedPiper PA-30 · Billings, MTNov 12, 1966 · N7730Y · Substantial damage NTSB CHI67A0064Accident · Serious injuriesClosedBoeing B-720 · Billings, MTNov 12, 1966 · N7203U · No damage NTSB SEA67D0194Accident · No injuriesClosedCessna 180 · Swan Lake, MTNov 11, 1966 · N2493F · Substantial damage NTSB SEA67D0192Accident · No injuriesClosedBeech 35 · Thom Falls, MTOct 29, 1966 · N80415 · Substantial damage NTSB SEA67D0195Accident · No injuriesClosedStinson 108-3 · Malta, MTOct 19, 1966 · N659C · Substantial damage NTSB SEA67D0186Accident · No injuriesClosedPiper PA-28 · Billings, MTOct 17, 1966 · N6991W · Substantial damage NTSB SEA67D0165Accident · No injuriesClosedCessna 172 · Chinook, MTOct 16, 1966 · N7327T · Substantial damage NTSB SEA67D0169Accident · No injuriesClosedPiper PA-22 · Square Butte, MTOct 15, 1966 · N1337C · Substantial damage