Fatal NTSB investigations: Piper PA-23-235

10 cases on aircraft the registry lists as Piper PA-23-235. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

Fatal NTSB investigations: Piper PA-23-235 per year, 1965–2026: 10 cases
1965	1
1966	1
1967	2
1968	1
1972	1
1973	1
1991	1
1998	1
2003	1

Where

Open the map

Latest cases

Query with 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 ('7102306')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "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 ('7102306'))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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 ('7102306'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB MIA03WA147Accident · 1 fatalForeign investigationPiper PA-23-235 · Freeport, BahamasJul 18, 2003 · N4928P · Destroyed NTSB FTW99IA024Incident · 1 fatalIncident investigationFinal reportPiper PA-23-235 · Mineral Wells, TXThe pilot-in-command's incapacitation due to cardiovascular disease.Nov 10, 1998 · N4927P · No damage NTSB NYC92FA047Accident · 1 fatalField investigationFinal reportPiper PA-23-235 · Fall River, MAThe pilot did not follow IFR proceedures and was manuvering at too low an altitude to remain clear of the terrain. Factors in the accident were; fatigue, fog and no visual ground clues.Dec 14, 1991 · N4959P · Destroyed NTSB MKC73AK070Accident · 2 fatalClosedPiper PA-23 · Cloquet, MNMay 26, 1973 · N4330Y · Destroyed NTSB CAN73F0906Accident · 3 fatalClosedPiper PA-23 · Aklavik, CanadaDec 8, 1972 · N4919P · Destroyed NTSB NYC69A0053Accident · 4 fatalClosedPiper PA-23 · Churchville, PANov 7, 1968 · N4946P · Destroyed NTSB MIA67A0121Accident · 2 fatalClosedPiper PA-28 · Isle Of Palms, SCMay 17, 1967 · N9006W · Destroyed NTSB OAK67A0057Accident · 2 fatalClosedPiper PA-23 · San Mateo, CAJan 19, 1967 · N4925P · Destroyed NTSB NYC67A0020Accident · 4 fatalClosedPiper PA-23 · Atlantic City, NJJul 31, 1966 · N4941P · Destroyed NTSB NYC66A0056Accident · 1 fatalClosedPiper PA-23 · Covington, VANov 12, 1965 · N4970P · Destroyed