# NTSB investigations: Cessna 177, IA

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 MKC88LA073](https://openairdocs.org/ntsb/MKC88LA073.md): Cessna 177 · Cedar Rapids, IA · Accident · Minor injuries · Limited investigation · Final report · Apr 2, 1988 · N29325 · Substantial damage
  > During a night cross country trip, PIC experienced a total power loss. An emergency ldg was attempted and the accident aircraft collided with the terrain. Post accident inspection revealed no mechanical or fuel starvation problems. The pilot reported that the…
- [NTSB MKC78FCD20](https://openairdocs.org/ntsb/MKC78FCD20.md): Cessna 177 · Des Moines, IA · Accident · No injuries · Closed · May 10, 1978 · N3158T · Substantial damage
- [NTSB MKC72FCD03](https://openairdocs.org/ntsb/MKC72FCD03.md): Cessna 177 · Independence, IA · Accident · No injuries · Closed · Jul 11, 1971 · N29462 · Substantial damage
- [NTSB MKC70DCD36](https://openairdocs.org/ntsb/MKC70DCD36.md): Cessna 177 · Nevada, IA · Accident · No injuries · Closed · May 30, 1970 · N29513 · Substantial damage
- [NTSB MKC70DCD01](https://openairdocs.org/ntsb/MKC70DCD01.md): Cessna 177 · Osage, IA · Accident · No injuries · Closed · Jan 10, 1970 · N3358T · Substantial damage
- [NTSB MKC70D0215](https://openairdocs.org/ntsb/MKC70D0215.md): Cessna 177 · Des Moines, IA · Accident · No injuries · Closed · Sep 17, 1969 · N3499T · Substantial damage
- [NTSB MKC70F0216](https://openairdocs.org/ntsb/MKC70F0216.md): Cessna 177 · Polk City, IA · Accident · No injuries · Closed · Sep 13, 1969 · N29490 · Substantial damage
- [NTSB MKC70D0157](https://openairdocs.org/ntsb/MKC70D0157.md): Cessna 177 · Marshallton, IA · Accident · No injuries · Closed · Aug 25, 1969 · N2295Y · Substantial damage
- [NTSB MKC69D0445](https://openairdocs.org/ntsb/MKC69D0445.md): Cessna 177 · Clermont, IA · Accident · Minor injuries · Closed · May 12, 1969 · N2923X · Substantial damage
- [NTSB MKC69F0429](https://openairdocs.org/ntsb/MKC69F0429.md): Cessna 177 · Jefferson, IA · Accident · No injuries · Closed · Apr 27, 1969 · N2605Q · Substantial damage
- [NTSB MKC69D0170](https://openairdocs.org/ntsb/MKC69D0170.md): Cessna 177 · Eagle Grove, IA · Accident · No injuries · Closed · Sep 4, 1968 · N3483T · Substantial damage
- [NTSB MKC69D0195](https://openairdocs.org/ntsb/MKC69D0195.md): Cessna 177 · Waukon, IA · Accident · No injuries · Closed · Aug 31, 1968 · N2260Y · Substantial damage
- [NTSB MKC68D0486](https://openairdocs.org/ntsb/MKC68D0486.md): Cessna 177 · Mt Ayr, IA · Accident · No injuries · Closed · Mar 16, 1968 · N2605Q · Substantial damage
- [NTSB CHI68D0623](https://openairdocs.org/ntsb/CHI68D0623.md): Cessna 177 · Dodgeville, IA · Accident · No injuries · Closed · Feb 23, 1968 · N2363Y · Substantial damage

## 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."eventStateOrRegion" = 'IA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073704'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2073704&state=IA

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