Skip to content

NTSB investigations: Piper PA-23-235

31 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

19642026

Where

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."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.\"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."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 SEA07LA036Accident · No injuriesLimited investigationFinal reportPiper PA 23-235 · Phoenix, AZThe landing gear collapsed for undetermined reasons while the aircraft was standing on the taxiway with the engines operating.Dec 17, 2006 · N5829X · Substantial damage 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 LAX91LA148Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Jean, NVFuel starvation due to the improper fuel management (positioning of the fuel selector) by the pilot, and his improper emergency procedures. The pilot's lack of experience in this make and model of aircraft was a related factor.Mar 30, 1991 · N99255 · Substantial damage NTSB LAX90LA262Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Long Beach, CAThe pilot's improper planning/decision, which resulted in fuel exhaustion.Jul 20, 1990 · N4950P · Substantial damage NTSB MIA83LA053Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Stuart, FLAircraft made a hard landing and damaged wings.Dec 19, 1982 · N4981P · Substantial damage NTSB FTW81DPD08Accident · No injuriesClosedPiper PA-23 · Fort Worth, TXJan 24, 1981 · N4927P · Substantial damage NTSB CHI78FEX07Accident · Minor injuriesClosedPiper PA-23 · St Paul, INDec 17, 1977 · N498HH · Substantial damage NTSB MKC73AK070Accident · 2 fatalClosedPiper PA-23 · Cloquet, MNMay 26, 1973 · N4330Y · Destroyed NTSB FTW73DOG32Accident · No injuriesClosedPiper PA-23 · Snyder, TXMar 5, 1973 · N330EC · Substantial damage NTSB CAN73F0906Accident · 3 fatalClosedPiper PA-23 · Aklavik, CanadaDec 8, 1972 · N4919P · Destroyed NTSB MIA72DKJ45Accident · No injuriesClosedPiper PA-23 · Decatur, ALMar 16, 1972 · N4959P · Substantial damage NTSB NYC69A0053Accident · 4 fatalClosedPiper PA-23 · Churchville, PANov 7, 1968 · N4946P · Destroyed NTSB NYC68F0446Accident · No injuriesClosedPiper PA-23 · Windsor Lks, CTApr 14, 1968 · N4329Y · Substantial damage NTSB NYC68D0068Accident · No injuriesClosedPiper PA-23 · Boston, MAJul 27, 1967 · N4330Y · Substantial damage NTSB SEA68F0078Accident · No injuriesClosedPiper PA-23 · Billings, MTJun 26, 1967 · N4986P · Substantial damage NTSB MIA67A0121Accident · 2 fatalClosedPiper PA-28 · Isle Of Palms, SCMay 17, 1967 · N9006W · Destroyed NTSB MKC67D0597Accident · No injuriesClosedPiper PA-23 · Emporia, KSMay 7, 1967 · N4960P · Substantial damage NTSB OAK67A0057Accident · 2 fatalClosedPiper PA-23 · San Mateo, CAJan 19, 1967 · N4925P · Destroyed NTSB DIA67F0023Accident · No injuriesClosedPiper PA-23 · Hagerstown, MDJan 11, 1967 · N4962P · Substantial damage NTSB NYC67F0445Accident · No injuriesClosedPiper PA-23 · Amityville, NYJan 3, 1967 · N4985P · Substantial damage NTSB NYC67A0020Accident · 4 fatalClosedPiper PA-23 · Atlantic City, NJJul 31, 1966 · N4941P · Destroyed NTSB NYC67D0135Accident · No injuriesClosedPiper PA-23 · Hyannis, MAJul 26, 1966 · N4330Y · Substantial damage NTSB NYC66A0056Accident · 1 fatalClosedPiper PA-23 · Covington, VANov 12, 1965 · N4970P · Destroyed NTSB MIA66F0237Accident · No injuriesClosedPiper PA-23 · San Juan, PRAug 23, 1965 · N4325Y · Substantial damage NTSB OAK66F0023Accident · No injuriesClosedPiper PA-23 · Eureka, CAJun 12, 1965 · N4928P · Substantial damage NTSB UNK65X1350Accident · No injuriesClosedPiper PA23 · Windsor Locks, CTJan 26, 1965 · N4941P · Substantial damage NTSB UNK65X0340Accident · No injuriesClosedPiper PA23 · Rome, OROct 19, 1964 · N4942P · Substantial damage NTSB UNK64X3275Accident · No injuriesClosedPiper PA23 · Park Hall, MDAug 8, 1964 · N4946P · Substantial damage NTSB UNK64X1989Accident · No injuriesClosedPiper PA23 · Jefferson, OHMay 28, 1964 · N4919P · Substantial damage