Skip to content

NTSB investigations: Piper PA-38-112, WI

20 cases on aircraft the registry lists as Piper PA-38-112. 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

19822026

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 ('7103812')) 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 ('7103812'))
  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 ('7103812'))
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 CHI98LA030Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Madison, WIthe flight instructor's (CFI's) inadequate supervision of the flight, and his failure to ensure that control of the airplane was maintained. Factors associated with the accident were: the CFI's improper use of flaps, and subsequent contact with the runway…Nov 5, 1997 · N2536N · Substantial damage NTSB CHI95LA315Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Milwaukee, WIthe pilot's premature liftoff which resulted in a stall.Sep 9, 1995 · N2596N · Substantial damage NTSB CHI92LA123Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Brookfield, WIFailure of the pilot (CFI) to attain the proper touchdown point for landing. Factors related to the accident were: the unfavorable wind condition, the excessive descent rate that developed on final approach, and the cfi's delay in taking remedial action to…Apr 5, 1992 · N6350A · Substantial damage NTSB CHI90LA103Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Wausau, WIA hard landing resulting from the pilot not taking timely remedial when a stall was encountered.Mar 24, 1990 · N2331C · Substantial damage NTSB CHI89LA147Accident · 1 fatalLimited investigationFinal reportPiper PA-38-112 · River Falls, WIImproper remedial action by the pilot following an abrupt maneuver. The pilot's lack of total aviation experience was a factor in the accident.Jul 27, 1989 · N25687 · Destroyed NTSB CHI89LA164Accident · No injuriesLimited investigationFinal reportPiper PA38-112 · Milwaukee, WIStudent pilot's misjudged aircraft handling during the landing flare/touchdown, and the cfi's inadequate supervision of the operation. These resulted in an abrupt touchdown, a subsequent loss of directional control, and the aircraft's collision with the VASI…Jul 24, 1989 · N9103A · Substantial damage NTSB CHI88LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Grafton, WIWhile landing at a 1,900' sod airstrip with a 10 knot crosswind, the aircraft swerved to the left, ran off the runway and struck some small trees and shrubs. The pilot lacked total experience in low wing aircraft and lacked familiarity with that particular…Jul 2, 1988 · N2496K · Substantial damage NTSB CHI88DEP03Accident · Minor injuriesFinal reportPiper PA-38-112 · Sheboygan, WIThe aircraft experienced a loss of control during the takeoff portion of a touch and go. The aircraft departed the runway and struck a snowbank collapsing the nose gear. The aircraft was substantially damaged.Jan 24, 1988 · N25760 · Substantial damage NTSB CHI87LA056Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Madison, WIWhile practicing touch & go landings, the student plt reports, the acft 'suddenly dropped' resulting in a hard landing. The acft then porpoised separating the nose gear and skidding to a stop off the rwy.Dec 26, 1986 · N4325E · Substantial damage NTSB CHI86LA213Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Clintonville, WIFollowing at least three successful practice low approaches to a farm field, the student pilot climbed over a small wooded area and did a 180 degree turn to perform an approach to another field. He flew down to within 20 feet of the ground, then applied full…Aug 24, 1986 · N2352N · Substantial damage NTSB CHI86LA210Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lodi, WIDuring a practice emergency landing approach, the instructor told the student to go around at an altitude of about 600 feet AGL. The student failed to add power and pulled the yoke all the way back. The aircraft then stalled. The instructor took control,…Aug 22, 1986 · N2430E · Substantial damage NTSB CHI86LA181Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Middleton, WIThe CFI and student had been practicing touch-and-go's and had just made a full stop landing. The CFI reported that during a subsequent soft field takeoff, accelleration seemed a little slow, and after lift-off, the aircraft seemed to stop accelerating…Jul 26, 1986 · N2444N · Substantial damage NTSB CHI86FEP02Accident · Serious injuriesFinal reportPiper PA-38-112 · Dexterville, WIOn the fourth flight of the day carrying relatives in the vicinity of another relatives house the pilot admitted that he allowed the airspeed to decay during a 55 degree bank and did not recognize an impending stall. When the aircraft stalled there was…Mar 31, 1986 · N23854 · Substantial damage NTSB CHI85LA131Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Madison, WIThe acft collided with a snowbank during takeoff after the plt lost directional control. The takeoff was attempted on rwy 22. The wind was from 180 degrees at 13 KTS.Mar 6, 1985 · N2365F · Substantial damage NTSB CHI85LA076Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Byron Township, WIThe low time 55 hr pilot was wx briefed on unfavorable flt conditions en route to destination. He departed no flt plan. As he approached destination, 8 mi south, the ceiling had lowered to 200 ft, visibility one mi; icing on windshield. While following…Dec 24, 1984 · N26055 · Destroyed NTSB CHI85LA049Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Wild Rose, WIThe plt stated that he was flying at 500 ft AGL over an open marsh that is surrounded by higher terrain covered with pine trees, looking for his father who was hunting in the area. The plt continued to state that he became preoccupied with trying to identify…Nov 18, 1984 · N2428L · Substantial damage NTSB CHI84LA088Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Holman, WIAfter flying in the local area for aprx 40 minutes the plt decided to shoot a landing at an airpark before returning to his home arpt. The plt stated that he applied carb heat on the downwind leg and then returned it to off position. He flew the remainder of…Jan 18, 1984 · N9555T · Substantial damage NTSB CHI84LA061Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Hayward, WIThe acft collided with a snow bank during the landing roll and nosed over. The rwy was covered with snow and was slick. The solo student plt said he landed with more airspeed than normal and the acft started to go to the left on the rwy. The plts attempted…Dec 18, 1983 · N25687 · Substantial damage NTSB CHI83LA174Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Middleton, WIAccording to the instructor pilot the student did not release enough back pressure or use enough right rudder after the acft became airborne. The acft drifted left and was going to stall. The instructor took over and landed the acft. The left main gear came…Apr 21, 1983 · N2444N · Substantial damage NTSB CHI83LA026Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Stevens Point, WIThe aircraft porpoised during landing. The pilot stated that he bounced off the main gear then the nose gear. He then applied power but the aircraft continued to bounce. After he shut down power to the engine the aircraft continued to bounce finally coming to…Oct 16, 1982 · N2428L · Substantial damage