# NTSB investigations: Cessna 177B, 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 CHI97FA283](https://openairdocs.org/ntsb/CHI97FA283.md): Cessna 177B · Crump, MI · Accident · 1 fatal · Field investigation · Final report · Sep 7, 1997 · N34142 · Destroyed
  > Continued flight by the non-instrument rated pilot into instrument meteorological conditions (IMC) and her failure to maintain control of the airplane, due to spatial disorientation. Related factors were the low ceiling, and the pilot's lack of instrument…
- [NTSB CHI97LA291](https://openairdocs.org/ntsb/CHI97LA291.md): Cessna 177B · Oxford, IA · Accident · No injuries · Limited investigation · Final report · Sep 6, 1997 · N34829 · Substantial damage
  > the instructor pilot's improper recovery from a bounced landing and his failure to maintain control of the airplane. Factors were the improper flare by the dual student and the instructor pilot's lack of familiarity with the airplane.
- [NTSB SEA97LA128](https://openairdocs.org/ntsb/SEA97LA128.md): Cessna 177B · Lake Powell, UT · Accident · Minor injuries · Limited investigation · Final report · Jun 4, 1997 · N34680 · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB SEA97LA078](https://openairdocs.org/ntsb/SEA97LA078.md): Cessna 177B · Everett, WA · Accident · No injuries · Limited investigation · Final report · Mar 23, 1997 · N35034 · Substantial damage
  > failure of the pilot to maintain directional control of the airplane after landing. Factors relating to the accident include: a blown (failed) nose tire, and soft terrain beside the runway.

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

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