# NTSB investigations, 2015, MI: Off-field or emergency landing

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 CEN15LA421](https://openairdocs.org/ntsb/CEN15LA421.md): Lerch RV6A · Deckerville, MI · Accident · Serious injuries · Limited investigation · Final report · Sep 22, 2015 · N215DG · Substantial damage
  > The in-flight loss of engine oil after the oil filter separated from the engine adapter assembly because of an incorrect modification of the oil filter adapter assembly, which resulted in a precautionary landing in a field.
- [NTSB CEN15LA332](https://openairdocs.org/ntsb/CEN15LA332.md): Alon A2 · Holland, MI · Accident · Minor injuries · Limited investigation · Final report · Jul 19, 2015 · N5607F · Substantial damage
  > A total loss of engine power due to fuel starvation during cruise flight. Contributing to the accident was the pilot’s inadequate preflight fuel planning.
- [NTSB CEN15LA346](https://openairdocs.org/ntsb/CEN15LA346.md): Ercoupe 415 · Saint Martin Island, MI · Accident · No injuries · Limited investigation · Final report · Jul 18, 2015 · CFGGS · Substantial damage
  > The failure of a connecting rod bearing, which resulted in a loss of engine power.
- [NTSB GAA15CA163](https://openairdocs.org/ntsb/GAA15CA163.md): Gates Learjet 35A · Grosse Ile, MI · Accident · No injuries · Data collection · Final report · Jun 22, 2015 · N640BA · Substantial damage
  > The airplane's collision with a deer on the unfenced runway during the takeoff roll. Contributing to the accident is the airport's failure to establish a continuous fence between the runway and the nature conservancy.

## 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") = 2015
  AND 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" = '440' 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/440/sequence?state=MI&year=2015

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