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 SEA71FTA20Accident · No injuriesClosedCessna 170B · Brusett, MTApr 27, 1971 · N3479C · Substantial damage NTSB SEA71FDG28Accident · No injuriesClosedPiper PA-18 · Hamilton, MTApr 19, 1971 · N4299Z · Substantial damage NTSB SEA71FDA18Accident · No injuriesClosedCessna A188 · Joliet, MTApr 17, 1971 · N9821V · Substantial damage NTSB SEA71AS040Accident · 4 fatalClosedLear Jet 24D · Butte, MTApr 17, 1971 · N123CB · Destroyed NTSB SEA71FDG27Accident · No injuriesClosedMooney M20C · Santa Rita, MTApr 16, 1971 · N5996Q · Substantial damage NTSB SEA71FDG26Accident · No injuriesClosedCessna 150 · Plains, MTApr 16, 1971 · N61087 · Substantial damage NTSB SEA71FTA06Accident · No injuriesClosedTaylorcraft BC12-D · Baker, MTApr 10, 1971 · N94966 · Substantial damage NTSB SEA71FDG25Accident · No injuriesClosedBellanca 14-19 · Butte, MTApr 8, 1971 · N9832B · Substantial damage NTSB SEA71FDA16Accident · No injuriesClosedCessna 182N · Hysham, MTMar 31, 1971 · N8949G · Substantial damage NTSB SEA71FDA15Accident · No injuriesClosedStinson 108-2 · Alzada, MTMar 19, 1971 · N171C · Substantial damage NTSB SEA71FDA17Accident · No injuriesClosedPiper PA-11 · Alzada, MTMar 11, 1971 · N4532M · Substantial damage NTSB SEA71FDA14Accident · No injuriesClosedCessna 310C · Miles City, MTMar 10, 1971 · N1814H · Substantial damage NTSB SEA71DDG24Accident · No injuriesClosedCessna 177 · Great Falls, MTMar 9, 1971 · N2237Y · Substantial damage NTSB SEA71FDG23Accident · No injuriesClosedBeech J35 · Drummond, MTFeb 25, 1971 · N8349D · Substantial damage NTSB SEA71FDA13Accident · No injuriesClosedBeech B-95 · Forsyth, MTFeb 7, 1971 · N9923R · Substantial damage NTSB SEA71FDG22Accident · No injuriesClosedCessna 310 · Kalispell, MTJan 27, 1971 · N2652C · Substantial damage NTSB SEA71FDA12Accident · No injuriesClosedCessna 150 · Billings, MTJan 20, 1971 · N50618 · Substantial damage NTSB SEA71FDG21Accident · No injuriesClosedBeech 65-80 · Great Falls, MTJan 19, 1971 · N138ES · Substantial damage NTSB SEA71FDG18Accident · No injuriesClosedCessna 205 · Winston, MTDec 17, 1970 · N8383Z · Substantial damage NTSB SEA71DDG20Accident · No injuriesClosedCessna 182 · Dutton, MTDec 17, 1970 · N71654 · Substantial damage NTSB SEA71DDA11Accident · No injuriesClosedPiper PA-18 · Garryowen, MTDec 4, 1970 · N8109Y · Substantial damage NTSB SEA71FDG19Accident · No injuriesClosedCessna 120 · Whitewater, MTDec 1, 1970 · N77416 · Substantial damage NTSB SEA71FDA08Accident · No injuriesClosedCessna 180H · Billings, MTNov 15, 1970 · N4772U · Substantial damage NTSB SEA71DDA10Accident · No injuriesClosedCessna 150F · Glendive, MTNov 15, 1970 · N3557L · Substantial damage NTSB SEA71DDA09Accident · No injuriesClosedAeronca 7AC · Opheim, MTNov 15, 1970 · N81782 · Substantial damage NTSB DEN71AD020Accident · 5 fatalClosedCessna 180 · Missoula, MTNov 1, 1970 · N1757C · 2 aircraft · Destroyed NTSB SEA71DDG17Accident · No injuriesClosedPiper PA-28 · Livingston, MTOct 31, 1970 · N7164R · Substantial damage NTSB SEA71FDG16Accident · Serious injuriesClosedMooney M20F · Cameron, MTOct 30, 1970 · N9646M · Substantial damage NTSB SEA71AS023Accident · 2 fatalClosedPiper PA-14 · Carlyle, MTOct 30, 1970 · N4266H · Destroyed NTSB SEA71DDG14Accident · Minor injuriesClosedMooney M20C · Melrose, MTSep 17, 1970 · N5637Q · Substantial damage NTSB SEA71FDG13Accident · No injuriesClosedCessna 170A · Fort Benton, MTSep 14, 1970 · N9543A · Substantial damage NTSB SEA71DDG11Accident · No injuriesClosedCessna 210 · Missoula, MTAug 30, 1970 · N6921R · Substantial damage NTSB SEA71AS010Accident · 1 fatalClosedMooney M20E · Big Fork, MTAug 23, 1970 · N6013Q · Destroyed NTSB SEA71DDA07Accident · No injuriesClosedTaylorcraft BC12-D · Melstone, MTAug 21, 1970 · N43333 · Substantial damage NTSB SEA71DDG10Accident · No injuriesClosedCessna 172A · Loring, MTAug 19, 1970 · N7308T · Substantial damage NTSB SEA71FDA05Accident · Serious injuriesClosedStinson 108-2 · Red Lodge, MTAug 17, 1970 · N454C · Destroyed NTSB SEA71DDA06Accident · No injuriesClosedCessna 180 · Kirby, MTAug 16, 1970 · N2951C · Substantial damage NTSB SEA71FDG09Accident · No injuriesClosedMooney M20A · Libby, MTAug 13, 1970 · CF-WKP · Substantial damage NTSB SEA71FDA04Accident · No injuriesClosedPiper PA-18A · Garryowen, MTAug 13, 1970 · N1190C · Substantial damage NTSB SEA71FDG15Accident · No injuriesClosedMooney M20E · Kalispell, MTAug 11, 1970 · N9228V · Substantial damage NTSB SEA71FDA02Accident · No injuriesClosedCessna 170B · Billings, MTAug 7, 1970 · N2304D · Substantial damage NTSB SEA71DDG08Accident · Minor injuriesClosedCessna 172 · Butte, MTAug 5, 1970 · N84748 · Substantial damage NTSB SEA71DDA03Accident · No injuriesClosedPiper PA-18 · Lavina, MTAug 4, 1970 · N5480H · Substantial damage NTSB SEA71FDG07Accident · No injuriesClosedLuscombe 8F · Butte, MTAug 2, 1970 · N1995B · Substantial damage NTSB SEA71FDG06Accident · No injuriesClosedBeech J35 · Helena, MTJul 21, 1970 · N3036C · Substantial damage NTSB SEA71FDG05Accident · No injuriesClosedPiper PA-23 · Helena, MTJul 16, 1970 · N1279P · Substantial damage NTSB SEA71DDG04Accident · No injuriesClosedPiper PA-18A · Brady, MTJul 15, 1970 · N2696P · Substantial damage NTSB SEA71FDG03Accident · No injuriesClosedPiper J3 · Cut Bank, MTJul 9, 1970 · N31162 · Substantial damage NTSB SEA71FDA01Accident · No injuriesClosedBeech A-23 · Roundup, MTJul 7, 1970 · N8886M · Substantial damage NTSB SEA71DDG02Accident · No injuriesClosedStinson 108-2 · Floweree, MTJul 7, 1970 · N9850K · Substantial damage