NTSB investigations: Piper PA-36-285
8 cases on aircraft the registry lists as Piper PA-36-285, where the sequence of events included Collision with terr/obj (non-CFIT). 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
| 2011 | 1 |
|---|---|
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2017 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2024 | 1 |
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 ('7103610', '7103611')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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 ('7103610', '7103611')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 WPR25LA008Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-36-285 · Marana, AZOn October 8, 2024, about 0745 mountain standard time, a Piper PA-36-285, N9928P, was substantially damaged when it was involved in an accident near Marana, Arizona. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN20LA381Accident · No injuriesClass 3 · LimitedFinal reportPiper PA36 · Ord, NEThe pilot’s failure to maintain adequate airspeed while in a turn during initial climb and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at a low altitude.NTSB GAA19CA437Accident · Minor injuriesData collectionFinal reportPiper PA36 · Bancroft, IDThe pilot's exceedance of the airplane's critical angle of attack during a low-altitude turn, which resulted in an aerodynamic stall.NTSB GAA17CA453Accident · No injuriesData collectionFinal reportPiper PA36 · McCook, NEThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack while maneuvering downwind during an agricultural application flight, which resulted in an aerodynamic stall at low altitude.NTSB CEN14LA519Accident · No injuriesLimited investigationFinal reportPiper PA 36-285 · Woodburn, INA loss of engine power during takeoff for reasons that could not be determined based on the available information.NTSB CEN13LA280Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-285 · Galena, KSThe loss of engine power due to improper maintenance by an unknown individual that led to the degradation and deterioration of the No. 2 piston, which was undetected because of overdue maintenance.NTSB CEN12CA542Accident · No injuriesData collectionFinal reportPiper PA-36-285 · Harvey, NDThe pilot’s decision to take off with the airplane over its maximum gross weight on a turf runway and with a tailwind, and his subsequent failure to maintain airplane control.NTSB WPR11CA281Accident · No injuriesData collectionFinal reportPiper PA-36-285 · Havre, MTThe pilot's failure to maintain directional control during takeoff.