# NTSB investigations: Piper PA-28R-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 ERA16FA257](https://openairdocs.org/ntsb/ERA16FA257.md): Piper PA 28R-201 · Esperance, NY · Accident · 3 fatal · Field investigation · Final report · Jul 16, 2016 · N2241Q · Destroyed
  > The pilot's inadequate preflight weight and balance and performance planning, which resulted in the airplane being over gross weight. Also causal were the pilot's decision not to use the entire runway for takeoff, his premature liftoff, and his failure to…
- [NTSB ERA12LA360](https://openairdocs.org/ntsb/ERA12LA360.md): Piper PA-28R-201 · Kingston, NY · Accident · No injuries · Limited investigation · Final report · May 19, 2012 · N6236C · Substantial damage
  > The pilot’s failure to maintain adequate clearance from trees/foliage at an undetermined point during the flight.
- [NTSB NYC99LA014](https://openairdocs.org/ntsb/NYC99LA014.md): Piper PA-28R-201 · Mattituck, NY · Accident · No injuries · Limited investigation · Final report · Oct 21, 1998 · N31869 · Destroyed
  > The pilot's failure to maintain the airplane's directional control during a go-around.
- [NTSB NYC89LA182](https://openairdocs.org/ntsb/NYC89LA182.md): Piper PA-28R-201 · Mattituck, NY · Accident · No injuries · Limited investigation · Final report · Aug 3, 1989 · N1707H · Substantial damage
  > Failure of right braking action due to a hydraulic leak.
- [NTSB NYC85LA094](https://openairdocs.org/ntsb/NYC85LA094.md): Piper PA-28R-201 · Red Hook, NY · Accident · No injuries · Limited investigation · Final report · Mar 31, 1985 · N2263Q · 2 aircraft · Substantial damage
  > During flt, a Piper PA-32R-201, N2263Q, & a bainbridge jodel F-12, N5700, encountered structural icing conditions. The windshields of both acft became covered with ice which restricted the forward visibility of the occupants in both acft. N5700 landed 1st.…
- [NTSB NYC81FHJ08](https://openairdocs.org/ntsb/NYC81FHJ08.md): Piper PA-28R · Shelter Island, NY · Accident · No injuries · Closed · May 21, 1981 · N6320C · Substantial damage

## 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 ('7102816', '7102833'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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