NTSB investigations: Piper PA-28R-200

7 cases on aircraft the registry lists as Piper PA-28R-200, where NTSB found Gear extension and retract sys. 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

20092026
NTSB investigations: Piper PA-28R-200 per year, 2009–2026: 7 cases
20091
20161
20181
20191
20241
20251
20261

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 ('7102811')
      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\", '01023230')))
  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 ERA26LA139Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · St. Augustine, FLThe pilot's failure to extend the landing gear before landing.Mar 5, 2026 · N44443 · Substantial damageNTSB CEN25LA120Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Lincoln, NEA failure of the flight crew to ensure that the landing gear was properly extended before landing.Mar 12, 2025 · N93TJ · Substantial damageNTSB CEN25LA061Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Crystal, MNThe malfunction of the landing gear system which resulted in a collapse of the main landing gear during the landing roll.Dec 12, 2024 · N4823F · Substantial damageNTSB GAA19CA206Accident · No injuriesData collectionFinal reportPiper PA28R · Hutchinson, KSThe pilot's failure to extend the landing gear before landing.Apr 15, 2019 · N55275 · Substantial damageNTSB GAA18CA418Accident · No injuriesData collectionFinal reportPiper PA28R · Houston, TXThe pilot receiving instruction's failure to extend the landing gear and the flight instructor's failure to ensure that the landing gear were extended during landing. Contributing to the accident was the pilot receiving instruction's and instructor's failure…Jul 10, 2018 · N7716C · Substantial damageNTSB GAA17CA109Accident · No injuriesData collectionFinal reportPiper PA28R · Kewanee, ILThe pilot’s failure to extend the landing gear during the approach to land.Dec 16, 2016 · N55484 · Substantial damageNTSB WPR09LA417Accident · No injuriesLimited investigationFinal reportPiper PA28R · Wendover, UTThe failure of the pilot to attain and maintain an airspeed sufficient for normal landing gear retraction during initial climb. Contributing to the accident was the pilot's failure to use the airplane's manual override landing gear system, misidentifying that…Aug 27, 2009 · N4837T · Substantial damage