Skip to content

NTSB investigations: Piper PA-22-108, AK

25 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" = 'AK' 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\" = 'AK' 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" = 'AK' 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 GAA18CA090Accident · No injuriesData collectionFinal reportPiper PA22 · Yentna, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a loss of directional control and subsequent nose-over.Dec 18, 2017 · N4805Z · Substantial damage NTSB ANC08LA047Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Ugashik, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over. A factor contributing to the accident was water on the surface of the ice-covered lake.Apr 1, 2008 · N5840Z · Substantial damage NTSB ANC01LA045Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Palmer, AKThe pilot's selection of an unsuitable takeoff area. A factor associated with the accident was rough/uneven terrain.Mar 31, 2001 · N4606Z · Substantial damage NTSB ANC97LA151Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Northway, AKThe pilot's failure to maintain directional control during the landing. A factor in the accident was the pilot's lack of familiarity with the airplane.Sep 16, 1997 · N5840Z · Substantial damage NTSB ANC93LA082Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Skwentna, AKThe pilot in command not maintaining directional control of the airplane. A factor in the accident was the gusty wind condition.Jun 6, 1993 · N5104Z · Substantial damage NTSB ANC89LA101Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Alder Creek, AKSelection of unsuitable terrain (unimproved strip) by the pilot. Soft/uneven terrain & low bushes on the strip, as well as alders beside the strip, were contributing factors.Jun 19, 1989 · N4912Z · Substantial damage NTSB ANC86LA089Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Egegik, AKThe airplane experienced a power failure and nosed over in one foot of water while making an emergency landing on a beach.Jun 19, 1986 · N5907Z · Substantial damage NTSB ANC78DAG20Accident · No injuriesClosedPiper PA-22 · Talkeenta, AKDec 25, 1977 · N5417Z · Substantial damage NTSB ANC75DAG97Accident · No injuriesClosedPiper PA-22 · Seward, AKJun 11, 1975 · N5613Z · No damage NTSB ANC74FAA05Accident · No injuriesClosedPiper PA-22 · Iowa Ridge, AKAug 16, 1973 · N5032Z · Substantial damage NTSB ANC74DAG12Accident · No injuriesClosedPiper PA-22 · Dillingham, AKJul 23, 1973 · N5789Z · Substantial damage NTSB ANC71AA050Accident · 1 fatalClosedPiper PA-22 · Fairbanks, AKApr 4, 1971 · N4951Z · Substantial damage NTSB ANC69D0095Accident · Minor injuriesClosedPiper PA-22 · Kodiak, AKNov 28, 1968 · N5205Z · Substantial damage NTSB ANC69D0043Accident · No injuriesClosedPiper PA-22 · Bethel, AKSep 2, 1968 · N5789Z · Substantial damage NTSB ANC69D0027Accident · No injuriesClosedPiper PA-22 · Healy, AKAug 10, 1968 · N4823Z · Destroyed NTSB ANC68D0015Accident · No injuriesClosedPiper PA-22 · Galena, AKJul 13, 1967 · N5110Z · Substantial damage NTSB ANC67D0098Accident · No injuriesClosedPiper PA-22 · Fairbanks, AKApr 9, 1967 · N4981Z · Substantial damage NTSB ANC67F0080Accident · No injuriesClosedPiper PA-22 · Fairbanks, AKFeb 19, 1967 · N5110Z · Substantial damage NTSB ANC66D0089Accident · No injuriesClosedPiper PA-22 · Anchorage, AKMar 5, 1966 · N5601Z · Substantial damage NTSB ANC66D0079Accident · No injuriesClosedPiper PA-22 · Anchorage, AKDec 11, 1965 · N5601Z · Substantial damage NTSB ANC66D0088Accident · No injuriesClosedPiper PA-22 · Anchorage, AKDec 7, 1965 · N5772Z · Substantial damage NTSB ANC66D0020Accident · Minor injuriesClosedPiper PA-22 · Sitkinak Is, AKJun 7, 1965 · N4841Z · Destroyed NTSB UNK64X1807Accident · No injuriesClosedPiper PA22 · Palmer, AKMay 17, 1964 · N4839Z · Substantial damage NTSB UNK64X0763Accident · No injuriesClosedPiper PA22 · Goose Bay, AKFeb 29, 1964 · N5789Z · Substantial damage NTSB UNK64X0455Accident · No injuriesClosedPiper PA22 · Anchorage, AKFeb 4, 1964 · N5295Z · Substantial damage