# NTSB investigations, MN: Vortex turbulence encountered

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 CHI98LA003](https://openairdocs.org/ntsb/CHI98LA003.md): Beech E18S · Lake Elmo, MN · Accident · No injuries · Limited investigation · Final report · Oct 2, 1997 · N916TM · Substantial damage
  > the pilot's failure identify the unsafe condition (vortex turbulence) which existed due to departing airplane and his subsequent inability to control the airplane once encountering the turbulence.
- [NTSB CHI85LA281](https://openairdocs.org/ntsb/CHI85LA281.md): Cessna 152 · Rochester, MN · Accident · No injuries · Limited investigation · Final report · Jul 10, 1985 · N69037 · Substantial damage
  > The student pilot on first solo x-country was ld on the 7500 ft runway. Tower had cautioned on wake turbulance from departing DC-9. On flare sp said acft dropped in swerved left, cartwheeled and nosed down.
- [NTSB CHI82DA279](https://openairdocs.org/ntsb/CHI82DA279.md): Bell 47G-2 · Plainview, MN · Accident · No injuries · Final report · Jul 28, 1982 · N19JM · Substantial damage
  > While making cleanup swaths over an odd shaped portion of a corn field, the pilot made two turns of about 220 degrees each in close proximity to each other. The second turn was made downwind from two previous swaths that had just been completed. During a…

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 410)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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