NTSB investigations: Piper PA-28-140, PA

5 cases on aircraft the registry lists as Piper PA-28-140, where the first occurrence was “Loss of control - on ground/water”. 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.

Cases per year

19862026
NTSB investigations: Piper PA-28-140, PA per year, 1986–2026: 5 cases
19862
19881
20021
20071

Latest 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\" = '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 ('7102802')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
  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.

NTSB NYC07CA242Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Indiana, PAThe student pilot's failure to maintain directional control while landing.Sep 30, 2007 · N1839T · Substantial damageNTSB NYC02LA189Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Titusville, PAThe student pilot's failure to maintain directional control during the landing roll.Sep 8, 2002 · N6947W · Substantial damageNTSB NYC88LA163Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lehighton, PAThe student pilot, on his third solo, experienced a loss of directional control during a go-around and settled into low trees and brush on the south side of the runway. The pilot reported the winds as calm. He stated that the left main wheel went off the left…Jun 11, 1988 · N44699 · DestroyedNTSB NYC86LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Bally, PAThe pilot landed on ruwnay 34 in winds he estimated to be from 270 degrees at 10-15 knots. He stated that at touchdown, the left wing was caught by a gust and raised. The aircraft drifted right. The pilot stated there was sufficent runway to continue the…Jun 23, 1986 · N5592U · DestroyedNTSB NYC86FHA01Accident · No injuriesFinal reportPiper PA-28-140 · Doylestown, PAThe Piper PA-28-140 was landing on rwy 23. The winds were reported to be from 320' - 330' with a velocity of 20 KTS and gusts to 30 KTS. The student pilot lost control on landing and veared off the right side of runway. The aircraft received substantial…Mar 1, 1986 · N2270Q · Substantial damage