# NTSB investigations: Cessna 170A, 2001

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 FTW02LA024](https://openairdocs.org/ntsb/FTW02LA024.md): Cessna 170A · Giddings, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 27, 2001 · N4127G · 2 aircraft · Substantial damage
  > The failure of the Cessna pilot to maintain directional control while landing, which resulted in a collision with the Lake.
- [NTSB ANC01LA127](https://openairdocs.org/ntsb/ANC01LA127.md): Cessna 170A · Chickaloon, AK · Accident · Serious injuries · Limited investigation · Final report · Aug 29, 2001 · N9791A · Substantial damage
  > The pilot's delay in aborting the takeoff. Factors in the accident were the presence of trees at the end of the departure path, and the pilot's improper use of the carburetor heat control.
- [NTSB NYC01LA142](https://openairdocs.org/ntsb/NYC01LA142.md): Cessna 170A · South Charlesto, WV · Accident · Minor injuries · Limited investigation · Final report · Jun 11, 2001 · N9509A · Substantial damage
  > The pilot's failure to maintain directional control while landing.
- [NTSB SEA01LA035](https://openairdocs.org/ntsb/SEA01LA035.md): Cessna 170A · Eastsound, WA · Accident · Serious injuries · Limited investigation · Final report · Jan 6, 2001 · N1703D · Substantial damage
  > The pilot's failure to use carburetor heat prior to reducing engine power to idle while operating in serious carburetor icing conditions. Factors include serious carburetor icing conditions, and trees in the area where the pilot found it necessary to attempt…

## 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") = 2001
  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=2001

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