# NTSB investigations: Piper PA-28-235, 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 NYC93LA042](https://openairdocs.org/ntsb/NYC93LA042.md): Piper PA-28-235 · Cheriton, VA · Accident · No injuries · Limited investigation · Final report · Dec 10, 1992 · N9102W · Substantial damage
  > The pilot's improperly planned approach, resulting in a touchdown too FAR down the runway, with excessive airspeed, and the subsequent encounter with soft terrain and nose over.
- [NTSB LAX92LA371](https://openairdocs.org/ntsb/LAX92LA371.md): Piper PA-28-235 · Casa Grande, AZ · Accident · No injuries · Limited investigation · Final report · Aug 29, 1992 · N8647W · Substantial damage
  > The pilots inadequate compensation for the existing wind conditions. The gusty nature of the cross wind condiitons encountered was a factor.
- [NTSB NYC92FA139](https://openairdocs.org/ntsb/NYC92FA139.md): Piper PA-28-235 · Honesdale, PA · Accident · 1 fatal · Field investigation · Final report · Aug 1, 1992 · N56692 · Destroyed
  > A loss of control in flight due to pilot incapacitation as a result of a heart attack.
- [NTSB LAX92LA144](https://openairdocs.org/ntsb/LAX92LA144.md): Piper PA28-235 · Havasu Lake, CA · Accident · No injuries · Limited investigation · Final report · Mar 20, 1992 · N8840W · Substantial damage
  > The dual student's failure to maintain directional control, the cfi's improper supervision of the flight, and the cfi's failure to perform the necessary remedial action. Contributing to this accident was the dual student's improper use of the brakes.

## 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 ('7102810'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7102810&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.