Skip to content

NTSB investigations: Piper PA-22-160, CA

35 cases on aircraft the registry lists as Piper PA-22-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 ('7102214')) 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 ('7102214'))
  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 ('7102214'))
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 WPR25LA121Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Tracy, CAThe pilot's failure to maintain directional control during the landing roll.Mar 25, 2025 · N9528D · Substantial damage NTSB WPR12CA340Accident · Minor injuriesData collectionFinal reportPiper PA-22-160 · McKinleyville, CAThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident were the pilot’s lack of experience in the accident airplane make and model and his lack of knowledge regarding the fuel system.Aug 2, 2012 · N3442Z · Substantial damage NTSB WPR10LA083Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · San Jose, CAA total loss of engine power due to water contamination in the fuel system as a result of the pilot's inadequate preflight inspection.Dec 15, 2009 · N9547D · Substantial damage NTSB LAX05CA019Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Vacaville, CAthe pilot's failure to maintain directional control during the landing rollout.Oct 30, 2004 · N8158D · Substantial damage NTSB LAX02LA265Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Ruth, CAThe pilot's inadequate compensation for the wind conditions and failure to maintain control.Aug 29, 2002 · N3607Z · Substantial damage NTSB LAX02LA122Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Vacaville, CAThe pilot's failure to maintain directional control.Mar 30, 2002 · N8158D · Substantial damage NTSB LAX01LA081Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Camarillo, CAThe failure of the pilot to maintain directional control during takeoff.Jan 27, 2001 · N9411D · Substantial damage NTSB LAX00LA267Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Lancaster, CAThe pilot's inadequate compensation for gusty winds conditions that resulted in the collision with a power line during final approach.Jul 15, 2000 · N8768D · Substantial damage NTSB LAX98LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Clarksburg, CAA total loss of engine power for undetermined non-mechanical reasons. A contributing factor in the landing nose-over was the presence of the soft terrain.May 15, 1998 · N198TP · Substantial damage NTSB LAX93LA257Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Oakdale, CAthe failure of the flying pilot to maintain directional control of the aircraft during the takeoff ground roll. A factor in the accident was the flying pilot's lack of recent total flight time and recent experience in conventional landing gear equipped…Jun 14, 1993 · N9618D · Substantial damage NTSB LAX89LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · El Cajon, CAThe inadequate maintenance of the airplane & inadequate preflight inspection which resulted in the undetection of contaminated fuel.Jun 19, 1989 · N8836D · Substantial damage NTSB LAX89LA148Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Lancaster, CAImproper planning/decision by the pilot. Strong/gusty winds contributed to the accident.Apr 1, 1989 · N3508Z · Substantial damage NTSB LAX87LA022Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Big Bear City, CAThe acft veered off rwy 7 during landing roll. The plt indicated the acft veered to the right. There was a single rubber skid mark aprx 150 ft long found on the rwy. The wind was reported by another plt to be 'down the runway at 10-15 knots.' Examination of…Oct 20, 1986 · N9206D · Substantial damage NTSB LAX84LA175Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Chino, CAThe acft groundlooped and ran off the side of the rwy during landing.Feb 12, 1984 · N3151Z · Substantial damage NTSB LAX80DUG55Accident · No injuriesClosedPiper PA-22 · Adelanto, CAAug 14, 1980 · N9547D · Substantial damage NTSB OAK79DXQ06Accident · No injuriesClosedPiper PA-22 · Honey Lake, CADec 9, 1978 · N9427D · Substantial damage NTSB OAK77FA016Accident · 1 fatalClosedPiper PA-22 · Clearlake Oaks, CAFeb 5, 1977 · N9015D · Destroyed NTSB OAK76DVG40Accident · No injuriesClosedPiper PA-22 · Angwin, CADec 26, 1975 · N162 · Substantial damage NTSB OAK76DVW10Accident · No injuriesClosedPiper PA-22 · Bishop, CADec 24, 1975 · N8689D · Destroyed NTSB OAK74DVA18Accident · No injuriesClosedPiper PA-22 · Kettleman, CASep 5, 1973 · N9411D · Substantial damage NTSB OAK73DVG70Accident · No injuriesClosedPiper PA-22 · Calistoga, CAJun 24, 1973 · N2803Z · Substantial damage NTSB OAK73DVG14Accident · No injuriesClosedPiper PA-22 · Redding, CAAug 26, 1972 · N8825D · Substantial damage NTSB LAX72FUQ82Accident · Minor injuriesClosedPiper PA-22 · Inyokern, CAApr 16, 1972 · N3154Z · Substantial damage NTSB LAX71DUG51Accident · No injuriesClosedPiper PA-22 · Desert Cntr, CAMar 11, 1971 · N8855D · Substantial damage NTSB OAK70AP044Accident · 1 fatalClosedPiper PA-22 · Clovis, CAFeb 15, 1970 · N3079Z · Destroyed NTSB LAX69D0188Accident · Minor injuriesClosedPiper PA-22 · Bermuda Dunes, CANov 24, 1968 · N9616D · Substantial damage NTSB LAX69D0065Accident · No injuriesClosedPiper PA-22 · Arvin, CAJul 26, 1968 · N9960D · Substantial damage NTSB OAK68D0273Accident · Minor injuriesClosedPiper PA-22 · Visalia, CAJan 21, 1968 · N3064Z · Substantial damage NTSB OAK68D0212Accident · No injuriesClosedPiper PA-22 · Placerville, CAAug 6, 1967 · N8552D · Substantial damage NTSB LAX67A0113Accident · 2 fatalClosedPiper PA-22 · S. Clemente, CAJun 3, 1967 · N3072Z · Destroyed NTSB LAX67F0004Accident · No injuriesClosedPiper PA-22 · Van Nuys, CAMay 30, 1966 · N8157D · Substantial damage NTSB OAK66F0107Accident · No injuriesClosedPiper PA-22 · Sacramento, CAOct 24, 1965 · N8725D · Substantial damage NTSB LAX66D0008Accident · No injuriesClosedPiper PA-22 · Inyokern, CAMar 12, 1965 · N8538D · Substantial damage NTSB UNK65X0202Accident · No injuriesClosedPiper PA22 · Sacramento, CAOct 9, 1964 · N3610Z · Substantial damage NTSB UNK64X2523Accident · No injuriesClosedPiper PA22 · Hilmar, CAJun 27, 1964 · N9203D · Substantial damage