# NTSB investigations, MN: Loss of visual reference

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 CEN23LA311](https://openairdocs.org/ntsb/CEN23LA311.md): Air Tractor AT-802 · Benson, MN · Accident · No injuries · Class 4 · Limited · Final report · Jul 14, 2023 · N22FK · Substantial damage
  > The pilot’s failure to adequately survey a field for obstructions prior to a low-level aerial application pass, which resulted in an impact with a powerline. Contributing to the accident was the degraded visibility due to the smoke in the area.
- [NTSB GAA17CA215](https://openairdocs.org/ntsb/GAA17CA215.md): Cessna 182 · Blue Earth, MN · Accident · Minor injuries · Data collection · Final report · Apr 3, 2017 · N8889X · Substantial damage
  > The pilot's decision to continue the night, visual flight into instrument meteorological conditions, which resulted in controlled flight into terrain while on final approach. Contributing to the accident was the pilot's improper use of an electronic flight…
- [NTSB CEN17LA043](https://openairdocs.org/ntsb/CEN17LA043.md): Beech 200 · Moorhead, MN · Accident · Minor injuries · Limited investigation · Final report · Nov 23, 2016 · N80RT · Substantial damage
  > The pilot's failure to attain a positive climb rate during an attempted missed approach in night instrument meteorological conditions that were at/near approach minimums, which resulted in controlled flight into terrain.
- [NTSB CEN12CA065](https://openairdocs.org/ntsb/CEN12CA065.md): Cessna 182J · Alexandria, MN · Accident · No injuries · Data collection · Final report · Nov 12, 2011 · N3051F · Substantial damage
  > The pilot's failure to maintain directional control during the night 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '402' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/402/sequence?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.