# NTSB investigations, MT: Approach

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 1 of 4 · 194 cases

## Latest cases

- [NTSB WPR26LA335](https://openairdocs.org/ntsb/WPR26LA335.md): Cessna 210 · Polson, MT · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 10, 2026 · N9517T · Substantial damage
  > On September 10, 2026, about 1005 mountain daylight time, a Cessna 210, N9517T, was substantially damaged when it was involved in an accident near Polson Airport (8S1), Polson, Montana. The student pilot was not injured. The airplane was operated as a Title…
- [NTSB WPR26LA155](https://openairdocs.org/ntsb/WPR26LA155.md): Aero Vodochody L-39 · Ennis, MT · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Apr 10, 2026 · N136EM · Substantial damage
  > On April 10, 2026, about 1210 mountain daylight time, an Aero Vodochody L 39, N136EM, was substantially damaged when it was involved in an accident near Ennis, Montana. The flight instructor sustained minor injuries, and the pilot undergoing instruction was…
- [NTSB WPR26LA152](https://openairdocs.org/ntsb/WPR26LA152.md): Just Highlander · Great Falls, MT · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 8, 2026 · N563JA · Substantial damage
  > On April 8, 2026, about 1106 mountain daylight time, an experimental amateur built Just Aircraft Highlander, N563JA, was substantially damaged when it was involved in an accident near Great Falls, Montana. The pilot was not injured. The airplane was operated…
- [NTSB WPR25LA251](https://openairdocs.org/ntsb/WPR25LA251.md): Socata TBM 700 · Kalispell, MT · Accident · No injuries · Class 4 · Limited · Final report · Aug 11, 2025 · N860CA · Destroyed
  > The pilot’s unstable approach to the runway, which resulted in an aerodynamic stall at low altitude and impact with terrain.
- [NTSB WPR25LA221](https://openairdocs.org/ntsb/WPR25LA221.md): Beech B35 · Helena, MT · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 24, 2025 · N5204C · Substantial damage
  > The 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 WPR23LA087](https://openairdocs.org/ntsb/WPR23LA087.md): Raytheon BE-200 · Poplar, MT · Accident · No injuries · Class 4 · Limited · Final report · Jan 18, 2023 · N200EJ · Substantial damage
  > The pilot’s failure to maintain adequate airspeed and descent rate during the landing approach, which resulted in an impact with terrain short of the runway threshold.
- [NTSB WPR22LA337](https://openairdocs.org/ntsb/WPR22LA337.md): Cessna 180 · Seeley Lake, MT · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 3, 2022 · N3135D · Substantial damage
  > The loss of engine power due to fuel starvation as a result of unporting of the fuel.
- [NTSB WPR22LA321](https://openairdocs.org/ntsb/WPR22LA321.md): Piper PA-22-135 · Twin Bridges, MT · Accident · No injuries · Class 4 · Limited · Final report · Aug 29, 2022 · N3268B · Substantial damage
  > The student pilot’s failure to maintain airplane control during an aborted landing, and the flight instructor’s delayed remedial action.
- [NTSB WPR22LA262](https://openairdocs.org/ntsb/WPR22LA262.md): Maule M-5-235C · Three Forks, MT · Accident · No injuries · Class 3 · Limited · Final report · Jul 20, 2022 · N6224M · Substantial damage
  > A loss of engine power due to degraded and incorrectly maintained ignition system components. Contributing to the accident was the pilot’s delay in turning the airplane towards the runway when the engine began to lose power.
- [NTSB WPR22LA024](https://openairdocs.org/ntsb/WPR22LA024.md): Cessna 182Q · St Ignatius, MT · Accident · Serious injuries · Class 4 · Limited · Final report · Oct 24, 2021 · N25WX · Substantial damage
  > The pilot's improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB WPR21LA315](https://openairdocs.org/ntsb/WPR21LA315.md): Bellanca 14-19-3 · Whitefish, MT · Accident · No injuries · Class 4 · Limited · Final report · Aug 10, 2021 · N1257R · Substantial damage
  > A total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to accomplish a preflight inspection.
- [NTSB WPR21LA219](https://openairdocs.org/ntsb/WPR21LA219.md): Stoddard Hamilton Glasair II · Darby, MT · Accident · Serious injuries · Class 3 · Limited · Final report · May 29, 2021 · N8176J · Substantial damage
  > The pilot’s impact with terrain during a go-around following an attempted precautionary landing due to a low oil pressure indication. The reason for the low oil pressure indication could not be determined based on the available information.
- [NTSB WPR21LA067](https://openairdocs.org/ntsb/WPR21LA067.md): Cessna 172 · Dillon, MT · Accident · Serious injuries · Class 4 · Limited · Final report · Dec 8, 2020 · N46017 · Substantial damage
  > The student pilot’s exceedance of the airplane’s critical angle attack during an attempted go-around, which resulted in an aerodynamic stall.
- [NTSB WPR21LA032](https://openairdocs.org/ntsb/WPR21LA032.md): Cessna 172 · Billings, MT · Accident · 1 fatal · Class 3 · Limited · Final report · Oct 31, 2020 · N124TW · Substantial damage
  > The pilot’s failure to maintain the proper descent glide path while on final approach for reasons that could not be determined from available evidence.
- [NTSB WPR20LA304](https://openairdocs.org/ntsb/WPR20LA304.md): Cessna 172 · Seeley Lake, MT · Accident · 2 fatal · Class 3 · Limited · Final report · Sep 13, 2020 · N3720R · Substantial damage
  > The noninstrument-rated pilot’s encounter with instrument meteorological conditions during a night visual approach due to wildfire smoke, which resulted in controlled flight into terrain.
- [NTSB WPR20LA308](https://openairdocs.org/ntsb/WPR20LA308.md): Piper PA 30 · Billings, MT · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 12, 2020 · N7602Y · Substantial damage
  > The pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB WPR19FA209](https://openairdocs.org/ntsb/WPR19FA209.md): Cessna 182 · Wolf Point, MT · Accident · 2 fatal · Class 3 · Field · Final report · Aug 5, 2019 · N3469R · Destroyed
  > The pilot's exceedance of the airplane's critical angle of attack while maneuvering to land, which resulted in an accelerated aerodynamic stall and subsequent loss of control.
- [NTSB GAA18CA220](https://openairdocs.org/ntsb/GAA18CA220.md): Piper PA 22 · Shelby, MT · Accident · No injuries · Data collection · Final report · Apr 19, 2018 · N1283C · Substantial damage
  > The pilot’s improper use of the fuel selector, which resulted in fuel starvation to the engine and an off-runway landing.
- [NTSB WPR17IA007](https://openairdocs.org/ntsb/WPR17IA007.md): Short Bros SD3 60 Sherpa · Missoula, MT · Incident · No injuries · Incident investigation · Final report · Oct 13, 2016 · N148Z · Minor damage
  > The failure of the nose landing gear down-lock piston to engage due to paint accumulation, which resulted in a nose landing gear collapse during landing. Also causal was the failure of the facility that performed the painting to comply with manufacturer…
- [NTSB WPR16FA170](https://openairdocs.org/ntsb/WPR16FA170.md): Cessna 182 · Clinton, MT · Accident · 2 fatal · Field investigation · Final report · Aug 28, 2016 · N9936T · Destroyed
  > The sudden right turn on approach to landing for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR15LA191](https://openairdocs.org/ntsb/WPR15LA191.md): Cessna 180A · Polson, MT · Accident · No injuries · Limited investigation · Final report · Jun 19, 2015 · N9699B · Substantial damage
  > A total loss of engine power during approach for reasons that could not be determined because postaccident examination revealed no anomalies that would have precluded normal operation.
- [NTSB WPR15LA036](https://openairdocs.org/ntsb/WPR15LA036.md): Champion 7AC · Darby, MT · Accident · Serious injuries · Limited investigation · Final report · Nov 7, 2014 · N84462 · Substantial damage
  > The 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 WPR13FA368](https://openairdocs.org/ntsb/WPR13FA368.md): Beech E35 · West Yellowstone, MT · Accident · 1 fatal · Field investigation · Final report · Aug 12, 2013 · N3226C · Substantial damage
  > The 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 WPR11LA317](https://openairdocs.org/ntsb/WPR11LA317.md): Schweizer SGS 2-32 · Bigfork, MT · Accident · 1 fatal · Limited investigation · Final report · Jul 8, 2011 · N591CC · Substantial damage
  > The 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 WPR11FA170](https://openairdocs.org/ntsb/WPR11FA170.md): Cessna T310R · Butte, MT · Accident · 1 fatal · Field investigation · Final report · Mar 19, 2011 · N4914A · Substantial damage
  > The 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…
- [NTSB WPR10CA469](https://openairdocs.org/ntsb/WPR10CA469.md): Piper PA-18-150 · White Sulphur Springs, MT · Accident · No injuries · Data collection · Final report · Sep 24, 2010 · N4036E · Substantial damage
  > The pilot's failure to maintain control of the airplane during a go-around in turbulent wind conditions, which resulted in a collision with trees.
- [NTSB WPR10LA180](https://openairdocs.org/ntsb/WPR10LA180.md): Piper PA-22-150 · Terry, MT · Accident · No injuries · Limited investigation · Final report · Mar 25, 2010 · N3351Z · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll in gusting winds. Contributing to the accident was a loss of engine power on final approach due to fuel exhaustion as a result of the pilot having to divert due to deteriorating…
- [NTSB WPR09LA179](https://openairdocs.org/ntsb/WPR09LA179.md): Cessna 182 · Kalispell, MT · Accident · No injuries · Limited investigation · Final report · Apr 4, 2009 · N6433A · Substantial damage
  > A partial loss of engine power during a go-around for undetermined reasons. Contributing to the accident was a fatigue failure of the right main landing gear spring.
- [NTSB WPR09CA092](https://openairdocs.org/ntsb/WPR09CA092.md): Ryan Navion · Three Forks, MT · Accident · No injuries · Data collection · Final report · Jan 19, 2009 · N4443K · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel system management. Contributing to the accident were the pilot's diverted attention and failure to perform the prelanding checklist.
- [NTSB SEA08CA010](https://openairdocs.org/ntsb/SEA08CA010.md): Welch RV-9 · Bigfork, MT · Accident · No injuries · Data collection · Final report · Oct 14, 2007 · N475TW · Substantial damage
  > Fuel starvation while on downwind for landing. The pilot's inadequate in-flight fuel management planning was a factor.
- [NTSB LAX07CA279](https://openairdocs.org/ntsb/LAX07CA279.md): Cessna 172L · Helena, MT · Accident · No injuries · Data collection · Final report · Sep 13, 2007 · N7221Q · Substantial damage
  > unexpected collision with birds on short final that damaged the airplane wing structure.
- [NTSB LAX07LA240](https://openairdocs.org/ntsb/LAX07LA240.md): Luscombe 8E · Polson, MT · Accident · No injuries · Limited investigation · Final report · Aug 3, 2007 · N45486 · Substantial damage
  > a flight control jam for undetermined reasons.
- [NTSB SEA07CA194](https://openairdocs.org/ntsb/SEA07CA194.md): Piper PA-18-150 · Jordan, MT · Accident · No injuries · Data collection · Final report · Jul 13, 2007 · N7145Z · Substantial damage
  > The pilot's failure to maintain aircraft control during a go-around. Contributing factors were the pilot's selection of unsuitable terrain for landing and the rough/uneven terrain.
- [NTSB SEA07TA174](https://openairdocs.org/ntsb/SEA07TA174.md): Cessna 185C · Kalispell, MT · Accident · No injuries · Final report · Jun 20, 2007 · N391M · Substantial damage
  > The complete loss of engine power during an attempted go-around from a simulated engine-out landing. Factors include rough/uneven terrain and high vegetation where the pilot made an emergency forced landing.
- [NTSB LAX07FA150](https://openairdocs.org/ntsb/LAX07FA150.md): Cessna S550 · Dillon, MT · Accident · 2 fatal · Field investigation · Final report · May 3, 2007 · N22HP · Destroyed
  > An in-flight loss of control for undetermined reasons.
- [NTSB SEA07LA002](https://openairdocs.org/ntsb/SEA07LA002.md): Cessna 340A · Kalispell, MT · Accident · No injuries · Limited investigation · Final report · Oct 2, 2006 · N1920E · Substantial damage
  > The fracture of the adjusting bellcrank in overstress due to binding in a linkage forward of the bell crank.
- [NTSB SEA06CA165](https://openairdocs.org/ntsb/SEA06CA165.md): Bell 407 · Havre, MT · Accident · No injuries · Data collection · Final report · Aug 19, 2006 · N407SH · Substantial damage
  > The pilot inadvertently allowing the helicopter to enter into a vortex ring state (settling with power) condition while he was lowering a long-line load to the ground, resulting in the helicopter settling to the ground and its tail rotor impacting part of the…
- [NTSB SEA06CA094](https://openairdocs.org/ntsb/SEA06CA094.md): Harold Vander Avid Flyer · Miles City, MT · Accident · No injuries · Data collection · Final report · May 14, 2006 · N157VM · Substantial damage
  > Failure of the engine to propeller reduction gearbox for undetermined reasons. High vegetation was a factor.
- [NTSB SEA06LA074](https://openairdocs.org/ntsb/SEA06LA074.md): Central Copters Lancair IV-P · Belgrade, MT · Accident · No injuries · Limited investigation · Final report · Apr 15, 2006 · N671 · Destroyed
  > The total loss of drive power to the aircraft's propeller while on a visual final approach, due to the decoupling of the quill shaft between the reduction gearbox and the engine power section. Factors include a dark night, no suitable terrain on which to…
- [NTSB SEA06FA068](https://openairdocs.org/ntsb/SEA06FA068.md): Beech C99 · Butte, MT · Accident · 2 fatal · Field investigation · Final report · Mar 18, 2006 · N54RP · Substantial damage
  > The second pilot's failure to follow the published instrument approach procedure and the captain/PIC's inadequate supervision. Snow and mountain obscuration were factors.
- [NTSB SEA06FA022](https://openairdocs.org/ntsb/SEA06FA022.md): Cessna 425 · Belgrade, MT · Accident · 1 fatal · Field investigation · Final report · Nov 30, 2005 · N701QR · Destroyed
  > The pilot's failure to maintain airspeed during the approach which resulted in an inadvertent stall. Factors associated with the accident were dark night conditions, clouds, icing conditions, low visibility and snow.
- [NTSB SEA05LA189](https://openairdocs.org/ntsb/SEA05LA189.md): Ballhagen/Shyrock Q-2 · Kalispell, MT · Accident · No injuries · Limited investigation · Final report · Sep 2, 2005 · N12QJ · Substantial damage
  > The pilot/owner's improper setting of the engine's valve clearance, leading to the failure of the exhaust valves to fully close and a total loss of power while on a VFR downwind, and the pilot/owner's failure to maintain sufficient airspeed as he tried to…
- [NTSB SEA05CA149](https://openairdocs.org/ntsb/SEA05CA149.md): Hughes 269A · Laurel, MT · Accident · Minor injuries · Data collection · Final report · Jul 21, 2005 · N801CP · Substantial damage
  > the pilot's failure to maintain rotor rpm while executing a pinnacle approach, which resulted in a loss of control and collision with terrain.
- [NTSB SEA05CA109](https://openairdocs.org/ntsb/SEA05CA109.md): Jackson Rans S-6S · Laurel, MT · Accident · No injuries · Data collection · Final report · May 28, 2005 · N133DJ · Substantial damage
  > The flight instructor's inadequate remedial action which resulted in a stall/spin during final approach to land. A contributing factor was the student pilot's failure to maintain adequate airspeed during the landing approach.
- [NTSB SEA05LA084](https://openairdocs.org/ntsb/SEA05LA084.md): Cessna T210N · Kalispell, MT · Accident · Minor injuries · Limited investigation · Final report · Apr 20, 2005 · N2AK · Destroyed
  > An airborne fire which was fueled by leaking hydraulic fluid (the ignition source for the fire was undetermined) from the landing gear hydraulic system located under the cockpit instrument panel due to inadequate maintenance from other maintenance personnel.…
- [NTSB SEA05LA066](https://openairdocs.org/ntsb/SEA05LA066.md): Abbott Glasair Legend · Cascade, MT · Accident · No injuries · Limited investigation · Final report · Mar 24, 2005 · C-GUTT · Substantial damage
  > The accumulation of wet snow on the engine inlet assembly protection screen during a rapid increase in outside air temperature, while on an instrument approach for landing. Factors include falling snow, a sudden and significant increase in outside air…
- [NTSB SEA05LA011](https://openairdocs.org/ntsb/SEA05LA011.md): Cessna T210H · Missoula, MT · Accident · No injuries · Limited investigation · Final report · Oct 23, 2004 · N2240R · Substantial damage
  > The pilot's failure to follow published procedures/directives (inducing excessive fuel flow to the engine), and the subsequent loss of engine power for nonmechanical reasons while on final approach. Contributing factors were the utility pole and the ditch.
- [NTSB SEA05LA010](https://openairdocs.org/ntsb/SEA05LA010.md): Beech 99A · Billings, MT · Accident · No injuries · Limited investigation · Final report · Oct 18, 2004 · N955AA · Substantial damage
  > the pilot's failure to follow the instrument approach procedure, which resulted in a premature descent below the decision height and subsequent collision with a building.
- [NTSB SEA04LA098](https://openairdocs.org/ntsb/SEA04LA098.md): Piper PA-18-150 · Columbus, MT · Accident · Minor injuries · Limited investigation · Final report · Jun 5, 2004 · N82172 · Substantial damage
  > The pilot's failure to maintain directional control of the aircraft during the landing and subsequent go-around. Inadequate compensation for the gusting winds and an airport hangar were factors.
- [NTSB SEA03CA102](https://openairdocs.org/ntsb/SEA03CA102.md): Piper PA-18 · Silver City, MT · Accident · No injuries · Data collection · Final report · Jun 14, 2003 · N82946 · Substantial damage
  > Proper descent rate not maintained while on final approach. A wind gust is a factor in the accident.

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?state=MT&page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
  crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
  current_codes AS (
    SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
      row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
    FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
    WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
      AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
  ),
  phases AS (
    SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
    FROM current_codes WHERE n = 1
    UNION ALL
    SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
    FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
    WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
  ),
  case_phases AS (
    SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
    FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
    LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
    WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
  )
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 case_mkey FROM case_phases WHERE main = 500)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?state=MT

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.
