Skip to content

NTSB investigations: Piper PA-28-140, WV

21 cases on aircraft the registry lists as Piper PA-28-140. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102802')) 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102802'))
  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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102802'))
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 ERA25LA025Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Fairmont, WVThe student pilot’s improper flare, which resulted in a bounced landing and subsequent loss of directional control.Oct 27, 2024 · N926MK · Substantial damage NTSB GAA16CA490Accident · No injuriesData collectionFinal reportPiper PA 28 · Parkersburg, WVThe 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…Sep 15, 2016 · N5673U · Substantial damage NTSB ERA15LA028Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Valley Point, WVUndetermined based on a lack of available information.Oct 26, 2014 · N5601U · Substantial damage NTSB MIA07CA096Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Fairmont, WVThe pilot's failure to maintain directional control during landing.May 10, 2007 · N38730 · Substantial damage NTSB BFO90LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · S. Charleston, WVPilot's failure to maintain directional control of the airplane. A related factor crosswind conditions.Jun 30, 1990 · N7454R · Substantial damage NTSB BFO90FA036Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Ona, WVThe improperly set stabilator trim and the improperly loaded aircraft.Apr 22, 1990 · N5886U · Destroyed 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…Jun 18, 1983 · N6575W · Substantial damage NTSB ATL80FIJ08Accident · Serious injuriesClosedPiper PA-28 · Huntington, WVAug 24, 1980 · N5723U · Substantial damage NTSB IAD77FA031Accident · 1 fatalClosedPiper PA-28 · Morgantown, WVMar 25, 1977 · N1500J · Destroyed NTSB IAD75FIJ08Accident · Serious injuriesClosedPiper PA-28 · Elkins, WVAug 31, 1974 · N56845 · Destroyed NTSB NYC74AM106Accident · 1 fatalClosedPiper PA-28 · Huntington, WVJun 8, 1974 · N7302F · Destroyed NTSB IAD74AI067Accident · 2 fatalClosedPiper PA-28 · Harper Ferry, WVJun 7, 1974 · N9979W · Destroyed NTSB IAD74DIJ09Accident · Minor injuriesClosedPiper PA-28 · Pineville, WVJan 24, 1974 · N7285J · Substantial damage NTSB IAD74AI001Accident · 2 fatalClosedPiper PA-28 · W.Slphr Spg, WVJul 1, 1973 · N1518J · Destroyed NTSB NYC73AN055Accident · 1 fatalClosedPiper PA-28 · Keyser, WVOct 28, 1972 · N917HP · Destroyed NTSB NYC72FGM42Accident · No injuriesClosedPiper PA-28 · New Cumbrlnd, WVApr 28, 1972 · N4522R · Substantial damage NTSB IAD72DIJ21Accident · No injuriesClosedPiper PA-28 · Amherstdale, WVJun 6, 1971 · N5906U · Substantial damage NTSB DIA68A0045Accident · 1 fatalClosedPiper PA-28 · Lizemores, WVMar 6, 1968 · N9835W · Destroyed NTSB DIA68D0006Accident · No injuriesClosedPiper PA-28 · Charleston, WVJun 11, 1967 · N6083W · Substantial damage NTSB NYC66F0297Accident · No injuriesClosedPiper PA-28 · Weirton, WVJul 26, 1965 · N6407W · Substantial damage NTSB UNK65X1180Accident · No injuriesClosedPiper PA28 · Morgantown, WVDec 29, 1964 · N6337W · Substantial damage