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 SEA78DA042Accident · 1 fatalClosedCessna 170A · Billings, MTJul 9, 1978 · N1780D · Destroyed NTSB SEA78FTA14Accident · No injuriesClosedMooney M20F · Savage, MTJul 4, 1978 · N3464N · Substantial damage NTSB SEA78FA041Accident · 2 fatalClosedCessna 210L · Belgrade, MTJun 30, 1978 · N22195 · Destroyed NTSB SEA78FTA15Accident · No injuriesClosedCessna 177 · Billings, MTJun 26, 1978 · N7MT · Substantial damage NTSB SEA78DTA13Accident · No injuriesClosedCessna 172 · Circle, MTJun 23, 1978 · N79190 · Substantial damage NTSB SEA78FA035Accident · No injuriesClosedCessna U206 · Billings, MTJun 9, 1978 · N2174F · Substantial damage NTSB SEA78FTI22Accident · 2 fatalClosedPiper PA-18 · Columbia Falls, MTJun 7, 1978 · N3473Z · Substantial damage NTSB SEA78DTA11Accident · No injuriesClosedPiper PA-18 · Lewistown, MTJun 4, 1978 · N54283 · Substantial damage NTSB SEA78FTI21Accident · 2 fatalClosedBellanca 7KCAB · Pray, MTMay 29, 1978 · N8527 · Destroyed NTSB SEA78FTI20Accident · No injuriesClosedPiper PA-20 · Deer Lodge, MTMay 29, 1978 · N1514A · Substantial damage NTSB SEA78FTI19Accident · No injuriesClosedPiper PA-25 · Conrad, MTMay 26, 1978 · N9883P · Substantial damage NTSB SEA78FTI18Accident · No injuriesClosedMaule M5235C · Havre, MTMay 24, 1978 · N381X · Substantial damage NTSB SEA78FTI17Accident · No injuriesClosedCessna 188B · Chinook, MTMay 21, 1978 · N9355R · Substantial damage NTSB SEA78FTI16Accident · No injuriesClosedEnstrom F-28C · Haugan, MTMay 20, 1978 · N643H · Substantial damage NTSB SEA78FTI15Accident · No injuriesClosedHiller Acft UH-12E · Highwood, MTMay 16, 1978 · N48234 · Destroyed NTSB SEA78FTI14Accident · Minor injuriesClosedCessna 150 · Hamilton, MTMay 16, 1978 · N6743G · Substantial damage NTSB SEA78FTI13Accident · No injuriesClosedPiper PA-28 · Kalispell, MTMay 8, 1978 · N16447 · Substantial damage NTSB SEA78FTI12Accident · No injuriesClosedCessna 305A · Belgrade, MTApr 15, 1978 · N5240G · Substantial damage NTSB SEA78FTI11Accident · No injuriesClosedCessna 206 · Helena, MTApr 11, 1978 · N206AM · Substantial damage NTSB SEA78FTI10Accident · No injuriesClosedEnstrom 280C · Trout Creek, MTApr 5, 1978 · N638H · Substantial damage NTSB SEA78FTI09Accident · No injuriesClosedLuscombe 8A · Hamilton, MTMar 19, 1978 · N45564 · Substantial damage NTSB SEA78FTI08Accident · No injuriesClosedCessna 172M · Stevensville, MTFeb 14, 1978 · N9068H · Substantial damage NTSB SEA78DTI07Accident · No injuriesClosedCessna 150M · Conrad, MTFeb 8, 1978 · N45662 · Substantial damage NTSB SEA78FTI06Accident · No injuriesClosedBellanca 7GCBC · Havre, MTJan 28, 1978 · N1116E · Substantial damage NTSB SEA78FTA10Accident · No injuriesClosedPiper PA-18 · Billings, MTJan 14, 1978 · N2230Y · Substantial damage NTSB SEA78FA017Accident · 1 fatalClosedAero Comdr 500B · Miles City, MTJan 5, 1978 · N6308U · Destroyed NTSB SEA78DTI05Accident · No injuriesClosedCessna 185 · Geraldine, MTJan 5, 1978 · N3360R · Substantial damage NTSB SEA78FA015Accident · 2 fatalClosedGrum Amer AA-5A · Anaconda, MTDec 28, 1977 · N9968U · Destroyed NTSB SEA78DTI04Accident · No injuriesClosedPiper PA-18 · Livingston, MTDec 23, 1977 · N4996P · Substantial damage NTSB SEA78FTA08Accident · Minor injuriesClosedBell 47G3B1 · Billings, MTDec 20, 1977 · N7860S · Destroyed NTSB SEA78DTI03Accident · No injuriesClosedCessna 170 · Browning, MTDec 18, 1977 · N5414C · Substantial damage NTSB SEA78FTA09Accident · No injuriesClosedCessna 150 · Peerless, MTDec 17, 1977 · N61067 · Substantial damage NTSB SEA78FTA07Accident · No injuriesClosedCessna TU206 · Zortman, MTDec 12, 1977 · N357DP · Substantial damage NTSB SEA78DTA06Accident · No injuriesClosedCessna 182 · Baker, MTNov 30, 1977 · N71638 · Substantial damage NTSB SEA78DTI01Accident · No injuriesClosedLuscombe 8AC · Boulder, MTNov 13, 1977 · N1041K · Substantial damage NTSB SEA78FTA05Accident · No injuriesClosedGrum Amer AA5A · Billings, MTNov 12, 1977 · N26106 · Substantial damage NTSB SEA77FTA04Accident · No injuriesClosedPiper PA-22 · Glendive, MTNov 7, 1977 · N8152D · Substantial damage NTSB SEA78FTA03Accident · No injuriesClosedCessna 185 · Bay Horse, MTNov 4, 1977 · N21709 · Substantial damage NTSB SEA78DTI02Accident · No injuriesClosedCessna 310G · Belgrade, MTOct 20, 1977 · N8984Z · Substantial damage NTSB SEA78FTA02Accident · Minor injuriesClosedCessna 210-5 · Lewistown, MTOct 2, 1977 · N8162Z · Substantial damage NTSB SEA77FTA01Accident · No injuriesClosedBellanca 8KCAB · Forsyth, MTOct 2, 1977 · N2535Z · Substantial damage NTSB SEA77DTI24Accident · No injuriesClosedCessna 120 · Chester, MTSep 23, 1977 · N2687N · Substantial damage NTSB SEA77DTI23Accident · No injuriesClosedCessna 182G · Ledger, MTSep 23, 1977 · N34105 · Substantial damage NTSB SEA77FTI22Accident · No injuriesClosedCessna 210D · W.Sulphur Spgs, MTSep 15, 1977 · N3964Y · Minor damage NTSB SEA77DTI20Accident · Minor injuriesClosedCessna 170 · Ft.Benton, MTSep 3, 1977 · N4212V · Substantial damage NTSB SEA77FTI19Accident · No injuriesClosedBell 47G3B2 · Missoula, MTSep 1, 1977 · N7937J · Substantial damage NTSB SEA77FTA29Accident · Serious injuriesClosedPiper PA-18 · Wyola, MTAug 29, 1977 · N3989P · Destroyed NTSB SEA77FTA30Accident · No injuriesClosedPiper PA-28 · Miles City, MTAug 26, 1977 · N5358L · Substantial damage NTSB SEA77DTI18Accident · No injuriesClosedCessna 180 · Cut Bank, MTAug 25, 1977 · N52102 · Substantial damage NTSB SEA77FTA28Accident · No injuriesClosedMaule M4 · Hardin, MTAug 12, 1977 · N12011 · Substantial damage