# Final 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 ATL82FLG06](https://openairdocs.org/ntsb/ATL82FLG06.md): Piper PA-23 · Hilton Head, SC · Accident · Serious injuries · Closed · Dec 7, 1981 · N5295Y · Destroyed
- [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 IAD79FIG09](https://openairdocs.org/ntsb/IAD79FIG09.md): Piper PA-23 · Baltimore, MD · Accident · Serious injuries · Closed · Jul 15, 1979 · N555WP · Destroyed
- [NTSB NYC78FFJ16](https://openairdocs.org/ntsb/NYC78FFJ16.md): Piper PA-23 · Dryden, NY · Accident · Minor injuries · Closed · Apr 20, 1978 · N6858Y · Substantial damage
- [NTSB DEN78FTE32](https://openairdocs.org/ntsb/DEN78FTE32.md): Piper PA-23 · Milner, CO · Accident · No injuries · Closed · Feb 18, 1978 · N6049Y · Destroyed
- [NTSB CHI78FEC13](https://openairdocs.org/ntsb/CHI78FEC13.md): Piper PA-23 · Troy, MI · Accident · No injuries · Closed · Feb 6, 1978 · N6704Y · Destroyed
- [NTSB CHI77FEE49](https://openairdocs.org/ntsb/CHI77FEE49.md): Piper PA-23 · Elgin, IL · Accident · No injuries · Closed · Aug 28, 1977 · N54767 · Substantial damage
- [NTSB CHI77FA060](https://openairdocs.org/ntsb/CHI77FA060.md): Piper PA-23 · Plano, IL · Accident · 1 fatal · Closed · Jul 21, 1977 · N5900Y · Destroyed
- [NTSB MKC77FCQ41](https://openairdocs.org/ntsb/MKC77FCQ41.md): Piper PA-23 · Minneapolis, KS · Accident · No injuries · Closed · Jun 15, 1977 · N54797 · Destroyed
- [NTSB CHI77FEE23](https://openairdocs.org/ntsb/CHI77FEE23.md): Piper PA-23 · Streator, IL · Accident · Minor injuries · Closed · May 26, 1977 · N5957Y · Substantial damage
- [NTSB MIA77DKA05](https://openairdocs.org/ntsb/MIA77DKA05.md): Piper PA-23 · San Juan, PR · Accident · Minor injuries · Closed · Apr 6, 1977 · N5519Y · Destroyed
- [NTSB MIA76DKK03](https://openairdocs.org/ntsb/MIA76DKK03.md): Piper PA-23 · Demopolis, AL · Accident · No injuries · Closed · Sep 16, 1976 · N62569 · Substantial damage
- [NTSB MIA76FLA70](https://openairdocs.org/ntsb/MIA76FLA70.md): Piper PA-23 · Hilliard, FL · Accident · Serious injuries · Closed · Sep 13, 1976 · N6036Y · 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 FTW76DRJ06](https://openairdocs.org/ntsb/FTW76DRJ06.md): Piper PA-23 · Alexandria, LA · Accident · Minor injuries · Closed · Aug 16, 1975 · N54166 · 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 CHI75FEE47](https://openairdocs.org/ntsb/CHI75FEE47.md): Piper PA-23 · Elgin, IL · Accident · No injuries · Closed · Feb 26, 1975 · N6800Y · Substantial damage
- [NTSB CHI75FEI23](https://openairdocs.org/ntsb/CHI75FEI23.md): Piper PA-23 · Oberlin, OH · Accident · No injuries · Closed · Oct 24, 1974 · N6308Y · 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 LAX69D0166](https://openairdocs.org/ntsb/LAX69D0166.md): Piper PA-23 · Sj Capistrano, CA · Accident · No injuries · Closed · Aug 23, 1968 · N6263Y · Substantial damage
- [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 OAK68D0283](https://openairdocs.org/ntsb/OAK68D0283.md): Piper PA-23 · Eureka, CA · Accident · No injuries · Closed · Jan 22, 1968 · N6168Y · Substantial damage
- [NTSB NYC68F0035](https://openairdocs.org/ntsb/NYC68F0035.md): Piper PA-23 · W.Milford, NJ · Accident · Serious injuries · Closed · Jun 30, 1967 · N6354Y · Destroyed
- [NTSB FTW67F0558](https://openairdocs.org/ntsb/FTW67F0558.md): Piper PA-23 · Haskell, TX · Accident · No injuries · Closed · Apr 13, 1967 · N6073Y · Substantial damage
- [NTSB CHI67A0034](https://openairdocs.org/ntsb/CHI67A0034.md): Piper PA-23 · Z · Accident · 3 fatal · Closed · Aug 27, 1966 · N5951Y · Destroyed
- [NTSB FTW66F0702](https://openairdocs.org/ntsb/FTW66F0702.md): Piper PA-23 · Lubbock, TX · Accident · No injuries · Closed · Jun 9, 1966 · N5951Y · Substantial damage
- [NTSB FTW66F0497](https://openairdocs.org/ntsb/FTW66F0497.md): Piper PA-23 · Lubbock, TX · Accident · No injuries · Closed · Jan 28, 1966 · N5951Y · Substantial damage
- [NTSB MIA66F0383](https://openairdocs.org/ntsb/MIA66F0383.md): Piper PA-23 · Winston Salem, NC · Accident · No injuries · Closed · Jan 12, 1966 · N5657Y · Substantial damage
- [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
- [NTSB UNK64X2981](https://openairdocs.org/ntsb/UNK64X2981.md): Piper PA23 · St Petersburg, FL · Accident · No injuries · Closed · Jul 22, 1964 · N5295Y · 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."completionStatus" = 'Completed'
  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?model=7102313&status=final

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