Skip to content

NTSB investigations, MT

17 cases where the sequence of events included Other weather encounter.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20112026

Where

Latest cases

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' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '400' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '400' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '400' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
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 WPR26LA105Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20 · Three Forks, MTThe pilot’s failure to maintain directional during the landing roll with a variable wind.Feb 13, 2026 · N1491A · Substantial damage NTSB WPR25LA043Accident · No injuriesClass 4 · LimitedFinal reportCharlie Guinn CCK-1865 · Lewiston, MTThe pilot’s failure to maintain directional control in a gusting tailwind, which resulted in an impact with a tree.Nov 14, 2024 · N247CC · Substantial damage NTSB WPR24LA180Accident · No injuriesClass 4 · LimitedFinal reportRepublic RC-3 · Butte, MTThe pilot’s failure to maintain control of the airplane during the takeoff with a gusty left quartering crosswind.Jun 5, 2024 · N87583 · Substantial damage NTSB WPR23LA280Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12S · Kalispell, MTThe pilot's failure to maintain directional control of the airplane during landing with a crosswind.Jul 21, 2023 · N48MR · Substantial damage NTSB WPR23LA254Accident · Minor injuriesClass 4 · LimitedFinal reportMaule MX7-180C · Belgrade, MTThe pilot’s failure to maintain directional control during landing with a quartering tailwind, which resulted in a runway excursion and nose over.Jul 4, 2023 · N3171H · Substantial damage NTSB WPR20CA149Accident · No injuriesClass 4 · Data collectionFinal reportCessna 185 · Winifred, MTAn inadequate flare that resulted in a bounced landing and the pilot's subsequent delayed decision to go-around that did not allow for sufficient clearance from trees when the airplane was affected by a gusting wind.May 17, 2020 · N185 · Substantial damage NTSB WPR20CA124Accident · No injuriesData collectionFinal reportCessna 180 · Marion, MTThe pilot's loss of directional control and subsequent improper brake application during the landing roll in gusting wind conditions, which resulted in a nose-over.Apr 16, 2020 · N53ES · Substantial damage NTSB WPR19CA069Accident · No injuriesData collectionFinal reportChampion 7GCBC · Townsend, MTThe pilot's failure to maintain airplane control during a precautionary landing on an uneven, soft surface.Jan 16, 2019 · N822TT · Substantial damage NTSB GAA18CA404Accident · No injuriesData collectionFinal reportCessna 180 · Cut Bank, MTThe pilot's failure to maintain directional control during the landing roll.Jul 9, 2018 · N180GB · Substantial damage NTSB WPR18LA145Accident · Minor injuriesLimited investigationFinal reportSportavia Putzer RF5B Sperber · Lookout Pass, MTThe pilot’s improper decision to continue flight toward rising terrain after the engine overheated, which necessitated a precautionary landing when the motorglider could not maintain altitude in downdrafts.May 22, 2018 · N66GL · Substantial damage NTSB GAA16CA265Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Laurel, MTThe pilot's loss of directional control during the landing touchdown, resulting in a runway excursion and substantial damage to the both wings.May 30, 2016 · N41553 · Substantial damage NTSB WPR15FA247Accident · 2 fatalField investigationFinal reportCessna 172P · Townsend, MTThe non-instrument-rated pilot's decision to conduct a cross-country flight over a mountain range in dark night conditions with limited night flight experience, which resulted in a collision with mountainous terrain.Aug 20, 2015 · N62731 · Substantial damage NTSB WPR15LA198Accident · Serious injuriesLimited investigationFinal reportCessna TU206F · Schafers Meadows, MTThe pilot's failure to maintain directional control of the airplane during the landing roll in variable and gusting wind conditions.Jun 23, 2015 · N8424Q · Substantial damage NTSB WPR14FA231Accident · 1 fatalField investigationFinal reportGrumman G 21A · Sula, MTThe pilot's decision to continue flight into deteriorating weather conditions in an airplane not maintained for instrument flight, which resulted in a loss of control due to spatial disorientation.Jun 17, 2014 · N888GG · Destroyed NTSB WPR13CA427Accident · No injuriesData collectionFinal reportAviat A-1C-200 · Dell, MTThe pilot's failure to maintain directional control while taxiing in gusting wind conditions.Sep 27, 2013 · N53WY · Substantial damage NTSB WPR13CA412Accident · Minor injuriesData collectionFinal reportPiper PA 11 · Bozeman, MTThe pilot's failure to maintain aircraft control and inadequate compensation for the high gusty wind conditions during taxi.Sep 16, 2013 · N4988M · Substantial damage NTSB WPR11FA170Accident · 1 fatalField investigationFinal reportCessna T310R · Butte, MTThe pilot's loss of airplane control during the missed approach for undetermined reasons. Contributing to the accident was the rapid and unforecast deterioration of the weather conditions to below the landing minimum and the pilot's decision to attempt the…Mar 19, 2011 · N4914A · Substantial damage