NTSB investigations: Piper PA-24
9 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
| 1984 | 1 |
|---|---|
| 1989 | 1 |
| 1992 | 2 |
| 1994 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2003 | 2 |
Where
Open the mapLatest 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.\"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.
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."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" 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 CHI03LA160Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Harvey, NDThe aborted takeoff not performed by the pilot. The inadequate short field takeoff procedure by the pilot and the short grass runway were contributing factors.NTSB CHI03LA064Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Halstead, KSFailure by the flight crew to execute an aborted takeoff when acceleration degraded and the improper soft field takeoff procedure as flown by the private pilot. Contributing factors were inadequate supervision by the flight instructor and the tailwind…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 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.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 ATL92LA083Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Moontown, ALThe pilot's excessive reference airspeed on landing, improper use of the wheel brakes, and his delay in executing an aborted landing. A factor was the wet runway surface.NTSB 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.NTSB MIA84LA152Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Valdosta, GAThe instructor plt (CFI) stated that he was giving a private plt a biennial flt review & that the private plt was the plt-in-command (PIC). While in the traffic pattern for their 2nd landing, they heard another acft entering the pattern, but they were not…