# NTSB investigations: Piper PA-28R-201T, 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 CHI97LA183](https://openairdocs.org/ntsb/CHI97LA183.md): Piper PA-28R-201T · Lansing, IL · Accident · No injuries · Limited investigation · Final report · Jun 24, 1997 · N99BF · Substantial damage
  > the pilot's inadequate compensation for wind conditions, and his failure to maintain sufficient airspeed to flare during the landing. The crosswind was a related factor.
- [NTSB FTW97LA192](https://openairdocs.org/ntsb/FTW97LA192.md): Piper PA-28R-210T · Fort Collins, CO · Accident · No injuries · Limited investigation · Final report · May 15, 1997 · N43761 · Substantial damage
  > the pilot's failure to know and follow the emergency procedure for extending the landing gear after loss of electrical power. Factors relating to the accident were: an inoperative alternator, inadequate maintenance by the operator, a depleted battery, and…
- [NTSB FTW97LA125](https://openairdocs.org/ntsb/FTW97LA125.md): Piper PA-28R-201T · Hartsel, CO · Accident · No injuries · Limited investigation · Final report · Mar 16, 1997 · N38703 · Destroyed
  > The pilot's misjudging the proper touchdown point on the dirt road due to excessive airspeed and his failure to deploy flaps. Factors were the partial loss of engine lubricating oil due to the oil filler cap separating because some unknown person failed to…
- [NTSB SEA97FA043](https://openairdocs.org/ntsb/SEA97FA043.md): Piper PA-28R · Fort Smith, MT · Accident · 2 fatal · Field investigation · Final report · Jan 6, 1997 · N3347Q · Destroyed
  > The pilot's failure to maintain clearance from terrain. Factors include the pilot inadvertently becoming lost/disoriented, the dark night (minimum ambient light), and mountainous/hilly 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") = 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 ('7102813'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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