# NTSB investigations: Cessna 170: Airframe/component/system failure/malfunction

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 SEA04LA050](https://openairdocs.org/ntsb/SEA04LA050.md): Cessna 170 · Herron, WA · Accident · 2 fatal · Limited investigation · Final report · Mar 1, 2004 · N2534V · Destroyed
  > The failure of the left muffler while maneuvering, resulting in a carbon monoxide leak into the cabin rendering the pilot incapacitated, and the subsequent uncontrolled descent and impact with water.
- [NTSB LAX04LA020](https://openairdocs.org/ntsb/LAX04LA020.md): Cessna 170 · San Diego, CA · Accident · No injuries · Limited investigation · Final report · Oct 20, 2003 · N3979V · Substantial damage
  > the pilot's inadequate preflight inspection which failed to determine the security of his seat, and his failure to maintain directional control.
- [NTSB FTW90LA056](https://openairdocs.org/ntsb/FTW90LA056.md): Cessna 170 · Crockett, TX · Accident · No injuries · Limited investigation · Final report · Jan 13, 1990 · N6303D · Substantial damage
  > The failure of the main landing gear axle due to fatigue which led to a loss of control after touchdown.
- [NTSB NYC87DHD02](https://openairdocs.org/ntsb/NYC87DHD02.md): Cessna 170 · Pittman, NJ · Accident · Serious injuries · Final report · Jan 7, 1987 · N2528V · Destroyed
  > The pilot stated that approx 15 mins after takeoff, while in a left turn, both he and his pax heard a loud snap. This was followed by collapse of the left rudder pedal and a right rolling motion. The aircraft began to spiral; just prior to impact the spiral…
- [NTSB CHI86LA055](https://openairdocs.org/ntsb/CHI86LA055.md): Cessna 170A · Grygla, MN · Accident · No injuries · Limited investigation · Final report · Dec 31, 1985 · N3828V · Substantial damage
  > The aircraft had been fitted with owner installd skis. During landing the left ski separates from its mount allowing the left ski mount to dig into the snow covered runway. The right wingtip struck a snowbank and the aircraft came to rest on its nose. The…

## 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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072302')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072302&occurrence=130

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