Skip to content

NTSB investigations: Piper PA-38-112, MI

19 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

19712026

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" = 'MI' 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\" = 'MI' 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" = 'MI' 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 CHI02LA122Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Hastings, MIThe failure to attain airspeed, inadequate supervision of the flight, and delayed remedial action which resulted in a stall.May 4, 2002 · N2494B · Substantial damage NTSB CHI00LA253Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Coopersville, MIfuel starvation due to the blocked carburetor. Factors relating to the accident were the foreign object (tab), the improper maintenance performed on the carburetor, and the corn crop.Aug 12, 2000 · N2545N · Substantial damage NTSB CHI00LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Alma, MIthe pilot's inadequate fuel consumption calculation. Factors were the rough terrain, the fence and the exhaustion of the fuel supply.Feb 8, 2000 · N4276E · Substantial damage NTSB CHI94LA318Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · West Branch, MIthe pilot's improper preflight planning in estimating the takeoff distance. The tall, wet grass on the runway was a factor.Sep 9, 1994 · N4286E · Substantial damage NTSB CHI93FA247Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Houghton, MIThe pilot's failure to maintain sufficient airspeed while maneuvering which resulted in a stall/mush. Intentional buzzing was a factor.Jul 9, 1993 · N6279A · Destroyed NTSB CHI93LA113Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mason, MIThe pilot-in-command's failure to maintain directional control.Mar 17, 1993 · N2440T · Substantial damage NTSB CHI89LA067Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Allegan, MIImproper use of flight controls by the student pilot, which resulted in his loss of directional control and an inadvertent ground swerve; and the instructor pilot's (cfi's) inadequate supervision. Factors related to the accident were: the crosswind condition,…Apr 2, 1989 · N9504T · Substantial damage NTSB CHI88LA182Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Flint, MIWhile on a solo instructional flight for the purpose of practicing takeoffs and landings, the student pilot executed a hard landing. The aircraft bounced; when it touched down again, the nose gear collapsed and the aircraft skidded to a stop on the runway.Jul 31, 1988 · N2539G · Substantial damage NTSB CHI87LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Gaylord, MIThe plt landed on a closed rwy and the acft collided with a snowbank. A NOTAM had been issued three days prior, closing the rwy, however, the plt stated that he had not checked notoms prior to departing traverse city. A plt of another acft, who reported being…Nov 16, 1986 · N2357E · Substantial damage NTSB CHI86LA166Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fraser, MIAircraft nosed over during an attempted downwind dead stick landing on an airport after running out of fuel. The aircraft landed at midfield and was unable to stop before running off of the end of the runway.Jul 4, 1986 · N9499T · Substantial damage NTSB CHI84LA005Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Portage, MIThe student plt was on his 1st solo flt. He stated that during the 1st landing, the acft turned right while it was still a few feet off the ground. The plt reported that he had a bad landing so he attempted to go around. During the go-around, the acft turned…Oct 2, 1983 · N26093 · Substantial damage NTSB CHI83LA072Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Detroit, MIThe plt stated that as she was crossing the threshold she noticed that the acft had been blown over too FAR to the rightof the rwy. After correcting for this, she leveled off too high & the acft nosed down onto the rwy.Jan 3, 1983 · N25920 · Substantial damage NTSB CHI82FA200Accident · 2 fatalField investigationFinal reportPiper PA-38 · Niles, MIAt about 1300 EDT, the aircraft took off on a local training flight with a student and a certified flight instructor on board. Later at about 1325, the plane crashed in a wooded area about 1 mi northeast of the approach end of runway 21. One witness reported…Jun 6, 1982 · N2588K · Destroyed NTSB CHI82DA028Accident · No injuriesFinal reportPiper PA-38-112 · Grand Rapids, MIThe pilot-in-command was a student on a check flight for a private license. The check pilot was an FAA inspector. The flight was conducted from an airport with runways that were partially covered with snow and ice. The mishap occurred while the pilot was…Jan 19, 1982 · N26093 · Substantial damage NTSB CHI81FEC30Accident · Minor injuriesClosedPiper PA-38 · Utica, MIJun 27, 1981 · N24088 · Destroyed NTSB CHI80FEM22Accident · No injuriesClosedPiper PA-38 · Saginaw, MIApr 16, 1980 · N2413F · Substantial damage NTSB CHI79DEC19Accident · No injuriesClosedPiper PA-38 · Lapeer, MIFeb 27, 1979 · N4342E · Substantial damage NTSB CHI78FEC47Accident · Serious injuriesClosedPiper PA-38 · Romeo, MIAug 17, 1978 · N9304T · Destroyed NTSB CHI71FBJ59Accident · No injuriesClosedPiper PA-22 · Lawton, MIMar 3, 1971 · N2529A · Substantial damage