# NTSB investigations, IN: Roll over

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 CEN24LA038](https://openairdocs.org/ntsb/CEN24LA038.md): Bede BD-4 · Lowell, IN · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 14, 2023 · N931AS · Substantial damage
  > Fatigue cracking of the propeller blade root, which resulted in the in-flight separation of the propeller blade from its root. Contributing to the accident was the improper machining of the blade root threads, which resulted in chatter/ratchet marks that…
- [NTSB GAA19CA392](https://openairdocs.org/ntsb/GAA19CA392.md): North Wing Uum Scout · Westfield, IN · Accident · No injuries · Data collection · Final report · Jul 8, 2019 · N419TN · Substantial damage
  > The student pilot's improper landing flare, which resulted in a bounced landing and wing strike.
- [NTSB GAA18CA424](https://openairdocs.org/ntsb/GAA18CA424.md): Bell 206 · New Castle, IN · Accident · No injuries · Data collection · Final report · Jul 16, 2018 · N39LR · Substantial damage
  > The pilot's failure to ensure that the fill hose was disconnected from the helicopter before takeoff, which resulted in the fill hose striking the tail rotor and the subsequent loss of tail rotor effectiveness. Contributing to the accident was inadequate…
- [NTSB CEN17LA302](https://openairdocs.org/ntsb/CEN17LA302.md): James F Hake MTO Sport · Mentone, IN · Accident · Minor injuries · Limited investigation · Final report · Aug 3, 2017 · N571UJ · Substantial damage
  > The pilot’s failure to maintain a proper touchdown attitude, which resulted in a loss of directional control during the landing roll.
- [NTSB CEN15LA216](https://openairdocs.org/ntsb/CEN15LA216.md): Piper PA 28-235 · Huntington, IN · Accident · Minor injuries · Limited investigation · Final report · May 4, 2015 · N8703W · Substantial damage
  > The pilot’s inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB CEN14LA307](https://openairdocs.org/ntsb/CEN14LA307.md): Rotorway Exec 162F · Mt. Comfort, IN · Accident · No injuries · Limited investigation · Final report · Jun 21, 2014 · N6828D · Substantial damage
  > The pilot’s installation of an unauthorized main rotor belt and his subsequent failure to properly inspect the belt, which resulted in inadequate belt tension, the belt’s failure, and the subsequent loss of engine power.

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

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