NTSB investigations: Piper PA-12
8 cases on aircraft the registry lists as Piper PA-12, where the sequence of events included Hard landing. 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 |
|---|---|
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2018 | 1 |
| 2020 | 2 |
| 2023 | 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 ('7101202')
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\" = '092' 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 ('7101202')
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" = '092' 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 ERA23LA356Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-12 · Myrtle Beach, SCThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN21LA082Accident · No injuriesClass 3 · LimitedFinal reportPiper PA12 · Spearfish, SDA total loss of engine power during initial climb for undetermined reasons.NTSB ERA20CA268Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 12 · Linconville, METhe pilot's improper landing flare, which resulted in a bounced landing and subsequent main landing gear collapse.NTSB GAA18CA320Accident · No injuriesData collectionFinal reportPiper PA 12 · Nulato, AKThe pilot’s improper landing flare, which resulted in a hard landing on upsloping terrain, and his subsequent failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during an attempted go-around, which resulted in…NTSB GAA16CA232Accident · No injuriesData collectionFinal reportPiper PA 12 · Simsbury, CTThe pilot's failure to attain the proper touchdown point and the airplane's subsequent impact with a fence during an attempted aborted landing.NTSB GAA16CA008Accident · No injuriesData collectionFinal reportPiper PA · Glennallen, AKThe pilot's failure to maintain clearance from trees during the approach to land, resulting in a collision with trees.NTSB ERA14LA103Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Zephyrhills, FLThe pilot’s inadequate compensation for gusting wind conditions, which resulted in a hard landing that produced forces beyond the structural capability of the airframe.NTSB ANC11CA063Accident · No injuriesData collectionFinal reportPiper PA-12 · Gulkana, AKThe pilot's inadequate recovery from a bounced landing.