Skip to content

NTSB investigations: Piper PA-22-150, WI

25 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" = 'WI' 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\" = 'WI' 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" = 'WI' 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 CEN20LA329Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · Burlington, WIA partial loss of engine power due to the formation of carburetor ice while on the ground, which resulted in reduced climb capability and impact with trees during the initial climb.Aug 9, 2020 · N6849B · Substantial damage NTSB GAA19CA157Accident · No injuriesData collectionFinal reportPiper PA22 · Superior, WIThe pilot's failure to maintain directional control during landing on a snow- and ice-covered runway, which resulted in impact with a snowbank and a nose-over.Mar 7, 2019 · N522DN · Substantial damage NTSB CEN12LA182Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · East Troy, WIThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Mar 5, 2012 · N6849B · Substantial damage NTSB CHI05CA241Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Brodhead, WIThe pilot's misjudged distance/altitude which resulted in an undershoot. A related factor was the vehicle the airplane contacted.Aug 20, 2005 · N2373P · Substantial damage NTSB CHI02LA245Accident · Minor injuriesLimited investigationFinal reportPiper PA22-150 · Sauk City, WIA loss of engine power due to a seized exhaust valve. A related factor was the mowed hay field.Aug 8, 2002 · N8910D · Substantial damage NTSB CHI98FA343Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Beaver Dam, WIThe continued flight into adverse weather conditions and aircraft control not maintained by the pilot-in-command. Contributing factors were the improper preflight planning/preparation and lack of certification by the pilot-in-command in addition to the…Aug 28, 1998 · N2931Z · Destroyed NTSB CHI93LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · La Pointe, WISpatial disorientation of the pilot.Jan 9, 1993 · N7057B · Substantial damage NTSB CHI91LA217Accident · No injuriesLimited investigationFinal reportPiper PA22/20 · Stevens Point, WIThe improper installation of the flight control system rudder control rod (rudder cable bellcrank torque tube) by maintenance personnel. A factor contributing to this accident was the inoperative tailwheel steering.Jul 13, 1991 · N5968D · Substantial damage NTSB MKC87FA161Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Solon Springs, WIThe surviving pax rprtd that drg initial climb after takeoff, the eng suddenly stopped & did not respond to atmts of a restart. The plt turned back toward the arpt, but was unable to reach the rwy. The acft impacted large trees in a wooded area, then crashed…Aug 15, 1987 · N5831D · Destroyed NTSB CHI85LA228Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Osceola, WIThe solo student plt attempted to land the acft with an aprx 90 deg x-wind of 24 KTS gusting to 32 KTS. Feeling unsure of the conditions on his first apch, he decided to make a go around. This he successfully accomplished. On his second attempt, he was able…Jun 8, 1985 · N1644P · Substantial damage NTSB CHI83LA367Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Franksville, WIThe acft was intentionally groundlooped as the acft was not stopping at the runways end. The pilot said the brakes malfunctioned. The mechanic who worked on the acft after the accident said brakes were available even though brake fluidwas low. The mechanic…Aug 6, 1983 · N2843Z · Substantial damage NTSB CHI83FA090Accident · 2 fatalField investigationFinal reportPiper PA-22-20 · Siren, WIWitnesses heard a sound of an acft eng, but because of low clouds & fog they could not see the acft. They heard the sound of the eng, a loud roar, the breaking of trees, & thena 'bang.' They then found the acft which had penetrated a wooded area at a 70 deg…Jan 23, 1983 · N3925P · Destroyed NTSB CHI80FEP54Accident · Minor injuriesClosedPiper PA-22 · Howard, WISep 13, 1980 · N7801D · Substantial damage NTSB CHI79DEP10Accident · No injuriesClosedPiper PA-22 · Middleton, WIDec 2, 1978 · N3666Z · Substantial damage NTSB CHI74FEP17Accident · No injuriesClosedPiper PA-22 · Arena, WISep 22, 1973 · N6838B · Substantial damage NTSB CHI73DEP65Accident · Minor injuriesClosedPiper PA-22 · Kenosha, WIJun 15, 1973 · N7316D · Substantial damage NTSB CHI73DEP46Accident · No injuriesClosedPiper PA-22 · Phillips, WIMar 30, 1973 · N7814D · Substantial damage NTSB CHI72DEP03Accident · No injuriesClosedPiper PA-22 · Washingtn Isl, WIJul 22, 1971 · N7821D · Destroyed NTSB CHI69D0179Accident · No injuriesClosedPiper PA-22 · Sister Bay, WIAug 7, 1968 · N3917P · Substantial damage NTSB CHI69D0108Accident · No injuriesClosedPiper PA-22 · Sherry, WIJun 4, 1968 · N2843Z · Substantial damage NTSB CHI68D0752Accident · No injuriesClosedPiper PA-22 · Stoughton, WIMay 8, 1968 · N6159D · Substantial damage NTSB CHI68D0402Accident · Minor injuriesClosedPiper PA-22 · Wonewoc, WISep 1, 1967 · N6029D · Substantial damage NTSB CHI67F0022Accident · Minor injuriesClosedPiper PA-22 · Middleton, WIJun 2, 1966 · N9964D · Substantial damage NTSB CHI66D0162Accident · No injuriesClosedPiper PA-22 · Lake Geneva, WIJun 20, 1965 · N4568A · Substantial damage NTSB UNK64X3067Accident · Minor injuriesClosedPiper PA22 · Lake Geneva, WIJul 27, 1964 · N2816P · Destroyed