# NTSB investigations, ID: Initial climb

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 6 · 265 cases

## Latest cases

- [NTSB WPR26FA101](https://openairdocs.org/ntsb/WPR26FA101.md): Sonex Onex · Caldwell, ID · Accident · 1 fatal · Class 3 · Field · Preliminary report · Feb 6, 2026 · N362DZ · Destroyed
  > On February 6, 2026, about 0945 mountain standard time, a Sonex Onex airplane, N362DZ, was destroyed when it was involved in an accident near Caldwell, Idaho. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…
- [NTSB WPR25LA283](https://openairdocs.org/ntsb/WPR25LA283.md): Cessna 150F · Rigby, ID · Accident · Minor injuries · Class 4 · Limited · Final report · Sep 17, 2025 · N8047F · Substantial damage
  > The flight instructor’s improper flap position during takeoff, which resulted in degraded climb performance and a subsequent impact with a building.
- [NTSB WPR25FA225](https://openairdocs.org/ntsb/WPR25FA225.md): Mooney M20J · Nampa, ID · Accident · 3 fatal · Class 3 · Field · Preliminary report · Jul 27, 2025 · N5764H · Substantial damage
  > On August 27, 2025, about 1741 mountain daylight time, a Mooney M20J, N5764H, was destroyed when it was involved in an accident near Nampa, Idaho. The pilot and two passengers were fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB WPR24LA280](https://openairdocs.org/ntsb/WPR24LA280.md): Piper PA-18-150 · Island Park, ID · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 19, 2024 · N9166T · Substantial damage
  > A loss of lateral control during takeoff due to an accumulation of water in the right wing.
- [NTSB WPR24FA215](https://openairdocs.org/ntsb/WPR24FA215.md): Cessna 182 · Big Creek, ID · Accident · 1 fatal · Class 3 · Field · Final report · Jun 28, 2024 · N6210A · Substantial damage
  > The pilot’s delayed decision to go around after descending below the recommended abort altitude with a slight tailwind and an over-gross-weight airplane, which resulted in impact with trees and terrain. Contributing to the accident was the pilot’s failure to…
- [NTSB WPR24FA190](https://openairdocs.org/ntsb/WPR24FA190.md): Cessna 177B · Elk River, ID · Accident · 1 fatal · Class 3 · Field · Final report · Jun 12, 2024 · N34903 · Destroyed
  > The pilot’s failure to maintain clearance from terrain while climbing in mountainous terrain during moderately high density altitude conditions, and conditions conducive to severe carburetor icing.
- [NTSB WPR24LA098](https://openairdocs.org/ntsb/WPR24LA098.md): Cessna 182A · Weippe, ID · Accident · No injuries · Class 4 · Limited · Final report · Feb 22, 2024 · N6323B · Substantial damage
  > The pilot’s failure to secure the oil filler cap during the preflight inspection, which resulted in a precautionary landing on the soft surface and subsequent nose over.
- [NTSB WPR23FA296](https://openairdocs.org/ntsb/WPR23FA296.md): Cessna T206H · Yellow Pine, ID · Accident · 1 fatal · Class 3 · Field · Final report · Jul 30, 2023 · N918KG · Substantial damage
  > The pilot’s decision to perform a go-around into rising mountainous terrain. Contributing to the accident was the pilot’s failure to follow published airport guidance about go-arounds, and landings and takeoffs with unfavorable winds.
- [NTSB WPR23FA225](https://openairdocs.org/ntsb/WPR23FA225.md): Cessna R182 · McCall, ID · Accident · 1 fatal · Class 3 · Field · Final report · Jun 12, 2023 · N3138C · Substantial damage
  > Maintenance personnel's failure to properly torque and inspect the magneto hardware, which resulted in a partial loss of engine power.
- [NTSB WPR23LA193](https://openairdocs.org/ntsb/WPR23LA193.md): Cessna 140 · American Falls, ID · Accident · Minor injuries · Class 4 · Limited · Final report · May 20, 2023 · N77J · Substantial damage
  > The pilot’s inadvertent selection of the off position of the fuel tank selector inflight, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB WPR23LA127](https://openairdocs.org/ntsb/WPR23LA127.md): Cessna 172L · Lewiston, ID · Accident · No injuries · Class 4 · Limited · Final report · Mar 11, 2023 · N7010Q · Substantial damage
  > The flight instructor’s inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB WPR22LA322](https://openairdocs.org/ntsb/WPR22LA322.md): Ray E Roberts Kitfox V Vixen · Caldwell, ID · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 26, 2022 · N52367 · Substantial damage
  > The partial loss of engine power due to a loose wire leading to the engine’s electronic control unit (ECU). Contributing was the pilot’s exceedance of the critical angle of attack while maneuvering, which resulted in an aerodynamic stall at an altitude too…
- [NTSB WPR22LA314](https://openairdocs.org/ntsb/WPR22LA314.md): Beech F33A · Wilder, ID · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 21, 2022 · N4133S · Substantial damage
  > Catastrophic engine failure during the initial climb due to an incorrectly installed crankshaft counterweight retaining ring.
- [NTSB WPR22FA304](https://openairdocs.org/ntsb/WPR22FA304.md): Aviat A-1A · Yellow Pine, ID · Accident · 2 fatal · Class 3 · Field · Final report · Aug 15, 2022 · N26HV · Substantial damage
  > The pilot's failure to maintain adequate airspeed during an initial climb, which resulted in the exceedance of the critical angle of attack, subsequent aerodynamic stall, and impact with terrain. Contributing was the pilot’s decision to operate the airplane…
- [NTSB WPR22LA238](https://openairdocs.org/ntsb/WPR22LA238.md): Piper PA20 · Challis, ID · Accident · 2 fatal · Class 3 · Limited · Final report · Jun 27, 2022 · N1231C · Substantial damage
  > The pilot's turn towards rising terrain with limited climb performance and his subsequent failure to maintain clearance from terrain that resulted in an impact with terrain.
- [NTSB WPR22LA037](https://openairdocs.org/ntsb/WPR22LA037.md): Cessna 172 · Stanley, ID · Accident · Minor injuries · Class 4 · Limited · Final report · Nov 14, 2021 · N8509B · Substantial damage
  > The pilot's failure to attain sufficient airspeed for the airplane to climb with a tailwind.
- [NTSB WPR21FA283](https://openairdocs.org/ntsb/WPR21FA283.md): Siai-Marchetti SM-1019B · Lewiston, ID · Accident · 1 fatal · Class 3 · Field · Final report · Jul 24, 2021 · N28U · Substantial damage
  > The pilot’s failure to remove the flight control lock before departure, which resulted in a loss of airplane control and impact with terrain. Contributing to the accident was his failure to perform an adequate preflight inspection and flight control check…
- [NTSB WPR21LA237](https://openairdocs.org/ntsb/WPR21LA237.md): Cessna 182P · Warren, ID · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 21, 2021 · N2087F · Destroyed
  > The pilot's decision to continue the approach for landing with excess airspeed, which resulted in an aborted landing and subsequent collision with trees.
- [NTSB WPR21LA139](https://openairdocs.org/ntsb/WPR21LA139.md): Beech B19 · Twin Falls, ID · Accident · No injuries · Class 4 · Limited · Final report · Mar 18, 2021 · N1956W · Substantial damage
  > The pilot’s failure to maintain airplane control during initial climb with a crosswind when the airspeed decreased, the airplane exceeded its critical angle of attack and aerodynamical stalled at too low an altitude for the pilot to recover before the…
- [NTSB WPR21LA011](https://openairdocs.org/ntsb/WPR21LA011.md): Rans S-7 · Spirit Lake, ID · Accident · 1 fatal · Class 3 · Limited · Final report · Oct 6, 2020 · N55893 · Substantial damage
  > The pilot’s exceedance of the airplane's critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall.
- [NTSB DCA20CA010](https://openairdocs.org/ntsb/DCA20CA010.md): De Havilland DHC8 · Boise, ID · Accident · No injuries · Data collection · Final report · Oct 29, 2019 · N402QX · Substantial damage
  > a bird strike during climb out.
- [NTSB WPR19FA150](https://openairdocs.org/ntsb/WPR19FA150.md): Beech 35 · Melba, ID · Accident · 1 fatal · Class 3 · Field · Final report · May 19, 2019 · N1888D · Substantial damage
  > The pilot's loss of control during a low-level aerobatic maneuver, which resulted in impact with terrain. Contributing to the accident was the pilot’s impairment due to the effects of alcohol and antidepressant medication.
- [NTSB WPR19FA042](https://openairdocs.org/ntsb/WPR19FA042.md): Piper PA-24-250 · Aberdeen, ID · Accident · 1 fatal · Class 2 · Field · Final report · Dec 17, 2018 · N6283P · Substantial damage
  > The pilot's diverted attention during the takeoff climb due to a loss of engine power, which resulted in the airplane’s exceedance of the critical angle of attack and subsequent stall/spin.
- [NTSB WPR18LA227](https://openairdocs.org/ntsb/WPR18LA227.md): Cessna 182 · Salmon, ID · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 18, 2018 · N84CP · Substantial damage
  > The pilot’s inadvertent encounter with downdraft conditions, which resulted in a loss of altitude, and the pilot’s subsequent decision to conduct a precautionary landing into a stand of trees.
- [NTSB WPR18LA224](https://openairdocs.org/ntsb/WPR18LA224.md): Cessna 140 · Marsing, ID · Accident · No injuries · Class 3 · Limited · Final report · Aug 14, 2018 · N89093 · Substantial damage
  > The loss of engine power during a low pass as a result of a blockage of the carburetor idle chambers which led to a forced landing in a river.
- [NTSB WPR18FA026](https://openairdocs.org/ntsb/WPR18FA026.md): Piper PA 18-150 · Murphy, ID · Accident · 1 fatal · Class 2 · Field · Final report · Nov 3, 2017 · N4393Z · Substantial damage
  > Failure of the left aileron control cable that resulted in a loss of aircraft control during takeoff. Contributing to the accident was inadequate maintenance inspections to the aileron cable connections.
- [NTSB GAA17CA526](https://openairdocs.org/ntsb/GAA17CA526.md): Cessna 172 · Coolin, ID · Accident · Serious injuries · Data collection · Final report · Sep 10, 2017 · N5703A · Substantial damage
  > The pilot's decision to take off in high-density altitude and gusting quartering tailwind conditions, which resulted in a loss of lift and an inability to gain altitude during the initial climb.
- [NTSB WPR17LA181](https://openairdocs.org/ntsb/WPR17LA181.md): Rans S9 · Athol, ID · Accident · Serious injuries · Limited investigation · Final report · Aug 4, 2017 · N519TB · Substantial damage
  > The pilot's loss of pitch attitude and ground proximity awareness, which resulted in an unintentionally steep initial climb and an overcorrection into a steep descent and ground impact.
- [NTSB WPR17LA078](https://openairdocs.org/ntsb/WPR17LA078.md): Swearingen SA226 · Boise, ID · Accident · No injuries · Limited investigation · Final report · Mar 20, 2017 · N158WA · Substantial damage
  > Company maintenance personnel's failure to remove a screwdriver that was left lodged in the windshield wiper area of the forward fuselage during maintenance and subsequently became dislodged on takeoff/initial climb and collided with a left propeller blade.
- [NTSB GAA16CA298](https://openairdocs.org/ntsb/GAA16CA298.md): Cessna 182 · Stanley, ID · Accident · No injuries · Data collection · Final report · Jun 9, 2016 · N1403S · Substantial damage
  > The pilot's failure to attain an adequate climb gradient, which resulted in a collision with a tree and subsequent substantial damage to the left wing and aileron.
- [NTSB WPR15IA263](https://openairdocs.org/ntsb/WPR15IA263.md): Cessna T206H · Idaho Falls, ID · Incident · Minor injuries · Incident investigation · Final report · Sep 21, 2015 · N7269T · Minor damage
  > An in-flight fire during initial climb due to the separation of the engine's turbocharger wastegate overboard exhaust tailpipe. Contributing to the accident was the owner's decision to not comply with a service bulletin that addressed the tailpipe separation.
- [NTSB WPR15LA190](https://openairdocs.org/ntsb/WPR15LA190.md): Piper PA 20 · Yellow Pine, ID · Accident · Serious injuries · Limited investigation · Final report · Jun 18, 2015 · N6939K · Substantial damage
  > The pilot's delayed decision to go around after realizing that the airplane’s airspeed and altitude were too high, which resulted in an inadequate flare and bounced landing and a subsequent go-around in high-density altitude conditions.
- [NTSB WPR14LA335](https://openairdocs.org/ntsb/WPR14LA335.md): Cessna 180A · Salmon, ID · Accident · No injuries · Limited investigation · Final report · Aug 10, 2014 · N7784A · Substantial damage
  > A loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR14CA333](https://openairdocs.org/ntsb/WPR14CA333.md): Kitfox Series 5 · Kamiah, ID · Accident · Minor injuries · Data collection · Final report · Aug 9, 2014 · N910MK · Substantial damage
  > A loss of engine power due to fuel starvation as a result of the pilot's failure to open the fuel shutoff valves for each fuel tank before takeoff.
- [NTSB WPR13CA323](https://openairdocs.org/ntsb/WPR13CA323.md): Cessna 152 · Kamiah, ID · Accident · Minor injuries · Data collection · Final report · Jul 10, 2013 · N46566 · Substantial damage
  > The student pilot’s failure to maintain aircraft control during the initial climb, which resulted in a collision with a powerline.
- [NTSB WPR13FA281](https://openairdocs.org/ntsb/WPR13FA281.md): Piper PA-30 · Idaho Falls, ID · Accident · 2 fatal · Field investigation · Final report · Jun 22, 2013 · N830SS · Substantial damage
  > A loss of power to the right engine during the initial climb due to fuel contamination and the pilot's failure to maintain adequate airspeed and airplane control. Contributing to the accident was the pilot's inadequate preflight check of the airplane.
- [NTSB WPR12LA418](https://openairdocs.org/ntsb/WPR12LA418.md): Cessna 180 · Nampa, ID · Accident · Serious injuries · Limited investigation · Final report · Sep 14, 2012 · N90RW · Substantial damage
  > An uncommanded bank after takeoff followed by an aerodynamic stall. The reason for the uncommanded bank could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR12CA401](https://openairdocs.org/ntsb/WPR12CA401.md): Piper PA-22-108 · Lewiston, ID · Accident · No injuries · Data collection · Final report · Sep 4, 2012 · N4798Z · Substantial damage
  > The pilot’s inadequate postmaintenance and preflight inspections, which resulted in the separation of the left main wheel after takeoff. Contributing to the accident was the improperly secured left main wheel spindle nut.
- [NTSB WPR12FA280](https://openairdocs.org/ntsb/WPR12FA280.md): Aviat A-1C-180 · Kooskia, ID · Accident · 1 fatal · Field investigation · Final report · Jun 28, 2012 · N63WY · Substantial damage
  > The pilot's decision to attempt a takeoff with a gusty tailwind, which resulted in his loss of airplane control during the initial climb and an aerodynamic stall/spin.
- [NTSB WPR12LA143](https://openairdocs.org/ntsb/WPR12LA143.md): Reich Glastar · Caldwell, ID · Accident · No injuries · Limited investigation · Final report · Mar 22, 2012 · N617G · Substantial damage
  > The failure of a propeller blade at the hub due to fatigue cracking.
- [NTSB WPR12FA089](https://openairdocs.org/ntsb/WPR12FA089.md): Garza Lancair IV-TP · Boise, ID · Accident · 1 fatal · Field investigation · Final report · Feb 3, 2012 · N321LC · Destroyed
  > A loss or commanded reduction of engine power during the initial climb for reasons that could not be determined because of postaccident impact damage and fire destruction to engine systems and components. Also causal were the pilot's failure to maintain…
- [NTSB WPR12LA048](https://openairdocs.org/ntsb/WPR12LA048.md): Piper PA-32RT-300T · Hailey, ID · Accident · Serious injuries · Limited investigation · Final report · Nov 30, 2011 · N36824 · Substantial damage
  > The pilot's failure to maintain course heading and terrain clearance because he was distracted by efforts to engage the autopilot shortly after takeoff on a dark night in mountainous terrain.
- [NTSB WPR11FA428](https://openairdocs.org/ntsb/WPR11FA428.md): Veatch Kitfox · Caldwell, ID · Accident · 2 fatal · Field investigation · Final report · Sep 4, 2011 · N624JS · Substantial damage
  > The pilot’s failure to prevent a low-altitude stall and spin following a complete loss of engine power during the initial climb after takeoff.
- [NTSB WPR11CA409](https://openairdocs.org/ntsb/WPR11CA409.md): Cessna 170A · Grangeville, ID · Accident · Serious injuries · Data collection · Final report · Aug 28, 2011 · N1238D · Substantial damage
  > The pilot's loss of directional control for undetermined reasons.
- [NTSB WPR11LA278](https://openairdocs.org/ntsb/WPR11LA278.md): Air Tractor AT-502 · Blackfoot, ID · Accident · No injuries · Limited investigation · Final report · Jun 21, 2011 · N1515P · Substantial damage
  > A partial loss of engine power during takeoff for undetermined reasons.
- [NTSB WPR11LA207](https://openairdocs.org/ntsb/WPR11LA207.md): Davison RV-7A · Marsing, ID · Accident · No injuries · Limited investigation · Final report · Apr 23, 2011 · N59TD · Substantial damage
  > A loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR10LA154](https://openairdocs.org/ntsb/WPR10LA154.md): Sutton Avid Hauler · Rigby, ID · Accident · No injuries · Limited investigation · Final report · Mar 7, 2010 · N22EJ · Substantial damage
  > A loss of engine power during takeoff for undetermined reasons.
- [NTSB WPR09LA463](https://openairdocs.org/ntsb/WPR09LA463.md): Frazier Tangent · Nampa, ID · Accident · 1 fatal · Limited investigation · Final report · Sep 24, 2009 · N72TZ · Substantial damage
  > The pilot's failure to maintain pitch control of the airplane.
- [NTSB WPR09LA427](https://openairdocs.org/ntsb/WPR09LA427.md): Stone Kitfox Series 6 · May, ID · Accident · Serious injuries · Limited investigation · Final report · Aug 30, 2009 · N2070A · Substantial damage
  > The pilot's failure to maintain clearance from obstacles during the takeoff initial climb.
- [NTSB WPR09LA343](https://openairdocs.org/ntsb/WPR09LA343.md): Cessna U206G · Yellow Pine, ID · Accident · Serious injuries · Limited investigation · Final report · Jul 14, 2009 · N71BS · Substantial damage
  > The pilot's failure to maintain clearance from the trees while taking off in a high-density altitude. Contributing to the accident were the pilot's failure to perform pre-takeoff performance calculations, his positioning of the elevator trim in a nose-down…

Next page: https://openairdocs.org/ntsb-phases/350/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 = 350)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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