NTSB investigations: Piper PA-23-160

6 cases on aircraft the registry lists as Piper PA-23-160, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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

19832026

NTSB investigations: Piper PA-23-160 per year, 1983–2026: 6 cases
1983	1
1989	1
1991	1
1994	1
1995	1
1998	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102304') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 351)) 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 ('7102304')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 351))
  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 ('7102304')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 351))
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 FTW98FA229Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Guthrie, OKThe designated pilot examiner's decision to execute a single engine go-around which exceeded the airplane's engine out climb capability in the gear down configuration. Factors were the arcing of an electrical wire that grounded the engine starter and the high…May 18, 1998 · N4410P · Destroyed NTSB ATL95LA094Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Dayton, TNInstallation of an improper crankshaft oil seal which eventually separated from its seat resulting in excessive oil loss, and the pilot's improper inflight planning in that he did not allow sufficient time to lower the landing gear.May 6, 1995 · N4300Y · Destroyed NTSB CHI94LA351Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · West Chicago, ILthe pilot's failure to use the manual hydraulic pump to lower the landing gear. Factors were the failure of the fuel selector handle, the subsequent fuel starvation, and the pilot's failure to properly crossfeed and restart the left engine.Sep 30, 1994 · N5272A · Substantial damage NTSB NYC91LA092Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Westbrook, MEImproper emergency procedures by the pilot. Factors related to the accident were: the pilot's lack of experience and flight time in type of airplane, the pilots decision to take an airplane with a known mechanical defect, a leaky accelerator pump seal on the…Mar 23, 1991 · N4155P · Substantial damage NTSB SEA89FA040Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Carson City, NVLoss of power on the left engine due to a foreign object which obstructed the fuel flow, and the pilot's failure to maintain airspeed above VMC during his attempted return to the airfield. Contributing to the accident was the lack of recent flight time by the…Jan 27, 1989 · N4391P · Destroyed NTSB FTW83LA082Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Mangum, OKThe pilot stated that shortly after takeoff the left engine surged twice and quit. He elected to make a precautionary landing in an open field which was soft from melting snow. During roll out the nose wheel dug in and the drag link broke which collapsed the…Jan 7, 1983 · N4171P · Substantial damage