# NTSB investigations, ID: Enroute

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 10 · 453 cases

## Latest cases

- [NTSB WPR26FA091](https://openairdocs.org/ntsb/WPR26FA091.md): N126c CCX-1865 · Montour, ID · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jan 27, 2026 · N126C · Substantial damage
  > On January 27, 2026, about 1100 mountain standard time, an amateur-built, experimental CCX-1865 Carbon Cub, N126C, was substantially damaged when it was involved in an accident near Montour, Idaho. The pilot and pilot-rated passenger were fatally injured. The…
- [NTSB WPR25LA210](https://openairdocs.org/ntsb/WPR25LA210.md): Hibbard Rick Rans S7 · Blackfoot, ID · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 13, 2025 · N69TY · Substantial damage
  > On July 12, 2025, about 2015 mountain daylight time, an experimental amateur-built Rans S7 airplane, N69TY, was substantially damaged when it was involved in an accident near Blackfoot, Idaho. The pilot was not injured. The airplane was operated as a Title 14…
- [NTSB WPR25LA183](https://openairdocs.org/ntsb/WPR25LA183.md): Piper PA-32RT-300T · Winchester, ID · Accident · Minor injuries · Class 4 · Limited · Final report · Jun 22, 2025 · N31998 · Substantial damage
  > The pilot’s improper fuel management resulting in fuel starvation, a total loss of engine power, and a subsequent off-airport forced landing. Contributing to the accident was the pilot’s reduced fuel level monitoring due to an inflight distraction.
- [NTSB WPR25LA167](https://openairdocs.org/ntsb/WPR25LA167.md): Cessna 182J · Kooskia, ID · Accident · Serious injuries · Class 3 · Limited · Preliminary report · May 31, 2025 · N3463F · Substantial damage
  > On May 31, 2025, about 0930 Pacific daylight time, a Cessna 182J, N3463F, was substantially damaged when it was involved in an accident near Kooskia, Idaho. The private pilot sustained serious injuries. The airplane was operated as a Title 14 Code of Federal…
- [NTSB WPR24LA265](https://openairdocs.org/ntsb/WPR24LA265.md): Bell 407 · Raft River, ID · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 3, 2024 · N20BH · Substantial damage
  > The pilot’s misdiagnosis of an erroneous engine instrument indication and his subsequent decision to enter an autorotation, which resulted in a hard landing due to degraded visual cues and low ambient light conditions. Contributing to the accident were the…
- [NTSB WPR24LA240](https://openairdocs.org/ntsb/WPR24LA240.md): Cessna 182B · Soldier, ID · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 13, 2024 · N2617G · Substantial damage
  > A total loss of engine power resulting from the failure of the No. 1 piston and the No. 2 piston connecting rod due to detonation.
- [NTSB WPR24LA087](https://openairdocs.org/ntsb/WPR24LA087.md): Mooney M20K · Burley, ID · Accident · Minor injuries · Class 3 · Limited · Final report · Feb 10, 2024 · C-FLQQ · Substantial damage
  > The failure of the pilot to fly a stabilized approach during an emergency landing with a tailwind, which resulted in a bounced landing and subsequent runway excursion during the landing roll. Contributing to the accident was the pilot’s inadequate preflight…
- [NTSB WPR23LA346](https://openairdocs.org/ntsb/WPR23LA346.md): Aeronca 11AC · Apple, ID · Accident · Minor injuries · Class 4 · Limited · Final report · Sep 16, 2023 · N46WR · Substantial damage
  > Fuel starvation due to the pilot’s incorrect movement of the fuel selector valve to OFF, which resulted in a loss of engine power.
- [NTSB WPR23LA318](https://openairdocs.org/ntsb/WPR23LA318.md): Cessna T210M · Indian Creek, ID · Accident · No injuries · Class 4 · Limited · Final report · Aug 5, 2023 · N7067Z · Substantial damage
  > The pilot's improper fuel management, which resulted in fuel starvation, and gear up landing on a dirt airstrip.
- [NTSB WPR23LA297](https://openairdocs.org/ntsb/WPR23LA297.md): Bell OH-58A · Blanchard, ID · Accident · No injuries · Class 3 · Limited · Final report · Jul 30, 2023 · N613SS · Substantial damage
  > Fuel contamination, which resulted in a loss of engine power. The source of the contamination could not be determined.
- [NTSB WPR22FA347](https://openairdocs.org/ntsb/WPR22FA347.md): Skiles Kenneth C RV-6A · Preston, ID · Accident · 2 fatal · Class 3 · Field · Final report · Sep 14, 2022 · N992KS · Substantial damage
  > The non-instrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.
- [NTSB WPR22LA089](https://openairdocs.org/ntsb/WPR22LA089.md): Blake D Barrymore Just Acft Superstol · Ketchum, ID · Accident · No injuries · Class 3 · Limited · Final report · Jan 30, 2022 · N8794G · Substantial damage
  > The total loss of engine power due to carburetor ice.
- [NTSB WPR22LA030](https://openairdocs.org/ntsb/WPR22LA030.md): Piper PA-28-140 · Newdale, ID · Accident · Minor injuries · Class 4 · Limited · Final report · Oct 28, 2021 · N1671J · Substantial damage
  > The flight instructor’s failure to monitor the flight to ensure terrain clearance during the dark night conditions.
- [NTSB WPR21LA220](https://openairdocs.org/ntsb/WPR21LA220.md): Piper PA-24 · Paris, ID · Accident · Serious injuries · Class 3 · Limited · Final report · May 29, 2021 · N6334P · Substantial damage
  > A total loss of engine power for reasons that could not be determined.
- [NTSB WPR21LA056](https://openairdocs.org/ntsb/WPR21LA056.md): Cessna 172 · Howe, ID · Accident · Minor injuries · Class 4 · Limited · Final report · Nov 14, 2020 · N8278B · Substantial damage
  > The pilot’s failure to maintain clearance from mountainous terrain after an encounter with a downdraft, which resulted in a collision with terrain.
- [NTSB WPR20FA206](https://openairdocs.org/ntsb/WPR20FA206.md): Cessna TU206 · Coeur d'Alene, ID · Accident · 8 fatal · Class 3 · Field · Final report · Jul 5, 2020 · N6373U · 2 aircraft · Destroyed
  > The failure of the pilots of both airplanes to see and avoid the other airplane.
- [NTSB WPR19FA216](https://openairdocs.org/ntsb/WPR19FA216.md): Lancair Lancair IV · Kooskia, ID · Accident · 2 fatal · Class 3 · Field · Final report · Aug 11, 2019 · N350CL · Substantial damage
  > The pilot’s failure to maintain airspeed while maneuvering in an area of precipitation and reduced visibility, which resulted in an aerodynamic stall and spin and loss of airplane control.
- [NTSB WPR19LA170](https://openairdocs.org/ntsb/WPR19LA170.md): James Experimental Cub · Stanley, ID · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 13, 2019 · N9WU · Substantial damage
  > Overstress failure of the right-wing spar due to an encounter with turbulence.
- [NTSB DCA18IA264](https://openairdocs.org/ntsb/DCA18IA264.md): Lindstrand 105A · Driggs, ID · Incident · No injuries · Incident investigation · Final report · Aug 10, 2018 · N1410C · 2 aircraft · No damage
  > the drone pilot's decision to fly without pre-coordination, and without the requisite skills and knowledge, to maneuver the drone in close proximity to another aircraft.
- [NTSB WPR18LA149](https://openairdocs.org/ntsb/WPR18LA149.md): Cessna 182 · Aberdeen, ID · Accident · No injuries · Class 3 · Limited · Final report · May 27, 2018 · N5700B · Substantial damage
  > The pilot's failure to use carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a partial loss of engine power and a subsequent forced landing and nose-over.
- [NTSB WPR18FA141](https://openairdocs.org/ntsb/WPR18FA141.md): Cessna 182G · Cascade, ID · Accident · 1 fatal · Field investigation · Final report · May 13, 2018 · N2377R · Destroyed
  > The non-instrument-rated pilot's improper decision to initiate a visual flight rules flight into an area with low ceilings due to mountain obscuration, which resulted in controlled flight into terrain.
- [NTSB GAA18CA095](https://openairdocs.org/ntsb/GAA18CA095.md): Cessna 150 · Nampa, ID · Accident · No injuries · Data collection · Final report · Jan 2, 2018 · N3229V · Substantial damage
  > The pilot’s geographic disoriention during a night flight, which resulted in an off-airport landing.
- [NTSB WPR17LA180](https://openairdocs.org/ntsb/WPR17LA180.md): Lockheed P2V 5F · Pocatello, ID · Accident · No injuries · Limited investigation · Final report · Aug 6, 2017 · N410NA · Substantial damage
  > Maintenance personnel's failure to secure hardware, which resulted in an uncommanded upward deflection of the left elevator and aft movement of the control yoke and inhibited the flight crew from adjusting the airplane's pitch attitude in flight. Contributing…
- [NTSB WPR17LA003](https://openairdocs.org/ntsb/WPR17LA003.md): Melborn Joe B Kolb Sport 600 · Roberts, ID · Accident · Minor injuries · Limited investigation · Final report · Oct 9, 2016 · N914NK · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB WPR16LA146](https://openairdocs.org/ntsb/WPR16LA146.md): Cessna 172 · Emmett, ID · Accident · No injuries · Limited investigation · Final report · Jul 17, 2016 · N8184B · 2 aircraft · Substantial damage
  > The failure of both pilots to see and avoid each other during cruise flight, which resulted in a midair collision.
- [NTSB WPR16FA013](https://openairdocs.org/ntsb/WPR16FA013.md): Aviat A-1C-200 · Swan Valley, ID · Accident · 1 fatal · Field investigation · Final report · Oct 15, 2015 · N280TB · Substantial damage
  > The pilot's failure to maintain airspeed while maneuvering in high density altitude conditions over mountainous terrain, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.
- [NTSB WPR16LA008](https://openairdocs.org/ntsb/WPR16LA008.md): Cessna T210K · Boise, ID · Accident · No injuries · Limited investigation · Final report · Oct 13, 2015 · N8273M · Substantial damage
  > The pilot’s improper in-flight fuel management due to distraction and self-induced pressure, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the pilot’s failure to conduct the descent checklist, which…
- [NTSB WPR16FA006](https://openairdocs.org/ntsb/WPR16FA006.md): Cessna 182 · Hope, ID · Accident · 3 fatal · Field investigation · Final report · Oct 8, 2015 · N6184F · Destroyed
  > The pilot's selection of an inadequate altitude to cross mountainous terrain and her subsequent failure to maintain terrain clearance. Contributing to the accident was the pilot's inadequate preflight evaluation of the weather conditions and flight plan.
- [NTSB WPR15LA237](https://openairdocs.org/ntsb/WPR15LA237.md): Piper PA 28-181 · American Falls, ID · Accident · No injuries · Limited investigation · Final report · Aug 3, 2015 · N7963C · Substantial damage
  > The low flight time pilot's inadequate in-flight fuel planning, which resulted in fuel exhaustion, a loss of engine power, and an off-airport landing in rough terrain.
- [NTSB WPR15LA220](https://openairdocs.org/ntsb/WPR15LA220.md): Cessna 182Q · Prichard, ID · Accident · No injuries · Limited investigation · Final report · Jul 21, 2015 · N759LV · Substantial damage
  > A total loss of engine power due to the fatigue failure of the No. 6 cylinder piston pin.
- [NTSB GAA15CA164](https://openairdocs.org/ntsb/GAA15CA164.md): Piper PA 18-135 · Twin Falls, ID · Accident · Minor injuries · Data collection · Final report · Jul 3, 2015 · N8086C · Substantial damage
  > The pilot's inadequate fuel inspection during his preflight fuel performance planning task, resulting in fuel exhaustion en route, and an emergency landing and collision with terrain.
- [NTSB WPR15FA206](https://openairdocs.org/ntsb/WPR15FA206.md): Piper PA 22-135 · Carey, ID · Accident · 1 fatal · Field investigation · Final report · Jul 2, 2015 · N8195C · Destroyed
  > Undetermined because examination of the airplane wreckage did not reveal any anomalies that would have precluded normal operation.
- [NTSB GAA15CA153](https://openairdocs.org/ntsb/GAA15CA153.md): Grumman American Avn. AA 5A · Mackay, ID · Accident · No injuries · Data collection · Final report · Jul 1, 2015 · N9887U · Substantial damage
  > The student pilot's disorientation in mountainous terrain and course deviation into a canyon, which resulted in the airplane's inability to out climb terrain and a forced landing.
- [NTSB WPR14LA345](https://openairdocs.org/ntsb/WPR14LA345.md): Piper PA 28-236 · Salmon, ID · Accident · Minor injuries · Limited investigation · Final report · Aug 13, 2014 · N2190H · Substantial damage
  > Maintenance personnel’s improper surface preparation of the accessory mount pad for the installation of the engine’s dry vacuum pump, which resulted in the loss of engine oil, oil pressure, and engine power during flight. Contributing to the accident was the…
- [NTSB WPR14FA316](https://openairdocs.org/ntsb/WPR14FA316.md): Meyer Legacy · Lolo Pass, ID · Accident · 1 fatal · Field investigation · Final report · Jul 28, 2014 · N29MM · Substantial damage
  > The fatigue fracture of an engine connecting rod, which resulted in a catastrophic engine failure and a forced landing in unsuitable terrain.
- [NTSB WPR14FA283](https://openairdocs.org/ntsb/WPR14FA283.md): American Champion 7GCBC · Landmark, ID · Accident · 1 fatal · Field investigation · Final report · Jul 7, 2014 · N162CG · 2 aircraft · Substantial damage
  > The failure of the overtaking airplane’s pilot to maintain visual contact and separation from the airplane being overtaken.
- [NTSB WPR14LA272](https://openairdocs.org/ntsb/WPR14LA272.md): Aerospatiale AS350B2 · Dietrich, ID · Accident · Serious injuries · Limited investigation · Final report · Jun 29, 2014 · N350CR · Substantial damage
  > The pilot’s sudden incapacitation from a previously undiagnosed medical condition while in cruise flight, which resulted in his inability to maintain helicopter control.
- [NTSB WPR14FA091](https://openairdocs.org/ntsb/WPR14FA091.md): Cirrus Design SR22 · Pocatello, ID · Accident · Minor injuries · Field investigation · Final report · Jan 9, 2014 · N903SR · Substantial damage
  > The distributor gear teeth failure of the right magneto that resulted in severe engine vibration and partial loss of engine power, which progressively led to the failure of the left magneto distributor drive gear teeth. Contributing to the airplane’s…
- [NTSB WPR14FA094](https://openairdocs.org/ntsb/WPR14FA094.md): Beech B36TC · Yellow Pine, ID · Accident · 5 fatal · Field investigation · Final report · Dec 1, 2013 · N36ML · Destroyed
  > The pilot’s continued flight into known light-to-moderate icing conditions over mountainous terrain. Contributing to the accident was the loss of engine power due to induction icing.
- [NTSB WPR14CA006](https://openairdocs.org/ntsb/WPR14CA006.md): Siemens Rotorway Exec 162F · Nampa, ID · Accident · Minor injuries · Data collection · Final report · Oct 5, 2013 · N104BJ · Substantial damage
  > A flight control malfunction during cruise flight for reasons that could not be determined. No follow-up examination was conducted due to a lapse in agency funding and subsequent government shutdown.
- [NTSB WPR13LA320](https://openairdocs.org/ntsb/WPR13LA320.md): Stinson 108-3 · Blackfoot, ID · Accident · No injuries · Limited investigation · Final report · Jul 10, 2013 · N703C · Substantial damage
  > A partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB WPR13LA304](https://openairdocs.org/ntsb/WPR13LA304.md): Dorman Bakeng · Garden Valley, ID · Accident · No injuries · Limited investigation · Final report · Jul 2, 2013 · N39796 · Substantial damage
  > A mechanical failure of the oil cooler, which resulted in a complete loss of oil and engine power.
- [NTSB WPR12CA429](https://openairdocs.org/ntsb/WPR12CA429.md): Piper PA-14 · Emmett, ID · Accident · Minor injuries · Data collection · Final report · Sep 17, 2012 · N5196H · Substantial damage
  > The pilot’s failure to maintain clearance from terrain.
- [NTSB WPR12LA365](https://openairdocs.org/ntsb/WPR12LA365.md): Cessna 182Q · McCall, ID · Accident · Minor injuries · Limited investigation · Final report · Aug 20, 2012 · N735KV · Substantial damage
  > The flight instructor’s selection of the wrong route while flying in mountainous terrain at a high-density altitude, which resulted in the airplane impacting terrain when the increase in elevation exceeded the airplane’s climb performance.
- [NTSB WPR12LA306](https://openairdocs.org/ntsb/WPR12LA306.md): Cessna 172N · Rockford, ID · Accident · No injuries · Limited investigation · Final report · Jul 16, 2012 · N5204K · Substantial damage
  > A partial loss of engine power during cruise flight due to the failure of the No. 3 cylinder exhaust valve for reasons that could not be determined due to the damage to the valve head and the missing valve stem. Contributing to the accident was the flight…
- [NTSB WPR12FA255](https://openairdocs.org/ntsb/WPR12FA255.md): Piper PA-32-300 · Mountain Home, ID · Accident · 1 fatal · Field investigation · Final report · Jun 9, 2012 · N8990N · Substantial damage
  > The noninstrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in controlled flight into mountainous terrain.
- [NTSB WPR12LA219](https://openairdocs.org/ntsb/WPR12LA219.md): Enstrom F28 · Twin Falls, ID · Accident · No injuries · Limited investigation · Final report · May 20, 2012 · N63VP · Substantial damage
  > The pilot's inability to maintain helicopter control during cruise flight due to the failure of the No. 2 main rotor Lamiflex bearing. Contributing to the accident was the pilot's decision to operate the helicopter with a known deficiency and the helicopter’s…
- [NTSB WPR11LA359](https://openairdocs.org/ntsb/WPR11LA359.md): Cessna 182A · Emmett, ID · Accident · Serious injuries · Limited investigation · Final report · Aug 2, 2011 · N6399B · Substantial damage
  > A total loss of engine power due to carburetor icing because the pilot did not use carburetor heat.
- [NTSB WPR11CA342](https://openairdocs.org/ntsb/WPR11CA342.md): Schleicher ASW-27 · Preston, ID · Accident · No injuries · Data collection · Final report · Jul 21, 2011 · N78AB · Substantial damage
  > The glider's impact with crops during the off-airport landing.
- [NTSB WPR11FA156](https://openairdocs.org/ntsb/WPR11FA156.md): Douglas AD-4N · Twin Falls, ID · Accident · 2 fatal · Field investigation · Final report · Mar 8, 2011 · N2088G · Substantial damage
  > The non-instrument-rated pilot’s encounter with localized instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.

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

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