Skip to content

NTSB investigations: Piper PA-23-250, OH

24 cases on aircraft the registry lists as Piper PA-23-250. 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."eventStateOrRegion" = 'OH' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102308')) 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.\"eventStateOrRegion\" = 'OH' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102308'))
  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."eventStateOrRegion" = 'OH' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102308'))
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 GAA17CA282Accident · No injuriesData collectionFinal reportPiper PA23 · Fremont, OHThe pilot’s failure to maintain an adequate glidepath during approach, which resulted in an impact with a semi-truck.May 9, 2017 · N63944 · Substantial damage NTSB IAD97LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Elyria, OHThe pilot's fuel mismanagement which led to fuel starvation to one engine, and the pilot's failure to maintain control of the airplane.Dec 7, 1996 · N4911P · Substantial damage NTSB BFO94LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250B · Kent, OHThe pilot's failure to maintain directional control.Jun 17, 1994 · N5257Y · Substantial damage NTSB NYC94LA053Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Parrfield, OHThe pilot's mismanagment of the fuel supply by the improper positioning of the fuel selector valves, which resulted in fuel starvation and the total loss of engine power.Mar 6, 1994 · N99BR · Substantial damage NTSB ATL88LA103Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Cleveland, OHThe plt rptd that both engines began to surge shortly after t/o during climb. The engines subsequently lost pwr completely, and the plt made a forced ldg in trees. Post-crash exam revealed that the fuel selectors were in the inbd tank positions. The lt inbd…Mar 5, 1988 · N198CD · Destroyed NTSB ATL88IA096Incident · No injuriesIncident investigationFinal reportPiper PA-23-250 · Elyria, OHFeb 21, 1988 · N5740Y · Minor damage NTSB ATL86LA224Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Wadsworth, OHDuring the landing roll on rwy 02, the pilot lost directional control and the acft veered off the right side of the runway. The reported winds were 290 degrees at 8 knots. The wreckage examination failed to disclose any malfunction or failure. The acft brake…Aug 24, 1986 · N50HZ · Substantial damage NTSB CHI85LA079Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · New Philadelphi, OHPlt felt vibration and reduced power on both engines to idle. Plt heard a 'thud' and discovered the left propeller had separated cutting through the nose of the acft as it departed. The propeller was not located. Two of the six propeller bolts remained with…Dec 27, 1984 · N6505Y · Substantial damage NTSB CHI83FA324Accident · No injuriesField investigationFinal reportPiper PA-23-250 · Youngstown, OHDuring an IFR flt, the acft was leveled at 13,000 ft & the power was set at 18 inches manifold pressure & 2300 RPM. Aprx 5 min later, the right eng began to surge to 3000 RPM & almost 'pegged.' The plt attempted to control the right propeller. Finally, the…Jul 19, 1983 · N54072 · Substantial damage NTSB CHI83LA211Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · East Liverpool, OHDuring the approach, the plt neglected to extend the gear, aand subsequently, made a wheels up landing.May 13, 1983 · N5512Y · Substantial damage NTSB CHI82FA011Accident · Serious injuriesClosedPiper PA-23 · Niles, OHNov 5, 1981 · N2457M · Destroyed NTSB CHI77FEI38Accident · No injuriesClosedPiper PA-23 · Painesville, OHSep 14, 1977 · N2428U · Substantial damage NTSB CHI77FA043Accident · 2 fatalClosedPiper PA-23 · Norwalk, OHMay 19, 1977 · N124MW · Destroyed NTSB CHI77FEK08Accident · Serious injuriesClosedPiper PA-23 · Mt Sterling, OHDec 6, 1976 · N5046Y · Destroyed NTSB CHI75FEK27Accident · No injuriesClosedPiper PA-23 · Columbus, OHMay 23, 1975 · N6046Y · Substantial damage NTSB CHI71DEI58Incident · No injuriesClosedPiper PA-23 · Alliance, OHJun 10, 1971 · N13994 · Minor damage NTSB CHI70FGG03Accident · No injuriesClosedPiper PA-23 · Van Wert, OHJan 11, 1970 · N5770Y · Substantial damage NTSB CHI69D0057Accident · No injuriesClosedPiper PA-23 · Lorain, OHMay 22, 1968 · N5070Y · Substantial damage NTSB CHI68F0722Accident · No injuriesClosedPiper PA-23 · Findlay, OHApr 25, 1968 · N5752Y · Substantial damage NTSB CHI68F0610Accident · No injuriesClosedPiper PA-23 · Middletown, OHFeb 24, 1968 · N4874P · Substantial damage NTSB CHI66F0536Accident · No injuriesClosedPiper PA-23 · Columbus, OHFeb 1, 1966 · N5512Y · Substantial damage NTSB CHI66D0051Accident · No injuriesClosedPiper PA-23 · Newark, OHJul 8, 1965 · N4528P · Substantial damage NTSB UNK65X0570Accident · No injuriesClosedPiper PA23 · Wilmington, OHNov 5, 1964 · N120BB · Substantial damage NTSB UNK64X2038Accident · No injuriesClosedPiper PA23 · Cleveland, OHMay 30, 1964 · N5141Y · Substantial damage