# NTSB investigations: Piper PA-28R-201: Landing gear collapse

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB CEN17LA150](https://openairdocs.org/ntsb/CEN17LA150.md): Piper PA 28R-201 · Pontiac, MI · Accident · No injuries · Limited investigation · Final report · Apr 9, 2017 · N36458 · Substantial damage
  > Maintenance personnel’s improper securing of an unused instrument lamp socket during recent maintenance, which resulted in an electrical short of the landing gear controls and stopped the landing gear while it was transitioning to the down position and led to…
- [NTSB CEN16LA374](https://openairdocs.org/ntsb/CEN16LA374.md): Piper PA-28R-201 · Bowling Green, OH · Accident · No injuries · Limited investigation · Final report · Sep 13, 2016 · N786BG · Substantial damage
  > The pilots’ failure to complete the Emergency Landing Gear Extension checklist and maintenance personnel’s failure to correctly repair spliced wires on the left main landing gear down limit switch, which prevented the pilots from knowing whether the gear was…
- [NTSB WPR14CA018](https://openairdocs.org/ntsb/WPR14CA018.md): Piper PA 28R-201 · Las Vegas, NV · Accident · No injuries · Data collection · Final report · Oct 16, 2013 · N3836M · Substantial damage
  > The collapse of a main landing gear for reasons that could not be determined due to no postaccident examination of the airframe.
- [NTSB WPR11CA314](https://openairdocs.org/ntsb/WPR11CA314.md): Piper PA-28R-201 · Spanish Fork, UT · Accident · No injuries · Data collection · Final report · Jul 4, 2011 · N47869 · Substantial damage
  > The pilot's improper landing flare, inadequate recovery from a bounced landing and failure to maintain directional control.
- [NTSB CEN11LA390](https://openairdocs.org/ntsb/CEN11LA390.md): Piper PA-28R-201 · Grand Forks, ND · Accident · No injuries · Limited investigation · Final report · May 14, 2011 · N204ND · Substantial damage
  > The flight instructor’s inadequate supervision of the landing, which resulted in an inadequate flare and subsequent hard landing.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102816', '7102833')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '094' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/094/sequence?model=7102816

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.