Skip to content

NTSB investigations, MT

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 DEN81DTI16Accident · No injuriesClosedCessna 182 · Great Falls, MTJul 12, 1981 · N21055 · Substantial damage NTSB DEN81DTI13Accident · No injuriesClosedCessna 172 · Schafers Mdws, MTJul 12, 1981 · N7304A · Substantial damage NTSB DEN81FTI14Accident · Minor injuriesClosedPiper PA-28 · Seely Lake, MTJul 10, 1981 · N41179 · Substantial damage NTSB DEN81DTA10Accident · No injuriesClosedPiper PA-24 · Miles City, MTJun 27, 1981 · N8935P · Substantial damage NTSB DEN81FTI12Accident · No injuriesClosedBell UH1B · Heart Butte, MTJun 26, 1981 · N4237V · Substantial damage NTSB DEN81FTI11Accident · No injuriesClosedHughes 269C · Ennis, MTJun 26, 1981 · N8988F · Substantial damage NTSB DEN81FTA08Accident · No injuriesClosedCessna 188A · Lavina, MTJun 14, 1981 · N5380J · Substantial damage NTSB DEN81FTA09Accident · No injuriesClosedCessna 188 · Flaxville, MTJun 12, 1981 · N9852V · Substantial damage NTSB DEN81DTI09Accident · No injuriesClosedCessna 180 · Jackson, MTJun 5, 1981 · N3431Y · Substantial damage NTSB DEN81DTI10Accident · No injuriesClosedHiller Acft UH-12E · Ulm, MTJun 2, 1981 · N67088 · Substantial damage NTSB DEN81FTI08Accident · Serious injuriesClosedCessna 188B · Turner, MTMay 27, 1981 · N4827Q · Substantial damage NTSB DEN81FTA07Accident · No injuriesClosedPiper PA-18 · Billings, MTMay 15, 1981 · N7474L · Substantial damage NTSB DEN81DTI07Accident · No injuriesClosedAero Comdr A9B · Townsend, MTMay 9, 1981 · N7949V · Substantial damage NTSB DEN81FTI06Accident · 1 fatalClosedBell 47G-3B · Thompson Falls, MTMay 4, 1981 · N14802 · Destroyed NTSB DEN81FTI05Accident · 1 fatalClosedCessna 185F · Geraldine, MTApr 30, 1981 · N1846R · Destroyed NTSB DEN81DTI04Accident · Minor injuriesClosedCessna 175 · Belgrade, MTApr 12, 1981 · N9428B · Substantial damage NTSB DEN81FTA06Accident · No injuriesClosedCessna 182 · Wolf Point, MTMar 24, 1981 · N2315G · Minor damage NTSB DEN81FA023Accident · 2 fatalClosedMooney M20G · Ryegate, MTMar 21, 1981 · N6844N · Destroyed NTSB DEN81FA021Accident · 2 fatalClosedTavlorcraft BC-12D · Stevensville, MTMar 14, 1981 · N96689 · Substantial damage NTSB DEN81FTA05Accident · No injuriesClosedCessna 210 · Billings, MTFeb 5, 1981 · N3964Y · Substantial damage NTSB DEN81FTA04Accident · Minor injuriesClosedBell 206B · Columbus, MTJan 28, 1981 · N8533K · Substantial damage NTSB DEN81DTI03Accident · No injuriesClosedPiper PA-18 · Cascade, MTJan 27, 1981 · N3981Z · Substantial damage NTSB DEN81DTI02Accident · Serious injuriesClosedRobinson R-22 · Havre, MTJan 22, 1981 · N9036N · Destroyed NTSB DEN81DTI01Accident · Minor injuriesClosedCessna 172 · Cut Bank, MTDec 26, 1980 · C-GXSI · Substantial damage NTSB DEN81DTA03Accident · No injuriesClosedPiper PA-18 · Saco, MTDec 26, 1980 · N83312 · Substantial damage NTSB DEN81FTA02Accident · No injuriesClosedBeech V35B · Billings, MTNov 24, 1980 · N9007V · Substantial damage NTSB DEN81FA007Accident · 3 fatalClosedBeech 65 · Sula, MTOct 17, 1980 · N35CS · Destroyed NTSB DEN80FA005Accident · 1 fatalClosedTaylorcraft BC12-D · St.Ignatius, MTOct 13, 1980 · N95518 · Substantial damage NTSB DEN81FTA01Accident · No injuriesClosedHelio Acft H-250 · Baker, MTOct 3, 1980 · N1XV · Substantial damage NTSB DEN80FTA23Accident · No injuriesClosedPiper PA-28 · Billings, MTSep 29, 1980 · N7498J · Substantial damage NTSB SEA80FA048Accident · 2 fatalClosedCessna T210L · Dillon, MTSep 11, 1980 · N2041S · Destroyed NTSB DEN80DTI15Accident · No injuriesClosedCessna 180 · Raynesford, MTSep 8, 1980 · N52155 · Substantial damage NTSB DEN80FTA21Accident · No injuriesClosedBell UH-1B · Red Lodge, MTSep 1, 1980 · N911CD · Substantial damage NTSB DEN80FA059Accident · 3 fatalClosedBell 206A/B · Red Lodge, MTAug 30, 1980 · N8030 · Destroyed NTSB DEN80FTA20Accident · No injuriesClosedCessna 182 · Winifred, MTAug 23, 1980 · N2478Q · Substantial damage NTSB DEN80FA057Accident · 5 fatalClosedPiper PA-32 · Choteau, MTAug 21, 1980 · N4429T · Substantial damage NTSB DEN80FTA19Accident · No injuriesClosedBeech 95-B55 · Miles City, MTAug 13, 1980 · N1552W · Substantial damage NTSB DEN80FTA18Accident · Serious injuriesClosedPiper PA-25 · Sidney, MTAug 7, 1980 · N7375Z · Substantial damage NTSB DEN80FA053Accident · Minor injuriesClosedAerospatle 315B · Dell, MTAug 2, 1980 · N7915 · Substantial damage NTSB DEN80FA051Accident · 1 fatalClosedAerospatle 315B · Dell, MTJul 28, 1980 · N67103 · Substantial damage NTSB DEN80FTA17Accident · No injuriesClosedCessna 150 · Sidney, MTJul 24, 1980 · N2235J · Substantial damage NTSB DEN80DTI13Accident · No injuriesClosedCessna 172 · Turner, MTJul 20, 1980 · N739KL · Substantial damage NTSB DEN80DTI12Accident · No injuriesClosedCallair B-1A · Valier, MTJul 18, 1980 · N7278V · Substantial damage NTSB DEN80FA048Accident · Serious injuriesClosedHiller Acft OH-23G · Cutbank, MTJul 16, 1980 · N603RA · Destroyed NTSB DEN80DTI14Accident · No injuriesClosedCessna 150 · Cut Bank, MTJul 11, 1980 · N6296S · Substantial damage NTSB DEN80FTA16Accident · Serious injuriesClosedCallair A-9B · Bridger, MTJun 28, 1980 · N7693V · Substantial damage NTSB DEN80FTA15Accident · No injuriesClosedBeech B-35 · Billings, MTJun 26, 1980 · N5224C · Substantial damage NTSB DEN80FTI10Accident · No injuriesClosedPiper PA-30 · Great Falls, MTJun 22, 1980 · N8817Y · Substantial damage NTSB DEN80FTI08Accident · No injuriesClosedPiper PA-25 · Oilmont, MTJun 22, 1980 · N6391Z · Substantial damage NTSB DEN80FTI09Accident · No injuriesClosedCessna 182 · Monarch, MTJun 21, 1980 · N52368 · Substantial damage