# NTSB investigations: Piper PA-32R-300, 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 LAX98LA027](https://openairdocs.org/ntsb/LAX98LA027.md): Piper PA-32R-300 · Santa Rosa, CA · Accident · No injuries · Limited investigation · Final report · Oct 31, 1997 · N1655H · Substantial damage
  > Loss of engine power for undetermined reasons.
- [NTSB CHI97LA294](https://openairdocs.org/ntsb/CHI97LA294.md): Piper PA-32R-300 · Fargo, ND · Accident · No injuries · Limited investigation · Final report · Sep 17, 1997 · N2680Q · Substantial damage
  > the pilot's misjudgment of altitude and distance to the runway, while on final approach to land, and failure to attain the proper touchdown point on the runway during the landing. The exposed runway lip was a related factor.
- [NTSB IAD97LA092](https://openairdocs.org/ntsb/IAD97LA092.md): Piper PA-32R-300 · Defiance, OH · Accident · No injuries · Limited investigation · Final report · Jun 21, 1997 · N5716F · Substantial damage
  > The failure of a wheel rim due to overstress separation with no clear evidence initiating event.
- [NTSB LAX97LA181](https://openairdocs.org/ntsb/LAX97LA181.md): Piper PA-32R-300 · Burbank, CA · Accident · No injuries · Limited investigation · Final report · May 12, 1997 · N3609Q · Substantial damage
  > improperly secured upper cowl fasteners by unknown person(s).
- [NTSB MIA97LA145](https://openairdocs.org/ntsb/MIA97LA145.md): Piper PA-32R-300 · Augusta, GA · Accident · No injuries · Limited investigation · Final report · Apr 23, 1997 · N1321H · Substantial damage
  > flight by the pilot into known adverse weather conditions, which resulted in a loss of aircraft control during the landing flare, and collision with the terrain. The adverse weather with nearby thunderstorm activity, crosswind, and gusts was a related factor.
- [NTSB NYC97LA073](https://openairdocs.org/ntsb/NYC97LA073.md): Piper PA-32R-300 · Lumberton, NJ · Accident · No injuries · Limited investigation · Final report · Apr 14, 1997 · N29M · Substantial damage
  > The pilot's delay in initiating remedial action to arrest an excessive descent rate during a go-around. A crosswind condition was a contributing factor.
- [NTSB FTW97LA107](https://openairdocs.org/ntsb/FTW97LA107.md): Piper PA-32R-300 · Salida, CO · Accident · No injuries · Limited investigation · Final report · Feb 18, 1997 · N4477F · Substantial damage
  > The airplane's performance being exceeded due to the pilot's inadequate preflight planning. Factors were the uphill runway, high density altitude, and the pilot's lack of experience performing takeoffs from a high altitude airport.

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

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