# NTSB investigations: Piper PA-28R-201T, 1992

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 FTW92FA180](https://openairdocs.org/ntsb/FTW92FA180.md): Piper PA-28R-201T · Tool, TX · Accident · 1 fatal · Field investigation · Final report · Jul 17, 1992 · N6959C · Destroyed
  > The pilot exceeded the design stress limits of the airframe as a result of flight into known adverse weather conditions.
- [NTSB SEA92FA077](https://openairdocs.org/ntsb/SEA92FA077.md): Piper PA-28R-201T · Briggsdale, CO · Accident · 2 fatal · Field investigation · Final report · Apr 14, 1992 · N2742M · Destroyed
  > Proper altitude was not maintained. Factors include ostentatious display.
- [NTSB BFO92LA030](https://openairdocs.org/ntsb/BFO92LA030.md): Piper PA-28R-201T · Brewer, ME · Accident · Serious injuries · Limited investigation · Final report · Mar 5, 1992 · N3768M · Destroyed
  > The pilot's decision to land on an icy runway and then attempt to take off. Contributing to the accident was the pilot's decision to completely raise the flaps after the balked landing.
- [NTSB LAX92LA122](https://openairdocs.org/ntsb/LAX92LA122.md): Piper PA-28R-201T · Ludlow, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 22, 1992 · N9343C · Substantial damage
  > The failure of the repair station to adequately perform a top overhaul and comply with a service bulletin. Contributing to this accident was the failure of the connecting rod due to fatigue and unsuitable terrain.

## 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 year(c."eventDate") = 1992
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102813'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7102813&year=1992

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