# NTSB investigations: Cessna 180A, 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 CHI07CA253](https://openairdocs.org/ntsb/CHI07CA253.md): Cessna 180A · Duluth, MN · Accident · No injuries · Data collection · Final report · Aug 1, 2007 · N5016E · Substantial damage
  > The pilot's failure to maintain directional control, which resulted in impact with terrain during an attempted aborted landing. A factor in the accident was the geese impacted during the landing roll.
- [NTSB CHI99LA209](https://openairdocs.org/ntsb/CHI99LA209.md): Cessna 180A · White Bear Lake, MN · Accident · No injuries · Limited investigation · Final report · Jul 5, 1999 · N9780B · Substantial damage
  > the pilot's inability to get the airplane to climb for undetermined reason, and the pilot landing the floatplane on the lake with the wheels extended. Factors contributing to this accident were the pilot's failure to perform a before landing checklist,…
- [NTSB CHI87FA162](https://openairdocs.org/ntsb/CHI87FA162.md): Cessna 180 · New Brighton, MN · Accident · 5 fatal · Field investigation · Final report · Jul 12, 1987 · N5027E · Destroyed
  > Witnesses observed the floatplane start a climbing left turn shortly after becoming airborne from a water takeoff. The aircraft's right wing dropped and the aircraft dove into the water where it struck the surface right wing first, flipped inverted and sank.…
- [NTSB MKC75FER36](https://openairdocs.org/ntsb/MKC75FER36.md): Cessna 180A · Detroit Lakes, MN · Accident · Serious injuries · Closed · Jan 3, 1975 · N9733B · Destroyed
- [NTSB MKC69D0294](https://openairdocs.org/ntsb/MKC69D0294.md): Cessna 180A · Waverly, MN · Accident · No injuries · Closed · Oct 29, 1968 · N7819A · Substantial damage
- [NTSB MKC67F0017](https://openairdocs.org/ntsb/MKC67F0017.md): Cessna 180A · Mora, MN · Accident · No injuries · Closed · Jun 12, 1966 · N5395D · Substantial damage
- [NTSB UNK64X3751](https://openairdocs.org/ntsb/UNK64X3751.md): Cessna 180 · Circle Pines, MN · Accident · No injuries · Closed · Sep 3, 1964 · N5318D · 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 ('2072604'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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