# NTSB investigations: Cessna 172F, 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 FTW98LA070](https://openairdocs.org/ntsb/FTW98LA070.md): Cessna 172F · Gonzales, LA · Accident · Serious injuries · Limited investigation · Final report · Dec 18, 1997 · N8426U · Substantial damage
  > The inadvertent stall resulting from the flight instructor's failure to maintain airspeed during his delayed recovery from the bounced landing. Factors were the student's failure to maintain the proper airspeed and the instructor's inadequate supervision…
- [NTSB FTW98LA036](https://openairdocs.org/ntsb/FTW98LA036.md): Cessna 172F · Hurley, NM · Accident · No injuries · Limited investigation · Final report · Oct 29, 1997 · N8714U · Substantial damage
  > the student pilot's failure to adequately compensate for the wind conditions. Factors included the gusty crosswind conditions and inadequate supervision of the student pilot's solo flight by his flight instructor.
- [NTSB ANC97LA061](https://openairdocs.org/ntsb/ANC97LA061.md): Cessna 172 · Ninilchik, AK · Accident · No injuries · Limited investigation · Final report · Apr 22, 1997 · N5407R · Substantial damage
  > failure of the pilot to maintain altitude/clearance from a closed runway, while making a low pass, which resulted in an inadvertent touchdown.
- [NTSB NYC97FA048](https://openairdocs.org/ntsb/NYC97FA048.md): Cessna 172F · Conrad, PA · Accident · 1 fatal · Field investigation · Final report · Jan 25, 1997 · N8835U · Destroyed
  > VFR flight by the pilot into instrument meteorological conditions (IMC), and spatial disorientation of the pilot, which led to loss of aircraft control, an uncontrolled descent, and subsequent collision with wooded terrain. Factors relating to the accident…

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

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