NTSB investigations: Piper PA-22-108
9 cases on aircraft the registry lists as Piper PA-22-108, where the first occurrence was “Loss of control - on ground/water”. 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
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1999 | 2 |
| 2006 | 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 ('7102204')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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 ('7102204')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 NYC06CA153Accident · No injuriesData collectionFinal reportPiper PA-22-108 · South Boston, VAThe pilot's failure to maintain directional control, which resulted in a collision with a rising embankment. A factor in the accident was the pilot's lack of recent flight experience.NTSB SEA99LA097Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Winthrop, WAThe pilot/passenger's failure to maintain directional control. A contributing factor was the fence.NTSB LAX99LA064Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Hayward, CAThe pilot-in-command's failure to maintain directional control. A factor in this accident was the inadvertent ground loop swerve.NTSB ANC97LA151Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Northway, AKThe pilot's failure to maintain directional control during the landing. A factor in the accident was the pilot's lack of familiarity with the airplane.NTSB CHI95LA131Accident · No injuriesLimited investigationFinal reportPiper PA-22-20-108 · Kankakee, ILThe pilot's inadequate recovery from a bounced landing.NTSB ANC89LA101Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Alder Creek, AKSelection of unsuitable terrain (unimproved strip) by the pilot. Soft/uneven terrain & low bushes on the strip, as well as alders beside the strip, were contributing factors.NTSB DEN88LA183Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Hoven, SDThe private plt and his wife were going to make a local flight in their airplane at 0215. The plt said he hand- propped the acft and moved to enter the cabin as the engine started. The acft began to move, and his wife pulled the parking brake lock, which…NTSB CHI85LA238Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Starbuck, MNPlt landed in crosswind conditions, veered off the edge of tha rwy onto rough, unleveled terrain. The nosewheel collapsed and the aircraft nosed over.NTSB NYC84LA120Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Lawrence, MAThe plt reported that the acft ballooned on landing, & on the 2nd touchdown, it veered left towards a snowbank. He maneuvered to avoid the snowbank, but the nose wheel collapsed in soft mud.