# NTSB investigations, HI: Other weather encounter

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 ANC23LA009](https://openairdocs.org/ntsb/ANC23LA009.md): Beech 77 · Lihue, HI · Accident · Serious injuries · Class 3 · Limited · Final report · Dec 15, 2022 · N991AB · Substantial damage
  > The airplane’s exceedance of its critical angle of attack after encountering a downdraft during departure, which resulted in an aerodynamic stall and impact with terrain.
- [NTSB ANC20CA027](https://openairdocs.org/ntsb/ANC20CA027.md): Cessna TP206 · Kahului, HI · Accident · No injuries · Data collection · Final report · Feb 13, 2020 · N8649Z · Substantial damage
  > The pilot's improper landing flare in gusting crosswind conditions, which resulted in the airplane porpoising and a subsequent a loss of directional control, runway excursion, and nose-over.
- [NTSB WPR16LA175](https://openairdocs.org/ntsb/WPR16LA175.md): Mcdonnell Douglas Helicopter 500N · Honolulu, HI · Accident · Serious injuries · Limited investigation · Final report · Sep 2, 2016 · N5232G · No damage
  > The pilot's failure to maintain helicopter control in gusting wind conditions, which resulted in the helicopter rescue net’s contact with a utility pole and serious injury to an occupant who fell from the rescue net. Contributing to the accident was the…
- [NTSB GAA16CA472](https://openairdocs.org/ntsb/GAA16CA472.md): Cessna 172 · Kahului, HI · Accident · No injuries · Data collection · Final report · Jul 10, 2016 · N335SP · Substantial damage
  > The pilot's incorrect pitch control during the landing flare, which resulted in a porpoise and hard landing.
- [NTSB GAA15CA147](https://openairdocs.org/ntsb/GAA15CA147.md): Robinson Helicopter R22 Beta · Kailua-Kona, HI · Accident · Minor injuries · Data collection · Final report · Jun 29, 2015 · N227FT · Substantial damage
  > The flight instructor's decision to conduct a high altitude pinnacle landing without adequate power, which resulted in the helicopter impacting terrain during the approach. Contributing to the accident was the density altitude at the high altitude pinnacle…
- [NTSB WPR12MA034](https://openairdocs.org/ntsb/WPR12MA034.md): Eurocopter EC 130 B4 · Pukoo, HI · Accident · 5 fatal · Major investigation · Final report · Nov 10, 2011 · N11QV · Substantial damage
  > The pilot's failure to maintain clearance from mountainous terrain while operating in marginal weather conditions, which resulted in the impact of the horizontal stabilizer and lower forward portion of the fenestron with ground and/or vegetation and led to…

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