NTSB investigations: Piper PA-23

7 cases on aircraft the registry lists as Piper PA-23, where the first occurrence was “Loss of engine power”. 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 per year, 1983–2026: 7 cases
1983	2
1985	1
1990	1
1991	1
1998	1
2004	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 ('7102302') 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" = 350)) 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 ('7102302')
      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\" = 350))
  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 ('7102302')
    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" = 350))
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 CHI05CA001Accident · Serious injuriesData collectionFinal reportPiper PA-23-180 · Beatrice, NEThe loss of right engine power undetermined reasons. Factors to the accident were the loss of engine power at a low altitude and below the single engine best rate of climb airspeed (Vyse), and the unsuitable terrain encountered during the subsequent forced…Oct 3, 2004 · N173DC · Destroyed NTSB FTW98LA321Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Bridgeport, TXThe flight instructor's delay in recognizing and responding to the loss of right engine power which resulted in the airplane landing short of the runway. A factor was the loss of right engine power for undetermined reasons.Jul 21, 1998 · N3154P · Substantial damage NTSB ATL91LA038Accident · Serious injuriesLimited investigationFinal reportPiper PA-23 · Bolivar, TNThe interruption of fuel to the left engine due to contamination of the left fuel tank, resulting in engine stoppage.Jan 14, 1991 · N1361P · Substantial damage NTSB NYC90LA162Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-150 · Radnow Township, PAWire strike during an off airport forced landing in unsuitable terrain. Contributing factors were a power loss, caused by an engine oil leak.Jul 16, 1990 · N3EF · Destroyed NTSB LAX85LA231Accident · Minor injuriesLimited investigationFinal reportPiper PA-23 · Clovis, CAOn initial climb, at 400 ft AGL, the acft's rt engine lost fuel pressure. Then all right engie power was lost. The lt eng continued to operate normally. The plt failed to feather the rt prop & allowed the acft to slow to the point where a mvc roll commenced.…May 3, 1985 · N1461P · Substantial damage NTSB FTW84FA074Accident · 4 fatalField investigationFinal reportPiper PA-23 · Comfort, TXWitnesses stated that the acft barely cleared trees at the end of the arpt & that smoke was seen trailing from the righteng. The acft entered a right turn, stalled & impacted a ridge in a steep, near vertically banked dive. Teardowns of both engs & both props…Nov 25, 1983 · N215EC · Destroyed NTSB LAX83LA432Accident · Minor injuriesLimited investigationFinal reportPiper PA23-150 · San Diego, CAThe student & instructor (CFI) were practicing touch & go landings. During takeoff from the 4th touch & go, the left eng lost power while climbing thru about 200 ft AGL. The CFI took control of the acft. At about the same time, the student saw oil coming from…Sep 10, 1983 · N2180P · Substantial damage