NTSB investigations, WV
18 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1983 | 2 |
|---|---|
| 1984 | 2 |
| 1985 | 1 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 2000 | 1 |
| 2001 | 3 |
| 2004 | 1 |
| 2006 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230)
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB NYC06CA173Accident · No injuriesData collectionFinal reportBell 47G-2 · Petersburg, WVThe passenger's inadvertent interference with the flight controls, which resulted in a loss of directional control and subsequent impact with the ground.NTSB NYC04FA139Accident · 2 fatalField investigationFinal reportBeech 200 · Rupert, WVThe pilot-in-command's improper decision to continue VFR flight into IMC conditions, which resulted in controlled flight into terrain. Factors were the FAA Principle Operations Inspector's inadequate surveillance of the operator, and a low ceiling.NTSB IAD01FA066Accident · 1 fatalField investigationFinal reportHughes 369A · Perry, WVThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain terrain clearance. A contributing factor was mountainous terrain.NTSB IAD01LA028Accident · No injuriesLimited investigationFinal reportPiper 34-200T · Bluefield, WVThe 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 NYC01FA064Accident · 1 fatalField investigationFinal reportCessna 310R · Bluefield, WVThe pilot's failure to execute the published missed approach procedure. A factor was heavy snowfall during the approach.NTSB NYC01LA050Accident · 1 fatalLimited investigationFinal reportMiller Slingshot · Kingwood, WVThe pilot's failure to maintain control of the airplane, and subsequent collision with trees.NTSB NYC94FA145Accident · 1 fatalField investigationFinal reportCessna 210N · Martinsburg, WVFailure 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 BFO94LA019Accident · Serious injuriesLimited investigationFinal reportMartin Streak Shadow · Mannington, WVThe pilot's failure to maintain clearance from the surrounding terrain.NTSB BFO93FA003Accident · 1 fatalField investigationFinal reportCessna 310R · Summersville, WVThe pilot's inadequate altitude (or clearance) from mountainous hilly terrain. Factors related to the accident were darkness, low clouds, and light snow.NTSB BFO92DOA01Accident · 1 fatalFinal reportPiper PA-28-181 · Belington, WVThe pilot's failure to maintain clearance above the terrain which resulted in inflight collision with the terrain. Contributing was mountainous terrain.NTSB BFO90FA076Accident · 1 fatalField investigationFinal reportPiper PA-601P · Wiley Ford, WVThe 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 BFO90FA050Accident · 4 fatalField investigationFinal reportRockwell 114 · Anawalt, WVFailure of the pilot to maintain proper altitude and clearance above the terrain. Factors related to the accident were: darkness, mountainous terrain, and low ceiling.NTSB BFO89LA045Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Moundsville, WVThe pilot failed to maintian directional control and obstacle clearance while hovering at low altitude. A tail rotor blade struck an obstacle causing an overload separation failure of the blade.NTSB ATL85FA283Accident · 1 fatalField investigationFinal reportBeech D18S · Huntington, WVThe 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 ATL84LA295Accident · Minor injuriesLimited investigationFinal reportBell 47G-5 · Bluefield, WVThe pilot stated that he hovered the helicopter, made a right pedal turn and initiated a hover taxi across a rocky ravine adjacent to the pad. When over the ravine the helicopter settled onto to boulders beneath it. The pilot also stated that he thought he…NTSB ATL84LA226Accident · No injuriesLimited investigationFinal reportBell 204 UH 1B · Tams, WVAn 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 ATL83FIG06Accident · Serious injuriesFinal reportCessna 150 · Petersburg, WVThe acft was unable to maintain altitude while crossing mountain ridges & stalled about 50 ft above a tree line. The pilots had been using automotive fuel during prefueling stopNTSB ATL83LA217Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Shinnston, WVThe instructor (CFI) was providing takeoff & landing instructions to his son, a student plt. After making a takeoff & landing, they took off again on rwy 22. At lift-off, the CFI noticed a Cessna 180 being taxied for takeoff. At aprx 300 ft AGL, they made a…