Skip to content

NTSB investigations: Piper PA-22-108, PA

35 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

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 ('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\" = '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 ('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" = '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 ('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 GAA16CA084Accident · No injuriesData collectionFinal reportPiper PA22 · New Castle, PAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a nose over.Dec 20, 2015 · N5667Z · Substantial damage NTSB NYC99LA111Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Chambersburg, PAThe loss of engine power for undetermined reasons.May 12, 1999 · N5938Z · Substantial damage NTSB NYC95LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Beans Cove, PAThe pilot's failure to maintain adequate obstacle clearance which resulted in an inflight collision with a tree.Oct 13, 1994 · N4878Z · Destroyed NTSB BFO92LA100Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Beavertown, PAThe pilot's failure to maintain ground clearance. Contributing to the accident was a downdraft and insufficient altitude.Jul 12, 1992 · N4754Z · Destroyed NTSB NYC86LA207Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Tunkhannock, PAStudent pilot was attempting a landing at sky haven airport and landed short, bounced and landed in a left turn. At this point, the plt could not maintain directional control and ran off the runway, hit a barrel with the right gear and the acft nosed over.Aug 14, 1986 · N5888Z · Substantial damage NTSB NYC85LA176Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Hookstown, PAThe instructor and student were practicing normal takeoffs and landings. According to the pilot, on the sixth landing, at the correct airspeed, the aircraft touched down on the main gear and then the noise wheel collapsed. The aircraft then nosed over.…Jul 16, 1985 · N5322Z · Substantial damage NTSB NYC78FA056Accident · 2 fatalClosedPiper PA-22 · Northampton, PAMay 20, 1978 · N4656Z · Destroyed NTSB NYC74FHA09Accident · Minor injuriesClosedPiper PA-22 · Prospectville, PASep 16, 1973 · N5826Z · Substantial damage NTSB NYC70D0198Accident · No injuriesClosedPiper PA-22 · Erie, PAOct 13, 1969 · N5841Z · Substantial damage NTSB NYC70D0114Accident · No injuriesClosedPiper PA-22 · Oxford, PAAug 9, 1969 · N5459Z · Substantial damage NTSB NYC70D0025Accident · No injuriesClosedPiper PA-22 · Warrington, PAJul 2, 1969 · N4738Z · Substantial damage NTSB NYC69D0396Accident · No injuriesClosedPiper PA-22 · James Creek, PAApr 12, 1969 · N5139Z · Substantial damage NTSB NYC69D0365Accident · No injuriesClosedPiper PA-22 · Ebensburg, PAMar 23, 1969 · N5507Z · Substantial damage NTSB NYC69D0262Accident · No injuriesClosedPiper PA-22 · Warrington, PADec 8, 1968 · N4738Z · Substantial damage NTSB NYC69D0172Accident · Serious injuriesClosedPiper PA-22 · Kittanning, PAAug 3, 1968 · N4896Z · Substantial damage NTSB NYC69D0125Accident · Minor injuriesClosedPiper PA-22 · Monroeville, PAJul 21, 1968 · N5433Z · Substantial damage NTSB NYC69D0021Accident · No injuriesClosedPiper PA-22 · Ambler, PAJun 15, 1968 · N5483Z · Substantial damage NTSB NYC68D0363Accident · No injuriesClosedPiper PA-22 · Warrington, PAFeb 4, 1968 · N4738Z · Substantial damage NTSB NYC68D0184Accident · Minor injuriesClosedPiper PA-22 · West Chester, PASep 11, 1967 · N5014Z · Substantial damage NTSB NYC68F0125Accident · No injuriesClosedPiper PA-22 · Butler, PAAug 13, 1967 · N5895Z · Substantial damage NTSB NYC67D0480Accident · Minor injuriesClosedPiper PA-28 · Millcreek, PADec 17, 1966 · N5483Z · Substantial damage NTSB NYC67D0375Accident · Minor injuriesClosedPiper PA-22 · Erie, PAOct 23, 1966 · N5385Z · Substantial damage NTSB NYC67D0160Accident · No injuriesClosedPiper PA-22 · Dubois, PAJul 7, 1966 · N5006Z · Substantial damage NTSB NYC66F0642Accident · No injuriesClosedPiper PA-22 · Sayre, PAApr 30, 1966 · N4604Z · Substantial damage NTSB NYC66D0487Accident · No injuriesClosedPiper PA-22 · Collegeville, PAFeb 20, 1966 · N5764Z · Substantial damage NTSB NYC66F0401Accident · Minor injuriesClosedPiper PA-22 · Butler, PADec 22, 1965 · N5843Z · Substantial damage NTSB NYC66D0181Accident · No injuriesClosedPiper PA-22 · Blairsville, PAJul 30, 1965 · N5328Z · Substantial damage NTSB NYC66D0083Accident · No injuriesClosedPiper PA-22 · Honesdale, PAJul 29, 1965 · N5407Z · Substantial damage NTSB NYC65F0063Accident · Minor injuriesClosedPiper PA-22 · Fredericksburg, PAFeb 21, 1965 · N4500Z · 2 aircraft · Substantial damage NTSB NYC65F0004Accident · No injuriesClosedPiper PA-22 · Prospectville, PAFeb 6, 1965 · N3516P · 2 aircraft · Substantial damage NTSB UNK65X1290Accident · Minor injuriesClosedPiper PA-22 · Prospectville, PAJan 15, 1965 · N4765Z · Substantial damage NTSB UNK64X1878Accident · Minor injuriesClosedPiper PA22 · Pymatuning Lke, PAMay 22, 1964 · N5931Z · Destroyed NTSB UNK64X1556Accident · No injuriesClosedPiper PA22 · Carrolton, PAMay 2, 1964 · N5779Z · Substantial damage NTSB UNK64X1128Accident · Minor injuriesClosedPiper PA-22 · Dravosburg, PAApr 1, 1964 · N5793Z · Substantial damage NTSB UNK64X0883Accident · No injuriesClosedPiper PA22 · Martinsburg, PAMar 11, 1964 · N5570Z · Substantial damage