# NTSB investigations: Piper PA-18: In flight collision with terrain/water

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 ANC99LA136](https://openairdocs.org/ntsb/ANC99LA136.md): Piper PA-18 · Cordova, AK · Accident · No injuries · Limited investigation · Final report · Sep 2, 1999 · N9130D · Substantial damage
  > The pilot's failure to avoid obstructions during takeoff. A factor associated with this accident was the high brush along the river bank.
- [NTSB ANC99LA117](https://openairdocs.org/ntsb/ANC99LA117.md): Piper PA-18 · Skwentna, AK · Accident · No injuries · Limited investigation · Final report · Aug 11, 1999 · N221BC · Substantial damage
  > The pilot's selection of unsuitable terrain for landing. A factor was high vegetation.
- [NTSB ANC94FA130](https://openairdocs.org/ntsb/ANC94FA130.md): Piper PA-18 · Gulkana, AK · Accident · 1 fatal · Field investigation · Final report · Sep 5, 1994 · N7867D · Substantial damage
  > The pilot's failure to maintain clearance from terrain.
- [NTSB MIA92LA150](https://openairdocs.org/ntsb/MIA92LA150.md): Piper PA-18 · Ft Walton Beach, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 19, 1992 · N3292Z · Substantial damage
  > The pilot misjudged his altitude while turning on final approach over water to land at an airport.
- [NTSB ANC85LA132](https://openairdocs.org/ntsb/ANC85LA132.md): Piper PA-18-150 · Mccarthy, AK · Accident · 1 fatal · Limited investigation · Final report · Jul 19, 1985 · N1109A · Destroyed
  > The pilot-in-command was departing from a 600 foot long airstrip at a 3400 foot field elevation. The takeoff run was downslope and the pilot had to pull the airplane off the ground by use of the control stick and the application of full flaps, the 40 degree…
- [NTSB NYC84LA040](https://openairdocs.org/ntsb/NYC84LA040.md): Piper PA-18 · Great Pond, ME · Accident · No injuries · Limited investigation · Final report · Nov 24, 1983 · N1473C · Substantial damage
  > The plt stated that he was going hunting in a bog with a stream running thru the area. Reportedly, he was making a low pass to check for rocks in the stream before landing when a deer jumped up beside the float plane. He stated that he was watching to see…
- [NTSB ANC82DAG28](https://openairdocs.org/ntsb/ANC82DAG28.md): Piper PA-18 · Kenai, AK · Accident · 1 fatal · Final report · May 30, 1982 · N9089D · Destroyed
  > Pilot was giving passengers rides along bishop creek. He was reported as flying low and erratic. On the last flight with two passengers, the wing dipped & caught the water. The acft then cartwheeled. The plt's blood alcohol level was 196 mg%.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101802')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7101802&occurrence=230

---
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.