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 UNK64X1665Accident · Minor injuriesClosedAeronca 7AC · Alzada, MTMay 8, 1964 · N82529 · Substantial damage NTSB UNK64X1650Accident · No injuriesClosedCessna 172 · Helena, MTMay 7, 1964 · N7856X · Substantial damage NTSB UNK64X1546Accident · No injuriesClosedPiper PA24 · Billings, MTMay 1, 1964 · N6203P · Substantial damage NTSB UNK64X1535Accident · No injuriesClosedPiper PA22 · Billings, MTApr 30, 1964 · N9724D · Substantial damage NTSB UNK64X1512Accident · 1 fatalClosedPiper PA18A · Belt, MTApr 29, 1964 · N3686P · Destroyed NTSB UNK64X1490Accident · 4 fatalClosedBeech 65 · Billings, MTApr 27, 1964 · N451HC · Destroyed NTSB UNK64X1295Accident · No injuriesClosedMooney M20E · Raynesford, MTApr 13, 1964 · N1946Y · Substantial damage NTSB UNK64X1009Accident · 2 fatalClosedMooney M20E · Butte, MTMar 21, 1964 · N1267X · Destroyed NTSB UNK64X1002Accident · No injuriesClosedCessna 182E · Conner, MTMar 21, 1964 · N2990Y · Substantial damage NTSB UNK64X1001Accident · No injuriesClosedCessna 172 · Red Lodge, MTMar 21, 1964 · N4138F · Substantial damage NTSB UNK64X0966Accident · Serious injuriesClosedBoeing B-720B · Billings, MTMar 17, 1964 · N732US · No damage NTSB UNK64X0890Accident · 5 fatalClosedDouglas DC-3C · Miles City, MTMar 12, 1964 · N61442 · Destroyed NTSB UNK64X0814Accident · No injuriesClosedPiper PA24 · Great Falls, MTMar 6, 1964 · N5712P · Substantial damage NTSB UNK64X0677Accident · No injuriesClosedPiper J3 · Belgrade, MTFeb 23, 1964 · N92394 · Substantial damage NTSB UNK64X0667Accident · 2 fatalClosedBeechcraft C35 · Forsyth, MTFeb 22, 1964 · N1800D · Destroyed NTSB UNK64X0557Accident · No injuriesClosedCessna 180 · Judith Basin, MTFeb 13, 1964 · N2202C · Substantial damage NTSB UNK64X0501Accident · No injuriesClosedCessna 172 · Anaconda, MTFeb 8, 1964 · N7109A · Substantial damage NTSB UNK64X0400Accident · No injuriesClosedCessna 170B · Browning, MTJan 29, 1964 · N4527C · Destroyed NTSB UNK64X0371Accident · Minor injuriesClosedLuscombe 8A · Missoula Mont, MTJan 26, 1964 · N1344K · Substantial damage NTSB UNK64X0282Accident · No injuriesClosedCessna 150 · Glasgow, MTJan 18, 1964 · N1206Y · Substantial damage NTSB UNK64X0178Accident · No injuriesClosedLuscombe 8E · Ft Benton, MTJan 6, 1964 · N1118B · Substantial damage NTSB UNK64X0145Accident · No injuriesClosedPiper PA22 · Paradise, MTJan 4, 1964 · N2822Z · Substantial damage NTSB SEA64A0032Accident · No injuriesClosedDouglas DC-3 · Kalispell, MTDec 11, 1963 · N2025A · Substantial damage NTSB LAX64A0008Accident · 1 fatalClosedCurtiss-Wrt C-46F · Great Falls, MTAug 14, 1963 · N67941 · Substantial damage