# NTSB investigations: Piper PA-23-150 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 2 of 2 · 79 cases ## Cases, newest first - [NTSB DEN69D0234](https://openairdocs.org/ntsb/DEN69D0234.md): Piper PA-23 · Greeley, CO · Accident · No injuries · Closed · Jan 10, 1969 · N1034P · Substantial damage - [NTSB DEN68F0202](https://openairdocs.org/ntsb/DEN68F0202.md): Piper PA-23 · Hobbs, NM · Accident · No injuries · Closed · Feb 2, 1968 · N1111P · Substantial damage - [NTSB LAX68F0252](https://openairdocs.org/ntsb/LAX68F0252.md): Piper PA-23 · Van Nuys, CA · Accident · No injuries · Closed · Jan 5, 1968 · N1276P · Substantial damage - [NTSB CHI68F0397](https://openairdocs.org/ntsb/CHI68F0397.md): Piper PA-23 · Aberdeen, OH · Accident · No injuries · Closed · Nov 1, 1967 · N1258P · Substantial damage - [NTSB MIA68D0009](https://openairdocs.org/ntsb/MIA68D0009.md): Piper PA-23 · Jackson, TN · Accident · No injuries · Closed · Jun 16, 1967 · N3237P · Substantial damage - [NTSB LAX68D0005](https://openairdocs.org/ntsb/LAX68D0005.md): Piper PA-23 · El Monte, CA · Accident · No injuries · Closed · May 17, 1967 · N3116P · Substantial damage - [NTSB MIA67F0517](https://openairdocs.org/ntsb/MIA67F0517.md): Piper PA-23 · Birmingham, AL · Accident · No injuries · Closed · May 16, 1967 · N1303P · Substantial damage - [NTSB MIA67F0428](https://openairdocs.org/ntsb/MIA67F0428.md): Piper PA-23 · Atlanta, GA · Accident · No injuries · Closed · Feb 3, 1967 · N3050P · Substantial damage - [NTSB CHI67D0429](https://openairdocs.org/ntsb/CHI67D0429.md): Piper PA-23 · Madison, WI · Accident · No injuries · Closed · Dec 15, 1966 · N3139P · Substantial damage - [NTSB DEN67F0135](https://openairdocs.org/ntsb/DEN67F0135.md): Piper PA-23 · Sterling, CO · Accident · No injuries · Closed · Oct 24, 1966 · N1094P · Substantial damage - [NTSB MIA67F0275](https://openairdocs.org/ntsb/MIA67F0275.md): Piper PA-23 · Atlanta, GA · Accident · No injuries · Closed · Oct 20, 1966 · N3050P · Substantial damage - [NTSB CHI66F0776](https://openairdocs.org/ntsb/CHI66F0776.md): Piper PA23 · Louisville, KY · Accident · No injuries · Closed · Jun 13, 1966 · N1258P · Substantial damage - [NTSB CHI66F0726](https://openairdocs.org/ntsb/CHI66F0726.md): Piper PA-23 · West Chicago, IL · Accident · No injuries · Closed · May 5, 1966 · N1247P · Substantial damage - [NTSB OAK66A0037](https://openairdocs.org/ntsb/OAK66A0037.md): Piper PA-23 · El Granada, CA · Accident · 3 fatal · Closed · Mar 19, 1966 · N2204P · Destroyed - [NTSB CHI66A0060](https://openairdocs.org/ntsb/CHI66A0060.md): Piper PA-23 · Knox, IN · Accident · 3 fatal · Closed · Dec 19, 1965 · N1100P · 2 aircraft · Destroyed - [NTSB CHI66F0478](https://openairdocs.org/ntsb/CHI66F0478.md): Piper PA-23 · East St Louis, IL · Accident · No injuries · Closed · Nov 22, 1965 · N3205P · Substantial damage - [NTSB CHI66F0143](https://openairdocs.org/ntsb/CHI66F0143.md): Piper PA-23 · South Bend, IN · Accident · No injuries · Closed · Aug 1, 1965 · N1211P · Substantial damage - [NTSB SEA66F0012](https://openairdocs.org/ntsb/SEA66F0012.md): Piper PA-23 · Bremerton, WA · Accident · No injuries · Closed · May 29, 1965 · N1479P · Substantial damage - [NTSB UNK65X1329](https://openairdocs.org/ntsb/UNK65X1329.md): Piper PA23 · Geneva, NY · Accident · No injuries · Closed · Jan 22, 1965 · N1313P · Substantial damage - [NTSB CHI65F0038](https://openairdocs.org/ntsb/CHI65F0038.md): Piper PA-23 · Des Plaines, IL · Accident · No injuries · Closed · Jan 14, 1965 · N3135P · Substantial damage - [NTSB UNK65X0938](https://openairdocs.org/ntsb/UNK65X0938.md): Piper PA-23 · Bimini Bwi, WN · Accident · 1 fatal · Closed · Dec 6, 1964 · N1420P · Substantial damage - [NTSB UNK65X0511](https://openairdocs.org/ntsb/UNK65X0511.md): Piper PA23 · Cynthiana, KY · Accident · No injuries · Closed · Nov 1, 1964 · N1143P · Substantial damage - [NTSB UNK64X2533](https://openairdocs.org/ntsb/UNK64X2533.md): Piper PA23 · Ft Worth, TX · Accident · No injuries · Closed · Jun 28, 1964 · N2154P · Substantial damage - [NTSB UNK64X1583](https://openairdocs.org/ntsb/UNK64X1583.md): Piper PA23 · Denver, CO · Accident · No injuries · Closed · May 3, 1964 · N1239P · Substantial damage - [NTSB UNK64X1035](https://openairdocs.org/ntsb/UNK64X1035.md): Piper PA23 · Reno, NV · Accident · No injuries · Closed · Mar 25, 1964 · N1211P · Destroyed - [NTSB UNK64X0977](https://openairdocs.org/ntsb/UNK64X0977.md): Piper PA-23 · Miramar, FL · Accident · No injuries · Closed · Mar 19, 1964 · N31A · Substantial damage - [NTSB UNK64X0691](https://openairdocs.org/ntsb/UNK64X0691.md): Piper PA-23 · Valparaiso, IN · Accident · 3 fatal · Closed · Feb 25, 1964 · N8690E · Destroyed - [NTSB UNK64X0600](https://openairdocs.org/ntsb/UNK64X0600.md): Piper PA23 · Lockport, IL · Accident · No injuries · Closed · Feb 17, 1964 · N1329P · Substantial damage - [NTSB UNK64X0188](https://openairdocs.org/ntsb/UNK64X0188.md): Piper PA23 · Vandalia, OH · Accident · No injuries · Closed · Jan 8, 1964 · N1450P · 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 ('7102303')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb?model=7102303&page=2 --- 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.