# NTSB investigations: Piper PA-28RT-201T: 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 ERA20CA103](https://openairdocs.org/ntsb/ERA20CA103.md): Piper PA28RT · Fort Myers, FL · Accident · No injuries · Data collection · Final report · Feb 2, 2020 · N8320H · Substantial damage
  > The fracture of the right main landing gear torque link bolt on landing, which resulted in the landing gear assembly rotating freely, the subsequent loss of directional control, and the landing gear collapsing.
- [NTSB CEN14LA474](https://openairdocs.org/ntsb/CEN14LA474.md): Piper PA 28RT-201T · Houston, TX · Accident · No injuries · Limited investigation · Final report · Jul 27, 2014 · N2148J · Substantial damage
  > The landing gear’s failure to extend for reasons that could not be determined based on the available evidence.
- [NTSB CEN11CA103](https://openairdocs.org/ntsb/CEN11CA103.md): Piper PA-28RT-201T · Spring, TX · Accident · No injuries · Data collection · Final report · Nov 18, 2010 · N8320H · Substantial damage
  > The failure of the right landing gear down-lock mechanism to fully engage. Contributing to the accident was the pilot’s inability to verify the landing gear extension due to the inoperative alternator.

## 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 ('7102817')
    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=7102817

---
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.