Skip to content

NTSB investigations: Piper PA-23, CA

42 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" = 'CA' 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\" = 'CA' 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" = 'CA' 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 LAX06FA289Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Santa Maria, CAThe non-instrument rated pilot's decision to continue flight into instrument meteorological conditions resulting in spatial disorientation and a loss of control.Sep 8, 2006 · N3082P · Destroyed NTSB LAX95LA045Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Oxnard, CAthe pilot's failure to ensure the aircraft was secured prior to attempting an engine start by handpropping.Dec 8, 1994 · N2027P · Substantial damage NTSB LAX92LA200Accident · No injuriesLimited investigationFinal reportPiper PA23-150 · Modesto, CAAn engine power loss due to fuel contamination.May 5, 1992 · N2310B · Substantial damage NTSB LAX90LA087Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-150 · Long Beach, CAThe pilot's failure to raise the gear and flaps during a go-around resulting in a loss of control. A contributing factor was the pilot's lack of experience in a PA-23.Feb 10, 1990 · N2118P · 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 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 NTSB LAX82FA010Accident · 2 fatalClosedPiper PA-23 · San Fernando, CANov 4, 1981 · N1099P · Destroyed NTSB OAK79DVA21Accident · No injuriesClosedPiper PA-23 · Visalia, CADec 21, 1978 · N1437P · Substantial damage NTSB OAK78DVD14Accident · No injuriesClosedPiper PA-28R · San Francisco, CAJan 22, 1978 · N1302P · Destroyed NTSB OAK78FVD08Accident · No injuriesClosedPiper PA-23 · Hayward, CAOct 31, 1977 · N1302P · Substantial damage NTSB OAK76FVG64Accident · Minor injuriesClosedPiper PA-23 · Alturas, CAApr 4, 1976 · N1092P · Destroyed NTSB OAK76AP027Accident · 2 fatalClosedPiper PA-23 · Orinda, CANov 5, 1975 · N1225P · Destroyed NTSB LAX76FUA02Accident · No injuriesClosedPiper PA-23 · Torrance, CAJul 1, 1975 · N1052P · Substantial damage NTSB OAK74DVA58Accident · No injuriesClosedPiper PA-23 · Stratford, CAApr 10, 1974 · N1074P · Substantial damage NTSB LAX72DVA81Accident · No injuriesClosedPiper PA-23 · Mcfarland, CAJun 13, 1972 · N1282P · Substantial damage NTSB OAK72AP030Accident · 4 fatalClosedPiper PA-23 · Redding, CAFeb 23, 1972 · N1149P · Destroyed NTSB OAK70DVM16Accident · No injuriesClosedPiper PA-23 · San Carlos, CAApr 26, 1970 · N3197P · Substantial damage NTSB LAX70FUD03Accident · Minor injuriesClosedPiper PA-23 · Compton, CAFeb 25, 1970 · N1055P · Substantial damage NTSB OAK70F0205Accident · No injuriesClosedPiper PA-23 · San Rafael, CADec 21, 1969 · N2101P · Substantial damage NTSB OAK70D0200Accident · No injuriesClosedPiper PA-23 · San Jose, CANov 9, 1969 · N1038P · Substantial damage NTSB LAX70F0179Accident · No injuriesClosedPiper PA-23 · Calexico, CAOct 15, 1969 · N1140P · Substantial damage NTSB LAX70D0048Accident · No injuriesClosedPiper PA-23 · Riverside, CAJul 10, 1969 · N1405P · Substantial damage NTSB OAK69D0186Accident · No injuriesClosedPiper PA-23 · Morgan Hill, CANov 5, 1968 · N1152P · Substantial damage NTSB LAX68F0152Accident · Minor injuriesClosedPiper PA-23 · Tehachapi, CASep 12, 1967 · N1250P · Substantial damage NTSB LAX68A0019Accident · 2 fatalClosedPiper PA-23 · Yucaipa, CAAug 9, 1967 · N2228P · Destroyed NTSB OAK68D0009Accident · No injuriesClosedPiper PA-23 · Oakland, CAMay 1, 1967 · N1371P · No damage NTSB LAX67D0369Accident · No injuriesClosedPiper PA-23 · San Diego, CAApr 23, 1967 · N3211P · Substantial damage NTSB LAX67D0343Accident · No injuriesClosedPiper PA-23 · Oceanside, CAApr 3, 1967 · N2176P · Substantial damage NTSB OAK67A0062Accident · 2 fatalClosedPiper PA-23 · Oakland, CAFeb 17, 1967 · N2043P · 2 aircraft · Destroyed NTSB LAX67D0259Accident · No injuriesClosedPiper PA-23 · Ontario, CAJan 22, 1967 · N2043P · Substantial damage NTSB OAK67D0113Accident · No injuriesClosedPiper PA-23 · Fresno, CASep 20, 1966 · N4631P · Substantial damage NTSB LAX67F0146Accident · No injuriesClosedPiper PA-23 · S Bernardino, CASep 12, 1966 · N2164P · Substantial damage NTSB LAX67D0041Accident · No injuriesClosedPiper PA-23 · Torrance, CAJun 23, 1966 · N2291P · Substantial damage NTSB OAK67D0014Accident · No injuriesClosedPiper PA-23 · Mammoth Lakes, CAMay 27, 1966 · N1438P · Substantial damage NTSB LAX66A0034Accident · 1 fatalClosedPiper PA-23 · San Diego, CASep 30, 1965 · N3025P · Destroyed NTSB OAK66D0108Accident · No injuriesClosedPiper PA-23 · San Francisco, CAAug 26, 1965 · N2214P · Substantial damage NTSB LAX66D0221Accident · No injuriesClosedPiper PA-23 · Long Beach, CAJun 14, 1965 · N1133P · Substantial damage NTSB UNK65X1340Accident · No injuriesClosedPiper PA23 · Vacaville, CAJan 24, 1965 · N2139P · Substantial damage NTSB UNK64X2356Accident · No injuriesClosedPiper PA23 · Lake Tahoe, CAJun 18, 1964 · N3068P · Substantial damage NTSB UNK64X1363Accident · No injuriesClosedPiper PA23 · Santa Ana, CAApr 18, 1964 · N1317P · 2 aircraft · No damage NTSB UNK64X0736Accident · 1 fatalClosedPiper PA23 · Idria, CAFeb 28, 1964 · N3186P · Destroyed NTSB UNK64X0228Accident · No injuriesClosedPiper PA23 · Corona, CAJan 12, 1964 · N1166P · Substantial damage