# NTSB investigations: Piper PA-28RT-201, 1997

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 FTW98FA031](https://openairdocs.org/ntsb/FTW98FA031.md): Piper PA-28RT-201 · Hazen, AR · Accident · 2 fatal · Field investigation · Final report · Oct 25, 1997 · N8146R · Destroyed
  > The pilot's failure to maintain aircraft control. Factors were the pilot's lack of total experience in the make and model of aircraft, the pilot's lack of total night flight experience, and the dark night conditions,
- [NTSB LAX97FA272](https://openairdocs.org/ntsb/LAX97FA272.md): Piper PA-28RT-201 · Hesperia, CA · Accident · 3 fatal · Field investigation · Final report · Aug 5, 1997 · N8227Q · Destroyed
  > failure of the pilot to see-and-avoid high voltage power lines, while coping with a lack of engine power during a go-around in a high density altitude condition. Factors relating to the accident were: high density altitude that resulted in a normal reduction…
- [NTSB FTW97LA235](https://openairdocs.org/ntsb/FTW97LA235.md): Piper PA-28RT-201 · Whitewright, TX · Accident · No injuries · Limited investigation · Final report · Jun 25, 1997 · N8326S · Substantial damage
  > The pilot's selection of an unsuitable area for takeoff. A factor was the dirt bank (terrace).
- [NTSB LAX97LA163](https://openairdocs.org/ntsb/LAX97LA163.md): Piper PA-28R-201T · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Apr 18, 1997 · N2847F · Substantial damage
  > The partial blockage of the No. 2 cylinder injection line/nozzle by a transient contaminant, which induced an excessively lean mixture in that cylinder, and the subsequent overheating of the cylinder and intake valve. The engine power loss was due to the open…
- [NTSB SEA97LA052](https://openairdocs.org/ntsb/SEA97LA052.md): Piper PA-28RT-201 · Chehalis, WA · Accident · Serious injuries · Limited investigation · Final report · Jan 26, 1997 · N344LC · Destroyed
  > The failure of the first pilot to conduct an adequate preflight inspection, and his failure to properly manage the aircraft fuel supply. This led to fuel starvation and a subsequent loss of engine power. Factors contributing to the accident are the false…

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

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

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