Skip to content

NTSB investigations: Piper PA-22-150, GA

32 cases on aircraft the registry lists as Piper PA-22-150. 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" = 'GA' 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 ('7102210')) 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\" = 'GA' 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 ('7102210'))
  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" = 'GA' 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 ('7102210'))
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 ERA23FA136Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-22-150 · Blue Ridge, GAA loss of engine power due to fuel starvation due to the improper positioning of the fuel selector.Mar 5, 2023 · N3410Z · Substantial damage NTSB ERA21LA088Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Cleveland, GAA total loss of engine power due to carburetor icing.Dec 27, 2020 · N5939D · Substantial damage NTSB ERA11CA108Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Thomaston, GAThe mechanic's failure to install a cotter retaining pin in the throttle arm retaining nut resulting in excessive throttle play and loss of engine power control.Jan 6, 2011 · N5706D · Substantial damage NTSB MIA99LA056Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Chamblee, GAThe pilot's excessive use of right wheel brake to correct for a left drift during landing rollout resulting in a ground loop to the right and the left wing contacting the runway.Oct 25, 1998 · N7357D · Substantial damage NTSB MIA98LA150Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Woodstock, GAThe pilot's failure to establish a positive climb to outclimb obstacle (tree) and his decision to execute a takeoff with a tailwind.May 6, 1998 · N3900P · Substantial damage NTSB MIA97LA106Accident · No injuriesLimited investigationFinal reportPiper PA22-150 · Cumming, GAa loss of engine power for an undermined reason, which resulted in a forced landing and subsequent impact with the ground.Mar 30, 1997 · N3201Z · Substantial damage NTSB ATL92LA037Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Griffin, GAThe excessive speed used by the pilot to land on the short private airstrip. A factor was unfavorable wind.Jan 12, 1992 · N6101D · Substantial damage NTSB ATL85LA102Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Lawrenceville, GAStudent pilot bought acft previous day, asked instructor to fly acft with him to home airport. CFI delayed en route to practice touch and go. On go around engine would not produce full power and acft would not climb. During subsequent interview pic/cfi told…Feb 21, 1985 · N1613P · Substantial damage NTSB ATL83LA372Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Jonesboro, GAThe acft crashed during a forced landing after the engine quit. The pilot said he had been flying in the local area and came in to practice touch and go landings. During the 2nd takeoff the engine missed. He landed and did a magneto check then another takeoff…Sep 17, 1983 · N7829D · Substantial damage NTSB ATL81DKG32Accident · Serious injuriesClosedPiper PA-22 · Griffin, GAJul 14, 1981 · N3919P · Substantial damage NTSB MIA80FKG21Accident · Minor injuriesClosedPiper PA-22 · Register, GAMar 19, 1980 · N6174D · Substantial damage NTSB MIA79FKG28Accident · Serious injuriesClosedPiper PA-22 · Lawrenceville, GAMar 18, 1979 · N7149B · Destroyed NTSB MIA79FKG02Accident · Serious injuriesClosedPiper PA-22 · Stone Mountain, GAOct 1, 1978 · N7846D · Minor damage NTSB MIA78FKG38Accident · Serious injuriesClosedPiper PA-22 · Loganville, GAApr 23, 1978 · N69PK · Destroyed NTSB MIA77DKG29Accident · No injuriesClosedPiper PA-22 · Newnan, GAMay 20, 1977 · N3115Z · Substantial damage NTSB MIA76DKG75Accident · No injuriesClosedPiper PA-22 · Sautee, GAJun 19, 1976 · N3362Z · Substantial damage NTSB MIA76AM083Accident · 1 fatalClosedPiper PA-22 · Lyons, GAMay 16, 1976 · N3813P · Destroyed NTSB MIA73DKG69Accident · Minor injuriesClosedPiper PA-22 · Blythe, GAApr 14, 1973 · N3627P · Substantial damage NTSB MIA73DKG12Accident · No injuriesClosedPiper PA-22 · Savannah, GAJul 13, 1972 · N1948P · Substantial damage NTSB MIA72FKG58Accident · Minor injuriesClosedPiper PA-22 · Lafayette, GADec 4, 1971 · N5961D · Substantial damage NTSB MIA72DKG39Accident · No injuriesClosedPiper PA-22 · Loganville, GASep 13, 1971 · N4352A · Substantial damage NTSB MIA71FKG93Accident · Minor injuriesClosedPiper PA-22 · Soperton, GAJun 13, 1971 · N8101D · Substantial damage NTSB MIA71DKG70Accident · No injuriesClosedPiper PA-22 · Jonesboro, GAMar 14, 1971 · N2658P · Substantial damage NTSB MIA70D0235Accident · No injuriesClosedPiper PA-22 · Athens, GANov 6, 1969 · N4406A · Substantial damage NTSB MIA69F0203Accident · No injuriesClosedPiper PA-22 · Austell, GAJul 14, 1968 · N6943D · Substantial damage NTSB MIA69F0115Accident · Minor injuriesClosedPiper PA-22 · Sylvania, GAJul 6, 1968 · N7837D · Substantial damage NTSB MIA68F0491Accident · Serious injuriesClosedPiper PA-22 · Sasser, GAJan 28, 1968 · N3133Z · Substantial damage NTSB MIA67F0133Accident · No injuriesClosedPiper PA-22 · Claxton, GAAug 18, 1966 · N4335A · Substantial damage NTSB MIA66F0033Accident · Serious injuriesClosedPiper PA-22 · Suwanee, GAMay 1, 1965 · N6906B · Destroyed NTSB UNK64X2129Accident · No injuriesClosedPiper PA22 · Lithonia, GAJun 5, 1964 · N3234Z · Substantial damage NTSB UNK64X1951Accident · No injuriesClosedPiper PA22 · Columbus, GAMay 25, 1964 · N9976D · Substantial damage NTSB UNK64X0543Accident · Minor injuriesClosedPiper PA22 · Carrolton, GAFeb 12, 1964 · N4534A · Substantial damage