Skip to content

NTSB investigations: Piper PA-38-112, IL

24 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

19782026

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" = 'IL' 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\" = 'IL' 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" = 'IL' 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 CEN23LA362Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-38-112 · Harvard, ILThe pilot’s failure to maintain directional control during takeoff that resulted in a runway excursion and an impact with the cornfield.Aug 10, 2023 · N2351A · Substantial damage NTSB CHI99FA342Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Warrensburg, ILAircraft control not being maintained by the private pilot candidate and the inadequate supervision by the FAA Designated Examiner. Factors relating to the accident were the inadvertent spin, the unsuccessful remedial action attempted by the flightcrew, and…Sep 17, 1999 · N9575T · Destroyed NTSB CHI97FA133Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Savoy, ILthe pilot's improper preflight planning/preparation and her not maintaining airspeed. Factors were fuel exhaustion and entering an inadvertent stall.May 18, 1997 · N383AV · Destroyed NTSB CHI95LA280Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Champaign, ILthe pilot's failure to maintain directional control of the airplane during takeoff.Aug 16, 1995 · N381AV · Substantial damage NTSB CHI93LA209Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Newark, ILThe pilot's premature liftoff.Jun 15, 1993 · N381CF · Substantial damage NTSB CHI92LA248Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lincoln, ILA premature liftoff and failure to maintain directional control during a takeoff ground run by the pilot in command. A delay in taking remedial action by the designated pilot examiner is an additional cause.Aug 21, 1992 · N2353L · Substantial damage NTSB CHI90FA193Accident · 2 fatalField investigationFinal reportPiper PA-38 · Hinckley, ILThe instructor pilot's inability to recover from a stall/spin. Factors were: acft wt & balance exceeded, and the instructor's and student pilot's lack of familiarity with acft.Jul 25, 1990 · N2508D · Destroyed NTSB CHI90LA014Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lincoln, ILImproper planning/decision by the pilot, which resulted in his failure to attain sufficient airspeed. Factors related to the accident were: the runway condition & obstructions.Oct 21, 1989 · N9487T · Substantial damage NTSB CHI88LA180Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · St. Jacob, ILDuring the initial climbout the student pilot failed to attain sufficient altitude to clear the power lines located off of the departure end of the runway. When the pilot realized that he would not be able to clear the power lines, he elected to attempt to…Jul 31, 1988 · N9291T · Substantial damage NTSB CHI87LA223Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Joliet, ILThe aircraft landed on what the pilot thought was a runway. He stated that on short final the aircraft floated before touching down and consequently there was not enough room to make a go-around. After touchdown, he braked hard and the aircraft swerved left…Sep 27, 1987 · N6320A · Substantial damage NTSB CHI87LA064Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Decatur, ILFollowing taxi to rwy 36, the plt stated that he completed an engine run-up. On the takeoff roll, the acft swerved to the left before colliding with a snowbank approximately 800 feet from the apch end of the rwy. According to the plt, opposite rudder was…Jan 23, 1987 · N2536A · Substantial damage NTSB CHI84LA101Accident · No injuriesLimited investigationFinal reportPiper PA38-112 · Lacon, ILThe plt was ferrying the acft to the Lacon arpt for winter storage. On final apch she touched down short & struck a snow bank on the apch end of the rwy. The plt stated that difficulty in depth perception due to the snow covered terrain resulted in touchdown…Feb 1, 1984 · N91469 · Substantial damage NTSB CHI84LA020Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · East Peoria, ILAt about 10 ft AGL a 300-400 RPM decrease in power occurred. The plt elected to land straight ahead into a cut bean field. He touched down about 400 ft from the end of the rwy, traveled about 500 ft further where a large rut was struck. About 10 flt hours…Oct 1, 1983 · N2347E · Substantial damage NTSB CHI83LA384Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Blue Island, ILAcft ran off side of rwy & the left wing collided with corn stalks causing the acft to spin 180 deg.Aug 15, 1983 · N2527N · Substantial damage NTSB CHI82DA315Accident · No injuriesFinal reportPiper PA-38 · New Haven, ILThe pilot reported that before departing on a routine pipe line patrol, he obtained a weather briefing. After about 30 minutes of flight, the visibility began to decrease due to ground fog. The pilot elected to land on a gravel road. During the landing roll,…Jul 30, 1982 · N25814 · Substantial damage NTSB CHI82DA268Accident · No injuriesFinal reportPiper PA-38 · Antioch, ILThe pilot initiated a soft field takeoff from a 2200 ft, wet, grass runway. After becoming airborne, he lowered the nose of the aircraft to increase his airspeed. The pilot stated that the aircraft failed to climb as expected and would not clear boats that…Jul 23, 1982 · N2365P · Destroyed NTSB CHI82DEE02Accident · No injuriesClosedPiper PA-38 · Joliet, ILOct 7, 1981 · N2560A · Substantial damage NTSB CHI79FEV32Accident · No injuriesClosedPiper PA-38 · Jerseyville, ILSep 18, 1979 · N2388T · Substantial damage NTSB CHI79DEE63Accident · No injuriesClosedPiper PA-38 · Lansing, ILJun 19, 1979 · N2365N · Substantial damage NTSB CHI79FEE61Accident · No injuriesClosedPiper PA-38 · Grayslake, ILJun 13, 1979 · N2466T · Destroyed NTSB CHI79DEE59Accident · No injuriesClosedPiper PA-38 · Schaumburg, ILMay 25, 1979 · N2572D · Substantial damage NTSB CHI79DEE45Accident · No injuriesClosedPiper PA-38 · Lockport, ILApr 17, 1979 · N9764T · Substantial damage NTSB CHI79DEE26Accident · No injuriesClosedPiper PA-38 · Frankfort, ILJan 7, 1979 · N4445E · Substantial damage NTSB CHI79DEE25Accident · No injuriesClosedPiper PA-38 · Schaumburg, ILDec 19, 1978 · N2560A · Substantial damage