# NTSB investigations, MI: VFR encounter with IMC

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 ERA22FA314](https://openairdocs.org/ntsb/ERA22FA314.md): Cessna 210C · Shelby, MI · Accident · 2 fatal · Class 3 · Field · Final report · Jul 15, 2022 · N3659Y · Destroyed
  > The non-instrument rated pilot’s decision to commence the flight in instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control. Contributing to the accident was the pilot’s self-induced pressure to…
- [NTSB CEN19FA247](https://openairdocs.org/ntsb/CEN19FA247.md): Piper PA28 · Ontonagon, MI · Accident · 1 fatal · Class 3 · Field · Final report · Aug 3, 2019 · N5167L · Destroyed
  > The non-instrument-rated pilot’s decision to continue visual flight into instrument meteorological conditions with thunderstorm activity, which resulted in spatial disorientation and a loss of airplane control.
- [NTSB CEN14FA102](https://openairdocs.org/ntsb/CEN14FA102.md): Mooney M20R · Boyne City, MI · Accident · 2 fatal · Field investigation · Final report · Jan 6, 2014 · N1046L · Substantial damage
  > The pilot’s failure to maintain control of the airplane as he attempted to return to the airport after encountering dark night conditions and heavy snow showers.
- [NTSB CEN10FA101](https://openairdocs.org/ntsb/CEN10FA101.md): Cessna 172 · Holland, MI · Accident · 2 fatal · Field investigation · Final report · Jan 17, 2010 · N8405E · Destroyed
  > The pilot's decision to take off in known instrument meteorological conditions without instrument currency or recent instrument experience, which led to spatial disorientation resulting in an inadvertent spin. Contributing to the accident was the pilot's lack…

## 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" = 'MI' 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" = '401' 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/401/sequence?state=MI

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