NTSB investigations: Piper PA-22-108, MA

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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

NTSB investigations: Piper PA-22-108, MA per year, 1964–2026: 11 cases
1964	1
1965	3
1966	1
1968	1
1972	1
1973	1
1981	1
1984	1
2001	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" = 'MA' 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

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\" = 'MA' 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" = 'MA' 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

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 NYC01LA132Accident · 1 fatalLimited investigationFinal reportPiper PA-22-108 · Falmouth, MAThe pilot's improper decision to takeoff and attempt VFR flight in IMC conditions.Jan 16, 2001 · N5391Z · Destroyed 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.Mar 25, 1984 · N4641Z · Substantial damage NTSB NYC81DNA22Accident · No injuriesClosedPiper PA-22 · Mansfield, MAJul 26, 1981 · N9116S · Substantial damage NTSB NYC74DNA26Accident · Minor injuriesClosedPiper PA-22 · Stow, MANov 4, 1973 · N5269Z · Substantial damage NTSB NYC73DNA27Accident · Minor injuriesClosedPiper PA-22 · Edgartown, MASep 24, 1972 · N4692Z · Destroyed NTSB NYC69A0020Accident · Minor injuriesClosedTaylorcraft BC12-D · Barre Plains, MAAug 18, 1968 · N43118 · 2 aircraft · Substantial damage NTSB NYC67A0015Accident · 1 fatalClosedPiper PA-22 · E Taunton, MAJul 16, 1966 · N5638Z · Destroyed NTSB NYC65F0044Accident · No injuriesClosedPiper PA22 · Hyannis, MAFeb 17, 1965 · N4975Z · Substantial damage NTSB NYC65F0008Accident · No injuriesClosedPiper PA22 · Barre, MAFeb 7, 1965 · N5973Z · Substantial damage NTSB NYC65F0006Accident · No injuriesClosedPiper PA22 · Tewksbury, MAFeb 3, 1965 · N5647Z · Substantial damage NTSB UNK64X3638Accident · Minor injuriesClosedPiper PA22 · Gt Barrington, MAAug 28, 1964 · N4721Z · Substantial damage