# NTSB investigations: Piper PA-23

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.

Page 7 of 7 · 331 cases

## Cases, newest first

- [NTSB MKC66F0093](https://openairdocs.org/ntsb/MKC66F0093.md): Piper PA-23 · Joplin, MO · Accident · No injuries · Closed · May 18, 1965 · N3132P · Substantial damage
- [NTSB FTW65F0022](https://openairdocs.org/ntsb/FTW65F0022.md): Piper PA-23 · San Antonio, TX · Accident · Minor injuries · Closed · Apr 13, 1965 · N1429P · Destroyed
- [NTSB NYC65A0122](https://openairdocs.org/ntsb/NYC65A0122.md): Piper PA-23 · Z · Accident · 1 fatal · Closed · Apr 12, 1965 · N2032P · Destroyed
- [NTSB MKC65A0058](https://openairdocs.org/ntsb/MKC65A0058.md): Piper PA-23 · Grand Forks, ND · Accident · 2 fatal · Closed · Apr 8, 1965 · N4021P · Destroyed
- [NTSB DEN65D0049](https://openairdocs.org/ntsb/DEN65D0049.md): Piper PA-23 · Tucson, AZ · Accident · No injuries · Closed · Apr 8, 1965 · N3071P · 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 UNK65X1340](https://openairdocs.org/ntsb/UNK65X1340.md): Piper PA23 · Vacaville, CA · Accident · No injuries · Closed · Jan 24, 1965 · N2139P · Substantial damage
- [NTSB UNK65X0618](https://openairdocs.org/ntsb/UNK65X0618.md): Piper PA23 · Ft Worth, TX · Accident · No injuries · Closed · Nov 8, 1964 · N2181P · Destroyed
- [NTSB UNK65X0534](https://openairdocs.org/ntsb/UNK65X0534.md): Piper PA23 · Vichy, MO · Accident · No injuries · Closed · Nov 2, 1964 · N2223R · Substantial damage
- [NTSB UNK65X0372](https://openairdocs.org/ntsb/UNK65X0372.md): Piper PA23 · Laporte, TX · Accident · No injuries · Closed · Oct 22, 1964 · N1119P · Substantial damage
- [NTSB UNK65X0159](https://openairdocs.org/ntsb/UNK65X0159.md): Piper PA-23 · Nairobi E Africa, Kenya · Accident · No injuries · Closed · Oct 6, 1964 · N616F · Substantial damage
- [NTSB UNK64X3944](https://openairdocs.org/ntsb/UNK64X3944.md): Piper PA23 · Broomfield, CO · Accident · No injuries · Closed · Sep 12, 1964 · N2050P · Substantial damage
- [NTSB UNK64X3835](https://openairdocs.org/ntsb/UNK64X3835.md): Piper PA23 · Markham, IL · Accident · 3 fatal · Closed · Sep 6, 1964 · N1252P · Destroyed
- [NTSB UNK64X3586](https://openairdocs.org/ntsb/UNK64X3586.md): Piper PA23 · St Petersburg, FL · Accident · No injuries · Closed · Aug 25, 1964 · N1201P · Substantial damage
- [NTSB UNK64X2356](https://openairdocs.org/ntsb/UNK64X2356.md): Piper PA23 · Lake Tahoe, CA · Accident · No injuries · Closed · Jun 18, 1964 · N3068P · Substantial damage
- [NTSB UNK64X2213](https://openairdocs.org/ntsb/UNK64X2213.md): Piper PA23 · Bedford, MA · Accident · Minor injuries · Closed · Jun 10, 1964 · N3006P · Substantial damage
- [NTSB UNK64X2197](https://openairdocs.org/ntsb/UNK64X2197.md): Piper PA23 · Bohemia, NY · Accident · No injuries · Closed · Jun 9, 1964 · N1083P · Substantial damage
- [NTSB UNK64X2086](https://openairdocs.org/ntsb/UNK64X2086.md): Piper PA23 · Deer Park, LA · Accident · No injuries · Closed · Jun 3, 1964 · N1362P · Substantial damage
- [NTSB UNK64X2000](https://openairdocs.org/ntsb/UNK64X2000.md): Piper PA23 · Elgin, IL · Accident · No injuries · Closed · May 29, 1964 · N3227P · Substantial damage
- [NTSB UNK64X1696](https://openairdocs.org/ntsb/UNK64X1696.md): Piper PA-23 · Albuquerque, NM · Accident · Minor injuries · Closed · May 10, 1964 · N72F · Substantial damage
- [NTSB UNK64X1437](https://openairdocs.org/ntsb/UNK64X1437.md): Piper PA-23 · Lilly Chapel, OH · Accident · 1 fatal · Closed · Apr 24, 1964 · N92N · Destroyed
- [NTSB UNK64X1363](https://openairdocs.org/ntsb/UNK64X1363.md): Piper PA23 · Santa Ana, CA · Accident · No injuries · Closed · Apr 18, 1964 · N1317P · 2 aircraft · No damage
- [NTSB UNK64X1334](https://openairdocs.org/ntsb/UNK64X1334.md): Piper PA23 · Comstock, TX · Accident · No injuries · Closed · Apr 16, 1964 · N1452P · Substantial damage
- [NTSB UNK64X1306](https://openairdocs.org/ntsb/UNK64X1306.md): Piper PA23 · Phoenix, AZ · Accident · No injuries · Closed · Apr 14, 1964 · N3119P · Destroyed
- [NTSB UNK64X1114](https://openairdocs.org/ntsb/UNK64X1114.md): Piper PA-23 · Detroit, MI · Accident · No injuries · Closed · Mar 31, 1964 · N1435P · Substantial damage
- [NTSB UNK64X0948](https://openairdocs.org/ntsb/UNK64X0948.md): Piper PA23 · Adrian, MI · Accident · No injuries · Closed · Mar 16, 1964 · N3169P · Substantial damage
- [NTSB UNK64X0736](https://openairdocs.org/ntsb/UNK64X0736.md): Piper PA23 · Idria, CA · Accident · 1 fatal · Closed · Feb 28, 1964 · N3186P · Destroyed
- [NTSB UNK64X0581](https://openairdocs.org/ntsb/UNK64X0581.md): Piper PA-23 · Cairo, Egypt · Accident · Serious injuries · Closed · Feb 16, 1964 · N2274P · Destroyed
- [NTSB UNK64X0537](https://openairdocs.org/ntsb/UNK64X0537.md): Piper PA23 · Beeville, TX · Accident · No injuries · Closed · Feb 11, 1964 · N3115P · Substantial damage
- [NTSB UNK64X0441](https://openairdocs.org/ntsb/UNK64X0441.md): Piper PA23 · Spartanburg, SC · Accident · No injuries · Closed · Feb 2, 1964 · N1104P · Substantial damage
- [NTSB UNK64X0228](https://openairdocs.org/ntsb/UNK64X0228.md): Piper PA23 · Corona, CA · Accident · No injuries · Closed · Jan 12, 1964 · N1166P · 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."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&page=7

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