# NTSB investigations, HI: Overrun

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 LAX05LA101](https://openairdocs.org/ntsb/LAX05LA101.md): Schweizer SGS 1-26B · Waialua, HI · Accident · No injuries · Limited investigation · Final report · Dec 23, 2004 · N2751Z · Substantial damage
  > the pilot misjudged distance and altitude and failed to attain the proper landing touchdown point.
- [NTSB LAX86LA119](https://openairdocs.org/ntsb/LAX86LA119.md): Beech E18S · Kalaupapa, HI · Accident · Minor injuries · Limited investigation · Final report · Feb 13, 1986 · N30Y · Destroyed
  > The acft crashed off the end of rwy 23 during an attempted go-around after touchdown. The plt stated that after the acft touched down aprx 300 ft down the 2,760 foot rwy he raised the flaps along with the nose of the acft to slow down. Brakes were applied and…
- [NTSB LAX82FJA04](https://openairdocs.org/ntsb/LAX82FJA04.md): Piper PA-28-140 · Kalaupapa, HI · Accident · Serious injuries · Final report · Feb 7, 1982 · N16524 · Destroyed
  > Witnesses stated that the aircraft touched down approximately halfway down runway 5 with the winds out of the west. The pilot stated that when nearing the end of the runway she put on full throttle to initiate a go around but it was too late. The aircraft…

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 340)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=340&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.