Fatal NTSB investigations: Piper PA-24

5 cases on aircraft the registry lists as Piper PA-24, where the first occurrence was “In flight collision with terrain/water”. 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

19892026
Fatal NTSB investigations: Piper PA-24 per year, 1989–2026: 5 cases
19891
19921
19941
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.\"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')
      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\" = 230))
  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 FTW95FA075Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Van Horn, TXThe pilot's failure to maintain proper altitude. Factors were reduced light conditions, clouds, and the pilot's premature descent.Dec 27, 1994 · N8112P · 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 DEN89FA208Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · Grantsville, UTImproper in-flight planning/decision by the pilot, by entering a box canyon with insufficient altitude to assure a safe exit. Contributing factors were: box canyon, rising terrain, and high density altitude.Sep 7, 1989 · N7835P · Destroyed