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 SEA75DTI23Accident · No injuriesClosedCessna 182 · Kalispell, MTMar 14, 1975 · N3189U · Substantial damage NTSB SEA75DTI22Accident · No injuriesClosedPiper PA-24 · Conrad, MTMar 4, 1975 · N8935P · Substantial damage NTSB SEA75FTA13Accident · Minor injuriesClosedBellanca 7GCBC · Ismay, MTMar 2, 1975 · N11644 · Substantial damage NTSB SEA75DTI21Accident · No injuriesClosedCessna 140A · Deer Lodge, MTFeb 27, 1975 · N1141D · Substantial damage NTSB SEA75DTI20Accident · No injuriesClosedPiper PA-18 · Adel, MTFeb 16, 1975 · N3378Z · Substantial damage NTSB SEA75DTI19Accident · No injuriesClosedCessna 150 · Wh.Sulphur Spg, MTFeb 16, 1975 · N50632 · Substantial damage NTSB SEA75FTA12Accident · 1 fatalClosedCessna 177 · Billings, MTFeb 6, 1975 · N2308Y · Minor damage NTSB SEA75DTI18Accident · No injuriesClosedPiper PA-28 · Anaconda, MTFeb 6, 1975 · N43481 · Substantial damage NTSB SEA75DTI17Accident · No injuriesClosedCessna 170B · Missoula, MTJan 18, 1975 · N8252A · Substantial damage NTSB SEA75FTI16Accident · Serious injuriesClosedPiper PA-24 · Butte, MTDec 9, 1974 · N6916P · Substantial damage NTSB SEA75FTA14Accident · No injuriesClosedPiper PA-18 · Hardin, MTDec 4, 1974 · N8109Y · Substantial damage NTSB SEA75FTA11Accident · No injuriesClosedCessna 210F · Ballatine, MTDec 1, 1974 · N5812F · Substantial damage NTSB SEA75DTI14Accident · No injuriesClosedStinson 108-2 · Wisdom, MTOct 27, 1974 · N9815K · Substantial damage NTSB SEA75FTI13Accident · Minor injuriesClosedPiper PA-22 · Victor, MTOct 9, 1974 · N1218C · Substantial damage NTSB SEA75FTA10Accident · Serious injuriesClosedCallair A-9 · Glendive, MTOct 9, 1974 · N9650Z · Substantial damage NTSB SEA75FTI11Accident · No injuriesClosedCessna 182 · Harve, MTSep 24, 1974 · N182F · Substantial damage NTSB SEA75FTA09Accident · No injuriesClosedCessna 180D · Circle, MTSep 15, 1974 · N6421X · Substantial damage NTSB SEA75DTI10Accident · No injuriesClosedCessna 180 · Hingham, MTSep 6, 1974 · N42359 · Substantial damage NTSB SEA75FTA08Accident · No injuriesClosedChampion 7GCAA · Carlyle, MTSep 4, 1974 · N8319V · Substantial damage NTSB SEA75FTA07Accident · No injuriesClosedCallair A-9 · Pryor, MTSep 3, 1974 · N3566G · Substantial damage NTSB SEA75DTI08Accident · No injuriesClosedChampion 7GCB · Kalispell, MTSep 3, 1974 · N9822Y · Substantial damage NTSB SEA75DTI09Accident · No injuriesClosedTaylorcraft BC12-D · Kalispell, MTSep 2, 1974 · N44286 · Substantial damage NTSB SEA75AS012Accident · 2 fatalClosedChampion 7GC · Florence, MTAug 31, 1974 · N8092E · Destroyed NTSB SEA75FTA06Accident · Serious injuriesClosedPiper PA-11 · Hammond, MTAug 19, 1974 · N4992H · Substantial damage NTSB SEA75 TI05Accident · No injuriesClosedPiper PA-18 · Big Fork, MTAug 6, 1974 · N3920Z · Substantial damage NTSB SEA74DTI06Accident · No injuriesClosedCessna 180 · Ferndale, MTAug 4, 1974 · N5067E · Substantial damage NTSB SEA75DTI04Accident · No injuriesClosedCessna 182 · Chinook, MTJul 27, 1974 · N2506G · Destroyed NTSB SEA75FTI03Accident · Serious injuriesClosedBellanca 7GCBC · Hogeland, MTJul 26, 1974 · N9183L · Destroyed NTSB SEA75FTA05Accident · No injuriesClosedGrumman G-164 · Baker, MTJul 25, 1974 · N664U · Substantial damage NTSB SEA75FTI02Accident · Serious injuriesClosedMooney M20F · Meadow Creek, MTJul 23, 1974 · N6428Q · Substantial damage NTSB SEA75AS005Accident · No injuriesClosedCessna U206E · Darby, MTJul 22, 1974 · N9420G · Substantial damage NTSB SEA75FTA04Accident · No injuriesClosedCessna 150 · Crane, MTJul 19, 1974 · N6484G · Substantial damage NTSB SEA75DTA03Accident · No injuriesClosedPiper PA-18 · Ft.Peck, MTJul 18, 1974 · N5775D · Substantial damage NTSB SEA75FTA02Accident · No injuriesClosedMooney M20D · Glasgow, MTJul 15, 1974 · N6619U · Substantial damage NTSB SEA75DTI01Accident · No injuriesClosedHiller Acft FH1100 · Glacier Park, MTJul 15, 1974 · N711KH · Substantial damage NTSB SEA75FTA01Accident · No injuriesClosedPiper PA-18 · Malta, MTJul 5, 1974 · N2625A · Substantial damage NTSB SEA74DTA29Accident · No injuriesClosedAeronca 7AC · Alzada, MTJun 22, 1974 · N84439 · Substantial damage NTSB SEA74FTI28Accident · No injuriesClosedCessna 210 · Deer Lodge, MTJun 21, 1974 · N59027 · Substantial damage NTSB SEA74FTA28Accident · No injuriesClosedPiper PA-18 · Saco, MTJun 18, 1974 · N3803Z · Substantial damage NTSB SEA74DTI26Accident · No injuriesClosedCessna 172 · Swan Lake, MTJun 18, 1974 · N6282E · Substantial damage NTSB SEA74DTI29Accident · No injuriesClosedBell 47G3B1 · Lima, MTJun 16, 1974 · N7928S · Substantial damage NTSB SEA74DTI24Accident · No injuriesClosedLuscombe 8A · Wise River, MTJun 13, 1974 · N45831 · Substantial damage NTSB SEA74FTI25Accident · Serious injuriesClosedPiper PA-25 · Pablo, MTJun 11, 1974 · N7070Z · Destroyed NTSB SEA74DTI27Accident · No injuriesClosedCessna 140 · Townsend, MTJun 9, 1974 · N76001 · Substantial damage NTSB SEA74FTA27Accident · No injuriesClosedPiper PA-25 · Broadview, MTJun 7, 1974 · N7051Z · Substantial damage NTSB SEA74FTI23Accident · Serious injuriesClosedPiper PA-18A · Brady, MTJun 1, 1974 · N2696P · Substantial damage NTSB SEA74AS044Accident · 1 fatalClosedBeech 35 · Townsend, MTMay 14, 1974 · N2962V · Destroyed NTSB SEA74DTA26Accident · No injuriesClosedCessna 182 · Ekalaka, MTMay 5, 1974 · N6244A · Substantial damage NTSB SEA74FTA25Accident · No injuriesClosedPiper PA-18 · Richey, MTMay 3, 1974 · N2206A · Substantial damage NTSB SEA74DTI22Accident · No injuriesClosedPiper PA-25 · Power, MTMay 3, 1974 · N7006Z · Destroyed