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 UNK65X0718Accident · No injuriesClosedPiper J3C · Billings, MTNov 15, 1964 · N6988H · Substantial damage NTSB UNK65X0716Accident · No injuriesClosedCessna 172 · Saco, MTNov 15, 1964 · N9857T · Substantial damage NTSB UNK65X0713Accident · No injuriesClosedMooney M21 · Plentywood, MTNov 15, 1964 · N6881U · Substantial damage NTSB UNK65X0708Accident · Minor injuriesClosedCessna 182 · Belt, MTNov 14, 1964 · N3034Y · Substantial damage NTSB UNK65X0691Accident · 1 fatalClosedCessna 170B · Roberts, MTNov 13, 1964 · N2561D · Destroyed NTSB UNK65X0467Accident · 1 fatalClosedMaule M-4 · Townsend, MTOct 28, 1964 · N4725T · Destroyed NTSB UNK65X0464Accident · No injuriesClosedStinson 108-3 · Glacier, MTOct 28, 1964 · N4161C · Substantial damage NTSB UNK65X0431Accident · No injuriesClosedCessna 172D · Broadus, MTOct 25, 1964 · N2379U · Substantial damage NTSB UNK65X0344Accident · No injuriesClosedBell 47G3 · Stevensville, MTOct 20, 1964 · N8418E · Destroyed NTSB UNK65X0309Accident · 4 fatalClosedCessna 185B · Augusta, MTOct 17, 1964 · N2566Z · Destroyed NTSB UNK65X0109Accident · No injuriesClosedCessna 175 · Great Falls, MTOct 1, 1964 · CF-KPG · Substantial damage NTSB UNK64X4215Accident · No injuriesClosedCessna 172D · Helena, MTSep 30, 1964 · N8536X · Substantial damage NTSB UNK64X4198Accident · No injuriesClosedPiper PA28 · Winfred, MTSep 28, 1964 · N8534W · Destroyed NTSB UNK64X4016Accident · No injuriesClosedCessna 190 · Ennis, MTSep 17, 1964 · N1058D · Substantial damage NTSB UNK64X3938Accident · No injuriesClosedPiper PA22 · Kremlin, MTSep 12, 1964 · N303F · Substantial damage NTSB UNK64X3712Accident · No injuriesClosedPiper PA12 · Belgrade, MTAug 31, 1964 · N3403M · Substantial damage NTSB UNK64X3611Accident · 4 fatalClosedPiper PA-30 · Choteau, MTAug 26, 1964 · CF-PHN · Destroyed NTSB UNK64X3483Accident · No injuriesClosedCessna 180 · Baker, MTAug 20, 1964 · N4657U · Substantial damage NTSB UNK64X3464Accident · No injuriesClosedMaule M4 · Hysham, MTAug 18, 1964 · N4705T · Substantial damage NTSB UNK64X3426Accident · No injuriesClosedBeechcraft 35 · Kalispell, MTAug 16, 1964 · N4685D · Substantial damage NTSB UNK64X3380Accident · No injuriesClosedAeronca 7DC · Sand Springs, MTAug 14, 1964 · N2836E · Substantial damage NTSB UNK64X3196Accident · No injuriesClosedCessna 140 · Medicine Lke, MTAug 3, 1964 · N2362V · Substantial damage NTSB UNK64X3131Accident · No injuriesClosedErcoupe 415C · Fishtail, MTJul 31, 1964 · N93472 · Substantial damage NTSB UNK64X3053Accident · No injuriesClosedCessna 170B · Billings, MTJul 26, 1964 · N8102A · Substantial damage NTSB UNK64X2962AccidentClosedPiper PA12 · Yellowstone, MTJul 21, 1964 · N3403M · Substantial damage NTSB UNK64X2905Accident · No injuriesClosedCessna 180 · Choteau, MTJul 18, 1964 · N4951A · Substantial damage NTSB UNK64X2847Accident · Minor injuriesClosedLuscombe 8A · Lookout Pass, MTJul 15, 1964 · N71491 · Destroyed NTSB UNK64X2834Accident · 1 fatalClosedChampion 7CCM · Flaxville, MTJul 14, 1964 · N4616E · Destroyed NTSB UNK64X2781Accident · 1 fatalClosedPiper PA-24 · W Yellowstone, MTJul 12, 1964 · N6002P · Destroyed NTSB UNK64X2740Accident · Serious injuriesClosedCessna 182 · Roscoe, MTJul 9, 1964 · N9355X · Destroyed NTSB UNK64X2716Accident · No injuriesClosedPiper PA18 · Ryegate, MTJul 8, 1964 · N5447H · Substantial damage NTSB UNK64X2598Accident · No injuriesClosedPiper PA22 · Baker, MTJul 1, 1964 · N4702Z · Substantial damage NTSB UNK64X2500Accident · No injuriesClosedBeechcraft D18S · Hardin, MTJun 26, 1964 · N9886H · Substantial damage NTSB UNK64X2260Accident · No injuriesClosedCessna 170 · Red Lodge, MTJun 13, 1964 · N3557C · Substantial damage NTSB UNK64X2246Accident · Minor injuriesClosedTaylorcraft BC12D · Poplar, MTJun 12, 1964 · N39161 · Destroyed NTSB UNK64X2210Accident · No injuriesClosedBell 47G3 · Yack Flats, MTJun 9, 1964 · N8400E · Substantial damage NTSB UNK64X2200Accident · No injuriesClosedCessna 182D · Schafer, MTJun 9, 1964 · N8974X · Substantial damage NTSB UNK64X2144Accident · No injuriesClosedBeechcraft D35 · Terry, MTJun 6, 1964 · N2153D · Substantial damage NTSB UNK64X2105Accident · Minor injuriesClosedPiper PA18A · Geraldine, MTJun 4, 1964 · N2693P · Destroyed NTSB UNK64X2053Accident · No injuriesClosedStinson 108 · Anaconda, MTMay 31, 1964 · N8599K · Substantial damage NTSB UNK64X2049Accident · No injuriesClosedCessna 170B · Poplar, MTMay 31, 1964 · N4585C · Substantial damage NTSB UNK64X2036Accident · No injuriesClosedMaule M-4 · Culbertson, MTMay 30, 1964 · N12032 · Substantial damage NTSB UNK64X2032Accident · No injuriesClosedPiper PA18 · Malta, MTMay 30, 1964 · N2534A · Substantial damage NTSB UNK64X2004Accident · No injuriesClosedPiper J3 · Winifred, MTMay 29, 1964 · N3666K · Substantial damage NTSB UNK64X1929Accident · No injuriesClosedCallair A9 · Belt, MTMay 24, 1964 · N9664Z · Substantial damage NTSB UNK64X1838Accident · No injuriesClosedPiper PA18 · Hellena, MTMay 19, 1964 · N3778P · Substantial damage NTSB UNK64X1824Accident · No injuriesClosedAeronca 7AC · Glasgow, MTMay 18, 1964 · N81712 · Substantial damage NTSB UNK64X1804Accident · No injuriesClosedCessna 172D · Livingston, MTMay 17, 1964 · N2800U · Substantial damage NTSB UNK64X1787Accident · No injuriesClosedCessna 140 · Belgrade, MTMay 16, 1964 · N76850 · Substantial damage NTSB UNK64X1705Accident · No injuriesClosedPiper PA28 · Nudita Gap, MTMay 10, 1964 · N5046W · Substantial damage