Skip to content

NTSB investigations: Piper PA-22-108, NC

22 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" = 'NC' 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\" = 'NC' 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" = 'NC' 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 GAA16CA183Accident · Minor injuriesData collectionFinal reportPiper PA22 · Pantego, NCA loss of directional control during the takeoff roll in gusting wind conditions, which resulted in a runway excursion, a nose over, and an impact with terrain. Contributing to the accident was the pilot's decision to takeoff in gusting crosswind conditions.Apr 9, 2016 · N5069Z · Substantial damage NTSB ERA16CA125Accident · No injuriesData collectionFinal reportPiper PA 22-108 · Lincolnton, NCThe non-certificated pilot's loss of directional control while landing.Mar 6, 2016 · N5488Z · Substantial damage NTSB ATL98LA026Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Jacksonville, NCthe pilot's improper preflight inspection by failing to ensure the fuel selector was properly positioned, which led to fuel starvation, loss of engine power, and a forced landing on rough/uneven terrain. The lack of suitable terrain for a forced landing was a…Dec 20, 1997 · N5258Z · Substantial damage NTSB ATL96LA014Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Durham, NCThe aircraft mechanic's failure to follow engine overhaul procedures which resulted in the failure of the camshaft drive gear.Nov 20, 1995 · N5057Z · Substantial damage NTSB ATL89LA017Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Advance, NCDuring takeoff climb eng quit then re-started. PIC turned to the north & engine quit again. PIC stalled acft & crashed into wheat field. Acft had STC for auto gas. Fuel in acft had water & rust contaminants. Fuel lines had dried. Carb had composite float. The…Oct 24, 1988 · N5361Z · Substantial damage NTSB IAD80FKM01Accident · Serious injuriesClosedPiper PA-22 · Charlotte, NCOct 7, 1979 · N5854Z · Substantial damage NTSB IAD76AI095Accident · 1 fatalClosedPiper PA-22 · Mooresville, NCAug 26, 1976 · N5182Z · Destroyed NTSB IAD76AI058Accident · 2 fatalClosedPiper PA-22 · Mooresville, NCFeb 29, 1976 · N5634Z · Substantial damage NTSB IAD75A1031|IAD75AI031Accident · 1 fatalClosedLuscombe 8A · Polkton, NCNov 23, 1974 · N2853K · 2 aircraft · Minor damage NTSB NYC73DKM12Accident · No injuriesClosedPiper PA-22 · Reidsville, NCSep 22, 1972 · N5361Z · Substantial damage NTSB DIA69F0158Accident · No injuriesClosedPiper PA-22 · Wadesboro, NCMar 22, 1969 · N5251Z · Substantial damage NTSB DIA68D0174Accident · No injuriesClosedPiper PA-22 · Hickory, NCFeb 25, 1968 · N5265Z · Substantial damage NTSB DIA67D0067Accident · No injuriesClosedPiper PA-22 · Winston-Salem, NCApr 8, 1967 · N5837Z · Substantial damage NTSB MIA66F0353Accident · No injuriesClosedPiper PA-22 · Greensboro, NCDec 17, 1965 · N4836Z · Substantial damage NTSB MIA65F0076Accident · Minor injuriesClosedPiper PA-22 · Etowah, NCApr 30, 1965 · N5852Z · Substantial damage NTSB UNK65X1358Accident · No injuriesClosedPiper PA22 · Greensboro, NCJan 27, 1965 · N4836Z · Substantial damage NTSB UNK65X1276Accident · Minor injuriesClosedPiper PA22 · Winston Salem, NCJan 12, 1965 · N5947Z · Destroyed NTSB UNK65X0639Accident · No injuriesClosedPiper PA22 · Winston Salem, NCNov 10, 1964 · N5911Z · Substantial damage NTSB UNK65X0492Accident · Serious injuriesClosedPiper PA22 · Pilot, NCOct 30, 1964 · N4750Z · Substantial damage NTSB UNK64X1374Accident · No injuriesClosedPiper PA22 · Sunbury, NCApr 19, 1964 · N4759Z · Substantial damage NTSB UNK64X0419Accident · Minor injuriesClosedPiper PA22 · Asheville, NCFeb 1, 1964 · N4784Z · Substantial damage NTSB UNK64X0327Accident · No injuriesClosedPiper PA22 · Marion, NCJan 23, 1964 · N5697Z · Substantial damage