# NTSB investigations: Piper PA-28RT-201, 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 IAD05FA146](https://openairdocs.org/ntsb/IAD05FA146.md): Piper PA-28RT-201 · Dunkirk, NY · Accident · 3 fatal · Field investigation · Final report · Aug 27, 2005 · N8164H · Destroyed
  > Loss of control for undetermined reasons.
- [NTSB NYC88LA138](https://openairdocs.org/ntsb/NYC88LA138.md): Piper PA-28RT-201 · Millbrook, NY · Accident · Serious injuries · Limited investigation · Final report · May 13, 1988 · N2819J · Substantial damage
  > The aircraft departed runway 17 at sky acres airport and after reachng an altitude of about 100 feet, witnesses observed the engine cowling extended vertically, partially attached. The pilot said he was unable to return to the departure airport, and the…
- [NTSB NYC82AA125](https://openairdocs.org/ntsb/NYC82AA125.md): Piper PA-28RT-201 · Dunkirk, NY · Accident · 4 fatal · Final report · Jun 17, 1982 · N8192A · Destroyed
  > The flt was cleared for a VOR rwy 24 apch. At 2226 the plt reported the arpt in sight. At 2228 the acft crashed 4,000 ftsouth of the departure end of rwy 24 on a heading of 115 deg. The jamestown,NY 2250 wx observation was partial obscuration, estimated 200…
- [NTSB NYC81FA016](https://openairdocs.org/ntsb/NYC81FA016.md): Piper PA-28R · Jamaica, NY · Accident · 4 fatal · Closed · Dec 7, 1980 · N29242 · 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 ('7102818'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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