Skip to content

NTSB investigations: Piper PA-23, OH

19 cases on aircraft the registry lists as Piper PA-23. 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 ('7102302')) 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 ('7102302'))
  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 ('7102302'))
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 CEN12LA401Accident · Serious injuriesLimited investigationFinal reportPiper PA-23 · Baltic, OHLoss of engine power due to fuel starvation as a result of particulate contaminant on the carburetor screens.Jun 28, 2012 · N3170P · Substantial damage NTSB CEN11FA557Accident · 3 fatalField investigationFinal reportPiper PA-23 · Millersburg, OHThe pilot’s failure to maintain clearance with terrain during the landing approach in night conditions and fog. Contributing to the accident was the pilot’s inadequate preflight planning.Aug 8, 2011 · N2286P · Substantial damage NTSB IAD03LA063Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-180 · Akron, OHthe pilot's failure to maintain minimum control single engine airspeed (Vmc) during a loss of power on one engine, which resulted in a loss of control in flight an in-flight collision with terrain. A factor was a shifted main journal, which resulted in a…Jul 12, 2003 · N825SA · Destroyed NTSB ATL86FA092Accident · 1 fatalField investigationFinal reportPiper PA-23 · Toledo, OHN3124P crashed while attempting an ILS approach to rwy 07 at express airport in Toledo, OH. The pilot had attempted an approach at metcalf airport but missed the approach because of the weather. The aircraft crashed about 1 mile short of the airport in a…Mar 13, 1986 · N3124P · No damage NTSB CHI84LA408Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Defiance, OHDuring initial takeoff climb at alt of 300 ft AGL, 9 1/4 inches of rt engine prop blade separated. Forced landing was make in field during which time the rt wing contacted a tree. Metallurgical examination revealed progressive fatigue over 75% of the…Sep 30, 1984 · N1424P · Substantial damage NTSB CHI81FEK10Accident · No injuriesClosedPiper PA-23 · Van Wert, OHJan 10, 1981 · N94M · Substantial damage NTSB CHI79FEI40Accident · Serious injuriesClosedGeronimo PA-23 · Middlefield, OHAug 16, 1979 · N2292P · Destroyed NTSB CHI77FA017Accident · 1 fatalClosedPiper PA-23 · North Royalton, OHDec 23, 1976 · N2264P · Destroyed NTSB CHI72FEG22Accident · No injuriesClosedPiper PA-23 · Miamisburg, OHNov 5, 1971 · N3129P · Substantial damage NTSB CHI71FEK42Accident · No injuriesClosedPiper PA-23 · Mt.Vernon, OHJun 27, 1971 · N2120P · Substantial damage NTSB CHI71FGD42Accident · Serious injuriesClosedPiper PA-23 · Sheffield, OHFeb 3, 1971 · N1397P · Destroyed NTSB CHI70FGG19Accident · No injuriesClosedPiper PA-23 · Johnston, OHMay 21, 1970 · N1333P · Substantial damage NTSB CHI69D0421Accident · No injuriesClosedPiper PA-23 · Bowling Grn, OHNov 26, 1968 · N3200P · Substantial damage NTSB CHI69F0121Accident · No injuriesClosedPiper PA-23 · Cincinnati, OHAug 4, 1968 · N2189P · Substantial damage NTSB CHI68F0585Accident · Minor injuriesClosedPiper PA-23 · Gahanna, OHFeb 7, 1968 · N1198P · Substantial damage NTSB CHI67F0602Accident · No injuriesClosedPiper PA-23 · Gahanna, OHApr 23, 1967 · N1459P · Substantial damage NTSB CHI67F0214Accident · No injuriesClosedPiper PA-23 · Cincinnatti, OHSep 22, 1966 · N2123P · Substantial damage NTSB CHI66F0444Accident · No injuriesClosedPiper PA-23 · Columbus, OHNov 24, 1965 · N1190P · Substantial damage NTSB UNK64X1437Accident · 1 fatalClosedPiper PA-23 · Lilly Chapel, OHApr 24, 1964 · N92N · Destroyed