# NTSB investigations, ID: Maneuvering

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 9 · 417 cases

## Latest cases

- [NTSB WPR26LA188](https://openairdocs.org/ntsb/WPR26LA188.md): Mcdonnell Douglas Helicopter 500 · Twin Falls, ID · Accident · Minor injuries · Class 4 · Limited · Final report · May 14, 2026 · N952SF · Substantial damage
  > The pilot’s failure to maintain control while hovering in gusty wind conditions, resulting in the helicopter rolling onto its side.
- [NTSB WPR26LA053](https://openairdocs.org/ntsb/WPR26LA053.md): Tecnam P2008 · Blackfoot, ID · Accident · Serious injuries · Class 4 · Limited · Final report · Nov 10, 2025 · N208CM · Substantial damage
  > The student pilot’s failure to maintain altitude and clearance from trees while maneuvering at night.
- [NTSB WPR25FA100](https://openairdocs.org/ntsb/WPR25FA100.md): Bell Helicopter Textron Canada 505 · Ririe, ID · Accident · 1 fatal · Class 3 · Field · Final report · Feb 20, 2025 · N118LG · Substantial damage
  > The pilot’s inadequate preflight planning and decision to maneuver the helicopter at a low altitude, and his subsequent failure to maintain clearance from power lines.
- [NTSB WPR25LA036](https://openairdocs.org/ntsb/WPR25LA036.md): Cessna 180 · Owinza, ID · Accident · Minor injuries · Class 4 · Limited · Final report · Oct 13, 2024 · N9493C
  > The pilot’s failure to maintain clearance from the water during a low pass over a lake.
- [NTSB WPR24LA315](https://openairdocs.org/ntsb/WPR24LA315.md): Cessna 172P · Kooskia, ID · Accident · Serious injuries · Class 4 · Limited · Final report · Sep 26, 2024 · N54829 · Substantial damage
  > The pilot’s decision to descend into a canyon that exceeded the performance capabilities of the airplane, which resulted in an impact with trees and terrain.
- [NTSB WPR24LA247](https://openairdocs.org/ntsb/WPR24LA247.md): Bell 407 · Stanley, ID · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 11, 2024 · N21BH · Substantial damage
  > A sudden wind shift which resulted in a rapid descent and subsequent dynamic rollover and collision into water.
- [NTSB WPR24FA225](https://openairdocs.org/ntsb/WPR24FA225.md): Game Composites GB1 Gamebird · Irwin, ID · Accident · 1 fatal · Class 3 · Field · Final report · Jul 4, 2024 · N786AE · Substantial damage
  > The pilot’s decision to perform a spin maneuver at an altitude that was insufficient to complete a successful recovery and subsequent failure to properly arrest the spin, which resulted in a secondary stall and an impact with terrain.
- [NTSB WPR24FA201](https://openairdocs.org/ntsb/WPR24FA201.md): Air Tractor AT-802 · Arco, ID · Accident · 1 fatal · Class 3 · Field · Final report · Jun 20, 2024 · N802TP · 2 aircraft · Destroyed
  > A midair collision between two airplanes during aerial application operations due to both pilots’ insufficient awareness of their proximity to each other and their failure to see and avoid each other. Contributing to the accident was the operator and both…
- [NTSB WPR24LA138](https://openairdocs.org/ntsb/WPR24LA138.md): Aerospatiale SA315B · Lewiston, ID · Accident · Minor injuries · Class 4 · Limited · Final report · May 2, 2024 · N42PL · Substantial damage
  > The pilot’s failure to maintain clearance from power lines during a low level aerial application.
- [NTSB WPR23LA265](https://openairdocs.org/ntsb/WPR23LA265.md): Robinson Helicopter R22 Beta · Emmett, ID · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 8, 2023 · N74778 · Substantial damage
  > The instructor’s failure to maintain airspeed during a simulated turning autorotation, which resulted in a hard landing.
- [NTSB WPR23LA242](https://openairdocs.org/ntsb/WPR23LA242.md): Piper PA-28-140 · Newdale, ID · Accident · No injuries · Class 4 · Limited · Final report · Jun 27, 2023 · N730SC · Substantial damage
  > The premature retraction of the flaps by the student pilot, while just above the airplane’s stall speed. Contributing to the accident was the flight instructor’s inadequate supervision and failure to regain aircraft control from the student pilot.
- [NTSB WPR22LA297](https://openairdocs.org/ntsb/WPR22LA297.md): Cessna 182B · Yellow Pine, ID · Accident · No injuries · Class 4 · Limited · Final report · Aug 5, 2022 · N722BS · Substantial damage
  > The pilot's failure to maintain clearance from a tree while maneuvering.
- [NTSB CEN22FA331](https://openairdocs.org/ntsb/CEN22FA331.md): Columbia Helicopters CH-47D · North Fork, ID · Accident · 2 fatal · Class 3 · Field · Final report · Jul 21, 2022 · N388RA · Destroyed
  > The failure of the flight crew to properly secure a company-issued iPad, leading to its migration into and jamming of the copilot’s left pedal, preventing the pilot from arresting a left yaw, and resulting in a loss of control.
- [NTSB WPR22FA173](https://openairdocs.org/ntsb/WPR22FA173.md): Blue Side UP Comp AIR 8 SS52 · Grasmere, ID · Accident · 2 fatal · Class 3 · Field · Final report · May 8, 2022 · N801DT · Substantial damage
  > The pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.
- [NTSB WPR22LA014](https://openairdocs.org/ntsb/WPR22LA014.md): Avid Mark IV · Payette, ID · Accident · No injuries · Class 3 · Limited · Final report · Oct 13, 2021 · N583DM · Substantial damage
  > A total loss of engine power during cruise flight due to fuel starvation. Contributing to the accident was the lack of an outlet screen on the fuel system header tank.
- [NTSB WPR21LA360](https://openairdocs.org/ntsb/WPR21LA360.md): Cessna 182E · Warren, ID · Accident · Serious injuries · Class 4 · Limited · Final report · Sep 27, 2021 · N3121Y · Destroyed
  > The pilot’s failure to maintain altitude while maneuvering in a valley of mountainous terrain.
- [NTSB WPR21LA354](https://openairdocs.org/ntsb/WPR21LA354.md): Hiller UH-12E · Bovill, ID · Accident · No injuries · Class 3 · Limited · Final report · Sep 23, 2021 · N5334V · Substantial damage
  > A loss of helicopter control for undetermined reasons based on the available evidence for this accident.
- [NTSB WPR21FA330](https://openairdocs.org/ntsb/WPR21FA330.md): Cessna TU206F · Bernard, ID · Accident · 2 fatal · Class 3 · Field · Final report · Aug 28, 2021 · N922MA · Substantial damage
  > The pilot’s decision to continue the flight into a canyon that exceeded the performance capabilities of the airplane, which resulted in an impact with trees an terrain.
- [NTSB WPR21LA324](https://openairdocs.org/ntsb/WPR21LA324.md): Cessna 172 · Athol, ID · Accident · No injuries · Class 4 · Limited · Final report · Aug 7, 2021 · N4110L · Substantial damage
  > The failure of the windshield during spin recovery for reasons that were not determined.
- [NTSB WPR21LA293](https://openairdocs.org/ntsb/WPR21LA293.md): Enstrom F-28A · Mountain Home, ID · Accident · No injuries · Class 4 · Limited · Final report · Jul 28, 2021 · N46MU · Substantial damage
  > The pilot's improper fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent hard landing on uneven terrain.
- [NTSB WPR21LA264](https://openairdocs.org/ntsb/WPR21LA264.md): Christen Industries A-1 · Twin Falls, ID · Accident · No injuries · Class 4 · Limited · Final report · Jul 1, 2021 · N9609H · Substantial damage
  > Partial loss of engine power during a low pass, due to carburetor icing and the pilot’s failure to use carburetor heat during the landing approach.
- [NTSB WPR21LA107](https://openairdocs.org/ntsb/WPR21LA107.md): Hughes OH-6A · Horseshoe Bend, ID · Accident · Serious injuries · Class 3 · Limited · Final report · Feb 5, 2021 · N6639R · Substantial damage
  > A partial loss of engine power due to a leak in the fuel cell outlet valve.
- [NTSB WPR20LA315](https://openairdocs.org/ntsb/WPR20LA315.md): Air Tractor AT-802A · Emmett, ID · Accident · 1 fatal · Class 3 · Limited · Final report · Sep 23, 2020 · N836MM · Substantial damage
  > The pilot’s descent below surrounding terrain and his delayed decision to initiate a climb which resulted in impact with terrain. Contributing to the accident were terrain and lighting conditions that affected the pilot’s ability to accurately assess terrain…
- [NTSB WPR20LA330](https://openairdocs.org/ntsb/WPR20LA330.md): Cessna 172 · Stanley, ID · Accident · Minor injuries · Class 4 · Limited · Final report · Sep 13, 2020 · N52700 · Substantial damage
  > The pilot's failure to maintain terrain clearance after flying into the wrong canyon in mountainous terrain which resulted in a collision with trees and terrain.
- [NTSB WPR20LA191](https://openairdocs.org/ntsb/WPR20LA191.md): Enstrom 280 · Hayden, ID · Accident · 1 fatal · Class 3 · Limited · Final report · Jun 24, 2020 · N280MM · Destroyed
  > The total loss of power while maneuvering at low altitude due to the detonation of two engine cylinders and damaged spark plugs.
- [NTSB WPR20CA179](https://openairdocs.org/ntsb/WPR20CA179.md): Ayres S2R · Lenore, ID · Accident · No injuries · Class 4 · Data collection · Final report · Jun 12, 2020 · N40226 · Destroyed
  > The pilot's failure to maintain clearance from power lines while maneuvering during an aerial application flight, which resulted in a wire strike.
- [NTSB WPR20CA171](https://openairdocs.org/ntsb/WPR20CA171.md): Enstrom 480 · Murphy, ID · Accident · Minor injuries · Class 4 · Data collection · Final report · Jun 4, 2020 · N130JS · Substantial damage
  > The pilot's failure to maintain clearance from a power line while maneuvering during an aerial application flight.
- [NTSB WPR20CA095](https://openairdocs.org/ntsb/WPR20CA095.md): Cessna 172 · Dubois, ID · Accident · No injuries · Data collection · Final report · Feb 27, 2020 · N7904G · Substantial damage
  > The student pilot's failure to maintain a proper airspeed and descent rate while conducting a low pass over a snow-covered runway after encountering a downdraft and the flight instructor's delayed action, which resulted in the wheels contacting the snow and…
- [NTSB WPR20FA015](https://openairdocs.org/ntsb/WPR20FA015.md): Mooney M20J · American Falls, ID · Accident · 1 fatal · Class 3 · Field · Final report · Oct 25, 2019 · N201BJ · Substantial damage
  > The pilot’s failure to ensure adequate fuel onboard and his subsequent failure to maintain airspeed while maneuvering which resulted in an aerodynamic stall following a total loss of engine power due to fuel exhaustion. Contributing to the accident was the…
- [NTSB GAA19CA437](https://openairdocs.org/ntsb/GAA19CA437.md): Piper PA36 · Bancroft, ID · Accident · Minor injuries · Data collection · Final report · Jul 15, 2019 · N57799 · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack during a low-altitude turn, which resulted in an aerodynamic stall.
- [NTSB GAA19CA283](https://openairdocs.org/ntsb/GAA19CA283.md): Rockwell S2R · Grangeville, ID · Accident · No injuries · Data collection · Final report · May 24, 2019 · N5569X · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack while turning at low altitude, which resulted in an aerodynamic stall.
- [NTSB WPR19LA092](https://openairdocs.org/ntsb/WPR19LA092.md): Cessna 172 · Melba, ID · Accident · No injuries · Class 3 · Limited · Final report · Mar 1, 2019 · N6486J · Substantial damage
  > The total loss of engine power due to a separated carburetor idle mixture adjustment screw and spring assembly for reasons that could not be determined.
- [NTSB GAA19CA110](https://openairdocs.org/ntsb/GAA19CA110.md): Robinson R44 · Grace, ID · Accident · No injuries · Data collection · Final report · Jan 3, 2019 · N4246Z · Substantial damage
  > The pilot's failure to maintain clearance from the power lines.
- [NTSB WPR18FA276](https://openairdocs.org/ntsb/WPR18FA276.md): Cessna T210 · Silver City, ID · Accident · 3 fatal · Class 2 · Field · Final report · Sep 30, 2018 · N732MV · Destroyed
  > The pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack while making a turn in gusting wind conditions while flying through hilly terrain, which resulted in an aerodynamic stall.
- [NTSB WPR18LA176](https://openairdocs.org/ntsb/WPR18LA176.md): Piper PA 18-150 · Yellow Pine, ID · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 21, 2018 · N1979P · Substantial damage
  > The pilot’s failure to maintain adequate airspeed while conducting a go-around and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall/spin at too low of an altitude to recover. Contributing to the accident were…
- [NTSB WPR18LA163](https://openairdocs.org/ntsb/WPR18LA163.md): North Wing Pulse · Mountain Home, ID · Accident · 1 fatal · Limited investigation · Final report · Jun 2, 2018 · N62073 · Substantial damage
  > The hang glider's encounter with a developing vortex or dust devil while maneuvering during an airshow routine, which resulted in a loss of control at an altitude that precluded recovery. Contributing to the accident was the pilot's preexisting and worsening…
- [NTSB WPR18LA050](https://openairdocs.org/ntsb/WPR18LA050.md): Gray Jim Robert Exec · Caldwell, ID · Accident · No injuries · Limited investigation · Final report · Dec 17, 2017 · N716JB · Substantial damage
  > Failure of the oil pressure gauge line, which resulted in oil exhaustion and a total loss of engine power.
- [NTSB GAA18CA044](https://openairdocs.org/ntsb/GAA18CA044.md): Cessna 172 · Bonners Ferry, ID · Accident · No injuries · Data collection · Final report · Nov 7, 2017 · N55234 · Substantial damage
  > The pilot’s failure to see and avoid power lines while maneuvering at a low altitude.
- [NTSB WPR17LA195](https://openairdocs.org/ntsb/WPR17LA195.md): Walker Edgar E Glastar · Cascade, ID · Accident · 1 fatal · Limited investigation · Final report · Sep 2, 2017 · N65EW · Destroyed
  > The pilot's inadequate flight planning, preparation, and navigation, which resulted in the airplane entering a canyon that the pilot was unable to exit by climbing the airplane. Also causal were his in-flight decision-making and his execution of the course…
- [NTSB WPR17FA128](https://openairdocs.org/ntsb/WPR17FA128.md): Prescot E. Wilkie RV-3 · Payette, ID · Accident · 1 fatal · Field investigation · Final report · Jun 17, 2017 · N177TT · Destroyed
  > The in-flight failure of the left wing due to the owner's use of improper hardware and his improper assembly of the airplane, which reduced the strength of the left wing and resulted in its subsequent failure following a sharp pullup maneuver.
- [NTSB WPR17LA113](https://openairdocs.org/ntsb/WPR17LA113.md): Bell 206B · Rockville, ID · Accident · Serious injuries · Limited investigation · Final report · May 26, 2017 · N24FS · Substantial damage
  > The in-flight failure of the engine-to-transmission drive shaft due to a fatigue fracture of one of the KAflex flex frames caused by a loose bolt, which resulted in a total loss of engine power and a subsequent hard landing.
- [NTSB GAA17CA202](https://openairdocs.org/ntsb/GAA17CA202.md): Cessna 182 · Mackay, ID · Accident · Minor injuries · Data collection · Final report · Mar 25, 2017 · N52743 · Substantial damage
  > The pilot's decision to maneuver the airplane over mountainous terrain in high-density altitude conditions, which resulted in the airplane’s inability to maintain altitude or establish a climb.
- [NTSB WPR16LA159](https://openairdocs.org/ntsb/WPR16LA159.md): Air Tractor AT 301 · Weiser, ID · Accident · No injuries · Limited investigation · Final report · Aug 2, 2016 · N23923 · Substantial damage
  > A partial loss of engine power due to an internal catastrophic failure of the master rod crankpin bearing.
- [NTSB WPR16LA133](https://openairdocs.org/ntsb/WPR16LA133.md): Cessna 172 · Salmon, ID · Accident · No injuries · Limited investigation · Final report · Jul 2, 2016 · N7748U · Substantial damage
  > A loss of engine power due to water in the fuel system. Contributing to the accident was an inadequate preflight inspection that failed to eliminate water from the fuel system.
- [NTSB WPR16FA131](https://openairdocs.org/ntsb/WPR16FA131.md): Cessna A185F · Coeur d'Alene, ID · Accident · 1 fatal · Field investigation · Final report · Jun 25, 2016 · N4585F · Substantial damage
  > The pilot's failure to maintain clearance from trees while maneuvering at low altitude in mountainous terrain.
- [NTSB WPR16FA120](https://openairdocs.org/ntsb/WPR16FA120.md): Rockwell S2R · De Smet, ID · Accident · 1 fatal · Field investigation · Final report · Jun 6, 2016 · N4191X · Substantial damage
  > The pilot's inadequate visual lookout, which resulted in his failure to maintain clearance from guy wires during an aerial application flight. Contributing to the accident was the pilot's reduced ability to see the guy wires due to sun glare.
- [NTSB WPR16LA082](https://openairdocs.org/ntsb/WPR16LA082.md): Grumman G164 · Juliaetta, ID · Accident · No injuries · Limited investigation · Final report · Mar 12, 2016 · N6894Q · Substantial damage
  > A partial loss of engine power due to a crack in the No. 2 cylinder.
- [NTSB WPR15LA255](https://openairdocs.org/ntsb/WPR15LA255.md): Extra Flugzeugbau EA 300/L · Jerome, ID · Accident · Serious injuries · Limited investigation · Final report · Sep 2, 2015 · N4BM · Destroyed
  > The pilot's failure to maintain clearance from terrain while conducting a low-altitude aerobatic maneuver.
- [NTSB GAA15CA255](https://openairdocs.org/ntsb/GAA15CA255.md): Aviat A-1C-200 · Irwin, ID · Accident · No injuries · Data collection · Final report · Aug 27, 2015 · N63BW · Substantial damage
  > The pilot's failure to maintain obstacle clearance during low level flight, which resulted in the airplane striking a wire, impacting water, and nosing over.
- [NTSB WPR14FA330](https://openairdocs.org/ntsb/WPR14FA330.md): David Fitzgerald Zenith · Warren, ID · Accident · 2 fatal · Field investigation · Final report · Aug 5, 2014 · N32FZ · Destroyed
  > The pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack while climbing to avoid terrain while operating at a high density altitude, which resulted in a stall at too low an altitude to allow recovery.

Next page: https://openairdocs.org/ntsb-phases/450/cases.md?state=ID&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" = 'ID' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 450)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

---
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.