# NTSB investigations: Cessna 170A, 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 LAX98LA011](https://openairdocs.org/ntsb/LAX98LA011.md): Cessna 170A · Quincy, CA · Accident · No injuries · Limited investigation · Final report · Oct 12, 1997 · N9212A · Substantial damage
  > loss of directional control due to a severe tail wheel vibration, which was induced by an improperly installed and adjusted tail wheel assembly.
- [NTSB FTW97LA372](https://openairdocs.org/ntsb/FTW97LA372.md): Cessna 170A · Oklahoma City, OK · Accident · No injuries · Limited investigation · Final report · Sep 30, 1997 · N10433 · Substantial damage
  > The pilot's inadequate compensation for the crosswind conditions resulting in an inadvertent groundloop. Factors were the crosswind, the pilot's lack of total experience in make and model, the separation of the left main wheel due to corroded bolts, and the…
- [NTSB SEA97LA200](https://openairdocs.org/ntsb/SEA97LA200.md): Cessna 170A · Elk City, ID · Accident · Serious injuries · Limited investigation · Final report · Aug 31, 1997 · N1487D · Destroyed
  > A horse and children wandered onto the airstrip.
- [NTSB ANC97LA130](https://openairdocs.org/ntsb/ANC97LA130.md): Cessna 170A · Iliamna, AK · Accident · No injuries · Limited investigation · Final report · Aug 24, 1997 · N9540A · Substantial damage
  > the pilot's inadequate compensation for wind conditions, and his failure to maintain directional control of the airplane, which resulted in a ground swerve and overload failure of the right main landing gear. Factors related to the accident were: the…
- [NTSB ANC97LA032](https://openairdocs.org/ntsb/ANC97LA032.md): Cessna 170A · Willow, AK · Accident · No injuries · Limited investigation · Final report · Mar 8, 1997 · N1364D · Substantial damage
  > The pilot's excessive speed while taxiing. A factor in the accident was flat light conditions.

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

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