NTSB investigations: Piper PA-22-108, WA
11 cases on aircraft the registry lists as Piper PA-22-108. 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
| 1964 | 3 |
|---|---|
| 1965 | 2 |
| 1967 | 1 |
| 1976 | 1 |
| 1980 | 1 |
| 1982 | 1 |
| 1986 | 1 |
| 1999 | 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.\"eventStateOrRegion\" = 'WA' 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 ('7102204'))
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" = 'WA' 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 ('7102204'))
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 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 SEA86LA042Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Ellensburg, WAA gust of wind occurred on short final and a loss of airspeed resulted at about 15 feet a.g.l the pilot failed to add power but raised the aircraft's nose to an attitude where he could no longer see the runway. Landing was accomplished to the left of the…NTSB SEA82DA056Accident · No injuriesFinal reportPiper PA-22-108 · Snohomish, WAThe pilot stated that he kept his speed up and landed farther down the runway than usual due to other traffic. After touchdown he found that the brakes had failed so he attempted to slow down the aircraft by swerving back and forth and finally turning off on…NTSB SEA80DYP13Accident · No injuriesClosedPiper PA-22 · Colville, WANTSB SEA76FYE23Accident · Serious injuriesClosedPiper PA-22 · Vashon, WANTSB SEA68D0232Accident · No injuriesClosedPiper PA-22 · Oak Harbor, WANTSB SEA66D0138Accident · No injuriesClosedPiper PA-22 · Port Angeles, WANTSB SEA65D0071Accident · No injuriesClosedPiper PA-22 · Oak Harbor, WANTSB UNK64X1023Accident · No injuriesClosedPiper PA22 · Bremerton, WANTSB UNK64X0984Accident · No injuriesClosedPiper PA22 · Fairchild Afb, WANTSB UNK64X0570Accident · No injuriesClosedPiper PA22 · Renton, WA