# NTSB investigations: Piper PA-23, 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 NYC96FA126](https://openairdocs.org/ntsb/NYC96FA126.md): Piper PA-23-150 · Cortland, NY · Accident · 3 fatal · Field investigation · Final report · Jun 14, 1996 · N2189P · Destroyed
  > the pilot failure to maintain directional control of the airplane which resulted in the airplane striking trees. Contributing factors were the pilot's spatial disorientation, dark night conditions, fog, and the pilot's self induced pressure to reach the…
- [NTSB NYC90LA164](https://openairdocs.org/ntsb/NYC90LA164.md): Piper PA-23 · Shirley, NY · Accident · Minor injuries · Limited investigation · Final report · Jul 14, 1990 · N44HH · Substantial damage
  > The pilot's lack of qualifications, the improper use of flight controls, the second pilot's lack of qualifications, and his decision to simulate the engine failure.
- [NTSB NYC81FA044](https://openairdocs.org/ntsb/NYC81FA044.md): Piper PA-23 · Mattituck, NY · Accident · Serious injuries · Closed · May 4, 1981 · N2HD · Substantial damage
- [NTSB NYC76AN052](https://openairdocs.org/ntsb/NYC76AN052.md): Piper PA-23 · Spring Valley, NY · Accident · 1 fatal · Closed · Dec 4, 1975 · N2191P · Destroyed
- [NTSB NYC75FHM02](https://openairdocs.org/ntsb/NYC75FHM02.md): Piper PA-23 · Montgomery, NY · Accident · Serious injuries · Closed · Jul 13, 1974 · N1067P · Substantial damage
- [NTSB NYC72FFJ19](https://openairdocs.org/ntsb/NYC72FFJ19.md): Piper PA-23 · Rochester, NY · Accident · Minor injuries · Closed · Oct 18, 1971 · N2183P · Destroyed
- [NTSB NYC72AN002](https://openairdocs.org/ntsb/NYC72AN002.md): Piper PA-23 · Utica, NY · Accident · 2 fatal · Closed · Jul 4, 1971 · N3373P · Destroyed
- [NTSB NYC66F0621](https://openairdocs.org/ntsb/NYC66F0621.md): Piper PA-23 · Syracuse, NY · Accident · No injuries · Closed · Apr 13, 1966 · N2183P · Substantial damage
- [NTSB NYC65A0108](https://openairdocs.org/ntsb/NYC65A0108.md): Piper PA-23 · Delancey, NY · Accident · 1 fatal · Closed · Feb 19, 1965 · N4827P · Destroyed
- [NTSB UNK64X2197](https://openairdocs.org/ntsb/UNK64X2197.md): Piper PA23 · Bohemia, NY · Accident · No injuries · Closed · Jun 9, 1964 · N1083P · 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 ('7102302'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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