NTSB investigations, MT
23 cases where the sequence of events included Aerodynamic stall/spin.
Cases per year
| 2009 | 2 |
|---|---|
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 3 |
| 2014 | 2 |
| 2015 | 3 |
| 2016 | 1 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 1 |
| 2024 | 1 |
| 2025 | 3 |
Where
Open the mapLatest cases
Query with SQL
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\" = '241' 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" = '241' 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 WPR25LA251Accident · No injuriesClass 4 · LimitedFinal reportSocata TBM 700 · Kalispell, MTThe pilot’s unstable approach to the runway, which resulted in an aerodynamic stall at low altitude and impact with terrain.NTSB WPR25LA221Accident · Minor injuriesClass 4 · LimitedFinal reportBeech B35 · Helena, MTThe pilot’s failure to properly configure the airplane during a go-around which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall at a low altitude.NTSB WPR25FA182Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172 · Billings, MTOn June 19, 2025, at 1412 mountain daylight time, a Cessna 172K airplane, N79306, was destroyed when it was involved in an accident near Billings, Montana. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB WPR24FA150Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-18-150 · Thurlow, MTThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, resulting in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s distraction by his cell phone use while…NTSB WPR22LA231Accident · Serious injuriesClass 3 · LimitedFinal reportJames C Geyman RV-9A · Missoula, MTThe pilot’s improper fuel management, which resulted in fuel starvation and a loss of engine power. Contributing to the accident was the pilot’s failure to activate the auxiliary fuel boost pump, which inhibited a successful engine restart.NTSB WPR21FA258Accident · 2 fatalClass 3 · FieldFinal reportCessna 172R · Missoula, MTThe pilot’s failure to maintain airspeed and exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB WPR21LA067Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Dillon, MTThe student pilot’s exceedance of the airplane’s critical angle attack during an attempted go-around, which resulted in an aerodynamic stall.NTSB WPR20LA245Accident · 1 fatalClass 3 · LimitedFinal reportCessna 337 · Ennis, MTThe pilot-in-command’s failure to maintain sufficient airspeed while attempting an evasive maneuver from a boxed canyon, which resulted in an aerodynamic stall/spin and impact with mountainous terrain. Contributing to the accident was the pilot-in-command’s…NTSB GAA19CA432Accident · Minor injuriesData collectionFinal reportAviat A1 · Ennis, MTThe pilot's exceedance of the airplane's critical angle of attack while turning at low altitude, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's distraction due to looking at wildlife.NTSB GAA16CA284Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Ferndale, MTThe pilot's loss of directional control during takeoff resulting in a decision to rotate early, and a collision with a hangar and subsequent fire.NTSB GAA16CA080Accident · Minor injuriesData collectionFinal reportAviat A1 · Broadus, MTThe pilot's failure to maintain clearance from the wires while flying at a low altitude resulting in a wire strike, a loss of airplane control, and the consequent impact with terrain.NTSB WPR16FA012Accident · 1 fatalField investigationFinal reportBucker Jungmeister BU 133 · Missoula, MTThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack while executing a return to the runway after takeoff, which resulted in an aerodynamic stall/spin. Contributing to the accident was the pilot’s…NTSB GAA15CA089Accident · No injuriesData collectionFinal reportCessna 188 · Polson, MTThe pilot's failure to maintain airplane pitch, power, and turn coordination while maneuvering at low altitude, resulting in an aerodynamic stall and a collision with terrain.NTSB WPR15LA036Accident · Serious injuriesLimited investigationFinal reportChampion 7AC · Darby, MTThe pilot's failure to maintain airspeed while maneuvering in gusting wind conditions, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB WPR14LA305Accident · 1 fatalLimited investigationFinal reportCessna 150M · Russian Flat, MTThe pilot's inadequate preflight performance planning and his operation of the airplane outside of the manufacturer's specified performance limitations, which resulted in his exceedance of the airplane's critical angle of attack and a subsequent aerodynamic…NTSB WPR14CA067Accident · Serious injuriesData collectionFinal reportBeech 58P · Kalispell, MTThe pilot's failure to maintain airplane control during the landing sequence.NTSB WPR13FA368Accident · 1 fatalField investigationFinal reportBeech E35 · West Yellowstone, MTThe pilot's failure to maintain airplane control while aligning the airplane with the runway for landing, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's…NTSB WPR13FA288Accident · 1 fatalField investigationFinal reportBeech J35 · Helena, MTThe pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall/spin and subsequent impact with terrain.NTSB WPR12FA123Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Brockton, MTThe pilot’s failure to maintain adequate airspeed and airplane control while maneuvering at a low altitude, which resulted in a stall and subsequent impact with terrain.NTSB WPR11LA317Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 2-32 · Bigfork, MTThe pilot’s failure to maintain adequate airspeed and his excessive control inputs during a simulated rope break while taking off, which resulted in an accelerated aerodynamic stall.NTSB WPR10FA330Accident · 4 fatalField investigationFinal reportPiper PA-28R-180 · Dixon, MTThe pilot’s failure to maintain adequate airspeed and aircraft control while maneuvering, resulting in an aerodynamic stall and collision with mountainous terrain.NTSB WPR09CA388Accident · No injuriesData collectionFinal reportAeronca 7AC · Broadus, MTThe pilot’s failure to maintain sufficient airspeed during low altitude maneuvering, which resulted in an inadvertent stall.NTSB WPR09LA286Accident · Serious injuriesLimited investigationFinal reportWermling KR-2 Rand Robinson · Anaconda, MTThe non-certificated pilot’s failure to maintain airspeed and aircraft control during initial climb resulting in a stall/spin.