# NTSB investigations: Piper PA-18, NY

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 NYC00LA220](https://openairdocs.org/ntsb/NYC00LA220.md): Piper PA-18 · Westhampton, NY · Accident · No injuries · Limited investigation · Final report · Aug 5, 2000 · N17080 · Substantial damage
  > The pilot's inadequate flare during the landing. Factors were the entanglement of the tow rope with the rudder horn, and restricted rudder movement.
- [NTSB NYC91FA123](https://openairdocs.org/ntsb/NYC91FA123.md): Piper PA-18-150 · Hancock Village, NY · Accident · 1 fatal · Field investigation · Final report · Apr 28, 1991 · N102LW · Destroyed
  > The loss of aircraft control and subsequent collision with trees after the pilot became physically incapacitated.
- [NTSB NYC85LA207](https://openairdocs.org/ntsb/NYC85LA207.md): Piper PA-18 · Moose River, NY · Accident · No injuries · Limited investigation · Final report · May 17, 1985 · N8105D · Destroyed
  > The acft collided with trees during takeoff and crashed. The plt said he encountered turbulence at about 100 ft AGL which' forced' the acft into the trees.
- [NTSB NYC84LA086](https://openairdocs.org/ntsb/NYC84LA086.md): Piper PA-18 · Hastings, NY · Accident · No injuries · Limited investigation · Final report · Feb 12, 1984 · N3264P · Substantial damage
  > The acft dragged a wing during landing after a ski had failed during takeoff. The plt stated that after takeoff he noticed that the left ski had turned over or dropped down in front. He landed the acft on the rwy and the ski tore off digging the landing gear…
- [NTSB NYC75FFA04](https://openairdocs.org/ntsb/NYC75FFA04.md): Piper PA-18 · Three Mile Bay, NY · Accident · No injuries · Closed · Jul 14, 1974 · N288NY · Substantial damage
- [NTSB NYC72FFA38](https://openairdocs.org/ntsb/NYC72FFA38.md): Piper PA-18 · Oneonta, NY · Accident · No injuries · Closed · May 6, 1972 · N1209A · Substantial damage
- [NTSB NYC72AN014](https://openairdocs.org/ntsb/NYC72AN014.md): Piper PA-18 · Essex, NY · Accident · 1 fatal · Closed · Jul 29, 1971 · N16689 · Destroyed
- [NTSB NYC72DFA21](https://openairdocs.org/ntsb/NYC72DFA21.md): Piper PA-18 · Potsdam, NY · Accident · No injuries · Closed · Jun 16, 1971 · N327T · Substantial damage
- [NTSB NYC67D0401](https://openairdocs.org/ntsb/NYC67D0401.md): Piper PA-18 · Richland, NY · Accident · Serious injuries · Closed · Nov 20, 1966 · N3258P · 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" = 'NY' 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 ('7101802'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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