NTSB investigations: Piper PA-22-108, OK

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

19652026

NTSB investigations: Piper PA-22-108, OK per year, 1965–2026: 11 cases
1965	1
1967	1
1969	2
1970	1
1974	1
1977	2
1978	1
1983	1
1998	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" = 'OK' 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\" = 'OK' 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" = 'OK' 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 FTW98LA124Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Frederick, OKThe loss of wheel brakes due to the failure of the brake actuating cable. A factor was the tailwind.Feb 3, 1998 · N4654Z · Substantial damage NTSB FTW84FA084Accident · 2 fatalField investigationFinal reportPiper PA-22-108 · Pawnee, OKThe acft collided with a guy wire on a micro-wave tower during flt in IMC weather. The plt had not received a weather briefing prior to takeoff and after encountering low ceilings the plt attempted to fly along a highway at low alt. The right wing of the acft…Dec 4, 1983 · N4579Z · Destroyed NTSB FTW78FPM13Accident · No injuriesClosedPiper PA-22 · Tulsa, OKMay 27, 1978 · N5760Z · Substantial damage NTSB FTW78FPJ08Accident · Minor injuriesClosedPiper PA-22 · Victory, OKNov 26, 1977 · N5921Z · Destroyed NTSB FTW77FPJ08Accident · No injuriesClosedPiper PA-22 · Duncan, OKMar 12, 1977 · N5426Z · Substantial damage NTSB FTW74FPJ22Accident · Serious injuriesClosedPiper PA-22 · Anadarko, OKMar 16, 1974 · N4939Z · Destroyed NTSB FTW71FPM01Accident · Minor injuriesClosedPiper PA-22 · Wagoner, OKJul 3, 1970 · N5020Z · Substantial damage NTSB FTW69F0531Accident · Serious injuriesClosedPiper PA-22 · Daisy, OKMay 11, 1969 · N4559Z · Destroyed NTSB FTW69F0424Accident · No injuriesClosedPiper PA-22 · Tulsa, OKMar 16, 1969 · N5218Z · Substantial damage NTSB FTW67D0382Accident · No injuriesClosedPiper PA-22 · Enid, OKJan 2, 1967 · N4517Z · Substantial damage NTSB UNK65X1432Accident · No injuriesClosedPiper PA22 · Ardmore, OKFeb 17, 1965 · N4579Z · Substantial damage