Skip to content

NTSB investigations, WV

11 cases where the first occurrence was “Hard landing”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19852026

Where

Latest cases

Query with SQL

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" = 200) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 200)
  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" = 200)
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 NYC04CA180Accident · No injuriesData collectionFinal reportCessna 182Q · Pence Springs, WVThe pilot's failure to maintain airspeed during final approach, which resulted in a hard landing and gear collapse.Jul 24, 2004 · N24VV · Substantial damage NTSB NYC02LA022Accident · No injuriesLimited investigationFinal reportMooney M20S · Buckhannon, WVThe CFI's improper flare, which resulted in a hard landing.Oct 31, 2001 · N1008R · Substantial damage NTSB IAD00LA007Accident · No injuriesLimited investigationFinal reportCessna 172XP · Phillipi, WVThe pilot's improper flare that resulted in a hard landing.Nov 21, 1999 · N758LR · Substantial damage NTSB NYC98LA028Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · Wheeling, WVthe failure of the pilot to maintain the minimum required airspeed while operating in icing conditions which resulted in ice accumulations and an inadvertent stall while on approach. Factors were the icing conditions and the pilot's lack of experience in the…Nov 14, 1997 · N80GP · Substantial damage NTSB IAD96LA054Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Taplin, WVthe pilot's improper level off and recovery from a bounced landing.Mar 27, 1996 · N61546 · Substantial damage NTSB BFO94LA061Accident · No injuriesLimited investigationFinal reportCessna 172N · Clarksburg, WVthe pilot's selection of a downwind runway, and his inadequate compensation for the wind conditions. A factor was the gusting tailwind.Apr 7, 1994 · N739HC · Substantial damage NTSB BFO91LA017Accident · No injuriesLimited investigationFinal reportRockwell 690C · Summerville, WVPilot's failure to maintain adequate aircraft control during the landing flare/touchdown. The turbulent weather was a related factor.Dec 4, 1990 · N840MD · Substantial damage NTSB BFO88LA064Accident · No injuriesLimited investigationFinal reportHughes 369D · Clarksburg, WVThe student and instructor practiced several maneuvers. At the time of the accident they were doing straight-in landings. The student did one landing after a demo by the instructor. The student was doing his second landing which the instructor described as…Jul 5, 1988 · N32CT · Substantial damage NTSB BFO87FA026Accident · 4 fatalField investigationFinal reportCessna 210M · Charleston, WVThe aircraft bounced after landing touchdown. Witnesses observed the aircraft assume a nose high attitude and heard some power applied to the engine as the aircraft veered to the right. It was not determined whether the pilot was attempting to abort the…Mar 5, 1987 · N1230M · Destroyed NTSB ATL85LA262Accident · No injuriesLimited investigationFinal reportCessna 404 · Huntington, WVSeveral men who were in a building at the airport reported that they could hear the aircraft on the approach and then a loud noise. They could not see the runway or the aircraft due to the fog. They got in the fire and rescue vehicles and had a hard time…Aug 28, 1985 · N255CS · Substantial damage NTSB ATL85IA153Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · White Sulphur, WVDuring VFR ldg apch, pilot noted a vehicle on the left edge of the rwy. The apch was contd and as the ldg flare was started, the pilot and one of his passengers stated that the vehicle started across the rwy in front of them. The pilot pulled the yoke back to…May 4, 1985 · N2618M · Minor damage