# NTSB investigations: Cessna 152, HI

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 LAX91IA039](https://openairdocs.org/ntsb/LAX91IA039.md): Cessna 152 · Wahiawa, HI · Incident · No injuries · Incident investigation · Final report · Nov 26, 1990 · N95144 · 2 aircraft · Minor damage
  > The inadequate visual lookout of the pilots of both airplanes which resulted in the collision. Contributing to the accident was the improper VFR procedures of N88TE while transitioning through the wheeler afb airport traffic area.
- [NTSB LAX89FA103](https://openairdocs.org/ntsb/LAX89FA103.md): Cessna 150K · Honolulu, HI · Accident · Minor injuries · Field investigation · Final report · Feb 9, 1989 · N6149G · 2 aircraft · Substantial damage
  > Inadequate control tower service provided by the local controller (lc), and failure of the two pilots to see and avoid each other's aircraft. Related factors were: identification of the wrong aircraft by the local controller, his excessive workload (heavy…
- [NTSB LAX87LA009](https://openairdocs.org/ntsb/LAX87LA009.md): Cessna 152 · Hana, HI · Accident · No injuries · Limited investigation · Final report · Oct 16, 1986 · N95354 · Substantial damage
  > During a solo instructional flight, the pilot was attempting to fly a course directly over a 10,400 foot mountain. At the 5,200 ft level the pilot encountered turbulence and noticed a cloud build-up over the mountain. The pilot then decided to divert to the…
- [NTSB LAX81FA112](https://openairdocs.org/ntsb/LAX81FA112.md): Cessna 152 II · Kaaawa Valley, HI · Accident · 1 fatal · Closed · Jul 28, 1981 · N5123B · Destroyed
- [NTSB LAX80DJA04](https://openairdocs.org/ntsb/LAX80DJA04.md): Cessna 152 · Honolulu, HI · Accident · No injuries · Closed · Nov 18, 1979 · N89774 · Substantial damage
- [NTSB OAK79FJA07](https://openairdocs.org/ntsb/OAK79FJA07.md): Cessna 152 · Pearl Harbor, HI · Accident · Serious injuries · Closed · Feb 7, 1979 · N25034 · Destroyed

## 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071835'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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