NTSB investigations, WV
14 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 1 |
| 1988 | 2 |
| 1990 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 2000 | 1 |
| 2002 | 3 |
| 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\" = 310)
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" = 310) 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 NYC06LA066Accident · 1 fatalLimited investigationFinal reportPiper PA-28-181 · Henderson, WVThe pilot's improper decision to attempt the off-airport takeoff; and his improper decision to continue the takeoff after striking a pole during the takeoff roll.NTSB NYC03LA007Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR-20 · Point Pleasant, WVAn inadvertent collision with wildlife. A factor in the accident was wildlife having access to the runway environment.NTSB NYC02LA146Accident · No injuriesLimited investigationFinal reportSaab-Scania 340A · Charleston, WVThe vehicle driver's failure to maintain clearance of the airplane.NTSB NYC02LA057Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Point Pleasant, WVAn inadvertent collision with a deer while landing at dusk. A factor in the accident was the dusk light condition.NTSB NYC01LA054Accident · Serious injuriesLimited investigationFinal reportEmbraer 120RT · Charleston, WVDeer on the runway. Factors included reduced visibility due to nighttime lighting and light snow conditions, breaches in the perimeter fence, increased seasonal deer activity, and the rural location of the airport.NTSB BFO93LA069Accident · No injuriesLimited investigationFinal reportBeech B100 · Clarksburg, WVThe pilot's failure to maintain adequate clearance from the hangar. Contributing to the accident was the dark night.NTSB NYC92LA182Accident · No injuriesLimited investigationFinal reportCessna 172H · New Cumberland, WVThe pilot's improper takeoff procedures and his lack of understanding of airplane performance which resulted in an aborted takeoff with insufficient runway to stop and the subsequent collision with a fence. Factors related to the accident were; the pilot's…NTSB BFO92LA029Accident · No injuriesLimited investigationFinal reportCessna 195 · Charleston, WVFailure of the pilot to maintain clearance from the taxiway sign.NTSB BFO91LA005Accident · No injuriesLimited investigationFinal reportCessna C152 · Bridgeport, WVThe pilot's inability to avoid a collision with deer which had moved onto the runway during their takeoff roll. The dark night contributed to the accident by limiting the pilots' visual outlook.NTSB BFO88LA040Accident · No injuriesLimited investigationFinal reportCessna 340 · Pineville, WVThe pilot failed to maintain clearance from obstacles while taxiing the aircraft.NTSB BFO88LA016Accident · No injuriesLimited investigationFinal reportDassault DA-20 · Wheeling, WVThe acft landed after an ILS apch to rwy 03. According to the plt shortly after touchdown he saw deer ahead on the rwy. Before he could take evasive action the acft struck two deer. Afterwards brake pressure was lost. The plt steered the acft onto grass off…NTSB BFO87LA010Accident · No injuriesLimited investigationFinal reportBeech BE-55 · Beckley, WVThe plt stated that before takeoff he did not see anything on the rwy. The landing and taxi lights on the acft were on for the takeoff. During the takeoff roll when the acft was almost at takeoff speed the plt heard a loud bang followedby the acft yawing to…NTSB ATL84LA265Accident · No injuriesLimited investigationFinal reportCessna 150D · Parkersburg, WVThe pilot was unable to see the deer on the rwy during the landing roll because of the dark night conditions.NTSB ATL83LIJ03Accident · No injuriesFinal reportPiper PA-28-140 · Bruceton Mills, WVThe acft collided with a fence during an attempted takeoff from a short sod private strip. The privately owned grass strip is approx. 800 feet long with a 5 deg upgrade from the midway point. The pilot said he realized he could not climbfast enough so he…