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 SEA76AS078Accident · 1 fatalClosedPiper PA-18 · Zurich, MTSep 24, 1976 · N8966C · Destroyed NTSB SEA76AS077Accident · 2 fatalClosedCessna A185F · Geraldine, MTSep 15, 1976 · N53075 · Destroyed NTSB SEA76FTI38Accident · 1 fatalClosedPiper PA-18A · Helena, MTAug 31, 1976 · N1189C · Substantial damage NTSB SEA76FTA29Accident · Minor injuriesClosedCessna 185 · Ekalaka, MTAug 26, 1976 · N9942X · Destroyed NTSB SEA76DTI37Accident · Minor injuriesClosedPiper PA-28 · Turner, MTAug 16, 1976 · N9051J · Substantial damage NTSB SEA76DTI36Accident · Minor injuriesClosedPiper PA-18 · Condon, MTAug 11, 1976 · N4380Z · Substantial damage NTSB SEA76DTA28Accident · No injuriesClosedPiper PA-28 · Powderville, MTAug 5, 1976 · N5827W · Substantial damage NTSB SEA76AS067Accident · No injuriesClosedDehavilland DHC-6 · Havre, MTAug 3, 1976 · N980FL · No damage NTSB SEA76AS065Accident · 3 fatalClosedBeech S35 · Billings, MTAug 1, 1976 · N8681Q · Destroyed NTSB SEA76FTA27Accident · Serious injuriesClosedCessna 170 · Fishtail, MTJul 31, 1976 · N2541V · Destroyed NTSB SEA76FTA26Accident · Serious injuriesClosedCessna 150L · Miles City, MTJul 30, 1976 · N11547 · Destroyed NTSB SEA76DTI34Accident · Serious injuriesClosedBellanca 7ECA · Alder, MTJul 29, 1976 · N8662 · Substantial damage NTSB SEA76FTI33Accident · No injuriesClosedCessna 182 · Seeley Lake, MTJul 25, 1976 · N7251E · Substantial damage NTSB SEA76AS064Accident · 1 fatalClosedPiper PA-28 · Butte, MTJul 25, 1976 · N6825W · Destroyed NTSB SEA76FTI35Accident · No injuriesClosedBeech 95-55 · Ennis, MTJul 24, 1976 · N9339Y · Substantial damage NTSB SEA76FTI32Accident · No injuriesClosedCessna 150D · Lincoln, MTJul 14, 1976 · N19422 · Substantial damage NTSB SEA76AS062Accident · 4 fatalClosedCessna 182H · Kalispell, MTJul 14, 1976 · N2087X · Destroyed NTSB SEA76FTI31Accident · 2 fatalClosedPiper PA-18 · Helena, MTJul 13, 1976 · N7490L · Destroyed NTSB SEA76FTI30Accident · Minor injuriesClosedBellanca 7GCBC · Inverness, MTJul 6, 1976 · N88310 · Substantial damage NTSB SEA76DTI29Accident · No injuriesClosedCallair A-9 · Pendroy, MTJul 6, 1976 · N9667Z · Substantial damage NTSB SEA77FTA01Accident · No injuriesClosedCessna 185 · Glasgow, MTJun 10, 1976 · N1688R · Substantial damage NTSB SEA76DTA24Accident · No injuriesClosedAero Comdr 600S2R · Scobey, MTJun 10, 1976 · N4901X · Substantial damage NTSB SEA76FTA25Accident · No injuriesClosedPiper PA-25 · Forsyth, MTJun 9, 1976 · N7611Z · Substantial damage NTSB SEA76FTA23Accident · No injuriesClosedCessna 205 · Fishtail, MTJun 9, 1976 · N8481Z · Substantial damage NTSB SEA76FTA22Accident · No injuriesClosedCessna 177 · Hardin, MTJun 5, 1976 · N34525 · Substantial damage NTSB SEA76AS055Accident · 1 fatalClosedPiper PA-23 · Hamilton, MTJun 3, 1976 · N6507Y · Destroyed NTSB SEA76DTA21Accident · No injuriesClosedCessna 172 · Harlowtown, MTMay 31, 1976 · N4244L · Substantial damage NTSB SEA76AS052Accident · 2 fatalClosedPiper J3C-65 · Rock Springs, MTMay 30, 1976 · N6519H · Destroyed NTSB SEA76FTI27Accident · No injuriesClosedCessna 188B · Three Forks, MTMay 17, 1976 · N4810Q · Substantial damage NTSB SEA76IS046Incident · 1 fatalClosedDouglas DC-10 · Billings, MTMay 13, 1976 · N1810U · No damage NTSB SEA76FTI26Accident · Minor injuriesClosedCessna U206F · Deer Lodge, MTMay 8, 1976 · N2515P · Destroyed NTSB SEA76DTI25Accident · No injuriesClosedCessna 150 · Three Forks, MTMay 5, 1976 · N18119 · Substantial damage NTSB SEA76DTI24Accident · No injuriesClosedCessna 210 · Stevensville, MTApr 17, 1976 · N59130 · Substantial damage NTSB SEA76FTA20Accident · No injuriesClosedCessna 185 · Glendive, MTApr 15, 1976 · N70283 · Substantial damage NTSB SEA76DTI28Accident · No injuriesClosedCessna A188B · Shelby, MTApr 15, 1976 · C-GWWU · Substantial damage NTSB SEA76DTI23Accident · No injuriesClosedGrumman G-164A · Chester, MTApr 9, 1976 · N5338 · Substantial damage NTSB SEA76FTA19Accident · Serious injuriesClosedCessna 150 · Shawmut, MTApr 2, 1976 · N7836E · Destroyed NTSB SEA76FTI22Accident · Minor injuriesClosedPiper PA-24 · Thompson Falls, MTMar 26, 1976 · N5482P · Substantial damage NTSB SEA76FTA17Accident · No injuriesClosedCessna 170A · Billings, MTMar 16, 1976 · N9581A · Substantial damage NTSB SEA76FTA16Accident · No injuriesClosedPiper PA-11 · Ashland, MTMar 10, 1976 · N5010H · Substantial damage NTSB SEA76DTI21Accident · No injuriesClosedPiper PA-28R · Missoula, MTMar 5, 1976 · N55916 · Substantial damage NTSB SEA76ATI15Accident · Serious injuriesClosedPiper PA-18 · Big Timber, MTMar 2, 1976 · N3474Z · Substantial damage NTSB SEA76FTA14Accident · No injuriesClosedCessna 150J · Kinsey, MTMar 1, 1976 · N5625G · Substantial damage NTSB SEA76FTI20Accident · No injuriesClosedPiper PA-28 · Helena, MTJan 30, 1976 · N33735 · Substantial damage NTSB SEA76DTI19Accident · No injuriesClosedStearman PT-17 · Marias Pass, MTJan 23, 1976 · N60131 · Substantial damage NTSB SEA76DTA12Accident · No injuriesClosedCessna 172 · Malta, MTJan 17, 1976 · N8398X · Substantial damage NTSB SEA76FTA13Accident · No injuriesClosedCessna 182 · Billings, MTJan 16, 1976 · N4698K · Substantial damage NTSB SEA76DTI18Accident · No injuriesClosedPiper PA-18 · Geraldine, MTJan 8, 1976 · N3690Z · Substantial damage NTSB SEA76FTA10Accident · No injuriesClosedPiper PA-18 · Glasgow, MTDec 23, 1975 · N5425H · Substantial damage NTSB SEA76FTA11Accident · No injuriesClosedCessna 172B · Billings, MTDec 22, 1975 · N4655C · Substantial damage