# NTSB investigations, HI: Simulated/training 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 WPR23LA043](https://openairdocs.org/ntsb/WPR23LA043.md): Robinson Helicopter R22 · Kapolei, HI · Accident · No injuries · Class 4 · Limited · Final report · Nov 11, 2022 · N948WB · Substantial damage
  > The pilot receiving instruction’s rapid reduction in throttle during hover autorotation training which resulted in a loss of control and collision with the ground.
- [NTSB WPR12LA195](https://openairdocs.org/ntsb/WPR12LA195.md): Robinson R22 · Kailua-Kona, HI · Accident · Serious injuries · Limited investigation · Final report · May 3, 2012 · N209KR · Substantial damage
  > A loss of engine power while maneuvering for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR12CA056](https://openairdocs.org/ntsb/WPR12CA056.md): Robinson Helicopter R22 Beta · Waipahu, HI · Accident · No injuries · Data collection · Final report · Dec 7, 2011 · N817AB · Substantial damage
  > The certified flight instructor's delayed remedial action and inadequate supervision during a practice autorotation. Contributing to the accident was the student pilot's excessive application of the throttle.
- [NTSB WPR10FA085](https://openairdocs.org/ntsb/WPR10FA085.md): Eurocopter AS350BA (FX2) · Hana, Maui, HI · Accident · Serious injuries · Field investigation · Final report · Dec 16, 2009 · N87EW · Substantial damage
  > An uncommanded engine shutdown due to an improperly calibrated fuel control unit (FCU) and power turbine governor (PTG). Also causal was the operator’s inadequate maintenance practices and procedures that failed to properly assess and correct the FCU and PTG…

## 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" = '600' 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/600/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.