# NTSB investigations, MI: Preflight or dispatch event

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 CEN23LA363](https://openairdocs.org/ntsb/CEN23LA363.md): Beech C-99 · Lansing, MI · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 15, 2023 · N261SW · Substantial damage
  > The pilot’s failure to properly set the rudder trim position which resulted in a loss of directional control during takeoff. Contributing was the pilot’s inadequate checklist procedures prior to takeoff.
- [NTSB CEN14LA086](https://openairdocs.org/ntsb/CEN14LA086.md): Piper PA-22-108 · Oscoda, MI · Accident · No injuries · Limited investigation · Final report · Dec 11, 2013 · N5386Z · Substantial damage
  > The student pilot’s loss of control during landing in gusting wind conditions. Contributing to the accident was the pilot’s decision to land with gusting wind.
- [NTSB CEN10CA548](https://openairdocs.org/ntsb/CEN10CA548.md): Piper PA-17 · Edwardsburg, MI · Accident · No injuries · Data collection · Final report · Sep 19, 2010 · N4610H · Substantial damage
  > A total loss of engine power during takeoff due to fuel exhaustion as a result of the pilot’s improper fuel planning.
- [NTSB CEN09LA605](https://openairdocs.org/ntsb/CEN09LA605.md): Piper PA-32-260 · Troy, MI · Accident · Minor injuries · Limited investigation · Final report · Sep 25, 2009 · N4864S · Substantial damage
  > A loss of engine power during initial climb due to fuel starvation as a result of the pilot's selection of an empty or nearly empty main tank for takeoff.
- [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" = '030' 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/030/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.