Skip to content

NTSB investigations: Piper PA-28-235, PA

18 cases on aircraft the registry lists as Piper PA-28-235. 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" = 'PA' 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 ('7102810')) 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\" = 'PA' 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 ('7102810'))
  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" = 'PA' 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 ('7102810'))
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 ERA21LA049Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Lititz, PAThe pilot’s inadvertent attempt to takeoff on a taxiway, rather than a runway, which resulted in a collision with a fence during takeoff.Nov 20, 2020 · N9086W · Substantial damage NTSB NYC05FA105Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · Fairview, PAA partial loss of engine power for undetermined reasons, which resulted in a forced landing after takeoff and subsequent collision with a residence.Jun 25, 2005 · N235G · Destroyed NTSB NYC02LA155Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Coatesville, PAThe pilot's inaccurate in-flight planning and fuel consumption calculations, and his improper decision to not land and refuel which led to fuel exhaustion and subsequent loss of engine power.Aug 6, 2002 · N31SW · Substantial damage NTSB IAD02LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Coatesville, PACollision with a deer during the takeoff roll.Nov 16, 2001 · N9373W · Substantial damage NTSB IAD97LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Morgantown, PAThe pilot's improper decision to attempt a landing on and his failure to align with an unlighted runway at night. Factors were the lack of runway lighting and the night light condition.Jun 14, 1997 · N9268W · Substantial damage NTSB CHI96FA045Accident · 1 fatalField investigationFinal reportPiper PA-28 · Friedens, PAthe pilot's failure to follow instrument approach procedures, by not maintaining proper altitude and by descending below the minimum descent altitude. Factors relating to the accident were: the air traffic controller's failure to issue a proper clearance, the…Dec 3, 1995 · N8775W · Destroyed NTSB NYC92FA139Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Honesdale, PAA loss of control in flight due to pilot incapacitation as a result of a heart attack.Aug 1, 1992 · N56692 · Destroyed NTSB NYC90LA205Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Reading, PAA loss of engine power for unknown reasons and an off airport landing on unsuitable terrain.Aug 30, 1990 · N15590 · Substantial damage NTSB NYC87FA244Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Altoona, PAThe aircraft departed cleveland, oh at approx 0915 hours on an unauthorized flt to atlantic city, NJ. The plt was not authorized to operate the aircraft or conduct the flt due to his license having been revoked in 1977 for repeatedly violating FARS. Near…Sep 6, 1987 · N8692W · Destroyed NTSB NYC77DHD11Accident · No injuriesClosedPiper PA-32 · Blue Bell, PAFeb 20, 1977 · N8982W · Substantial damage NTSB NYC72DGM32Accident · No injuriesClosedPiper PA-28 · Greenville, PAFeb 5, 1972 · N9471W · Substantial damage NTSB NYC68A0080Accident · 2 fatalClosedPiper PA-28 · Stowe, PADec 17, 1967 · N8883W · Destroyed NTSB NYC67D0379Accident · No injuriesClosedPiper PA-28 · Clearfield, PANov 13, 1966 · N8546W · Substantial damage NTSB NYC66F0700Accident · No injuriesClosedPiper PA-28 · Williamsport, PAMay 13, 1966 · N9018W · Substantial damage NTSB NYC66F0459Accident · Minor injuriesClosedPiper PA-28 · Doylestown, PAFeb 5, 1966 · N8896W · Substantial damage NTSB NYC66D0479Accident · No injuriesClosedPiper PA-28 · Clearfield, PAFeb 5, 1966 · N8546W · Substantial damage NTSB UNK65X0587Accident · 1 fatalClosedPiper PA-28 · Center Valley, PANov 6, 1964 · N8892W · Substantial damage NTSB UNK64X3990Accident · No injuriesClosedPiper PA28 · Lewistown, PASep 14, 1964 · N8606W · Substantial damage