# NTSB investigations: Piper PA-28-235, 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 CHI98LA034](https://openairdocs.org/ntsb/CHI98LA034.md): Piper PA-28-235 · Ulysses, KS · Accident · Minor injuries · Limited investigation · Final report · Nov 12, 1997 · N9404W · Destroyed
  > the pilot's continued flight into adverse weather conditions, his failure to activate the pitot heat system, and his failure to maintain clearance from the terrain. Factors associated with this accident were: the pilot did not obtain a preflight weather…
- [NTSB CHI97FA308](https://openairdocs.org/ntsb/CHI97FA308.md): Piper PA-28-235 · St. Ignaces, MI · Accident · 2 fatal · Field investigation · Final report · Sep 14, 1997 · N9399W · Destroyed
  > The noninstrument-rated pilot's improper decision to depart in instrument meteorological conditions, which resulted in impact with terrain.
- [NTSB IAD97LA089](https://openairdocs.org/ntsb/IAD97LA089.md): Piper PA-28 · Morgantown, PA · Accident · No injuries · Limited investigation · Final report · Jun 14, 1997 · N9268W · Substantial damage
  > The pilot's improper decision to attempt a landing on and his failure to align with an unlighted runway at night. Factors were the lack of runway lighting and the night light condition.
- [NTSB CHI97LA097](https://openairdocs.org/ntsb/CHI97LA097.md): Piper PA-28-235 · Des Moines, IA · Accident · No injuries · Limited investigation · Final report · Apr 2, 1997 · N9004W · Substantial damage
  > oil contamination and starvation due to the inadequate maintenance inspection of the pilot/owner. Factors included the deterioration of the piston pin plug, the connecting rod failure, and the unsuitable terrain for landing.
- [NTSB CHI97LA076](https://openairdocs.org/ntsb/CHI97LA076.md): Piper PA-28-235 · West Chicago, IL · Accident · Minor injuries · Limited investigation · Final report · Mar 2, 1997 · N9420W · Substantial damage
  > fuel starvation due to the pilot's improper fuel tank selection.
- [NTSB MIA97FA063](https://openairdocs.org/ntsb/MIA97FA063.md): Piper PA-28-235 · Okeechobee, FL · Accident · 1 fatal · Field investigation · Final report · Jan 16, 1997 · N712DB · Destroyed
  > the noninstrument-rated pilot's decision to conduct a VFR flight into instrument meteorological flight conditions. The weather was a factor.

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

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