# NTSB investigations, HI: Aircraft maintenance 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 ANC20FA024](https://openairdocs.org/ntsb/ANC20FA024.md): Cessna 305 · Mokuleia, HI · Accident · 2 fatal · Class 3 · Field · Final report · Feb 22, 2020 · N65070 · Substantial damage
  > A separation of the left rudder cable due to inadequate maintenance, which resulted in an in-flight loss of control and impact with terrain.
- [NTSB WPR18LA221](https://openairdocs.org/ntsb/WPR18LA221.md): Hughes 369 · Honolulu, HI · Accident · No injuries · Class 2 · Limited · Final report · Aug 8, 2018 · N369MH · Substantial damage
  > The operator's improper installation of the tail rotor (TR) teeter bearings, which resulted in cascading in-flight failures of the TR components and attach hardware.
- [NTSB WPR16FA072](https://openairdocs.org/ntsb/WPR16FA072.md): Bell 206B · Honolulu, HI · Accident · 1 fatal · Field investigation · Final report · Feb 18, 2016 · N80918 · Substantial damage
  > The in-flight failure of the engine-to-transmission drive shaft due to improper maintenance, which resulted in low main rotor rpm and a subsequent hard landing to water.
- [NTSB WPR11LA081](https://openairdocs.org/ntsb/WPR11LA081.md): Apollo AS-III · Poipu, HI · Accident · No injuries · Limited investigation · Final report · Dec 22, 2010 · N157AP · Substantial damage
  > The pilot's lack of compliance with manufacturer's guidance for care and handling of the aircraft combined with incomplete preflight inspections, which resulted in an undetected material failure of the nose cone.
- [NTSB WPR09LA097](https://openairdocs.org/ntsb/WPR09LA097.md): Cessna 177B · Honolulu, HI · Accident · Minor injuries · Limited investigation · Final report · Jan 21, 2009 · N30740 · Substantial damage
  > An oil starvation induced catastrophic engine failure due to the fracture and separation of the propeller governor oil line, which was a result of inadequate inspection by maintenance personnel.

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

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