NTSB investigations: Piper PA-22-160, WI
5 cases on aircraft the registry lists as Piper PA-22-160. 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 | 1 |
|---|---|
| 1966 | 1 |
| 1983 | 1 |
| 1989 | 1 |
| 1997 | 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\" = 'WI' 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 ('7102214'))
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" = 'WI' 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 ('7102214'))
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 CHI97LA099Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Oshkosh, WIthe pilot's inadequate compensation for the wind conditions, and his failure to maintain proper runway alignment, which resulted in a subsequent nose over. The gusty crosswind condition was a related factor.NTSB CHI90LA035Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Barron, WIImproper use of the carburetor heat by the pilot and subsequent carburetor ice. Contributing factors were: carburetor icing conditions, slick (wet/snow covered) runway, and trees/brush near the departure end of the runway.NTSB CHI83LA354Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Juneau, WIThe pilot stated that he made the approach at 85-90 mph with 40 degrees flaps and 1100 RPM. The winds were from 270 degrees at 10 KTS gusting to 20 KTS the acft started to sink on the short final and the pilot applied power and pulled back on the stick in an…NTSB CHI67D0120Accident · Minor injuriesClosedPiper PA-22 · Whitewater, WINTSB CHI65F0033Accident · No injuriesClosedPiper PA-22 · Milwaukee, WI