Skip to content

NTSB investigations: Piper PA-22-160, PA

20 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

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" = 'PA' 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

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

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 MIA08LA168Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Jeannette, PAFailure of the brakes to function due to inadequate inspection of the brake cable by maintenance personnel.Aug 19, 2008 · N9403D · Substantial damage NTSB IAD01LA001Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Lewisberg, PAThe loss of engine power for undetermined reasons.Oct 1, 2000 · N9697D · Substantial damage NTSB BFO94LA067Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Butler, PAThe pilot's failure to select the proper fuel tank, which resulted in fuel starvation and the loss of engine power.Apr 17, 1994 · N9183D · Destroyed NTSB NYC91LA240Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Slippery Rock, PAThe on ground collision with a farm vehicle during landing roll out.Sep 18, 1991 · N9741D · Substantial damage NTSB NYC89LA122Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Gettysburg, PAThe pilot's poor preflight and in-flight planning in electing to continue the flight beyond the planned destination which resulted in fuel exhaustion.Apr 19, 1989 · N8745D · Destroyed NTSB NYC87LA092Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Tunkhannock, PAThe plt was lndg on a grass rwy with an access road bordering the apch end. Across the road from the rwy threshold, there was a pile of snow which previously had been plowed from the rwy. In reference to lndg at ngt, the plt stated, 'coming in on final, I…Feb 22, 1987 · N3045Z · Substantial damage NTSB NYC82DA202Accident · No injuriesFinal reportPiper PA-22-160 · Tunkhannock, PADuring a landing in calm wind conditions, the aircraft was high on final approach, so the pilot added flaps and slipped the plane to lose altitude. He touched down about 1000 ft down the 2000 ft runway. He reported that after landing, he applied the brakes,…Aug 16, 1982 · N3732Z · Substantial damage NTSB NYC80FA089Accident · 3 fatalClosedPiper PA-22 · Hyner, PASep 18, 1980 · N9527D · Destroyed NTSB NYC79FGM33Accident · No injuriesClosedPiper PA-22 · Zelienople, PAJul 7, 1979 · N9741D · Substantial damage NTSB NYC79FGM23Accident · No injuriesClosedPiper PA-22 · Conneaut, PAMay 8, 1979 · N9809D · Substantial damage NTSB NYC76DGM46Accident · Minor injuriesClosedPiper PA-22 · Zelienople, PAAug 20, 1976 · N3431Z · Substantial damage NTSB NYC71FGT17Accident · Minor injuriesClosedPiper PA-22 · Bloomsburg, PAMay 7, 1971 · N3241Z · Substantial damage NTSB NYC68D0318Accident · No injuriesClosedPiper PA-22 · Coudersport, PADec 2, 1967 · N8953D · Substantial damage NTSB NYC67F0629Accident · No injuriesClosedPiper PA-22 · Gettysburg, PAApr 29, 1967 · N9951D · Substantial damage NTSB NYC67F0230Accident · Minor injuriesClosedPiper PA-22 · Milroy, PAAug 31, 1966 · N9552D · Substantial damage NTSB NYC65D0237Accident · No injuriesClosedPiper PA-22 · Distant, PAApr 20, 1965 · N3046Z · Substantial damage NTSB UNK64X2776Accident · Minor injuriesClosedPiper PA22 · Matamoras, PAJul 12, 1964 · N9032D · Substantial damage NTSB UNK64X2510Accident · No injuriesClosedPiper PA22 · Stroudsburg, PAJun 27, 1964 · N8618D · Substantial damage NTSB UNK64X1937Accident · No injuriesClosedPiper PA22 · Selinsgrove, PAMay 24, 1964 · N3048Z · Substantial damage NTSB UNK64X0784Accident · No injuriesClosedPiper PA22 · New Kingston, PAMar 1, 1964 · N9243D · Substantial damage