NTSB investigations: Piper PA-28-140

10 cases on aircraft the registry lists as Piper PA-28-140, where NTSB found Landing flare. 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

20082026
NTSB investigations: Piper PA-28-140 per year, 2008–2026: 10 cases
20081
20091
20161
20181
20191
20201
20211
20221
20241
20251

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.\"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_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f.\"findingCode\", '01062041')))
  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 CEN25LA284Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · New Hudson, MIThe student pilot’s improper landing flare and the flight instructor’s delayed remedial action during landing that resulted in a loss of control and impact with terrain.Jul 23, 2025 · N1812J · Substantial damageNTSB 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 damageNTSB ERA22LA285Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Manassas, VAThe pilot’s improper landing flare, which resulted in a bounced landing and subsequent nose landing gear collapse.Jun 22, 2022 · N6599W · Substantial damageNTSB ERA21LA285Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Greensboro, NCThe student pilot’s improper flare which resulted in abnormal ground contact and loss of control.Jul 7, 2021 · N91W · Substantial damageNTSB WPR20LA332Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Oregon City, ORThe pilot’s improper landing flare which resulted in a bounced landing, loss of directional control and subsequent collision with a hangar.Sep 30, 2020 · N5397S · Substantial damageNTSB GAA19CA430Accident · No injuriesData collectionFinal reportPiper PA28 · Wasilla, AKThe pilot's improper landing flare, which resulted in an aerodynamic stall and subsequent hard landing, runway excursion, and collision with a sign.Jul 10, 2019 · N4245J · Substantial damageNTSB GAA19CA040Accident · No injuriesData collectionFinal reportPiper PA28 · Miami, FLThe student pilot's improper landing flare, which resulted in a hard landing.Oct 26, 2018 · N15888 · Substantial damageNTSB GAA17CA120Accident · No injuriesData collectionFinal reportPiper PA28 · St. Louis, MOThe student pilot's improper landing flare, which resulted in a bounced landing.Nov 27, 2016 · N56809 · Substantial damageNTSB ERA09CA287Accident · Serious injuriesData collectionFinal reportPiper PA-28-140 · Danville, PAThe student pilot's failure to maintain control during a landing.May 11, 2009 · N8403R · Minor damageNTSB NYC08CA316Accident · No injuriesData collectionFinal reportPiper PA28-140 · Carrabassett, METhe pilot's improper landing flare.Sep 20, 2008 · N2318T · Substantial damage