# NTSB investigations, ID: 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 5 · 249 cases

## Latest cases

- [NTSB WPR26LA302](https://openairdocs.org/ntsb/WPR26LA302.md): Cessna 208B · Salmon, ID · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 9, 2026 · N247JP · Substantial damage
  > On August 9, 2026, at 1420 mountain daylight time, a Cessna 208B airplane, N247JP, was substantially damaged when it was involved in an accident near Salmon, Idaho. The pilot and eight passengers were not injured. The airplane was operated as a Title 14 Code…
- [NTSB WPR26LA252](https://openairdocs.org/ntsb/WPR26LA252.md): Fairchild M-62A · Greenleaf, ID · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 5, 2026 · N53953 · Substantial damage
  > The pilot’s failure to maintain proper airspeed during approach and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and impact with terrain.
- [NTSB WPR26LA234](https://openairdocs.org/ntsb/WPR26LA234.md): Piper PA-12 · Dixie, ID · Accident · No injuries · Class 4 · Limited · Final report · Jun 23, 2026 · N3013M · Substantial damage
  > The pilot's delayed decision to initiate a go-around and subsequent failure to maintain clearance from rising terrain.
- [NTSB WPR26LA206](https://openairdocs.org/ntsb/WPR26LA206.md): Cessna 177 · Cascade, ID · Accident · Serious injuries · Class 4 · Limited · Final report · May 28, 2026 · N13430 · Substantial damage
  > The pilot’s improper approach, which resulted in a faster than normal touchdown and subsequent runway overrun.
- [NTSB WPR26LA046](https://openairdocs.org/ntsb/WPR26LA046.md): Michael W Verzwyvelt SS-7 Super Sport · Boise, ID · Accident · Minor injuries · Class 4 · Limited · Final report · Nov 9, 2025 · N14PM · Substantial damage
  > The pilot’s operation of the airplane while intoxicated, resulting in its impact with obstacles while on approach.
- [NTSB WPR25LA230](https://openairdocs.org/ntsb/WPR25LA230.md): Ballisodare Lancair Evolution · Coeur d' Alene, ID · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jul 27, 2025 · N505RF · Destroyed
  > On July 27, 2025, about 1010 Pacific daylight time, an experimental amateur-built Lancair Evolution airplane, N505RF, was destroyed when it was involved in an accident near Coeur d’Alene, Idaho. The pilot and two passengers sustained minor injuries. The…
- [NTSB WPR25LA021](https://openairdocs.org/ntsb/WPR25LA021.md): Piper PA-11 · Rexburg, ID · Accident · Serious injuries · Class 4 · Limited · Final report · Oct 19, 2024 · N4846M · Substantial damage
  > The pilot’s failure to see and avoid transmission wires during the landing approach.
- [NTSB WPR24LA034](https://openairdocs.org/ntsb/WPR24LA034.md): Cessna 310 · Hayden, ID · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 13, 2023 · N86H · Substantial damage
  > The pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in a loss of control and subsequent stall during a precautionary landing. Contributing to the accident was the improper maintenance…
- [NTSB WPR22LA362](https://openairdocs.org/ntsb/WPR22LA362.md): Angus Watt Zenair Stolch 750 · Howe, ID · Accident · No injuries · Class 4 · Limited · Final report · Sep 19, 2022 · N750RH · Substantial damage
  > The pilot’s failure to maintain adequate airspeed during the landing approach, which resulted in an aerodynamic stall.
- [NTSB WPR22LA207](https://openairdocs.org/ntsb/WPR22LA207.md): Cessna 175 · Blackfoot, ID · Accident · Minor injuries · Class 4 · Limited · Final report · Jun 7, 2022 · N7303M · Substantial damage
  > The pilot’s loss of airplane control during the landing approach which, resulted in an undershoot and collision with a fence.
- [NTSB WPR22FA151](https://openairdocs.org/ntsb/WPR22FA151.md): Cessna 208B · Heyburn, ID · Accident · 1 fatal · Class 3 · Field · Final report · Apr 13, 2022 · N928JP · Substantial damage
  > The pilot’s failure to maintain altitude during an instrument approach, which resulted in a descent below the approach path and impact with a vent stack. Also causal was the failure of the processing plant to correctly paint the vent stacks, which had been…
- [NTSB WPR22LA132](https://openairdocs.org/ntsb/WPR22LA132.md): Robinson Helicopter R44 II · Howe, ID · Accident · Minor injuries · Class 4 · Limited · Final report · Mar 22, 2022 · N44DQ · Substantial damage
  > The pilot’s failure to maintain adequate rotor rpm while descending with a gusting tailwind condition, which resulted in a loss of helicopter control.
- [NTSB WPR21LA234](https://openairdocs.org/ntsb/WPR21LA234.md): Bolstridge Wallace R SKY Raider 1 · Nampa, ID · Accident · No injuries · Class 4 · Limited · Final report · Jun 22, 2021 · N8010B · Substantial damage
  > A total loss of engine power due to the pilot’s failure to premix the two-cycle oil/gasoline mixture, which resulted in a forced landing in a field and collision with terrain.
- [NTSB WPR21LA212](https://openairdocs.org/ntsb/WPR21LA212.md): Maule M-5-235C · Stanley, ID · Accident · No injuries · Class 3 · Limited · Final report · May 29, 2021 · N9254E · Substantial damage
  > The pilot’s failure to use carburetor heat in weather conditions conducive to carburetor icing, resulting in a partial loss of engine power and a forced landing during which the airplane struck an object and nosed over.
- [NTSB WPR19LA179](https://openairdocs.org/ntsb/WPR19LA179.md): Stinson 108 · Caldwell, ID · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 27, 2019 · N6116M · Substantial damage
  > A total loss of engine power during approach due to a failed piston. The reason for the piston failure could not be determined based on the available information.
- [NTSB GAA19CA054](https://openairdocs.org/ntsb/GAA19CA054.md): Cessna 206 · Boise, ID · Accident · No injuries · Data collection · Final report · Nov 10, 2018 · N16HT · Substantial damage
  > The airplane’s impact with a bird during the approach.
- [NTSB WPR18LA215](https://openairdocs.org/ntsb/WPR18LA215.md): Cessna T337 · Lewiston, ID · Accident · No injuries · Limited investigation · Final report · Aug 9, 2018 · N255 · Substantial damage
  > The liberation of an internal snap ring from a landing gear door actuator, which resulted in a complete loss of hydraulic fluid and a gear-up landing. Contributing to the accident was the failure of maintenance personnel to replace the snap ring during the…
- [NTSB GAA17CA421](https://openairdocs.org/ntsb/GAA17CA421.md): Aviat A 1 · Dixie, ID · Accident · No injuries · Data collection · Final report · Jul 3, 2017 · N368HY · Substantial damage
  > The pilot's failure to maintain an appropriate glidepath to landing with sun glare and downdraft conditions, which resulted in the airplane landing in a ravine short of the runway.
- [NTSB WPR17LA122](https://openairdocs.org/ntsb/WPR17LA122.md): Luscombe 8A · Rexberg, ID · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 3, 2017 · N1627K · Substantial damage
  > A loss of engine power for reasons that could not be determined based on the available information which resulted in a landing short of the runway.
- [NTSB WPR16LA135](https://openairdocs.org/ntsb/WPR16LA135.md): Bert N Norris RV-6 · St. Maries, ID · Accident · No injuries · Limited investigation · Final report · Jul 4, 2016 · N916BN · Substantial damage
  > A partial loss of engine power due to carburetor icing, which resulted from the pilot’s failure to apply carburetor heat.
- [NTSB WPR15LA001](https://openairdocs.org/ntsb/WPR15LA001.md): Gaston Thomas D Thunder Mustang · Council, ID · Accident · 1 fatal · Limited investigation · Final report · Oct 3, 2014 · N51TG · Destroyed
  > The pilot's failure to maintain control while maneuvering for landing following a loss of oil pressure. Contributing to the accident was foreign material contamination of the oil system due to improper maintenance.
- [NTSB WPR14CA275](https://openairdocs.org/ntsb/WPR14CA275.md): Hoffman David K Hoffman BMW Airtrike · Payette, ID · Accident · Minor injuries · Data collection · Final report · Jul 1, 2014 · N190DH · Substantial damage
  > The pilot's failure to maintain adequate airspeed during the go-around which resulted in a stall.
- [NTSB WPR14LA271](https://openairdocs.org/ntsb/WPR14LA271.md): Cessna 182Q · Big Creek, ID · Accident · Serious injuries · Limited investigation · Final report · Jun 29, 2014 · N132K · Substantial damage
  > The pilot’s execution of a traffic pattern that did not put the airplane in position for a normal final approach and the pilot’s decision to continue the landing attempt instead of initiating a go-around, which resulted in the airplane exceeding its critical…
- [NTSB WPR14CA190](https://openairdocs.org/ntsb/WPR14CA190.md): Aviat A 1B · Hayden, ID · Accident · No injuries · Data collection · Final report · May 15, 2014 · N176WW · Substantial damage
  > A partial loss of engine power due to encounter with weather conditions conducive to carburetor icing. Contributing the accident was the pilot's inadequate weather planning.
- [NTSB WPR13LA416](https://openairdocs.org/ntsb/WPR13LA416.md): Beech C90 - A · Idaho Falls, ID · Accident · Serious injuries · Limited investigation · Final report · Sep 19, 2013 · N191TP · Substantial damage
  > The pilot's inadequate preflight fuel planning, which resulted in departure with insufficient fuel to complete the flight, and consequent inflight power loss due to fuel exhaustion.
- [NTSB WPR13CA395](https://openairdocs.org/ntsb/WPR13CA395.md): Beech C-50 · Homedale, ID · Accident · No injuries · Data collection · Final report · Sep 1, 2013 · N212G · Substantial damage
  > The pilot's delayed action to arrest a loss of altitude on short final, which resulted in a loss of aircraft control and collision with a fence post.
- [NTSB WPR13CA326](https://openairdocs.org/ntsb/WPR13CA326.md): Cessna A185F · Cascade, ID · Accident · No injuries · Data collection · Final report · Jul 14, 2013 · N185BW · Substantial damage
  > The pilot’s failure to maintain clearance from trees during final approach due to the sun glare that obscured the pilot's vision.
- [NTSB WPR13FA296](https://openairdocs.org/ntsb/WPR13FA296.md): Piper PA-22-135 · Yellow Pine, ID · Accident · 1 fatal · Field investigation · Final report · Jun 28, 2013 · N1540P · 2 aircraft · Substantial damage
  > The pilot's failure to see and avoid the airplane ahead of his position in the airport traffic pattern, which resulted in a midair collision while both airplanes were on approach to land. Contributing to the accident was both pilots’ failure to adequately…
- [NTSB WPR13CA280](https://openairdocs.org/ntsb/WPR13CA280.md): Aviat A-1A · McCall, ID · Accident · Minor injuries · Data collection · Final report · Jun 21, 2013 · N26HV · Substantial damage
  > The pilot’s failure to maintain adequate airspeed while on approach for landing, which resulted in a loss of airplane control and a hard landing.
- [NTSB WPR13LA167](https://openairdocs.org/ntsb/WPR13LA167.md): Enstrom F-28F · Twin Falls, ID · Accident · No injuries · Limited investigation · Final report · Mar 27, 2013 · N918DK · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR13LA005](https://openairdocs.org/ntsb/WPR13LA005.md): Cessna 180H · St Maries, ID · Accident · Minor injuries · Limited investigation · Final report · Oct 7, 2012 · N2780X · Substantial damage
  > The total loss of engine power for reasons that could not be determined because postaccident examination of the engine and airframe did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR12LA225](https://openairdocs.org/ntsb/WPR12LA225.md): Waggonner Excalibur · Buhl, ID · Accident · Serious injuries · Limited investigation · Final report · May 22, 2012 · N165AW · Substantial damage
  > The pilot’s failure to maintain control of the airplane while on final approach, which resulted in an aerodynamic stall.
- [NTSB WPR12CA157](https://openairdocs.org/ntsb/WPR12CA157.md): Fisher HP-14 Sailplane · Nampa, ID · Accident · No injuries · Data collection · Final report · Apr 6, 2012 · N990 · Substantial damage
  > The pilot’s incorrect positioning of the wing flaps during the landing approach, which resulted in a loss of lift and hard landing.
- [NTSB WPR11CA413](https://openairdocs.org/ntsb/WPR11CA413.md): Cessna 172F · Atlanta, ID · Accident · Minor injuries · Data collection · Final report · Aug 29, 2011 · N8698U · Substantial damage
  > The pilot’s misjudgment of his final approach path. Contributing to the accident was the pilot’s inadequate preflight planning.
- [NTSB WPR11FA404](https://openairdocs.org/ntsb/WPR11FA404.md): Cessna 150G · Cavanaugh Bay, ID · Accident · Serious injuries · Field investigation · Final report · Aug 23, 2011 · N2870S · Substantial damage
  > The pilot’s failure to maintain adequate airspeed during an attempt to execute a go-around with a tailwind condition, which resulted in an aerodynamic stall and spin.
- [NTSB WPR11FA392](https://openairdocs.org/ntsb/WPR11FA392.md): Briegleb BG-12B · Moore, ID · Accident · 1 fatal · Field investigation · Final report · Aug 18, 2011 · N559Y · Substantial damage
  > The pilot’s decision to perform a low pass over the runway in the opposite direction of his intended landing, and his subsequent failure to maintain airspeed and glider control during the reverse-course maneuver. Contributing to the accident was the effect of…
- [NTSB WPR11FA335](https://openairdocs.org/ntsb/WPR11FA335.md): Mooney M20C · Grace, ID · Accident · 3 fatal · Field investigation · Final report · Jul 18, 2011 · N6855N · Substantial damage
  > The pilot’s failure to maintain aircraft control while maneuvering in the traffic pattern, which resulted in an aerodynamic stall.
- [NTSB WPR11CA271](https://openairdocs.org/ntsb/WPR11CA271.md): Luscombe 8F · McCall, ID · Accident · No injuries · Data collection · Final report · Jun 21, 2011 · N1459B · Substantial damage
  > The pilot's failure to maintain adequate airspeed that resulted in a stall/mush. Contributing to the accident was the pilot's failure to maintain an adequate spacing from the aircraft ahead of him.
- [NTSB WPR10CA442](https://openairdocs.org/ntsb/WPR10CA442.md): Schweizer 269C · Caldwell, ID · Accident · No injuries · Data collection · Final report · Aug 31, 2010 · N1534C · Substantial damage
  > The failure of both pilots to maintain adequate main rotor RPM, the flight instructor's delayed remedial actions, and inadequate supervision of the flight.
- [NTSB WPR10CA049](https://openairdocs.org/ntsb/WPR10CA049.md): Piper PA-18-150 · Lewiston, ID · Accident · No injuries · Data collection · Final report · Nov 1, 2009 · N82213 · Substantial damage
  > The pilot's delayed decision to execute a go-around in gusting winds and with up-sloping terrain.
- [NTSB WPR09LA378](https://openairdocs.org/ntsb/WPR09LA378.md): Gray RV-6 · Caldwell, ID · Accident · 1 fatal · Limited investigation · Final report · Aug 1, 2009 · N69KG · Destroyed
  > The pilot's failure to maintain adequate airspeed that led to a stall/spin while maneuvering in the traffic pattern.
- [NTSB WPR09CA315](https://openairdocs.org/ntsb/WPR09CA315.md): Piper PA-25-235 · Preston, ID · Accident · Minor injuries · Data collection · Final report · Jun 27, 2009 · N8600L · Substantial damage
  > A loss of engine power due to fuel exhaustion that resulted from the pilot's inadequate fuel planning.
- [NTSB WPR09CA121](https://openairdocs.org/ntsb/WPR09CA121.md): Cessna 182 · Caldwell, ID · Accident · Minor injuries · Data collection · Final report · Feb 20, 2009 · N4729D · Substantial damage
  > The loss of engine power due to carburetor icing as a result of the pilot's failure to apply carburetor heat before reducing power and his failure to clear the engine during a prolonged glide.
- [NTSB SEA08CA203](https://openairdocs.org/ntsb/SEA08CA203.md): Snelling Zodiac · Rexburg, ID · Accident · No injuries · Data collection · Final report · Sep 17, 2008 · N826W · Substantial damage
  > The private pilot's excessive use of the flight controls and improper landing flair, which resulted in a hard landing and subsequent gear collapse.
- [NTSB SEA08CA154](https://openairdocs.org/ntsb/SEA08CA154.md): Uetz, Walter Spitfire II · Kamiah, ID · Accident · Minor injuries · Data collection · Final report · Jun 19, 2008 · N7530L · Substantial damage
  > The total loss of engine power for undetermined reasons, and the pilot's failure maintain the proper descent rate during the last part of his approach to a forced landing in an open hayfield.
- [NTSB SEA08FA116](https://openairdocs.org/ntsb/SEA08FA116.md): Cessna 172N · McCall, ID · Accident · 3 fatal · Field investigation · Final report · May 3, 2008 · N75856 · 2 aircraft · Destroyed
  > The failure of the pilot to maintain adequate visual lookout and clearance from another airplane while attempting to land on the same runway. Contributing to the accident was the non-standard pattern entry of the pilot.
- [NTSB SEA07LA234](https://openairdocs.org/ntsb/SEA07LA234.md): Cessna 182P · Nampa, ID · Accident · No injuries · Limited investigation · Final report · Aug 14, 2007 · N52581 · Substantial damage
  > The total loss of engine power due to the carburetor throat becoming obstructed with paint that had pealed off of the induction air inlet channel in an area where paint should not have been applied. Factors include an earthen berm running across the field…
- [NTSB LAX07CA246](https://openairdocs.org/ntsb/LAX07CA246.md): Found Aircraft Canada FBA-2C1 · Challis, ID · Accident · No injuries · Data collection · Final report · Jul 30, 2007 · N705BH · Substantial damage
  > the pilot's inadequate bounced landing recovery technique, which resulted in a hard landing.
- [NTSB SEA07LA209](https://openairdocs.org/ntsb/SEA07LA209.md): Cessna TU206F · Nampa, ID · Accident · Serious injuries · Limited investigation · Final report · Jul 22, 2007 · N2089U · Destroyed
  > The total loss of engine power for an undetermined reason. Factors include a power transmission line between the point were the aircraft lost power and the runway that the pilot was attempting to reach.
- [NTSB SEA07CA125](https://openairdocs.org/ntsb/SEA07CA125.md): Cessna 170B · Fairfield, ID · Accident · No injuries · Data collection · Final report · May 17, 2007 · N2778C · Substantial damage
  > The pilot's failure to maintain adequate airspeed while turning from base to final, resulting in an inadvertent stall/mush and subsequent collision with terrain.

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

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