# NTSB investigations, MT: Standing

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.

## Latest cases

- [NTSB ENG24LA012](https://openairdocs.org/ntsb/ENG24LA012.md): British Aerospace BAE 146 Series 200A · Missoula, MT · Incident · Class 3 · Limited · Final report · Mar 1, 2024 · N474NA · 2 aircraft · Minor damage
  > The use of a new long term fire retardant with a chemical composition incompatible with the retardant previously in use for the integration-operational field evaluation without adequate testing and qualification.
- [NTSB SEA95GA062](https://openairdocs.org/ntsb/SEA95GA062.md): Bell 206 · Dillon, MT · Accident · No injuries · Final report · Feb 24, 1995 · N2277T · Substantial damage
  > The pilot's selection of a landing site that was not suitable to support the weight of the helicopter. Factors include terrain covered with soft snow.
- [NTSB SEA93GA052](https://openairdocs.org/ntsb/SEA93GA052.md): Hiller UH-12E · Chinook, MT · Accident · 1 fatal · Final report · Jan 15, 1993 · N28908 · Minor damage
  > Inattentive FBO personnel.
- [NTSB DEN90LA032](https://openairdocs.org/ntsb/DEN90LA032.md): Piper PA-18-150 · Powderville, MT · Accident · 1 fatal · Limited investigation · Final report · Dec 3, 1989 · N62672 · No damage
  > The pilot in command left the airplane unattended with the engine running. That the pilot's son did not understand the unsafe condition is considered a contributing factor.
- [NTSB DEN88LA034](https://openairdocs.org/ntsb/DEN88LA034.md): Cessna 177RG · Great Falls, MT · Accident · Serious injuries · Limited investigation · Final report · Dec 6, 1987 · N8035G · Minor damage
  > The private plt was preparing for departure on an IFR flight plan. After finding that the starter would not operate properly, the plt tried to manually repositon the propeller. The ignition was still on and the engine fired. The propeller struck the plt's…
- [NTSB DEN87LA189](https://openairdocs.org/ntsb/DEN87LA189.md): Aerospatiale SA316B · Red Lodge, MT · Accident · No injuries · Limited investigation · Final report · Jul 19, 1987 · N48184 · Substantial damage
  > The plt said he was getting ready to take off from a 9400-FT MSL landing zone a top a mountain 7 mi ssw of Red Lodge, MT. The plat said the helicopter was positioned on a slight north-south slope and pointed towards the west. The wind was from the south…
- [NTSB DEN85FA131](https://openairdocs.org/ntsb/DEN85FA131.md): Consolidated-Vultee PBY-5A · Lewistown, MT · Accident · 1 fatal · Field investigation · Final report · May 9, 1985 · N84857 · Substantial damage
  > During taxi to takeoff the brakes failed. The plt attempted to groundloop the acft. The acft rolled down hill and collided with a gully. The plt was fatally injured. During preflight the co-plt inadvertently added hydraulic fluid in the alcohol tank. The…
- [NTSB DEN84LA034](https://openairdocs.org/ntsb/DEN84LA034.md): Cessna 172N · Helena, MT · Accident · Serious injuries · Limited investigation · Final report · Dec 2, 1983 · N4818D · Minor damage
  > The acft propeller struck a passenger who was attemping to sweep snow off the acft. The plt's and passenger's version of mishap vary. The plt stated he instructed the passenger to stay away from the acft. The passenger stated the plt toldhim to sweep the snow…
- [NTSB SEA76AS067](https://openairdocs.org/ntsb/SEA76AS067.md): Dehavilland DHC-6 · Havre, MT · Accident · No injuries · Closed · Aug 3, 1976 · N980FL · No damage
- [NTSB SEA75FTA12](https://openairdocs.org/ntsb/SEA75FTA12.md): Cessna 177 · Billings, MT · Accident · 1 fatal · Closed · Feb 6, 1975 · N2308Y · Minor damage
- [NTSB UNK64X1824](https://openairdocs.org/ntsb/UNK64X1824.md): Aeronca 7AC · Glasgow, MT · Accident · No injuries · Closed · May 18, 1964 · N81712 · Substantial damage

## 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 = 150)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/150/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.
