Skip to content

Fatal NTSB investigations: Piper PA-22-160

45 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."highestInjuryLevel" = 'Fatal' 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.\"highestInjuryLevel\" = 'Fatal'
    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."highestInjuryLevel" = 'Fatal'
  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 WPR19LA063Accident · 1 fatalClass 2 · LimitedFinal reportPiper PA22 · Kingman, AZThe student pilot's failure to secure the fuel caps, which led to the fuel being siphoned overboard, fuel exhaustion, and the total loss of engine power.Jan 13, 2019 · N9227D · Substantial damage NTSB WPR15FA215Accident · 2 fatalField investigationFinal reportPiper PA 22-160 · Twin Sisters Mtn, WAThe noninstrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in controlled flight into mountainous terrain.Jul 11, 2015 · N9712D · Destroyed NTSB ATL07LA111Accident · 1 fatalLimited investigationFinal reportPiper PA-22-160 · Leonardtown, MDThe pilot's inadequate performance planning and failure to abort the takeoff.Aug 9, 2007 · N2731P · Destroyed NTSB ANC98LA001Accident · 1 fatalLimited investigationFinal reportPiper PA-22-160 · Sterling, AKUndetermined.Oct 3, 1997 · N8955D · Destroyed NTSB LAX97FA126Accident · 4 fatalField investigationFinal reportPiper PA-22-160 · Bagdad, AZfailure of the pilot to obtain and/or maintain adequate airspeed during takeoff/initial climb, which resulted in an inadvertent stall and collision with the terrain. High density altitude was a related factor.Mar 19, 1997 · N3629Z · Destroyed NTSB SEA90FA149Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Leavenworth, WAThe pilot's misjudgement in preflight planning when departing toward rising terrain. Contributing factors in this accident were his decision to attempt a climb-out with full flaps extended, and the minimal performance data available to him upon which he could…Jul 30, 1990 · N9978D · Destroyed NTSB MIA89FA174Accident · 1 fatalField investigationFinal reportPiper PA-22-160 · St. Augustine, FLThe pilot failed to maintain airspeed during the turn to return to the airport, resulting in the loss of control. Contributing to the accident was his continued takeoff with intermittent engine power.Jun 10, 1989 · N9834D · Substantial damage NTSB SEA84FA196Accident · 1 fatalField investigationFinal reportPiper PA-22-160 · Bonners Ferry, IDThe plt took off with 3 adult passengers & a 2 yr old child on board & flew aprx 1.3 hrs. Just prior to the accident, he reported on a left downwind for rwy 20. As the plt continued the apch, the acft was observed over the rwy at aprx 100' AGL, reportedly at…Aug 12, 1984 · N9050D · Destroyed NTSB FTW81FA110Accident · 4 fatalClosedPiper PA-22 · Busch, ARJun 20, 1981 · N8773D · Destroyed NTSB NYC80FA089Accident · 3 fatalClosedPiper PA-22 · Hyner, PASep 18, 1980 · N9527D · Destroyed NTSB ANC79FAH05Accident · 1 fatalClosedPiper PA-22 · Palmer, AKSep 4, 1979 · N8666D · Destroyed NTSB CHI79FA057Accident · 3 fatalClosedPiper PA-22 · St Charles, ILJul 4, 1979 · N3027Z · Destroyed NTSB MIA79FA092Accident · 3 fatalClosedPiper PA-22 · Redlick, MSJun 5, 1979 · N9560D · Destroyed NTSB UNK78X0126Accident · 1 fatalClosedPiper PA22 · Arramberri, MexicoJun 15, 1978 · N9014D · Destroyed NTSB CHI78FA043Accident · 4 fatalClosedPiper PA-22 · Saint Helen, MIMay 28, 1978 · N3610Z · Destroyed NTSB MKC78FA027Accident · 1 fatalClosedPiper PA-22 · Rapid City, SDMar 12, 1978 · N9820D · Substantial damage NTSB OAK77FA016Accident · 1 fatalClosedPiper PA-22 · Clearlake Oaks, CAFeb 5, 1977 · N9015D · Destroyed NTSB MIA76AM112Accident · 4 fatalClosedPiper PA-22 · Treasure Is, FLSep 27, 1976 · N8541D · Destroyed NTSB SEA76AS060Accident · 3 fatalClosedPiper PA-22 · Hoquiam, WAJul 3, 1976 · N9344D · Destroyed NTSB IAD76AI063Accident · 1 fatalClosedPiper PA-22 · Sperryville, VAMar 30, 1976 · N9734D · Destroyed NTSB CHI76AC049Accident · 3 fatalClosedPiper PA-22 · Lebanon, INFeb 16, 1976 · N3501Z · Destroyed NTSB DEN7LAD007Accident · 2 fatalClosedPiper PA-22 · Fremont, UTAug 1, 1975 · N3567Z · Destroyed NTSB ANC75FAA22Accident · 2 fatalClosedPiper PA-22 · Missing AircraftNov 30, 1974 · N9686D · Destroyed NTSB NYC75AN051Accident · 1 fatalClosedPiper PA-22 · Westville, NYOct 19, 1974 · N8831D · Destroyed NTSB DEN74AD045Accident · 4 fatalClosedPiper PA-22 · Cedar City, UTMar 23, 1974 · N8490D · Destroyed NTSB FTW72AF058Accident · 3 fatalClosedPiper PA-22 · Colorado City, TXFeb 26, 1972 · N9655D · Destroyed NTSB MKC72AK022Accident · 2 fatalClosedPiper PA-22 · Kenmare, NDSep 30, 1971 · N8946D · Destroyed NTSB MIA72AM021Accident · 2 fatalClosedPiper PA-22 · Morris, ALAug 29, 1971 · N8526D · Destroyed NTSB NYC72AN001Accident · 3 fatalClosedPiper PA-22 · Machias, NYJul 3, 1971 · N9539D · Destroyed NTSB OAK70AP044Accident · 1 fatalClosedPiper PA-22 · Clovis, CAFeb 15, 1970 · N3079Z · Destroyed NTSB MKC69A0038Accident · 2 fatalClosedPiper PA-22 · Morris, MNDec 14, 1968 · N9533D · Destroyed NTSB CHI68F0174Accident · 1 fatalClosedPiper PA-22 · Chicago, ILJul 4, 1967 · N3054Z · Destroyed NTSB LAX67A0113Accident · 2 fatalClosedPiper PA-22 · S. Clemente, CAJun 3, 1967 · N3072Z · Destroyed NTSB MKC67A0073Accident · 4 fatalClosedPiper PA-22 · Marshall, MOMay 29, 1967 · N9345D · Destroyed NTSB NYC67A0093Accident · 1 fatalClosedPiper PA-22 · Frederick, MDDec 10, 1966 · N8813D · Destroyed NTSB MKC66A0034Accident · 1 fatalClosedPiper PA-22 · Burr, NEDec 9, 1965 · N9584D · Destroyed NTSB UNK66X0110Accident · 2 fatalClosedPiper PA-22 · Ogeman, ARNov 22, 1965 · N8950D · Destroyed NTSB CHI66F0382Accident · 1 fatalClosedPiper PA-22 · Coffeen, ILOct 6, 1965 · N9238D · Substantial damage NTSB NYC65A0129Accident · 3 fatalClosedPiper PA22 · Schuyler Lake, NYApr 21, 1965 · N9032D · Destroyed NTSB MIA65A0096Accident · 3 fatalClosedPiper PA-22 · Caguas, PRMar 27, 1965 · N9518D · Destroyed NTSB CHI65A0080Accident · 1 fatalClosedPiper PA-22 · Madison, INMar 8, 1965 · N3317Z · Destroyed NTSB UNK65X1105Accident · 1 fatalClosedPiper PA-22 · Winona, MNDec 23, 1964 · N3142Z · Destroyed NTSB UNK64X3310Accident · 2 fatalClosedPiper PA-22 · Bluefield, WVAug 9, 1964 · N3236Z · Destroyed NTSB UNK64X2990Accident · 1 fatalClosedPiper PA22 · Bethune, SCJul 23, 1964 · N8611D · Destroyed NTSB UNK64X2886Accident · 1 fatalClosedPiper PA-22 · Joliet, ILJul 17, 1964 · N9232D · Substantial damage