NTSB investigations: Piper PA-22-135
17 cases on aircraft the registry lists as Piper PA-22-135, 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 | 4 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2015 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 3 |
| 2022 | 1 |
| 2025 | 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 ('7102206')
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 ('7102206')
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 ERA25LA251Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Elberta, ALPilot’s decision to take off from a wet and unmaintained field that was unsuitable for airplane operations, resulting in a loss of control and subsequent nose over. Contributing was the pilot’s self-induced pressure to complete the flight.NTSB CEN25LA222Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Sweetwater, TXThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB WPR22LA170Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22/135 · Mesa, AZThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB ANC21LA082Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Soldotna, AKThe pilot’s failure to maintain directional control during landing, which resulted in a ground-loop.NTSB WPR21LA159Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Pullman, WAThe pilot's failure to maintain directional control during taxiing in crosswind conditions, which resulted in the airplane nosing over.NTSB WPR21LA132Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Eastsound, WAThe pilot’s failure to maintain directional control during the landing roll with a tailwind, which resulted in a landing gear collapse and collision with terrain.NTSB ERA20CA248Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA22 · Culpeper, VAThe pilot’s failure to maintain directional control on landing resulting in a runway excursion and subsequent ground loop. Contributing to the outcome were the flight instructor’s inadequate remedial actions.NTSB WPR20CA048Accident · No injuriesData collectionFinal reportPiper PA22 · Caldwell, IDThe student pilot's failure to establish a positive climb rate during an aborted landing, which resulted in abnormal runway contact, a subsequent loss of directional control, runway excursion, and the right main landing gear collapsing.NTSB GAA18CA560Accident · Minor injuriesData collectionFinal reportPiper PA22 · Hillsdale, MIThe pilot’s exceedance of the airplane’s critical angle of attack during the landing flare, which resulted in an aerodynamic stall.NTSB GAA18CA359Accident · Minor injuriesData collectionFinal reportPiper PA 22 · Hillsboro, OHThe pilot’s failure to maintain directional control during landing.NTSB GAA15CA036Accident · No injuriesData collectionFinal reportPiper PA 22-135 · Drexel, MOThe pilot's failure to maintain airplane control while taxiing in unfavorable wind conditions.NTSB ERA10CA245Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Hoensdale, PAThe pilot's improper final approach, resulting in a bounced landing and ground loop. Contributing to the accident was the pilot's lack of experience in tailwheel airplanes.NTSB CEN09CA484Accident · Minor injuriesData collectionFinal reportPiper PA22 · Terrell, TXThe pilot's improper decision to continue the approach and landing during thunderstorm activity, resulting in the loss of aircraft control.NTSB SEA08CA150Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Logan, UTThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll. Contributing to the accident was a crosswind wind gust.NTSB CHI08CA148Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Delphi, INThe pilot's inadequate compensation for the gusting crosswind during landing rollout. Contributing to the accident was the gusting crosswind condition.NTSB CHI08CA089Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Scribner, NEThe inadequate compensation for wind conditions and the directional control not obtained/maintained by the pilot during landing. A contributing factor was the crosswind.NTSB LAX08CA061Accident · No injuriesData collectionFinal reportPiper PA-22 · El Cajon, CAThe failure of both pilots to maintain directional control during landing and the flight instructor's inadequate supervision of the flight.