Skip to content

NTSB investigations: Piper PA-23-160, CA

27 cases on aircraft the registry lists as Piper PA-23-160. 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 ('7102304')) 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 ('7102304'))
  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 ('7102304'))
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 LAX08FA109Accident · Serious injuriesField investigationFinal reportPiper PA-23-160 · San Dimas, CAA loss of engine power in the left engine due to fuel starvation as a result of the pilot's inadequate preflight inspection and the pilot's failure to abort the takeoff following the power loss.Apr 16, 2008 · N4080P · Substantial damage NTSB LAX06CA013Accident · Minor injuriesData collectionFinal reportPiper PA-23-160 · Upland, CAthe pilot's failure to maintain directional control during landing.Oct 19, 2005 · N4252P · Substantial damage NTSB LAX01LA117Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Anza, CAThe pilot's failure to maintain control of the airplane following the opening of the cockpit/cabin door. The door came open because of improperly installed upholstery, which resulted in the inability to lock the door.Mar 14, 2001 · N333PE · Substantial damage NTSB LAX92FA374Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Concord, CAThe following Probable Cause was modified on April18, 2007, as a result of new information provided to the NTSB. The improper installation of the 1.75 inch od plug in the crankshaft by unknown maintenance personnel which resulted in an inadvertent feathering…Sep 2, 1992 · N4305Y · Destroyed NTSB LAX89LA263Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-180 · Lancaster, CAThe pilot's failure to follow established procedures in restarting the engine that drives the hydrualic pump and his failure to follow published emergency landing gear extension procedures. The pilot's decision to shut down an engine and feather the propeller…Aug 4, 1989 · N4376P · Substantial damage NTSB LAX86LA271Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Upland, CAThe plt stated that he was practicing single engine procedures and he forgot to lower the landing gear. Another plt alerted him on the radio and he attempted to lower the gear but landed with the gear only partially extended. The plt stated that he chose to…Jun 29, 1986 · N17278 · Substantial damage NTSB LAX81FUG10Accident · No injuriesClosedPiper PA-23 · Hemet, CAFeb 2, 1981 · N4220P · Substantial damage NTSB LAX80FA061Accident · 5 fatalClosedPiper PA-23 · So.Lake Tahoe, CAMar 3, 1980 · N4180P · Destroyed NTSB LAX79FUG44Accident · No injuriesClosedPiper PA-23 · Riverside, CAJun 3, 1979 · N3407P · Substantial damage NTSB OAK77FVM25Accident · No injuriesClosedPiper PA-23 · Hollister, CAAug 21, 1977 · N3417P · Substantial damage NTSB OAK75AP044Accident · 5 fatalClosedPiper PA-23 · Healdsburg, CAMar 18, 1975 · N246Z · Destroyed NTSB OAK71FVG90Accident · No injuriesClosedPiper PA-23 · Elk Grove, CAJun 30, 1971 · N4302Y · Substantial damage NTSB LAX70AL053Accident · 2 fatalClosedPiper PA-23 · Pacoima, CAMar 5, 1970 · N3496P · Destroyed NTSB LAX70D0047Accident · No injuriesClosedPiper PA-23 · Palm Springs, CAJul 13, 1969 · N436CB · Substantial damage NTSB LAX69A0054Accident · 2 fatalClosedPiper PA-23 · Costa Mesa, CAMar 16, 1969 · N4308P · Destroyed NTSB LAX69F0241Accident · Serious injuriesClosedPiper PA-23 · Hawthorne, CAJan 15, 1969 · N3313P · Destroyed NTSB LAX68F0401Accident · No injuriesClosedPiper PA-23 · Long Beach, CAApr 6, 1968 · N4106P · Substantial damage NTSB OAK68D0352Accident · No injuriesClosedPiper PA-23 · San Carlos, CAMar 18, 1968 · N4410P · Substantial damage NTSB LAX68F0218Accident · No injuriesClosedPiper PA-23 · Long Beach, CANov 21, 1967 · N4106P · Substantial damage NTSB LAX68D0118Accident · No injuriesClosedPiper PA-23 · Torrance, CAAug 28, 1967 · N4106P · Substantial damage NTSB LAX68D0042Accident · No injuriesClosedPiper PA-23 · Bakersfield, CAJun 24, 1967 · N4279P · Substantial damage NTSB OAK67D0260Accident · No injuriesClosedPiper PA-23 · San Carlos, CAAug 29, 1966 · N4302P · Substantial damage NTSB OAK67A0005Accident · 1 fatalClosedPiper PA-23 · San Jose, CAJul 11, 1966 · N5550V · Destroyed NTSB LAX66D0118Accident · No injuriesClosedPiper PA-23 · Thousand Oaks, CAJul 21, 1965 · N4120P · Substantial damage NTSB LAX65F0072Accident · Minor injuriesClosedPiper PA-23 · Fullerton, CAMar 16, 1965 · N4307Y · Substantial damage NTSB LAX66F0066Accident · Minor injuriesClosedPiper PA-23 · Lucerne Valy, CAJan 9, 1965 · N3251P · Destroyed NTSB UNK64X0181Accident · No injuriesClosedPiper PA23 · Long Beach, CAJan 6, 1964 · N4209P · Substantial damage