Fatal NTSB investigations: Piper PA-24, CA

7 cases on aircraft the registry lists as Piper PA-24. 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.

Cases per year

19622026
Fatal NTSB investigations: Piper PA-24, CA per year, 1962–2026: 7 cases
19621
19731
19791
19871
19921
19991
20001

Latest cases

Query with SQL
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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102402'))
  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.

NTSB LAX00FA302Accident · 1 fatalField investigationFinal reportPiper PA-24 · Independence, CAThe pilot's failure to maintain terrain clearance. Factors included night conditions, cockpit lighting, which compromised the pilot's night vision, and drug impairment.Aug 16, 2000 · N300P · Substantial damageNTSB LAX99FA316Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · June Lake, CAThe pilot's continued VFR flight into known instrument meteorological conditions, including icing, which resulted in an in-flight collision with mountainous terrain.Sep 18, 1999 · N5673P · DestroyedNTSB LAX93FA024Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · Kelso, CAThe pilot's poor preflight planning; his inadequate weather evaluation; and his intentional VFR flight into instrument meteorological conditions. Contributing to the accident was the turbulence, rain and low clouds.Oct 31, 1992 · N7902P · DestroyedNTSB LAX87FA088Accident · 3 fatalField investigationFinal reportPiper PA-24-180 · Oceano, CAShortly after takeoff, the surviving pax (s/p) noticed the acft began losing alt. She heard the plt comment about a 'clicking noise in the left wing' which she also heard & said sounded like metal clicking together. Ground witnesses noticed a change in eng…Jan 17, 1987 · N5982P · Substantial damageNTSB LAX80FA020Accident · 3 fatalClosedPiper PA-24 · Alturas, CANov 24, 1979 · N5664P · DestroyedNTSB LAX73AL033Accident · 1 fatalClosedPiper PA-24 · Avalon, CAJan 14, 1973 · N5334P · DestroyedNTSB LAX94LA336Accident · 4 fatalLimited investigationClosedPiper PA24-180 · Bridgeport, CAIn-flight collision with terrain for unknown reason(s).Jul 20, 1962 · N5069P · Destroyed