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 SEA66F0270Accident · Minor injuriesClosedCessna 180 · Dutton, MTMay 19, 1966 · N4531B · Destroyed NTSB SEA66D0265Accident · No injuriesClosedCessna 172 · Havre, MTMay 12, 1966 · N7285A · Substantial damage NTSB SEA66D0294Accident · No injuriesClosedCessna 180 · Circle, MTMay 9, 1966 · N708 · Substantial damage NTSB SEA66D0276Accident · No injuriesClosedCessna 180 · Butte, MTMay 9, 1966 · N4590B · Substantial damage NTSB SEA66D0278Accident · No injuriesClosedBoeing A75N1 · Billings, MTMay 8, 1966 · N55164 · Substantial damage NTSB SEA66F0291Accident · No injuriesClosedPiper PA-32 · Anaconda, MTMay 7, 1966 · N3436W · Substantial damage NTSB SEA66D0271Accident · No injuriesClosedPiper PA28 · Ut Bank, MTMay 6, 1966 · N6434W · Substantial damage NTSB SEA66F0277Accident · No injuriesClosedBeech S35 · Big Timber, MTMay 1, 1966 · N5850K · Substantial damage NTSB SEA66D0293Accident · No injuriesClosedBeech D35 · Miles City, MTMay 1, 1966 · N5842C · Substantial damage NTSB SEA66A0053Accident · No injuriesClosedBell 47G-3B · Missoula, MTApr 30, 1966 · N8414E · Substantial damage NTSB SEA66D0247Accident · No injuriesClosedPiper PA-28 · Great Falls, MTMar 28, 1966 · N6304W · Substantial damage NTSB SEA66F0223Accident · No injuriesClosedMooney M20C · Scobey, MTMar 24, 1966 · N5996Q · Substantial damage NTSB SEA66D0242Accident · Minor injuriesClosedPiper PA-17 · Savage, MTMar 15, 1966 · N4828H · Substantial damage NTSB SEA66D0235Accident · No injuriesClosedPiper J3C · Lewiston, MTFeb 27, 1966 · N88253 · Substantial damage NTSB SEA66F0241Accident · No injuriesClosedErco 415-C · Butte, MTFeb 22, 1966 · N3926H · Substantial damage NTSB SEA66D0211Accident · No injuriesClosedCessna 140 · St Ignatius, MTFeb 20, 1966 · N75728 · Substantial damage NTSB SEA66D0239Accident · No injuriesClosedPiper J3C · Powderville, MTFeb 16, 1966 · N88298 · Substantial damage NTSB SEA66D0212Accident · Minor injuriesClosedPiper PA-22 · Anaconda, MTFeb 15, 1966 · N7104D · Substantial damage NTSB SEA66D0224Accident · No injuriesClosedPiper PA-18 · Lloyd, MTFeb 14, 1966 · N5486H · Substantial damage NTSB SEA66D0197Accident · No injuriesClosedMooney M20C · Polson, MTJan 12, 1966 · N5704Q · Substantial damage NTSB SEA66D0210Accident · No injuriesClosedPiper PA-22 · Roundup, MTJan 6, 1966 · N864A · Substantial damage NTSB SEA66D0188Accident · No injuriesClosedCessna 180 · Babb, MTDec 29, 1965 · N6494X · Substantial damage NTSB SEA66D0203Accident · No injuriesClosedPiper PA-18 · Billings, MTDec 26, 1965 · N3684Z · Substantial damage NTSB SEA66D0200Accident · No injuriesClosedAeronca 7AC · Billings, MTDec 19, 1965 · N1128N · Substantial damage NTSB SEA66D0195Accident · No injuriesClosedBellanca 14-13 · Billings, MTDec 9, 1965 · N86720 · Substantial damage NTSB SEA66D0189Accident · No injuriesClosedBeechcraft C33 · Chester, MTDec 7, 1965 · N6128V · Substantial damage NTSB SEA66F0192Accident · No injuriesClosedCessna 320 · Billings, MTNov 18, 1965 · N3027T · Substantial damage NTSB SEA66D0178Accident · No injuriesClosedPiper PA-11 · Lambert, MTNov 14, 1965 · N4765M · Substantial damage NTSB SEA66D0169Accident · No injuriesClosedCessna 210 · Highwood, MTNov 14, 1965 · N8383Z · Substantial damage NTSB SEA66F0180Accident · Minor injuriesClosedPiper PA-18A · Huntley, MTNov 8, 1965 · N3688A · Substantial damage NTSB SEA66F0171Accident · No injuriesClosedDehaviland DH-82A · Helena, MTNov 8, 1965 · N3301T · Substantial damage NTSB SEA66A0030Accident · No injuriesClosedBrantly B-2 · Bigfork, MTNov 3, 1965 · N5991X · Destroyed NTSB SEA66D0161Accident · No injuriesClosedPiper PA-28 · Avon, MTNov 1, 1965 · N8782W · Substantial damage NTSB SEA66A0028Accident · 1 fatalClosedStinson 108-3 · Augusta, MTOct 28, 1965 · N348 · Destroyed NTSB SEA66A0027Accident · 1 fatalClosedCessna 140 · Ryegate, MTOct 28, 1965 · N77103 · Destroyed NTSB SEA66F0190Accident · No injuriesClosedPiper PA-24 · Twin Bridges, MTOct 18, 1965 · N6380 · Substantial damage NTSB SEA66F0148Accident · No injuriesClosedCessna 182F · Broadus, MTOct 10, 1965 · N3170U · Substantial damage NTSB SEA66D0142Accident · Minor injuriesClosedPiper PA-18 · Stanford, MTOct 3, 1965 · N7699Y · Substantial damage NTSB SEA66F0122Accident · No injuriesClosedMooney M20C · Red Lodge, MTSep 19, 1965 · N5882Q · Substantial damage NTSB SEA66A0022Accident · No injuriesClosedHiller UH-12E · Choteau, MTSep 17, 1965 · N5360V · Substantial damage NTSB SEA66A0021Accident · 2 fatalClosedNavion B · Judith Gap, MTSep 11, 1965 · N4400K · Destroyed NTSB SEA66F0141Accident · Minor injuriesClosedAeronca 7AC · Ronan, MTSep 7, 1965 · N85023 · Substantial damage NTSB SEA66F0105Accident · No injuriesClosedPiper PA-17 · Deborgia, MTAug 31, 1965 · N4638H · Substantial damage NTSB SEA66F0099Accident · No injuriesClosedLuscombe 8E · W.Yellowston, MTAug 30, 1965 · N1781K · Substantial damage NTSB SEA66A0017Accident · 1 fatalClosedCallair A-9 · 14s Ryegate, MTAug 29, 1965 · N8250H · Destroyed NTSB SEA66D0104Accident · No injuriesClosedCessna 180 · Livingston, MTAug 22, 1965 · N7630A · Substantial damage NTSB SEA66A0012Accident · No injuriesClosedBell 47G3B1 · Libby, MTAug 16, 1965 · N73920 · Substantial damage NTSB SEA66D0117Accident · No injuriesClosedCessna 120 · Whitefish, MTAug 15, 1965 · N77000 · Substantial damage NTSB SEA66F0066Accident · Serious injuriesClosedLuscombe 8E · Billings, MTAug 10, 1965 · N2422K · Substantial damage NTSB SEA66D0109Accident · No injuriesClosedCessna 140A · Vida, MTAug 10, 1965 · N9414A · Substantial damage