NTSB investigations: Piper PA-22-135, WI

9 cases on aircraft the registry lists as Piper PA-22-135. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19662026

NTSB investigations: Piper PA-22-135, WI per year, 1966–2026: 9 cases
1966	1
1968	1
1969	2
1975	2
1976	1
1978	1
2002	1

Where

Open the map

Latest cases

Query with SQL

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 ('7102206')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('7102206'))
  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 ('7102206'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CHI02LA229Accident · Minor injuriesLimited investigationFinal reportPiper PA22-135 · Lyons, WIFailure of the pilot to maintain a sufficient rate-of-climb and to obtain a safe altitude/clearance from the tree line at end of the runway. Contributing factors were the uphill runway gradient and the trees.Aug 2, 2002 · N3522A · Substantial damage NTSB CHI78FEP51Accident · No injuriesClosedPiper PA-22 · Milwaukee, WIJul 28, 1978 · N8195C · Substantial damage NTSB CHI76DEP22Accident · No injuriesClosedPiper PA-22 · Rhinelander, WIJan 15, 1976 · N3347A · Substantial damage NTSB CHI76AC023Accident · 2 fatalClosedPiper PA-22 · Cataract, WISep 7, 1975 · N3279B · Destroyed NTSB CHI76FER03Accident · Serious injuriesClosedPiper PA-22 · Siren, WIAug 11, 1975 · N1409C · Destroyed NTSB CHI70D0193Accident · Minor injuriesClosedPiper PA-22 · Cassville, WIJul 3, 1969 · N1340C · Substantial damage NTSB CHI70D0012Accident · No injuriesClosedPiper PA-22 · Madison, WIApr 18, 1969 · N3347A · Substantial damage NTSB CHI69D0129Accident · No injuriesClosedPiper PA-22 · Neenah, WIJul 7, 1968 · N2244A · Substantial damage NTSB CHI67D0107Accident · Minor injuriesClosedPiper PA-22 · Osseo, WIJul 29, 1966 · N8803C · Substantial damage