Skip to content

NTSB investigations: Piper PA-22-150, AZ

27 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" = 'AZ' 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\" = 'AZ' 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" = 'AZ' 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 WPR16LA079Accident · No injuriesLimited investigationFinal reportPiper PA 22-150 · Fountain Hills, AZA partial loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Mar 2, 2016 · N4356A · Substantial damage NTSB ANC06CA034Accident · No injuriesData collectionFinal reportPiper PA-22 · Grand Canyon, AZThe pilot's improper recovery from a bounced landing during touchdown, which resulted in a loss of control and encounter with terrain. Factors associated with the accident are the pilot's misjudged flare, and a gusty wind.Mar 26, 2006 · N6123D · Substantial damage NTSB LAX92LA308Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tucson, AZThe pilot's poorly planned approach and failure to attain the proper descent rate. The loss of engine power for undetermined reasons and the rough terrain conditions in the area of the forced landing were factors in the accident.Jul 19, 1992 · N3406Z · Substantial damage NTSB LAX89LA316Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Winkelman, AZImproper in-flight planning/decision by the pilot, after he became lost/disoriented, which resulted in fuel exhaustion, before he was able to complete a precautionary landing. Factors related to the accident were: darkness, the pilot's lack of visual cues at…Sep 20, 1989 · N3015Z · Substantial damage NTSB LAX88LA143Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Payson, AZThe pilot reported that during the landing roll a dust devil (whirlwind) pushed the aircraft off the runway, colliding with the terrain resulting in substantial damage. The pilot reported that the wind velocity was 25 knots gusting to 30 as a quartering…Mar 29, 1988 · N8524D · Substantial damage NTSB LAX84LA290Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Phoenix, AZThe plt had just purchased the acft & had flown it only 3 hrs. The purpose of this flt was to ferry it to deer valley for a paint job. He reported that when he landed, the wind was from 150 deg at 6 gusting 12 KTS. During the landing, the nose wheel touched…May 12, 1984 · N3634P · Substantial damage NTSB LAX80DUJ35Accident · No injuriesClosedPiper PA-22 · Phoenix, AZFeb 25, 1980 · N8447D · Substantial damage NTSB LAX79DUJ53Accident · No injuriesClosedPiper PA-22 · Bisbee, AZMar 3, 1979 · N4335A · Substantial damage NTSB LAX77DUJ66Accident · Minor injuriesClosedPiper PA-22 · Safford, AZJun 24, 1977 · N5834D · Substantial damage NTSB LAX75AL011Accident · 1 fatalClosedPiper PA-22 · Theba, AZSep 1, 1974 · N6099D · Substantial damage NTSB LAX72FUJ43Accident · No injuriesClosedPiper PA-22 · Casa Grande, AZSep 10, 1971 · N3848P · Substantial damage NTSB LAX72DUJ14Accident · Minor injuriesClosedPiper PA-22 · Page, AZJul 15, 1971 · N7112B · Substantial damage NTSB LAX70DUJ26Accident · No injuriesClosedPiper PA-22 · Chino Vally, AZApr 29, 1970 · N7136D · Substantial damage NTSB LAX69D0191Accident · Minor injuriesClosedPiper PA-22 · Bonita, AZNov 15, 1968 · N7426D · Substantial damage NTSB LAX69D0117Accident · No injuriesClosedPiper PA-22 · Tucson, AZAug 26, 1968 · N3848P · Substantial damage NTSB LAX68F0336Accident · Minor injuriesClosedPiper PA-22 · Globe, AZFeb 9, 1968 · N6817B · Substantial damage NTSB LAX68D0192Accident · No injuriesClosedPiper PA-22 · Coolidge, AZSep 28, 1967 · N2914P · Substantial damage NTSB LAX68D0236Accident · No injuriesClosedPiper PA-22 · Wenden, AZSep 10, 1967 · N8446D · Substantial damage NTSB LAX67F0442Accident · Minor injuriesClosedPiper PA-22 · Tucson, AZMay 29, 1967 · N3543Z · Substantial damage NTSB LAX67D0235Accident · No injuriesClosedPiper PA-22 · Williams, AZDec 10, 1966 · N3507P · Substantial damage NTSB LAX67D0218Accident · No injuriesClosedPiper PA-22 · Seligman, AZOct 13, 1966 · N2437P · Substantial damage NTSB DEN66A0042Accident · 2 fatalClosedPiper PA-22 · Quartzsite, AZNov 24, 1965 · N2924P · Destroyed NTSB UNK65X1516Accident · No injuriesClosedPiper PA-22 · Casa Grande, AZJul 7, 1965 · N1583P · Destroyed NTSB DEN65D0015Accident · No injuriesClosedPiper PA-22 · Phoenix, AZFeb 27, 1965 · N2437P · Destroyed NTSB UNK64X2518Accident · Minor injuriesClosedPiper PA22 · Stanfield, AZJun 27, 1964 · N4551A · Substantial damage NTSB UNK64X1701Accident · No injuriesClosedPiper PA22 · Mesa, AZMay 10, 1964 · N1828P · Substantial damage NTSB UNK64X1332Accident · No injuriesClosedPiper J3C · Tolleson, AZApr 15, 1964 · N26815 · 2 aircraft · Minor damage