NTSB investigations: Piper PA-22-160
17 cases on aircraft the registry lists as Piper PA-22-160, where the sequence of events included Loss of control on ground. 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 | 1 |
|---|---|
| 2009 | 3 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2017 | 2 |
| 2018 | 1 |
| 2021 | 1 |
| 2023 | 1 |
| 2025 | 2 |
| 2026 | 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 ('7102214')
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\" = '230' 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 ('7102214')
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" = '230' 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 WPR26LA290Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA22 · Goldendale, WANTSB WPR25LA206Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Page, AZThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.NTSB WPR25LA121Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Tracy, CAThe pilot's failure to maintain directional control during the landing roll.NTSB ERA23LA186Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · White Plains, NYThe pilot's failure to maintain directional control during the landing rollout in gusting wind, which resulted in a runway excursion and subsequent nose over.NTSB WPR21LA160Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Cottonwood, AZThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB GAA18CA363Accident · No injuriesData collectionFinal reportPiper PA22 · Yakutat, AKThe pilot’s failure to maintain directional control during landing.NTSB GAA17CA210Accident · No injuriesData collectionFinal reportPiper PA22 · Soldotna, AKThe pilot’s unstabilized approach and failure to attain the proper touchdown point, which resulted in a runway overrun and collision with a snowbank.NTSB GAA17CA187Accident · No injuriesData collectionFinal reportPiper PA22 · Ruby, AKThe pilot’s failure to maintain directional control while landing in flat light conditions on a hard-packed snow-covered landing area.NTSB WPR14CA246Accident · No injuriesData collectionFinal reportPiper PA 22-160 · Jackson, MTThe pilot's failure to maintain directional control of the airplane during landing roll.NTSB CEN13CA290Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Pella, IAThe pilot's failure to maintain directional control during landing.NTSB ERA12LA505Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Bay Minette, ALThe separation of the tailwheel linkage for reasons that could not be determined because the linkage was not located, which resulted in a loss of directional control during landing.NTSB WPR11CA235Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Yakima, WAThe pilot’s failure to maintain directional control upon landing.NTSB WPR10CA170Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Phoenix, AZThe student pilot's inadequate compensation for the quartering tailwind during landing and the flight instructor's delay in taking remedial action.NTSB CEN09CA464Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Fort Collins, COThe pilot's failure to maintain directional control while landing in gusty, crosswind conditions.NTSB CEN09CA237Accident · No injuriesData collectionFinal reportPiper PA-22-160 · North Little Rock, ARThe pilot's inadequate compensation for the wind conditions during takeoff.NTSB WPR09CA136Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Ogden, UTThe loss of directional control during the landing roll due to the separation of the tailwheel spring retaining clip for unknown reasons.NTSB NYC08CA283Accident · Minor injuriesData collectionFinal reportPiper PA-22-160 · Cleveland, GAThe pilot's improper decision to land with a tailwind, and his failure to maintain aircraft control during the landing. Contributing to the accident was the tailwind.