NTSB investigations: Piper PA-22, WA
15 cases on aircraft the registry lists as Piper PA-22. 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
| 1965 | 3 |
|---|---|
| 1966 | 2 |
| 1968 | 1 |
| 1970 | 1 |
| 1973 | 1 |
| 1975 | 1 |
| 1979 | 1 |
| 1994 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2007 | 1 |
| 2011 | 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 ('7102202'))
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 ('7102202'))
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 WPR12LA064Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Friday Harbor, WAA total loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB SEA07CA086Accident · No injuriesData collectionFinal reportPiper PA-22 · Enumclaw, WAThe pilot's failure to apply carburetor heat during cruise flight. Factors include ambient weather conditions that were conducive to carburetor icing, and soft, muddy terrain at the location where the pilot attempted the power-off forced landing.NTSB SEA03LA198Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Cle Elum, WAAn undershoot due to the pilot's failure to maintain a proper glide path on final approach to landing. A factor was the gravel.NTSB SEA02LA061Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Friday Harbor, WAThe failure of the brake system during the landing roll. An intentional ground loop and a dirt bank were factors.NTSB SEA94FA174Accident · 3 fatalField investigationFinal reportPiper PA-22-135 · Leavenworth, WAThe pilot's inadequate preflight planning/preparation. Factors related to the accident were: high density altitude, the runway condition (with areas of soft or uneven terrain and tall grass), and obstructions (trees) near the departure end of the runway.NTSB SEA79FYM39Accident · Minor injuriesClosedPiper PA-22 · Vancouver, WANTSB SEA76FYE21Accident · Serious injuriesClosedPiper PA-22 · Lummi Island, WANTSB SEA73DYG33Accident · No injuriesClosedPiper PA-22 · Mazama, WANTSB SEA71DWG31Accident · Minor injuriesClosedPiper PA-22 · Othello, WANTSB SEA69D0036Accident · No injuriesClosedPiper PA-22 · Starbuck, WANTSB SEA66F0285Accident · Minor injuriesClosedPiper PA-22 · Maple Valley, WANTSB SEA66F0213Accident · Minor injuriesClosedPiper PA-22 · Vancouver, WANTSB SEA66F0123Accident · No injuriesClosedPiper PA-22 · Bellevue, WANTSB SEA66D0030Accident · No injuriesClosedPiper PA-22 · Rosalia, WANTSB SEA65D0052Accident · No injuriesClosedPiper PA-22 · Bellevue, WA