Skip to content

NTSB investigations, MT

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 SEA79FTA15Accident · No injuriesClosedPiper PA-18 · Circle, MTJun 5, 1979 · N5493H · Substantial damage NTSB SEA79FTI15Accident · No injuriesClosedScorpion II · Belgrade, MTMay 21, 1979 · N133RW · Substantial damage NTSB SEA79FTA14Accident · No injuriesClosedCessna 150 · Billings, MTMay 5, 1979 · N704JL · Substantial damage NTSB SEA79FTA13Accident · No injuriesClosedGrumman G-164B · Billings, MTMay 3, 1979 · N6753Q · Substantial damage NTSB SEA79DTI13Accident · Serious injuriesClosedPiper PA-24 · Sula, MTApr 20, 1979 · N8372P · Destroyed NTSB SEA79FA031Accident · 2 fatalClosedBell 214B-1 · Darby, MTApr 19, 1979 · N226RM · Destroyed NTSB SEA79FTA12Accident · No injuriesClosedStinson 108-2 · Sidney, MTApr 14, 1979 · N9379K · Substantial damage NTSB SEA79DTI12Accident · No injuriesClosedCessna 172 · Valier, MTApr 5, 1979 · N4343L · Substantial damage NTSB SEA79DTI10Accident · No injuriesClosedCessna 188 · Carter, MTMar 21, 1979 · N21759 · Substantial damage NTSB SEA79DTI09Accident · No injuriesClosedPiper PA-22 · Turner, MTMar 11, 1979 · N8690C · Substantial damage NTSB SEA79FTA10Accident · No injuriesClosedPiper PA-18 · Terry, MTFeb 28, 1979 · N3803Z · Substantial damage NTSB SEA79FA021Accident · 1 fatalClosedCessna T210P · Lavina, MTFeb 28, 1979 · N6995N · Destroyed NTSB SEA79FTI08Accident · No injuriesClosedCessna 180K · Missoula, MTFeb 26, 1979 · N64211 · Substantial damage NTSB SEA79FTA09Accident · Serious injuriesClosedCessna 180 · Miles City, MTFeb 25, 1979 · N9434C · Destroyed NTSB SEA79DTI07Accident · No injuriesClosedCessna 185E · Cut Bank, MTFeb 2, 1979 · N70263 · Substantial damage NTSB SEA79FTI06Accident · No injuriesClosedCessna 150L · Stevensville, MTJan 31, 1979 · N10903 · Substantial damage NTSB SEA79DTA07Accident · No injuriesClosedCessna 150 · Scobey, MTJan 29, 1979 · N50281 · Substantial damage NTSB SEA79FTA08Accident · No injuriesClosedBellanca 7GCBC · Sand Springs, MTJan 25, 1979 · N62972 · Substantial damage NTSB SEA79FA018Accident · No injuriesClosedHandly-Page HP-137 · Missoula, MTJan 15, 1979 · N14RJ · Substantial damage NTSB SEA79FTI05Accident · Minor injuriesClosedBell 214B-1 · Darby, MTDec 27, 1978 · N224RM · Substantial damage NTSB SEA79FTA06Accident · No injuriesClosedCessna 195 · Baker, MTDec 11, 1978 · N4324N · Substantial damage NTSB SEA79FTA04Accident · No injuriesClosedPiper PA-24 · Billings, MTDec 2, 1978 · N8758P · Substantial damage NTSB SEA79DTI04Accident · No injuriesClosedPiper PA-18 · Geraldine, MTNov 29, 1978 · N3690Z · Substantial damage NTSB SEA79DTA05Accident · No injuriesClosedCessna 172B · Circle, MTNov 21, 1978 · N7487X · Substantial damage NTSB SEA79FA015Accident · No injuriesClosedCessna 310J · Wolf Point, MTNov 12, 1978 · N3057L · Substantial damage NTSB SEA79FTI03Accident · No injuriesClosedCessna 182C · Trident, MTNov 5, 1978 · N8996T · Substantial damage NTSB SEA79FA008Accident · 1 fatalClosedCessna 150H · Swan Lake, MTOct 31, 1978 · N7056S · Destroyed NTSB SEA79FTA03Accident · Serious injuriesClosedPiper PA-18 · Denton, MTOct 28, 1978 · N4053Z · Destroyed NTSB SEA79FTI02Accident · Serious injuriesClosedCessna T210L · Great Falls, MTOct 22, 1978 · N30751 · Substantial damage NTSB SEA79DTA02Accident · No injuriesClosedPiper PA-18 · Miles City, MTOct 20, 1978 · N3180Z · Substantial damage NTSB SEA79FA003Accident · 2 fatalClosedPiper PA-18S · Bozeman, MTOct 13, 1978 · N302T · Destroyed NTSB SEA79FTI01Accident · Serious injuriesClosedPiper PA-28 · Belgrade, MTOct 8, 1978 · N43481 · Substantial damage NTSB SEA79FA002Accident · 1 fatalClosedPiper PA-11 · Nashua, MTOct 7, 1978 · N4838M · Destroyed NTSB SEA79FTA01Accident · No injuriesClosedPiper J-3 · Belfry, MTSep 28, 1978 · N33160 · Substantial damage NTSB SEA78FA066Accident · 4 fatalClosedPiper PA-28 · Hall, MTSep 19, 1978 · N8359C · Destroyed NTSB SEA78DTA22Accident · Minor injuriesClosedCessna 172 · Red Lodge, MTSep 7, 1978 · N739CW · Substantial damage NTSB SEA78FA062Accident · 1 fatalClosedAero Comdr 500B · Great Falls, MTSep 6, 1978 · N6112X · Destroyed NTSB SEA78FTA21Accident · No injuriesClosedPiper PA-18 · Miles City, MTSep 3, 1978 · N9897D · Substantial damage NTSB SEA78FTA20Accident · No injuriesClosedCessna R182 · Billings, MTAug 30, 1978 · N7309Y · Substantial damage NTSB SEA78FTA19Accident · No injuriesClosedCessna 170B · Broadus, MTAug 26, 1978 · N4657C · Substantial damage NTSB SEA78DTA18Accident · No injuriesClosedBell 47G3B1 · Billings, MTAug 20, 1978 · N90769 · Substantial damage NTSB SEA78FA057Accident · 6 fatalClosedCessna 320 · Anaconda, MTAug 18, 1978 · N24P · Destroyed NTSB SEA78FTA17Accident · No injuriesClosedCessna 172 · Roundup, MTAug 2, 1978 · N4374R · Substantial damage NTSB SEA78FTI27Accident · No injuriesClosedCessna 180E · Belgrade, MTJul 28, 1978 · N2666Y · Substantial damage NTSB SEA78FTI26Accident · No injuriesClosedCessna 182P · Buffalo, MTJul 28, 1978 · N21483 · Substantial damage NTSB SEA78FTI25Accident · No injuriesClosedCessna A188B · Chester, MTJul 25, 1978 · N9289R · Substantial damage NTSB SEA78FTI24Accident · Minor injuriesClosedPiper PA-18 · Waterloo, MTJul 19, 1978 · N40142 · Substantial damage NTSB SEA78DTA16Accident · No injuriesClosedCessna 150 · Miles City, MTJul 15, 1978 · N19313 · Substantial damage NTSB SEA78FTI23Accident · Serious injuriesClosedPiper PA-28 · Augusta, MTJul 14, 1978 · N9875W · Destroyed NTSB SEA78DA042Accident · 1 fatalClosedCessna 170A · Billings, MTJul 9, 1978 · N1780D · Destroyed