NTSB investigations: Piper PA-18, AK
10 cases on aircraft the registry lists as Piper PA-18, 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
| 2008 | 2 |
|---|---|
| 2009 | 2 |
| 2011 | 1 |
| 2012 | 1 |
| 2016 | 2 |
| 2019 | 1 |
| 2023 | 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\" = 'AK' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101802')
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."eventStateOrRegion" = 'AK' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101802')
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 ANC23LA049Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18 · Beluga, AKThe pilot's selection of an unsuitable takeoff site, resulting in a collision with brush-covered terrain.NTSB ANC19LA054Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 18 · Beluga, AKThe pilot’s decision to perform a takeoff with an overweight float-equipped airplane, which resulted in diminished climb performance.NTSB ANC16CA066Accident · No injuriesData collectionFinal reportPiper PA 18 · McGrath, AKThe pilot's excessive taxi speed, which resulted in a loss of control and subsequent nose over.NTSB GAA16CA204Accident · No injuriesData collectionFinal reportPiper PA 18 · Palmer, AKThe pilot's decision to land on unsuitable terrain and incorrect brake application during the landing roll, which resulted in a nose over.NTSB ANC12CA109Accident · No injuriesData collectionFinal reportPiper PA-18 · Healy, AKThe pilot's selection of unsuitable terrain for takeoff, resulting in an aborted takeoff and collision with terrain.NTSB ANC12CA003Accident · No injuriesData collectionFinal reportPiper PA-18 · Skwentna, AKThe pilot's inadequate clearance from a tree during an off-airport landing.NTSB ANC10LA011Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Willow, AKThe pilot’s failure to ensure that the airplane’s fuel selector valve was on before takeoff, resulting in a loss of engine power due to fuel starvation, and his subsequent decision to attempt a low altitude turn towards the departure airport, resulting in an…NTSB ANC09CA096Accident · No injuriesData collectionFinal reportPiper PA-18 · Fairbanks, AKThe pilot’s decision to land on unsuitable terrain, which resulted in a loss of control and a collision with trees.NTSB ANC08LA122Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot's failure to maintain sufficient airspeed to preclude a stall while maneuvering at a low altitude, resulting in an uncontrolled descent and collision with terrain.NTSB ANC08FA072Accident · 1 fatalField investigationFinal reportPiper PA-18 · Quinhagak, AKThe pilot's failure to maintain adequate airspeed while maneuvering at a low altitude in high winds, resulting in an aerodynamic stall and uncontrolled descent to the ground. Contributing to the accident were the high winds.