# NTSB investigations, WV: 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 2 · 95 cases ## Latest cases - [NTSB ERA21FA377](https://openairdocs.org/ntsb/ERA21FA377.md): Beech C23 · Lansing, WV · Accident · 3 fatal · Class 3 · Field · Final report · Sep 26, 2021 · N3342L · Substantial damage > The pilot’s exceedance of the airplane’s critical angle of attack while maneuvering to avoid trees and terrain after takeoff, which resulted in an aerodynamic stall and loss of control. Also causal was the pilot’s decision to operate the airplane outside of… - [NTSB CEN19LA172](https://openairdocs.org/ntsb/CEN19LA172.md): Karns SKY Ranger · Hedgesville, WV · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 14, 2019 · N106RK · Substantial damage > A partial loss of engine power during takeoff due to the formation of carburetor ice while on the ground, which resulted in an impact with terrain. - [NTSB ERA16LA184](https://openairdocs.org/ntsb/ERA16LA184.md): Globe GC 1B · Hedgesville, WV · Accident · Serious injuries · Limited investigation · Final report · May 14, 2016 · N78193 · Substantial damage > The pilot's failure to maintain airplane control when it encountered a wind gust during climbout. - [NTSB ERA15FA049](https://openairdocs.org/ntsb/ERA15FA049.md): Mooney M20C · Lewisburg, WV · Accident · Serious injuries · Field investigation · Final report · Nov 10, 2014 · N6581U · Substantial damage > The pilot's failure to maintain airspeed while maneuvering, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident were abnormal engine operation due to improper… - [NTSB ERA15LA028](https://openairdocs.org/ntsb/ERA15LA028.md): Piper PA-28-140 · Valley Point, WV · Accident · Serious injuries · Limited investigation · Final report · Oct 26, 2014 · N5601U · Substantial damage > Undetermined based on a lack of available information. - [NTSB ERA14LA294](https://openairdocs.org/ntsb/ERA14LA294.md): Cub Crafters CC18-180 · Pennsboro, WV · Accident · No injuries · Limited investigation · Final report · Jun 17, 2014 · N696RP · Substantial damage > A loss of engine power during initial climb for reasons that could not be determined because the postaccident engine examination did not reveal any anomalies that would have precluded normal operation. - [NTSB ERA13CA283](https://openairdocs.org/ntsb/ERA13CA283.md): Hughes TH-55A · Morgantown, WV · Accident · No injuries · Data collection · Final report · Jun 12, 2013 · N7057H · Substantial damage > The pilot’s inadequate planning which resulted in an encounter with settling with power and descent into terrain during takeoff. - [NTSB ERA13CA218](https://openairdocs.org/ntsb/ERA13CA218.md): Cessna 172P · Davis, WV · Accident · Serious injuries · Data collection · Final report · Apr 26, 2013 · N96178 · Substantial damage > The pilot’s improper glidepath as he approached the runway and his subsequent delayed decision to abort the landing. - [NTSB ERA12LA285](https://openairdocs.org/ntsb/ERA12LA285.md): Willoughby Pete A Streak Shadow · Salem, WV · Accident · Serious injuries · Limited investigation · Final report · Apr 15, 2012 · N2828W · Substantial damage > A total loss of engine power due to a piston seizure that resulted from a fuel system restriction and poorly secured fuel lines. Contributing to the accident were the pilot/builder’s failure to follow the engine manufacturer procedures and his use of… - [NTSB ERA12FA006](https://openairdocs.org/ntsb/ERA12FA006.md): Harry L. Weber Arion LI · Hedgesville, WV · Accident · 1 fatal · Field investigation · Final report · Oct 5, 2011 · N747HW · Substantial damage > An aerodynamic stall at low altitude due to the pilot’s acute cardiac event. - [NTSB ERA10LA475](https://openairdocs.org/ntsb/ERA10LA475.md): Cessna 150 · Fayetteville, WV · Accident · Serious injuries · Limited investigation · Final report · Sep 10, 2010 · N7922E · Substantial damage > A loss of engine power due to the failure of the left magneto system’s distributor gear as a result of the improper maintenance of the magnetos by maintenance personnel. - [NTSB NYC08FA012](https://openairdocs.org/ntsb/NYC08FA012.md): Aero Commander 560-F · Wiley Ford, WV · Accident · 4 fatal · Field investigation · Final report · Oct 14, 2007 · N6370U · Destroyed > A partial power loss in the right engine due to the failure of the number one exhaust valve, and the airplane's inability to maintain a climb on one engine for unknown reasons. Contributing to the accident were fog and rising terrain. [This report was… - [NTSB NYC06FA162](https://openairdocs.org/ntsb/NYC06FA162.md): Cessna 310D · Sutton, WV · Accident · 2 fatal · Field investigation · Final report · Jun 30, 2006 · N6867T · Destroyed > The pilot's failure to maintain sufficient airspeed during takeoff-initial climb to avoid a stall/mush. A factor associated with the accident was the inadvertent stall/mush. - [NTSB NYC04LA151](https://openairdocs.org/ntsb/NYC04LA151.md): Beech 35 · Morgantown, WV · Accident · Minor injuries · Limited investigation · Final report · Jul 1, 2004 · N5345E · Substantial damage > The pilot's improper fuel management, which resulted in fuel starvation and a subsequent loss of engine power. - [NTSB NYC04CA032](https://openairdocs.org/ntsb/NYC04CA032.md): Cessna 172N · Philippi, WV · Accident · Minor injuries · Data collection · Final report · Nov 9, 2003 · N738UL · Substantial damage > The pilot's improper decision to depart from a runway of insufficient length. Factors in the accident were the turf runway and tailwind condition. - [NTSB IAD03CA057](https://openairdocs.org/ntsb/IAD03CA057.md): Boeing A75N1(PT17) · Sutton, WV · Accident · Minor injuries · Data collection · Final report · Jun 13, 2003 · N55175 · Substantial damage > The pilot's failure to abort the takeoff in a timely manner. Factors included the high density altitude conditions, and the pilot's lack of familiarity with the airplane's high density altitude performance characteristics. - [NTSB NYC00FA226](https://openairdocs.org/ntsb/NYC00FA226.md): Cessna 172 · Davis, WV · Accident · 1 fatal · Field investigation · Final report · Aug 12, 2000 · N8874B · Substantial damage > The pilot-in-command's inadequate weather evaluation, which resulted in a takeoff with a tailwind, and a subsequent inadvertent stall. Factors were a high gross weight, a high density altitude, and a tailwind. - [NTSB NYC00LA099](https://openairdocs.org/ntsb/NYC00LA099.md): Cessna 172 · Sissonville, WV · Accident · No injuries · Limited investigation · Final report · Mar 26, 2000 · N7879T · Substantial damage > The pilot's failure to maintain runway alignment during takeoff. A factor in the accident was wind gusts. - [NTSB NYC99LA141](https://openairdocs.org/ntsb/NYC99LA141.md): Prendergast Seawind · Martinsburg, WV · Accident · No injuries · Limited investigation · Final report · Jun 14, 1999 · N8190J · Substantial damage > The air-intake's inner liner separating from its outer liner, which blocked airflow to the fuel servo, resulting in a loss of engine power. A factor in the accident was the owner/builder's inadequate inspection of the airplane. - [NTSB IAD98FA042](https://openairdocs.org/ntsb/IAD98FA042.md): Piper PA-30 · Mcmechen, WV · Accident · 1 fatal · Field investigation · Final report · Apr 5, 1998 · N7845Y · Destroyed > The pilot's inadequate pre-flight planning and preparation which resulted in fuel exhaustion during takeoff. - [NTSB IAD98LA026](https://openairdocs.org/ntsb/IAD98LA026.md): Mooney M20J · Davis, WV · Accident · Serious injuries · Limited investigation · Final report · Feb 8, 1998 · N4120H · Substantial damage > A loss of power due to blockage of the fuel screen and one of the four fuel injector nozzles. A contributing factor was snow covered terrain. - [NTSB CHI97IA075](https://openairdocs.org/ntsb/CHI97IA075.md): de Havilland DHC-8-102 · Charleston, WV · Incident · No injuries · Incident investigation · Final report · Jan 22, 1997 · N852MA · No damage > a fractured fusion weld in the piston of the roll spoiler servoactuator, which allowed the plug at the base of the piston to separate and jam the piston. A factor relating to the incident was: the inadequate design of the airplane's roll spoiler servoactuator… - [NTSB IAD96FA132](https://openairdocs.org/ntsb/IAD96FA132.md): Cessna 172P · Summersville, WV · Accident · 3 fatal · Field investigation · Final report · Aug 11, 1996 · N65632 · Destroyed > The pilot's improper flare, his delay in aborting a landing, and his failure to maintain adequate airspeed, which resulted in a bounced landing and a stall during climb out in an attempt to avoid collision with trees. - [NTSB IAD96LA099](https://openairdocs.org/ntsb/IAD96LA099.md): Aeronca L-3B · Morgantown, WV · Accident · No injuries · Limited investigation · Final report · Jun 16, 1996 · N46634 · Substantial damage > An inadequate maintenance/annual inspection and failure of the muffler which resulted in melted insulation on the magneto 'P' leads and subsequent loss of engine power. A related factor was the lack of suitable terrain for the forced landing. - [NTSB BFO94LA158](https://openairdocs.org/ntsb/BFO94LA158.md): Cessna 140 · Ravenswood, WV · Accident · Serious injuries · Limited investigation · Final report · Aug 30, 1994 · N2150N · Substantial damage > The poorly planned approach which resulted in unporting of fuel from the left fuel tank and loss of engine power due to fuel starvation. - [NTSB BFO94LA060](https://openairdocs.org/ntsb/BFO94LA060.md): Talago Thundergull JT2 · Clarksburg, WV · Accident · Serious injuries · Limited investigation · Final report · Apr 4, 1994 · N73ST · Substantial damage > The builder's inadequate maintenance adjustment which resulted in the aileron control assembly becoming disconnected. - [NTSB BFO93LA151](https://openairdocs.org/ntsb/BFO93LA151.md): Piper PA-34-200T · Williamson, WV · Accident · No injuries · Limited investigation · Final report · Sep 2, 1993 · N31858 · Destroyed > A fire in the cockpit area for undetermined reasons. - [NTSB BFO93LA088](https://openairdocs.org/ntsb/BFO93LA088.md): Cessna 150L · Fairmont, WV · Accident · No injuries · Limited investigation · Final report · May 15, 1993 · N16224 · Substantial damage > Failure of the pilots to properly clear the engine during the approach. - [NTSB BFO92LA149](https://openairdocs.org/ntsb/BFO92LA149.md): Cessna 150 · Glenville, WV · Accident · Serious injuries · Limited investigation · Final report · Sep 26, 1992 · N45657 · Destroyed > The pilot failed to follow the takeoff procedure which to led to a partial loss of power during takeoff. Contributing to the accident was the trees. - [NTSB BFO92LA111](https://openairdocs.org/ntsb/BFO92LA111.md): Cessna 172 · Charleston, WV · Accident · Minor injuries · Limited investigation · Final report · Jul 23, 1992 · N12921 · Destroyed > The pilot's failure to attain adequate airspeed to outclimb obstacles. - [NTSB BFO91LA052](https://openairdocs.org/ntsb/BFO91LA052.md): Piper PA-22-150 · Elkins, WV · Accident · No injuries · Limited investigation · Final report · Jun 1, 1991 · N6904B · Substantial damage > The loss of engine power for undetermined reasons. - [NTSB BFO90FA036](https://openairdocs.org/ntsb/BFO90FA036.md): Piper PA-28-140 · Ona, WV · Accident · 2 fatal · Field investigation · Final report · Apr 22, 1990 · N5886U · Destroyed > The improperly set stabilator trim and the improperly loaded aircraft. - [NTSB BFO89LA055](https://openairdocs.org/ntsb/BFO89LA055.md): Hughes 500D · Williamson, WV · Accident · Serious injuries · Limited investigation · Final report · Jul 7, 1989 · N51516 · Substantial damage > Pilot's failure to see and avoid the wire which crossed the end of the field in which he was taking off. - [NTSB BFO89LA051](https://openairdocs.org/ntsb/BFO89LA051.md): Cessna 140 · Bridgeport, WV · Accident · No injuries · Limited investigation · Final report · Jul 1, 1989 · N1975N · Substantial damage > The loss of engine power because of fuel starvation. Fuel starvation occurred because of unporting of fuel from the tank outlet when the aircraft was in a slip attitude shortly before the power loss. A contributing factor is inadequate information in the… - [NTSB BFO88LA058](https://openairdocs.org/ntsb/BFO88LA058.md): Sikorsky S-76A · Moundsville, WV · Accident · Minor injuries · Limited investigation · Final report · Jun 23, 1988 · N54C · Destroyed > The helicopter contacted power lines shortly after takeoff from a mine site. The nose gear of the helicopter contacted an uninsulated static wire. This wire was strung with one other static wire and two black insulated power lines. Both crew members stated… - [NTSB BFO88FA022](https://openairdocs.org/ntsb/BFO88FA022.md): Cessna 150M · So. Charleston, WV · Accident · 1 fatal · Field investigation · Final report · Feb 17, 1988 · N9399U · Destroyed > The stu plt said the engine began to alternate between partial and full power during the initial tkf climb. The acft was about 100 ft AGL and about 300 ft past the rwy end. According to the stu the inst took control of the acft, turned left, reversed course… - [NTSB BFO87LA060](https://openairdocs.org/ntsb/BFO87LA060.md): Fleet 16B · Spencer, WV · Accident · Minor injuries · Limited investigation · Final report · Jul 17, 1987 · N47058 · Substantial damage > Shortly after takeoff on runway 16, the engine began misfiring. The pilot turned back toward the airport to make a landing. He circled the airport and then attemped to land on runway 34. The pilot stated he was over the approach end ofrunway 34, turning left… - [NTSB ATL86LA188](https://openairdocs.org/ntsb/ATL86LA188.md): Piper J3C-65 · Welch, WV · Accident · Serious injuries · Limited investigation · Final report · Jul 7, 1986 · N70824 · Destroyed > Witnesses reported that the pilot had worked on the engine carburetor for some time as well as just before the accident takeoff. At about 200 feet after takeoff from rwy 27 the engine quit and the pilot made a left turn back to the rwy and tried to align the… - [NTSB ATL85FIJ01](https://openairdocs.org/ntsb/ATL85FIJ01.md): Starduster SA-100 · Point Pleasant, WV · Accident · Minor injuries · Final report · Sep 22, 1985 · N21GT · Substantial damage > The plt stated that she made a normal preflt. She reported that the float type fuel gage indicated that the main fuel tank, which had a capacity of 12 gal, was half full. While climbing thru about 500 ft AGL after takeoff, the eng sputtered & lost power. The… - [NTSB ATL85LA201](https://openairdocs.org/ntsb/ATL85LA201.md): Beech 76 · Morgantown, WV · Accident · Serious injuries · Limited investigation · Final report · Jun 30, 1985 · N6002P · Destroyed > The CFI & dual student were on a flt to fairmont, WV so the student could receive a multi-eng flt exam. The student stated that shortly after lift-off from rwy 18, the CFI closed the mixture control on the right eng 'to simulate an engine failure.' The acft… - [NTSB ATL85LA086](https://openairdocs.org/ntsb/ATL85LA086.md): Beech E18S · Huntington, WV · Accident · Serious injuries · Limited investigation · Final report · Feb 1, 1985 · N95HA · Substantial damage > 3-4 Inch snow accumulation on acft prior to flt. Plt said he swept snow off except an area he could not reach. Heavy snowfall, wet snow reported as acft was prepared for departure, drg runup, taxi and takeoff. Plt advised by tower that visibility was 1/8 mile… - [NTSB ATL84LA226](https://openairdocs.org/ntsb/ATL84LA226.md): Bell 204 UH 1B · Tams, WV · Accident · No injuries · Limited investigation · Final report · Jul 20, 1984 · N91307 · Destroyed > An over gross takeoff was attempted from a 500 ft long zone. Translational lift was not achieved and rotor RPM deteriorated. The helicopter collided with trees, crashed & burned. The plt stated that the wind may have shifted during his takeoff. - [NTSB ATL84LA221](https://openairdocs.org/ntsb/ATL84LA221.md): Cessna 172K · Fayetteville, WV · Accident · No injuries · Limited investigation · Final report · Jul 17, 1984 · N46547 · Substantial damage > The plt stated that the eng suddenly lost power as he was climbing thru about 150 ft AGL. He continued straight ahead & landed after the acft brushed the top of a small tree then hit another small tree. No reason for the loss of power was found. One of the… - [NTSB ATL84FA093](https://openairdocs.org/ntsb/ATL84FA093.md): Piper PA-32RT-300T · Bluefield, WV · Accident · 4 fatal · Field investigation · Final report · Feb 9, 1984 · N22457 · Destroyed > The non-instrument rated plt began his takeoff during the hours of darkness, but in VMC wx. He stated that during the takeoff roll at about 65 to 75 KTS just prior to rotation, the landing light extinguished. Plt stated that 2 to 3 seconds later, he rotated &… - [NTSB ATL84LA010](https://openairdocs.org/ntsb/ATL84LA010.md): Cessna C-150 · Parkersburg, WV · Accident · No injuries · Limited investigation · Final report · Oct 3, 1983 · N63666 · Substantial damage > The acft collided with a deer during climbout on a night training mission. The weather was VMC but the night was dark. The CFI said they were doing touch and go landings. After completing a landing and during climbout the acft struck a deer. The acft was… - [NTSB ATL84FA001](https://openairdocs.org/ntsb/ATL84FA001.md): Bell 47G-3B1 · Pliny, WV · Accident · 1 fatal · Field investigation · Final report · Oct 1, 1983 · N1334X · Destroyed > The helicopter was being used in the construction of elect transmission lines. A 150-FT longline cable had been utilizedon an earlier flight for lifting external loads. However, there was no reason for the longline to be attached on the accident flight as the… - [NTSB ATL83LA354](https://openairdocs.org/ntsb/ATL83LA354.md): Bell 47G · Charleston, WV · Accident · No injuries · Limited investigation · Final report · Sep 7, 1983 · N88754 · Substantial damage > The helicopter settled after takeoff and rolled over after touching down on sloping terrain. One of the two pilots aboard was being transported to receive a private rating in helicopters. He had been endorsed for solo in the Bell 47 and had flown the Bell 47… - [NTSB ATL82FIJ02](https://openairdocs.org/ntsb/ATL82FIJ02.md): Piper PA-12 · Dunbar, WV · Accident · 2 fatal · Final report · May 10, 1982 · N7583H · Substantial damage > The pilot took off eastbound toward multiple power lines that crossed the river. The aircraft climbed to about 100 feet and was turning left away from the wires when it nosed over and crashed into the river. The pilot did not have a seaplane rating but had… - [NTSB ATL82DA069](https://openairdocs.org/ntsb/ATL82DA069.md): Cessna 182P · Huntington, WV · Accident · Minor injuries · Final report · Mar 14, 1982 · N7154Q · Substantial damage > According to the pilot the engine failed after liftoff at about the 3500 foot point down the runway at approximately 300 feet AGL. The runway has 1000 feet of overrun and the aircraft came to rest near the runup area for runway 12. The aircraft had not been… - [NTSB ATL81FIJ09](https://openairdocs.org/ntsb/ATL81FIJ09.md): Baby Ace D · S.Charleston, WV · Accident · Serious injuries · Closed · Jun 11, 1981 · N6941 · Destroyed Next page: https://openairdocs.org/ntsb-phases/350/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 = 350) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/350/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.