# NTSB investigations, MI: 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 CEN19LA051](https://openairdocs.org/ntsb/CEN19LA051.md): Piper PA 23 · Beaver Island, MI · Accident · 1 fatal · Limited investigation · Final report · Dec 31, 2018 · N2146P · Destroyed
  > The pilot's failure to maintain a positive rate of climb after takeoff which resulted in an impact with trees and terrain. Contributing to the accident was the pilot's inability to see a visible horizon due to the dark night lighting conditions and limited…
- [NTSB CEN18FA368](https://openairdocs.org/ntsb/CEN18FA368.md): Piper PA32RT · St Ignace, MI · Accident · 1 fatal · Field investigation · Final report · Sep 1, 2018 · N500MJ · Destroyed
  > The pilot's failure to maintain sufficient altitude after takeoff in dark night conditions which resulted in a collision with the water.
- [NTSB CEN14CA368](https://openairdocs.org/ntsb/CEN14CA368.md): Mckenzie Douglas E Stol CH750 · Dodgeville, MI · Accident · Minor injuries · Data collection · Final report · Jul 13, 2014 · N792MC · Substantial damage
  > The pilot's failure to maintain control of the airplane during takeoff resulting in an impact with a tree and terrain.
- [NTSB CEN13FA135](https://openairdocs.org/ntsb/CEN13FA135.md): Cessna 208B · Pellston, MI · Accident · 1 fatal · Field investigation · Final report · Jan 16, 2013 · N1120N · Destroyed
  > The pilot's inadvertent controlled descent into terrain due to spatial disorientation. Contributing to the accident was lack of visual reference due to night conditions.
- [NTSB CEN09CA269](https://openairdocs.org/ntsb/CEN09CA269.md): Let L-23 Super Blanik · Adrian, MI · Accident · No injuries · Data collection · Final report · Apr 26, 2009 · N238SB · Substantial damage
  > The flight instructor's inadequate compensation for the strong, gusting crosswind during landing. Contributing to the accident was the flight instructor's decision to attempt flight with known adverse weather approaching the airport.

## 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" = '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=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.