# NTSB investigations: Cessna 177, MN

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 CHI97LA269](https://openairdocs.org/ntsb/CHI97LA269.md): Cessna 177 · Maple Lake, MN · Accident · No injuries · Limited investigation · Final report · Aug 24, 1997 · N29379 · Substantial damage
  > the pilot failure to maintain control of the airplane while landing and his improper recovery from the bounced landing. Factors associated with the accident were the night conditions and the pilot lack of recent experience with night operations.
- [NTSB CHI86LA040](https://openairdocs.org/ntsb/CHI86LA040.md): Cessna 177 · Crookston, MN · Accident · No injuries · Limited investigation · Final report · Dec 5, 1985 · N3386T · Substantial damage
  > While doing a 270 degree turn on base leg for runway realignment the pilot permitted the acft to fly into the ground.
- [NTSB MKC80FER04](https://openairdocs.org/ntsb/MKC80FER04.md): Cessna 177 · Wheaton, MN · Accident · No injuries · Closed · Oct 19, 1979 · N29486 · Substantial damage
- [NTSB MKC79FA040](https://openairdocs.org/ntsb/MKC79FA040.md): Cessna 177 · Le Sueur, MN · Accident · 1 fatal · Closed · Jul 13, 1979 · N3162T · Destroyed
- [NTSB MKC78FER35](https://openairdocs.org/ntsb/MKC78FER35.md): Cessna 177 · Lakeville, MN · Accident · Minor injuries · Closed · Mar 30, 1978 · N3404T · Substantial damage
- [NTSB MKC76FER83](https://openairdocs.org/ntsb/MKC76FER83.md): Cessna 177 · Minnetonka, MN · Accident · Minor injuries · Closed · Jul 27, 1976 · N3419T · Substantial damage
- [NTSB MKC70F0231](https://openairdocs.org/ntsb/MKC70F0231.md): Cessna 177 · Oklee, MN · Accident · No injuries · Closed · Aug 24, 1969 · N2233Y · Substantial damage
- [NTSB CHI70D0144](https://openairdocs.org/ntsb/CHI70D0144.md): Cessna 177 · Spooner, MN · Accident · Serious injuries · Closed · Aug 2, 1969 · N2311Y · Substantial damage
- [NTSB MKC69D0455](https://openairdocs.org/ntsb/MKC69D0455.md): Cessna 177 · Silver Lake, MN · Accident · No injuries · Closed · May 4, 1969 · N2218Y · Substantial damage
- [NTSB MKC69D0403](https://openairdocs.org/ntsb/MKC69D0403.md): Cessna 177A · Lake Elmo, MN · Accident · No injuries · Closed · Apr 7, 1969 · N30388 · Substantial damage
- [NTSB MKC69F0244](https://openairdocs.org/ntsb/MKC69F0244.md): Cessna 177 · Whte Bear Lk, MN · Accident · Minor injuries · Closed · Oct 12, 1968 · N2210Y · Substantial damage
- [NTSB MKC69F0066](https://openairdocs.org/ntsb/MKC69F0066-109083.md): Cessna 177 · Minneapolis, MN · Accident · No injuries · Closed · Aug 19, 1968 · N2233Y · Substantial damage
- [NTSB MKC69D0059](https://openairdocs.org/ntsb/MKC69D0059-109299.md): Cessna 177 · Eden Prairie, MN · Accident · No injuries · Closed · Jul 27, 1968 · N3419T · Substantial damage
- [NTSB MKC69D0048](https://openairdocs.org/ntsb/MKC69D0048-109404.md): Cessna 177 · Rushford, MN · Accident · No injuries · Closed · Jul 6, 1968 · N30040 · 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" = 'MN' 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=MN

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