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
| 1962 | 1 |
|---|---|
| 1973 | 1 |
| 1979 | 1 |
| 1987 | 1 |
| 1992 | 1 |
| 1999 | 1 |
| 2000 | 1 |
Where
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.
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" DESCRun 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 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.NTSB 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.NTSB 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.NTSB 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…NTSB LAX80FA020Accident · 3 fatalClosedPiper PA-24 · Alturas, CANTSB LAX73AL033Accident · 1 fatalClosedPiper PA-24 · Avalon, CANTSB LAX94LA336Accident · 4 fatalLimited investigationClosedPiper PA24-180 · Bridgeport, CAIn-flight collision with terrain for unknown reason(s).