# NTSB investigations, MN: Snow/ice

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 CEN20CA101](https://openairdocs.org/ntsb/CEN20CA101.md): Cessna A185 · Hawley, MN · Accident · No injuries · Data collection · Final report · Feb 22, 2020 · N550FK · Substantial damage
  > The pilot's improper landing flare and touchdown, which resulted in a bounced landing and loss of directional control and the airplane's subsequent impact with a snowbank and ground loop during an attempted go-around.
- [NTSB CEN14CA154](https://openairdocs.org/ntsb/CEN14CA154.md): Cessna 185 · Eden Prairie, MN · Accident · No injuries · Data collection · Final report · Mar 9, 2014 · N4764B · Substantial damage
  > The pilot's loss of directional control during takeoff with a gusty crosswind.
- [NTSB CEN14CA156](https://openairdocs.org/ntsb/CEN14CA156.md): Olson Kenneth H T Zodiac 601 HDS · Garrison, MN · Accident · No injuries · Data collection · Final report · Mar 8, 2014 · N981HT · Substantial damage
  > The pilot's failure to maintain directional control during takeoff which resulted in the airplane striking a snow bank.
- [NTSB CEN14CA130](https://openairdocs.org/ntsb/CEN14CA130.md): Taylorcraft BC12 D · Worthington, MN · Accident · Minor injuries · Data collection · Final report · Feb 3, 2014 · N43462 · Substantial damage
  > The pilot's loss of control during a crosswind landing.

## 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03022060'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/03022060/cases?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, except the copies of manufacturers’ service documents, which belong to their rights holders.
