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 SEA72AS046Accident · 2 fatalClosedAero Comdr 500 · Noxon, MTApr 8, 1972 · N2776 · Destroyed NTSB SEA72AS042Accident · 2 fatalClosedPiper PA-24 · Ronan, MTMar 23, 1972 · N7843P · Destroyed NTSB SEA72DTA14Accident · Minor injuriesClosedPiper PA-25 · Brusett, MTMar 22, 1972 · N7312Z · Substantial damage NTSB SEA72FTI16Accident · No injuriesClosedCessna 206 · Conner, MTMar 21, 1972 · N5011U · Substantial damage NTSB SEA72FTI15Accident · No injuriesClosedCessna 310G · Great Falls, MTMar 17, 1972 · N2905R · Substantial damage NTSB SEA72FTA15Accident · No injuriesClosedCessna 150J · Ashland, MTMar 16, 1972 · N5625G · Substantial damage NTSB SEA72FTA13Accident · Minor injuriesClosedStinson 108-3 · Red Lodge, MTFeb 26, 1972 · N6984M · Substantial damage NTSB SEA72DTI14Accident · No injuriesClosedPiper PA-18A · Conrad, MTFeb 20, 1972 · N3087Z · Substantial damage NTSB SEA72DTA12Accident · No injuriesClosedCessna 140 · Glendive, MTFeb 20, 1972 · N2040N · Substantial damage NTSB SEA72FTA11Accident · No injuriesClosedCessna 140 · Hardin, MTFeb 15, 1972 · N72261 · Substantial damage NTSB SEA72DTI13Accident · No injuriesClosedMooney M20E · Great Falls, MTFeb 6, 1972 · N9228V · Substantial damage NTSB SEA72DTI10Accident · No injuriesClosedAeronca 7EC · Malta, MTJan 21, 1972 · N7406B · Substantial damage NTSB SEA72FTI11Accident · No injuriesClosedCessna 172 · Kalispell, MTJan 19, 1972 · N6185E · Substantial damage NTSB SEA72DTI12Accident · No injuriesClosedCessna 172G · Loma, MTDec 27, 1971 · N3636L · Substantial damage NTSB SEA72AS021Accident · 2 fatalClosedMooney M20C · Broadus, MTNov 27, 1971 · N6436U · Destroyed NTSB SEA72AS019Accident · 1 fatalClosedCessna 150L · Ulm, MTNov 9, 1971 · N6691G · Destroyed NTSB SEA72DTA10Accident · No injuriesClosedLuscombe 8E · Volborg, MTOct 25, 1971 · N2472K · Substantial damage NTSB SEA72FTI09Accident · Serious injuriesClosedCessna 150 · Chinook, MTOct 24, 1971 · N6180T · Destroyed NTSB SEA72FTA09Accident · No injuriesClosedCessna 170B · Billings, MTOct 23, 1971 · N8234A · Substantial damage NTSB SEA72DTI08Accident · Serious injuriesClosedMooney M20C · Great Falls, MTOct 3, 1971 · N78939 · Substantial damage NTSB SEA72DTI07Accident · No injuriesClosedCessna 320 · Philipsburg, MTOct 2, 1971 · N5719X · Substantial damage NTSB SEA72FTA07Accident · No injuriesClosedPiper PA-23 · Harlowton, MTAug 31, 1971 · N4081P · Substantial damage NTSB SEA72DTI05Accident · No injuriesClosedDehavilland DH 104 · Chester, MTAug 21, 1971 · N1565V · Substantial damage NTSB SEA72DTI06Accident · No injuriesClosedCessna 337E · Livingston, MTAug 19, 1971 · N86545 · Substantial damage NTSB SEA72DTA08Accident · No injuriesClosedHughes 369HS · Mosby, MTAug 18, 1971 · N9059F · Substantial damage NTSB SEA72DTI04Accident · No injuriesClosedCessna 177 · Drummond, MTAug 6, 1971 · N29666 · Substantial damage NTSB SEA72FTA05Accident · No injuriesClosedCessna 150 · Sand Springs, MTAug 1, 1971 · N7971E · Substantial damage NTSB SEA72FTI03Accident · No injuriesClosedCessna 180 · Helena, MTJul 31, 1971 · N4577B · Substantial damage NTSB SEA72FTA02Accident · No injuriesClosedCallair A-9 · Laurel, MTJul 19, 1971 · N8264H · Substantial damage NTSB SEA72FTA04Accident · No injuriesClosedMaule M-4 · Wolf Point, MTJul 18, 1971 · N4700T · Substantial damage NTSB SEA72FTA03Accident · No injuriesClosedCessna 172 · Miles City, MTJul 14, 1971 · N8469U · Substantial damage NTSB SEA72DTI02Accident · No injuriesClosedAeronca 7AC · Conrad, MTJul 10, 1971 · N84458 · Substantial damage NTSB SEA72FTA01Accident · No injuriesClosedCessna 180D · Lodge Grass, MTJul 6, 1971 · N8609X · Substantial damage NTSB SEA72FTI01Accident · No injuriesClosedCessna 421B · Ennis, MTJul 5, 1971 · N803HK · Substantial damage NTSB SEA71FTA23Accident · No injuriesClosedCallair A-9 · Opheim, MTJun 20, 1971 · N9650Z · Substantial damage NTSB SEA71DTA24Accident · No injuriesClosedPiper PA-11 · Alzada, MTJun 16, 1971 · N4986H · Substantial damage NTSB SEA71FTI38Accident · 1 fatalClosedPiper PA-18 · Turner, MTJun 13, 1971 · N5765D · Destroyed NTSB SEA71DTI39Accident · No injuriesClosedLuscombe T-8F · Chinook, MTJun 13, 1971 · N2216B · Substantial damage NTSB SEA71FTI37Accident · No injuriesClosedCessna A188A · Havre, MTJun 8, 1971 · N9955G · Substantial damage NTSB SEA71FTI36Accident · Minor injuriesClosedCallair A-5 · Havre, MTJun 7, 1971 · N2957G · Substantial damage NTSB SEA71FTI35Accident · No injuriesClosedChampion 7AC · Belgrade, MTJun 5, 1971 · N84885 · Substantial damage NTSB SEA71DTI34Accident · No injuriesClosedCessna 182F · Shelby, MTJun 4, 1971 · N3463U · Substantial damage NTSB SEA71FTA22Accident · No injuriesClosedBeech A23-19 · Terry, MTJun 2, 1971 · N4722J · Substantial damage NTSB SEA71FTI33Accident · Minor injuriesClosedCessna 140 · Butte, MTMay 29, 1971 · N3079N · Substantial damage NTSB SEA71DTI32Accident · No injuriesClosedPiper PA-28 · Belgrade, MTMay 27, 1971 · N6357R · Substantial damage NTSB SEA71DTI31Accident · No injuriesClosedPiper PA-18 · Gallatin Gwy, MTMay 23, 1971 · N3695A · Substantial damage NTSB SEA71FTA21Accident · No injuriesClosedCessna 150J · Sidney, MTMay 17, 1971 · N60792 · Substantial damage NTSB SEA71FTA19Accident · 1 fatalClosedPitts Spec SC-1 · Lewiston, MTMay 9, 1971 · N21F · Destroyed NTSB SEA71DTI30Accident · No injuriesClosedCessna 175 · Havre, MTMay 2, 1971 · N7169M · Substantial damage NTSB SEA71FTI29Accident · No injuriesClosedCessna 150F · Libby, MTApr 29, 1971 · N6618F · Substantial damage