# Fatal NTSB investigations: Piper PA-23-250 (6PCLM)

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 DEN83FA062](https://openairdocs.org/ntsb/DEN83FA062.md): Piper PA-23F-250 · Moab, UT · Accident · 2 fatal · Field investigation · Final report · Feb 16, 1983 · N63808 · Destroyed
  > The acft crashed into the top of a mesa at the 5500 ft level (MSL). The acft then cartwheeled about 300 ft on a heading of 360 degrees. Sheriffs deputies discovered at the accident site that the acft was loaded with marijuana weighing ABOUT798 lbs. An…
- [NTSB MIA81FA124](https://openairdocs.org/ntsb/MIA81FA124.md): Piper PA-23 · Daytona Beach, FL · Accident · 2 fatal · Closed · Sep 29, 1981 · N62628 · Destroyed
- [NTSB ATL81FA053](https://openairdocs.org/ntsb/ATL81FA053.md): Piper PA-23 · Kingstree, SC · Accident · 2 fatal · Closed · Mar 11, 1981 · N6545Y · Destroyed
- [NTSB LAX80FA083](https://openairdocs.org/ntsb/LAX80FA083.md): Piper PA-23 · Solvang, CA · Accident · 4 fatal · Closed · Apr 20, 1980 · N63780 · Destroyed
- [NTSB MIA80FA045](https://openairdocs.org/ntsb/MIA80FA045.md): Piper PA-23 · Bradley Jct, FL · Accident · 1 fatal · Closed · Mar 10, 1980 · N6102Y · Destroyed
- [NTSB IAD79FA092](https://openairdocs.org/ntsb/IAD79FA092.md): Piper PA-23 · Greensboro, NC · Accident · 1 fatal · Closed · Sep 29, 1979 · N6378Y · Destroyed
- [NTSB CHI77FA060](https://openairdocs.org/ntsb/CHI77FA060.md): Piper PA-23 · Plano, IL · Accident · 1 fatal · Closed · Jul 21, 1977 · N5900Y · Destroyed
- [NTSB NYC76AN074](https://openairdocs.org/ntsb/NYC76AN074.md): Piper PA-23 · S Burlington, VT · Accident · 2 fatal · Closed · Feb 4, 1976 · N65TM · Destroyed
- [NTSB LAX76AL032](https://openairdocs.org/ntsb/LAX76AL032.md): Piper PA-23 · San Dimas, CA · Accident · 3 fatal · Closed · Oct 31, 1975 · N1356E · Destroyed
- [NTSB NYC76AN045](https://openairdocs.org/ntsb/NYC76AN045.md): Piper PA-23 · Whitehouse Sta, NJ · Accident · 6 fatal · Closed · Oct 25, 1975 · N54005 · Destroyed
- [NTSB ANC75AA082](https://openairdocs.org/ntsb/ANC75AA082.md): Piper PA-23 · Savoonga, AK · Accident · 6 fatal · Closed · May 12, 1975 · N5607Y · Substantial damage
- [NTSB CHI75AC085](https://openairdocs.org/ntsb/CHI75AC085.md): Piper PA-23 · Cleveland, OH · Accident · 1 fatal · Closed · May 10, 1975 · N644N · Destroyed
- [NTSB CHI75AC066](https://openairdocs.org/ntsb/CHI75AC066.md): Piper PA-23 · Grandview, IN · Accident · 2 fatal · Closed · Mar 16, 1975 · N54212 · Destroyed
- [NTSB DEN75AD045](https://openairdocs.org/ntsb/DEN75AD045.md): Piper PA-23 · Albuquerque, NM · Accident · 2 fatal · Closed · Feb 26, 1975 · N6920Y · Destroyed
- [NTSB MKC75AK019](https://openairdocs.org/ntsb/MKC75AK019.md): Piper PA-23 · Austin, MN · Accident · 6 fatal · Closed · Sep 11, 1974 · N6168Y · Destroyed
- [NTSB SEA74AS047](https://openairdocs.org/ntsb/SEA74AS047.md): Piper PA-23 · Toledo, WA · Accident · 4 fatal · Closed · Jun 3, 1974 · N54074 · Destroyed
- [NTSB LAX74AL036](https://openairdocs.org/ntsb/LAX74AL036.md): Piper PA-23 · Alpine, CA · Accident · 3 fatal · Closed · Nov 15, 1973 · N6694Y · Destroyed
- [NTSB DEN73AD025](https://openairdocs.org/ntsb/DEN73AD025.md): Piper PA-23 · Nederland, CO · Accident · 1 fatal · Closed · Nov 25, 1972 · N6767Y · Destroyed
- [NTSB SEA72AS039](https://openairdocs.org/ntsb/SEA72AS039.md): Piper PA-23 · Salem, OR · Accident · 1 fatal · Closed · Mar 14, 1972 · N5600Y · Destroyed
- [NTSB NYC69A0091](https://openairdocs.org/ntsb/NYC69A0091.md): Piper PA-23 · Missing Aircraft · Accident · 6 fatal · Closed · Mar 29, 1969 · N6116Y · Destroyed
- [NTSB NYC69A0011](https://openairdocs.org/ntsb/NYC69A0011.md): Piper PA-23 · Wyandanch, NY · Accident · 8 fatal · Closed · Jul 28, 1968 · N5980Y · 2 aircraft · Destroyed
- [NTSB CHI67A0034](https://openairdocs.org/ntsb/CHI67A0034.md): Piper PA-23 · Z · Accident · 3 fatal · Closed · Aug 27, 1966 · N5951Y · Destroyed
- [NTSB CAN65AF367](https://openairdocs.org/ntsb/CAN65AF367.md): Piper PA-23 · Gander Nf, Canada · Accident · 1 fatal · Closed · May 16, 1965 · N5725Y · Destroyed
- [NTSB MIA65A0076](https://openairdocs.org/ntsb/MIA65A0076.md): Piper PA23 · Atlantic Ocean (Atlantic Ocean) · Accident · 1 fatal · Closed · Jan 20, 1965 · N5585Y · 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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102313'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=7102313

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