# NTSB investigations, 2022, MN: Loss of control in flight

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 CEN23LA004](https://openairdocs.org/ntsb/CEN23LA004.md): Taylorcraft F19 · Waconia, MN · Accident · Minor injuries · Class 4 · Limited · Final report · Oct 3, 2022 · N3560T · Substantial damage
  > The pilot's failure to maintain aircraft control during a touch-and-go landing.
- [NTSB ERA23FA001](https://openairdocs.org/ntsb/ERA23FA001.md): Cessna 172S · Hermantown, MN · Accident · 3 fatal · Class 3 · Field · Final report · Oct 2, 2022 · N262TA · Substantial damage
  > The pilot’s loss of airplane control due to spatial disorientation during initial climb in dark night and low instrument meteorological conditions, which resulted in a descent into terrain. Contributing to the accident was the pilot’s fatigue due to a long…
- [NTSB CEN22LA241](https://openairdocs.org/ntsb/CEN22LA241.md): American AA-1A · Granite Falls, MN · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 10, 2022 · N9207L · Substantial damage
  > The pilot’s failure to maintain airplane control while in the airport traffic pattern that resulted in an uncontrolled descent and impact with terrain.
- [NTSB CEN22LA212](https://openairdocs.org/ntsb/CEN22LA212.md): Aviat A-1C-180 · Madison, MN · Accident · No injuries · Class 4 · Limited · Final report · May 25, 2022 · N125WY · Substantial damage
  > The pilot’s failure to maintain aircraft control during landing that resulted in an impact with terrain.

## 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 year(c."eventDate") = 2022
  AND 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" = '240' 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/240/sequence?state=MN&year=2022

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