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 DEN80FTA14Accident · No injuriesClosedPiper PA-34 · Billings, MTJun 21, 1980 · C-GRPI · Substantial damage NTSB DEN80FA042Accident · 2 fatalClosedPiper PA-30 · Saltese, MTJun 18, 1980 · N7181Y · Destroyed NTSB DEN80FA041Accident · 1 fatalClosedBellanca 7GCBC · Joplin, MTJun 15, 1980 · N31276 · Substantial damage NTSB DEN80FTA13Accident · 1 fatalClosedGrumman G-164A · Sand Springs, MTJun 14, 1980 · N667U · Destroyed NTSB DEN80DTI11Accident · No injuriesClosedCessna 140 · Lost Prairie, MTJun 8, 1980 · N76657 · Substantial damage NTSB DEN80FTA12Accident · No injuriesClosedCessna 150 · Winnett, MTJun 3, 1980 · N11499 · Substantial damage NTSB DEN80FA035Accident · 3 fatalClosedMooney 20F · Raynesford, MTMay 23, 1980 · N7068V · Destroyed NTSB DEN80FTI07Accident · No injuriesClosedCessna 188B · Havre, MTMay 17, 1980 · N9172G · Substantial damage NTSB DEN80FTA22Accident · No injuriesClosedPiper PA-18 · Alzada, MTMay 17, 1980 · N7671D · Substantial damage NTSB SEA80DTA11Accident · No injuriesClosedCallair A-9 · Bloomfield, MTApr 24, 1980 · N8246H · Substantial damage NTSB SEA80FTA10Accident · No injuriesClosedGrumman G-164B · Billings, MTApr 19, 1980 · N6687K · Destroyed NTSB SEA80FTA09Accident · Minor injuriesClosedPiper PA-18 · Winifred, MTApr 17, 1980 · N54283 · Destroyed NTSB DEN80FA031Accident · 2 fatalClosedCessna 441 · Butte, MTApr 1, 1980 · N36941 · Destroyed NTSB SEA80FTI06Accident · No injuriesClosedPiper PA-24 · Havre, MTMar 30, 1980 · N8820P · Substantial damage NTSB SEA80DTI05Accident · No injuriesClosedCessna A185F · Condon, MTFeb 25, 1980 · N4914E · Substantial damage NTSB SEA80FTA08Accident · No injuriesClosedCessna 180 · Big Timber, MTFeb 11, 1980 · N9296C · Substantial damage NTSB SEA80DTI04Accident · No injuriesClosedBellanca 7GCBC · Browning, MTJan 29, 1980 · N5026G · Substantial damage NTSB SEA80DTI03Accident · No injuriesClosedPiper PA-28 · Missoula, MTJan 18, 1980 · N38313 · Substantial damage NTSB SEA80FA015Accident · 4 fatalClosedPiper PA-28R · Kalispell, MTJan 10, 1980 · N3839M · Destroyed NTSB SEA80FTA07Accident · 1 fatalClosedScorpion 133 · Nashua, MTDec 29, 1979 · NONE · Destroyed NTSB SEA80FTA06Accident · No injuriesClosedCessna 210M · Glendive, MTDec 21, 1979 · N8197M · Substantial damage NTSB SEA80FTA05Accident · No injuriesClosedPiper PA-22 · Laurel, MTDec 20, 1979 · N7403D · Substantial damage NTSB SEA80FTI02Accident · Serious injuriesClosedPiper PA-32R · Chester, MTDec 19, 1979 · N2168D · Destroyed NTSB SEA80FTA03Accident · No injuriesClosedCessna 182E · Red Lodge, MTDec 2, 1979 · N3136Y · Substantial damage NTSB SEA80FTA04Accident · No injuriesClosedCessna 140 · Malta, MTDec 1, 1979 · N2197N · Substantial damage NTSB SEA80FTA02Accident · No injuriesClosedCessna 210 · Billings, MTOct 20, 1979 · N3976Y · Substantial damage NTSB SEA80FTA01Accident · No injuriesClosedCessna 150 · Billings, MTOct 19, 1979 · N45361 · Substantial damage NTSB SEA80FTI01Accident · 2 fatalClosedCessna A185F · Dillon, MTOct 16, 1979 · N4961Q · Destroyed NTSB SEA79FTI27Accident · Serious injuriesClosedCessna 182C · Whitefish, MTSep 30, 1979 · N9054T · Destroyed NTSB SEA79FTI26Accident · No injuriesClosedCessna 172K · Three Forks, MTSep 27, 1979 · N84445 · Substantial damage NTSB SEA79FTA21Accident · No injuriesClosedPiper PA-18 · Winnett, MTSep 25, 1979 · N83613 · Substantial damage NTSB SEA79FA060Accident · 2 fatalClosedCessna 150 · Sula, MTSep 20, 1979 · CG-CMZ · Destroyed NTSB SEA79FTA20Accident · Minor injuriesClosedCessna 182G · Billings, MTSep 19, 1979 · N3410S · Substantial damage NTSB SEA79DTI25Accident · No injuriesClosedCessna 172 · Conrad, MTSep 13, 1979 · N2015S · Substantial damage NTSB SEA79FT124Accident · Serious injuriesClosedPiper PA-24 · Big Sandy, MTAug 29, 1979 · N5791P · Destroyed NTSB SEA79FTA19Accident · No injuriesClosedBell 206B · Absarokee, MTAug 28, 1979 · N5013C · Substantial damage NTSB SEA79FT123Accident · Minor injuriesClosedKaman HH-43F · Hamilton, MTAug 24, 1979 · N4524 · Destroyed NTSB SEA79FA050Accident · 4 fatalClosedBeech B23 · Neihart, MTAug 24, 1979 · N7635R · Destroyed NTSB SEA79FTA18Accident · No injuriesClosedGrum Amer AA-5 · Laurel, MTAug 23, 1979 · N5880L · Substantial damage NTSB SEA79FTA17Accident · No injuriesClosedErco 415-C · Billings, MTJul 31, 1979 · N2467H · Substantial damage NTSB SEA79FA048Accident · 2 fatalClosedGrum Amer AA-5A · Augusta, MTJul 24, 1979 · N9966U · Destroyed NTSB SEA79DTI22Accident · Minor injuriesClosedCessna 182 · Schafer, MTJul 21, 1979 · N6166B · Substantial damage NTSB SEA79DTI20Accident · No injuriesClosedCessna 170B · Cut Bank, MTJul 18, 1979 · N8051A · Substantial damage NTSB SEA79FTA16Accident · No injuriesClosedCessna 180 · Landusky, MTJul 8, 1979 · N1674C · Substantial damage NTSB SEA79FA041Accident · 2 fatalClosedBellanca 7GCBC · Big Sky, MTJul 1, 1979 · N6397V · Destroyed NTSB SEA79FTI19Accident · No injuriesClosedBell 47G3B1 · Emigrant, MTJun 25, 1979 · N3078G · Substantial damage NTSB SEA79FA040Accident · 1 fatalClosedBellanca 7KCAB · Laurel, MTJun 22, 1979 · N1833G · Destroyed NTSB SEA79FTI16Accident · Serious injuriesClosedCessna TU206F · Sula, MTJun 10, 1979 · N8733Q · Substantial damage NTSB SEA79FTI18Accident · No injuriesClosedCessna 188 · Toston, MTJun 9, 1979 · N4810Q · Substantial damage NTSB SEA79FTI17Accident · No injuriesClosedCessna 140 · Brady, MTJun 8, 1979 · N77318 · Substantial damage