# NTSB investigations, WV: 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 3 · 117 cases

## Latest cases

- [NTSB ERA26LA303](https://openairdocs.org/ntsb/ERA26LA303.md): Mcfarland Larry C Zenith 601 HDS · Ripley Landing, WV · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 15, 2026 · N601EZ · Substantial damage
  > On August 15, 2026, about 1300 eastern daylight time, an experimental, amateur-built Zenith 601 HDS airplane, N601EZ, was substantially damaged when it was involved in an accident near Ripley Landing, West Virginia. The private pilot was seriously injured.…
- [NTSB ERA26FA266](https://openairdocs.org/ntsb/ERA26FA266.md): Sikorsky S76 · Huntersville, WV · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 10, 2026 · N93RT · Destroyed
  > On July 10, 2026, about 0745 eastern daylight time, a Sikorsky S-76D helicopter, N93RT, was destroyed when it was involved in an accident near Huntersville, West Virginia. The commercial pilot was fatally injured. The helicopter was operated as a Title 14…
- [NTSB DCA26LA159](https://openairdocs.org/ntsb/DCA26LA159.md): Pyka Pelican Cargo · Summit Point, WV · Accident · No injuries · Class 4 · Limited · Final report · Mar 17, 2026 · N136ZP · Substantial damage
  > The inaccurate obstacle height entered into mission planning that resulted in the aircraft wing’s impact with a tree during descent, resulting resulted in a loss of control.
- [NTSB ERA25LA186](https://openairdocs.org/ntsb/ERA25LA186.md): Beech 95-C55 · Lakin, WV · Accident · Serious injuries · Class 4 · Limited · Final report · Apr 23, 2025 · N591R · Substantial damage
  > The pilot’s inadequate preflight inspection, and inadequate inflight fuel management, which resulted in a total loss of engine power due to fuel starvation and subsequent forced landing.
- [NTSB ERA23LA128](https://openairdocs.org/ntsb/ERA23LA128.md): Cessna 210 · Buckhannon, WV · Accident · No injuries · Class 4 · Limited · Final report · Feb 18, 2023 · N6597X · Substantial damage
  > A total loss of engine power due to fuel starvation. Contributing was the pilot’s decision to depart on the flight with an inoperative fuel selector valve.
- [NTSB ERA23LA010](https://openairdocs.org/ntsb/ERA23LA010.md): Green L/Gilner D RV-4 · Rowlesburg, WV · Accident · Serious injuries · Class 4 · Limited · Final report · Oct 7, 2022 · N262DF · Substantial damage
  > The pilot's failure to maintain an appropriate airspeed/angle-of-attack during the landing approach, which resulted in an aerodynamic stall, and impact with terrain.
- [NTSB ERA18LA067](https://openairdocs.org/ntsb/ERA18LA067.md): Cessna 172RG · Martinsburg, WV · Accident · No injuries · Limited investigation · Final report · Jan 21, 2018 · N9415B · Substantial damage
  > A hydraulic leak in the right main landing gear actuator, which resulted in the main landing gear not extending.
- [NTSB GAA16CA490](https://openairdocs.org/ntsb/GAA16CA490.md): Piper PA 28 · Parkersburg, WV · Accident · No injuries · Data collection · Final report · Sep 15, 2016 · N5673U · Substantial damage
  > The flight instructor’s delayed remedial action during the approach for landing, which resulted in impact with terrain short of the runway threshold. Contributing to the accident was the student pilot’s failure to maintain an appropriate descent rate during…
- [NTSB ERA15CA317](https://openairdocs.org/ntsb/ERA15CA317.md): Ercoupe 415 C · Fairmont, WV · Accident · Minor injuries · Data collection · Final report · Aug 14, 2015 · N93606 · Substantial damage
  > The pilot's failure to maintain airspeed and his exceedance of the wing's critical angle of attack, which resulted in an aerodynamic stall and subsequent collision with terrain.
- [NTSB ERA14LA086](https://openairdocs.org/ntsb/ERA14LA086.md): Cirrus Design SR22 · Buckhannon, WV · Accident · Minor injuries · Limited investigation · Final report · Jan 4, 2014 · N450TX · Substantial damage
  > The pilot’s improper in-flight fuel mixture management and failure to use the appropriate checklist or manuals during approach to landing, which resulted in a loss of engine power.
- [NTSB ERA10LA506](https://openairdocs.org/ntsb/ERA10LA506.md): Cirrus SR22 · Mathias, WV · Accident · Serious injuries · Limited investigation · Final report · Sep 30, 2010 · N567WT · Substantial damage
  > The pilot's loss of control of the airplane during an instrument approach in turbulent weather conditions.
- [NTSB ERA09CA390](https://openairdocs.org/ntsb/ERA09CA390.md): Piper J3C · South Charleston, WV · Accident · No injuries · Data collection · Final report · Jul 8, 2009 · N88025 · Substantial damage
  > The pilot's failure to maintain control during the attempted go-around.
- [NTSB NYC07CA014](https://openairdocs.org/ntsb/NYC07CA014.md): Cessna 172N · Morgantown, WV · Accident · No injuries · Data collection · Final report · Oct 29, 2006 · N952AC · Substantial damage
  > The student pilot's failure to maintain directional control and the flight instructor's improper planning and supervision of the student's solo cross country flight. A contributing factor was the wind gusts.
- [NTSB IAD05LA122](https://openairdocs.org/ntsb/IAD05LA122.md): Enstrom 280C · Saulsville, WV · Accident · Serious injuries · Limited investigation · Final report · Aug 12, 2005 · N5691B · Substantial damage
  > The pilot's inadequate remedial action following a loss of control during the landing approach.
- [NTSB IAD04LA035](https://openairdocs.org/ntsb/IAD04LA035.md): Giles Mustang II · Rainelle, WV · Accident · Serious injuries · Limited investigation · Final report · Aug 8, 2004 · N91061 · Substantial damage
  > The partial loss of engine power due to a broken throttle mechanism, which resulted in a forced landing over unsuitable terrain
- [NTSB IAD03LA030](https://openairdocs.org/ntsb/IAD03LA030.md): Young Challenger II · Huntington, WV · Accident · Minor injuries · Limited investigation · Final report · Feb 3, 2003 · N851MY · Substantial damage
  > The pilot's improper decision to switch off the ignition on approach and not attaining the proper touchdown point.
- [NTSB IAD02LA089](https://openairdocs.org/ntsb/IAD02LA089.md): Puhl Genesis · Petersburg, WV · Accident · 1 fatal · Limited investigation · Final report · Aug 25, 2002 · N51XT · Destroyed
  > The pilot's failure to maintain airspeed after a loss of engine power, which resulted in an inadvertent stall/spin. Factors included the pilot's inadequate preflight planning which resulted in fuel exhaustion, and the transmission wires in the pilot's glide…
- [NTSB IAD01LA028](https://openairdocs.org/ntsb/IAD01LA028.md): Piper 34-200T · Bluefield, WV · Accident · No injuries · Limited investigation · Final report · Jan 20, 2001 · N99ED · Substantial damage
  > The pilot's failure to enter the correct altimeter setting, which resulted in continued flight below the decision height and a subsequent collision with trees.
- [NTSB NYC01FA064](https://openairdocs.org/ntsb/NYC01FA064.md): Cessna 310R · Bluefield, WV · Accident · 1 fatal · Field investigation · Final report · Jan 8, 2001 · N123RA · Destroyed
  > The pilot's failure to execute the published missed approach procedure. A factor was heavy snowfall during the approach.
- [NTSB NYC00LA205](https://openairdocs.org/ntsb/NYC00LA205.md): Lake LA-4-200 · Logan, WV · Accident · No injuries · Limited investigation · Final report · Jul 22, 2000 · N12SF · Substantial damage
  > Fuel exhaustion of the engine due to improper fuel consumption calculations performed by the pilot.
- [NTSB NYC97IA123](https://openairdocs.org/ntsb/NYC97IA123.md): Beech 1900D · Clarksburg, WV · Incident · No injuries · Incident investigation · Final report · Jun 19, 1997 · N165YV · Minor damage
  > The right outboard flap detaching from the flap aft roller bearings, at the flap track, which was a result of the manufacturer's inadequate inspection program.
- [NTSB NYC96FA073](https://openairdocs.org/ntsb/NYC96FA073.md): Piper PA-23-250 · Bridgeport, WV · Accident · 1 fatal · Field investigation · Final report · Mar 11, 1996 · N222WR · Destroyed
  > The pilot's inablility to maintain aircraft control due to a full nose down trim condition, which resulted in a loss of control and collision with terrain.
- [NTSB NYC95LA122](https://openairdocs.org/ntsb/NYC95LA122.md): Cessna 172N · Weston, WV · Accident · 2 fatal · Limited investigation · Final report · May 27, 1995 · N5085G · Destroyed
  > the pilot's failure to maintain airspeed which resulted in an inadvertent stall, and a subsequent uncontrolled descent and collision with the ground.
- [NTSB NYC95LA045](https://openairdocs.org/ntsb/NYC95LA045.md): Cessna 150H · Wheeling, WV · Accident · Minor injuries · Limited investigation · Final report · Dec 21, 1994 · N7175S · Destroyed
  > The student pilot's inadequately planned cross-country flight, and his subsequent disorientation, resulting in fuel exhaustion and a collision with an object.
- [NTSB NYC94FA145](https://openairdocs.org/ntsb/NYC94FA145.md): Cessna 210N · Martinsburg, WV · Accident · 1 fatal · Field investigation · Final report · Aug 3, 1994 · N4875U · Destroyed
  > Failure of the pilot to maintain adequate altitude and proper climb during the missed approach. Factors related to the accident were: darkness, fog, and conditions conducive to pilot fatigue.
- [NTSB BFO93LA160](https://openairdocs.org/ntsb/BFO93LA160.md): Smyth Sidewinder · Point Pleasant, WV · Accident · No injuries · Limited investigation · Final report · Sep 6, 1993 · N2116B · Destroyed
  > The pilot's failure to maintain a proper glidepath.
- [NTSB NYC93LA161](https://openairdocs.org/ntsb/NYC93LA161.md): Beech A23 · Morgantown, WV · Accident · Serious injuries · Limited investigation · Final report · Aug 18, 1993 · N3552R · Substantial damage
  > The pilot's failure to follow IFR procedures in which he descended below the decision height without visual detection of the runway. Factors are the fog conditions, trees and the pilot's inattention to altitude.
- [NTSB BFO93FA049](https://openairdocs.org/ntsb/BFO93FA049.md): British Aerospace BAE 3101 · Beckley, WV · Accident · Minor injuries · Field investigation · Final report · Mar 18, 1993 · N159PC · Substantial damage
  > Failure of the captain to assure proper alignment with the plowed portion of the runway (or perform a missed approach). Factors related to the accident were: darkness, the adverse weather condition, inadequate removal of snow from the runway with snow along…
- [NTSB BFO93FA003](https://openairdocs.org/ntsb/BFO93FA003.md): Cessna 310R · Summersville, WV · Accident · 1 fatal · Field investigation · Final report · Nov 8, 1992 · N711RG · Destroyed
  > The pilot's inadequate altitude (or clearance) from mountainous hilly terrain. Factors related to the accident were darkness, low clouds, and light snow.
- [NTSB BFO92FA048](https://openairdocs.org/ntsb/BFO92FA048.md): Mooney M20M · Youngs Bottom, WV · Accident · 2 fatal · Field investigation · Final report · Mar 27, 1992 · N9136J · Destroyed
  > The pilot's inadequate inflight decision to continue flight in icing condition which resulted in degraded aircraft performance, inadequate airspeed, and aerodynamic stall. A related factor is the pilot's inadequate evaluation of the weather.
- [NTSB BFO92LA004](https://openairdocs.org/ntsb/BFO92LA004.md): Cessna T210N · Wheeling, WV · Accident · No injuries · Limited investigation · Final report · Oct 26, 1991 · N6466N · Substantial damage
  > The engine failure caused by fuel starvation and the pilot's improper fuel management.
- [NTSB BFO91FA031](https://openairdocs.org/ntsb/BFO91FA031.md): Cessna 182F · Princeton, WV · Accident · Serious injuries · Field investigation · Final report · Mar 14, 1991 · N3529Y · Destroyed
  > The pilot's inadequate inflight decision which resulted in airframe icing.
- [NTSB BFO90FA076](https://openairdocs.org/ntsb/BFO90FA076.md): Piper PA-601P · Wiley Ford, WV · Accident · 1 fatal · Field investigation · Final report · Sep 19, 1990 · N8249J · Destroyed
  > The pilot's improper IFR procedure by not maintaining sufficient altitude, while circling to land. Factors related to the accident were: the low ceiling and visibility conditions in fog.
- [NTSB BFO90FA057](https://openairdocs.org/ntsb/BFO90FA057.md): Mooney M20E · Charleston, WV · Accident · 2 fatal · Field investigation · Final report · Jun 15, 1990 · N3260F · Destroyed
  > The pilot's improper IFR procedures, his failure to maintain a proper glide path on the ILS approach, and his failure to initiate a missed approach at the decision height. The adverse weather was a related factor.
- [NTSB BFO90DIG01](https://openairdocs.org/ntsb/BFO90DIG01.md): Rolladen-Schneider LS-6 · Cabins, WV · Accident · 1 fatal · Final report · Feb 19, 1990 · N511M · Substantial damage
  > The pilot failed to detect and remain clear of the power line which crossed the field in which he was attempting to land. Contributing to the accident was the moderate to severe turbulence in the area at the time of the accident.
- [NTSB BFO89LA030](https://openairdocs.org/ntsb/BFO89LA030.md): Cessna 150F · New Cumberland, WV · Accident · No injuries · Limited investigation · Final report · Apr 19, 1989 · N3570L · Substantial damage
  > The pilot's failure to compensate for crosswind conditions during an attempted go-around. Contributing factors were the crosswind condition and the pilot's low level of experience.
- [NTSB BFO88LA080](https://openairdocs.org/ntsb/BFO88LA080.md): Piper PA-28R-200 · Charleston, WV · Accident · No injuries · Limited investigation · Final report · Aug 31, 1988 · N15948 · Substantial damage
  > The plt was executing the ILS rwy 5 apch when he entered fog about 350 ft above the dh. According to the plt, upon reaching the dh he sighted the rwy and continued the apch. Afterward the plt said he deviated left of the localizer centerline and as he was…
- [NTSB BFO87FA056](https://openairdocs.org/ntsb/BFO87FA056.md): Cessna 190 · Hedgesville, WV · Accident · 2 fatal · Field investigation · Final report · Aug 17, 1987 · N9827A · Destroyed
  > There were no eyewitnesses to the acdnt, but 3 persons heard the eng rev up to a high power setting before the plane crashed. Subsequently, it crashed in a wooded area north of the plt's 2600' pvt strip. There was a wooded hill north of the strip. The plt's…
- [NTSB BFO87DIG07](https://openairdocs.org/ntsb/BFO87DIG07.md): Cessna 150/Horton Stol · Maysville, WV · Accident · Minor injuries · Final report · Jun 24, 1987 · N150VA · Substantial damage
  > The plt/owner was flying a Cessna 150 which was equipped with a horton stol kit. Drg an apch to rwy 3, he used an airspeed of 40 KTS. While apchg the rwy, the acft settled & the nose gear struck a bump on the apch edge of the rwy. The plt rprtd that the…
- [NTSB BFO87LA035](https://openairdocs.org/ntsb/BFO87LA035.md): Beech A23 · Ravenswood, WV · Accident · Serious injuries · Limited investigation · Final report · May 9, 1987 · N3543R · Destroyed
  > The pilot was providing free promotional rides for a flight school. He was on the fourth flight of the day, on final approach, in a nose high attitude when the aircraft's left wing struck small trees. The aircraft impacted the ground 250FEET short of the…
- [NTSB ATL86FA212](https://openairdocs.org/ntsb/ATL86FA212.md): Cessna 172 · Bridgeport, WV · Accident · 2 fatal · Field investigation · Final report · Jul 28, 1986 · N96701 · Destroyed
  > The aircraft collided with a tree while on final approach to runway 21. The flight had been cleared for the approach after the pilot reported having the airport in sight. There was no current weather observation available at that time, but a local air taxi…
- [NTSB ATL86LA012](https://openairdocs.org/ntsb/ATL86LA012.md): Cessna 152 · Parkersburg, WV · Accident · No injuries · Limited investigation · Final report · Oct 28, 1985 · N48987 · Substantial damage
  > The acft experienced a total loss of power due to fuel exhaustion while on a baseleg for landing. The pilot elected to land in a corn field approx 1.5 miles short of the runway because he did not think he could make it to the runway. The plt was returning…
- [NTSB ATL85FA283](https://openairdocs.org/ntsb/ATL85FA283.md): Beech D18S · Huntington, WV · Accident · 1 fatal · Field investigation · Final report · Sep 25, 1985 · N25Q · Destroyed
  > The acft contacted the terrain with the left wing tip, cartwheeled and came to rest inverted during an ILS rwy 12 apch at Huntington (hts). Minimum apch visibility for the ILS is 3/4 of a mile. While en route the plt was informed the hts visibility was 1/8 of…
- [NTSB ATL85LA277](https://openairdocs.org/ntsb/ATL85LA277.md): Piper PA-22-125 · Shinnston, WV · Accident · No injuries · Limited investigation · Final report · Sep 15, 1985 · N909A · Substantial damage
  > The plt reported that he initiated a normal apch to land on rwy 27. However, when he flared, he failed to stop the descent. Subsequently, the acft landed hard just short of the rwy. During the landing, the nose gear collapsed & the acft nosed over.
- [NTSB ATL85FA118](https://openairdocs.org/ntsb/ATL85FA118.md): Cessna 177RG · Charleston, WV · Accident · 2 fatal · Field investigation · Final report · Mar 11, 1985 · N1625H · Destroyed
  > The plt filed an IFR flt plan before obtaining the en route wx. He then revised the flt plan by extending the planned flt from Washington, DC, (dulles) to Charleston, WV. The plt did not obtain wx info pertinent to revised flt plan. The plt was unfamiliar…
- [NTSB BFO85LA021](https://openairdocs.org/ntsb/BFO85LA021.md): Cessna 150 · Martinsburg, WV · Accident · Minor injuries · Limited investigation · Final report · Mar 3, 1985 · N6562F · Substantial damage
  > The plt took off on rwy 35 & departed the arpt without contacting the tower. Aprx 30 min later, he returned & made svrl missed apchs, still without contacting the tower. Tower psnl tried to communicate with the plt & used light signals while directing other…
- [NTSB ATL85LA002](https://openairdocs.org/ntsb/ATL85LA002.md): Cessna 150L · So.Charleston, WV · Accident · No injuries · Limited investigation · Final report · Oct 3, 1984 · N10931 · Substantial damage
  > Shortly after takeoff while on the base leg at 900 ft AGL, the engine quit. Plt stated attempts to restart the engine failed. During the forced landing apch the acft collided with trees and a high tension wire. The acft spun around 180 deg and came to rest on…
- [NTSB ATL84LA263](https://openairdocs.org/ntsb/ATL84LA263.md): Rotorway Scorpion 133 · West Hamlin, WV · Accident · 1 fatal · Limited investigation · Final report · Aug 20, 1984 · N4230S · Destroyed
  > Acft was observed proceeding over open field used as air strip in level flt, aprx 130 ft AGL, at 50 KTS. At end of field acft began left turn, nose dropped to steep descent attitude which continued to ground impact. Post-mortem showed triple-bypass surgery…
- [NTSB ATL84FIJ02](https://openairdocs.org/ntsb/ATL84FIJ02.md): Taylorcraft F-19 · Middlebourne, WV · Accident · Serious injuries · Final report · May 27, 1984 · N2001K · Substantial damage
  > After returning to the arpt, the plt made an apch to rwy 10, which had a drop-off on the apch end. The winds were reported as variable & occasionally gusty. On the 1st apch, the acft encounter 'slight air turbulence' & the plt elected to go around. He stated…
- [NTSB ATL83LA006](https://openairdocs.org/ntsb/ATL83LA006.md): Cessna 150G · Glenville, WV · Accident · No injuries · Limited investigation · Final report · Oct 1, 1983 · N2857S · Substantial damage
  > Ground fog started developing as the flt approached its destination. During the vor-b approach to rwy 16 the plt spotted the rwy lights about a mile out & set up on left base to the rwy. The plt turned final but drifted left of base. The plt stated that due…

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?state=WV&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" = 'WV' 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=WV

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