# NTSB investigations, HI: Nose over/nose down

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 ANC20CA034](https://openairdocs.org/ntsb/ANC20CA034.md): Cessna 172 · Kahului, HI · Accident · Minor injuries · Data collection · Final report · Mar 17, 2020 · N738DB · Substantial damage
  > The student pilot's failure to avoid wake turbulence while landing behind a heavy jet airplane, which resulted in a loss of roll control and subsequent hard landing.
- [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 WPR14LA045](https://openairdocs.org/ntsb/WPR14LA045.md): Cessna Ector 305A · Mokuleia, HI · Accident · Minor injuries · Limited investigation · Final report · Nov 7, 2013 · N65070 · Substantial damage
  > A landing gear brake malfunction during the landing for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR13LA389](https://openairdocs.org/ntsb/WPR13LA389.md): Champion 8KCAB · Wahiawa, HI · Accident · Serious injuries · Limited investigation · Final report · Aug 28, 2013 · N413JJ · Substantial damage
  > A total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the engine and airframe did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR12CA088](https://openairdocs.org/ntsb/WPR12CA088.md): Cessna 172S · Mokuleia, HI · Accident · No injuries · Data collection · Final report · Feb 2, 2012 · N5026C · Substantial damage
  > The pilot's improper landing flare and inadequate recovery from a bounced landing.
- [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" = '096' 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/096/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.