# NTSB investigations, IN: Maintenance/inspections

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 CEN25LA013](https://openairdocs.org/ntsb/CEN25LA013.md): Rotorway Exec · Plymouth, IN · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 11, 2024 · N314AC · Substantial damage
  > A loss of control due to the failed forward tail rotor belt as a result of the owner’s failure to follow the helicopter manufacturer’s tail rotor belt replacement recommendations.
- [NTSB CEN16LA300](https://openairdocs.org/ntsb/CEN16LA300.md): Wings AN Things Avid Flyer · Bluffton, IN · Accident · Serious injuries · Limited investigation · Final report · Aug 3, 2016 · N430WT · Substantial damage
  > The loss of roll control during climb for reasons that could not be determined because postaccident examination of the airframe revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation.
- [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.
- [NTSB CEN10CA147](https://openairdocs.org/ntsb/CEN10CA147.md): Piper PA-28-140 · Martinsville, IN · Accident · No injuries · Data collection · Final report · Mar 6, 2010 · N6852W · Substantial damage
  > The pilot's inadequate preflight planning and his exceedance of the airplane's takeoff capability.
- [NTSB CEN09LA396](https://openairdocs.org/ntsb/CEN09LA396.md): Champion 7GCAA · Shelbyville, IN · Accident · No injuries · Limited investigation · Final report · Jun 29, 2009 · N9085L · Substantial damage
  > The partial loss of engine power due to the failure of the mixture control cable. Contributing to the accident was the inadequate maintenance on the airplane and the pilot's decision to operate the airplane in a condition that was not airworthy.

## 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010105'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/010105/cases?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, except the copies of manufacturers’ service documents, which belong to their rights holders.
