Skip to content

NTSB investigations: Piper PA-38-112, OH

17 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

19792026

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" = 'OH' 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\" = 'OH' 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" = 'OH' 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 CEN12LA007Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Centerburg, OHThe pilot's improper pre-flight planning and failure to ensure that there was an adequate fuel supply on board to complete the flight, which resulted in fuel exhaustion. Contributing to the accident was the malfunction of the fuel quantity indicator.Oct 5, 2011 · N6403A · Substantial damage NTSB NYC02LA176Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Athens, OHThe student pilot's improper fuel management, which resulted in fuel starvation during cruise flight. A factor was the operator's failure to perform maintenance on a fuel gauge that was noted twice in a discrepancy log.Aug 27, 2002 · N4307E · Substantial damage NTSB IAD97LA040Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Colombia Staton, OHinadequate supervision by the flight instructor (CFI), and his failure to ensure that sufficient altitude and/or clearance was maintain from obstructions (trees) during the approach. Darkness was a related factor.Dec 31, 1996 · N2587G · Substantial damage NTSB BFO92LA015Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Wadsworth, OHFailure of the pilot to attain an adequate airspeed during an attempted go around, which resulted in a stall. His premature raising of the flaps and lack of experience in the make and model of aircraft were related factors.Jan 4, 1992 · N2587L · Substantial damage NTSB NYC91FA235Accident · 1 fatalField investigationFinal reportPiper PA38-112 · Akron, OHThe pilot lost control of the airplane and inadvertently stalled and spun the airplane at too low an altitude to allow recovery. Factors related to the accident were; the pilot's improper preflight and planning, which resulted in fuel exhaustion, a loss of…Sep 12, 1991 · N9302T · Destroyed NTSB CHI89LA106Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Elyria, OHFailure (shearing) of the right main gear attaching bolts. A contributing factor was: failure of the owner/operator to comply with service bulletin #673B.Jun 9, 1989 · N2529D · Substantial damage NTSB ATL88LA143Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Painesville, OHThe CFI reported that while performing a simulated short field take-off the acft encountered a downdraft and settled into the trees. The CFI held his certificate for one month and the student plt had logged just over fifty hours. This airport was not approved…Apr 14, 1988 · N91371 · Destroyed NTSB ATL87LA112Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Ravenna, OHThe student plt was making a touch and go ldg on rwy 27. After touchdown, he retracted the flaps and applied full power to takeoff again. The acft began to veer left after power was applied. The CFI reported that she told the student to apply right rudder as…Apr 10, 1987 · N2606K · Substantial damage NTSB ATL86FEI04Accident · No injuriesFinal reportPiper PA-38-112 · Wauseon, OHThe acft landed & nosed over about 770 ft upwind of the rwy it had used for takeoff. The CFI thought that the sod strip was too soft for the student to make the takeoff so he took the controls. The acft was unable to gain proper airspeed or alt and landed in…Mar 31, 1986 · N2572C · Substantial damage NTSB CHI83LA253Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Strongville, OHThe acft collided with trees at the departure end of the runway during an aborted takeoff. The instructor pilot who was doing a demonstration flt stated that 'the acft rotated to a normal climb attitude but did not climb out of ground effect. After electing…Jun 12, 1983 · N24802 · Substantial damage NTSB CHI83LA178Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Wadsworth, OHReportedly, the passenger, who was building an ultralight acft, was in the left seat & was being familiarized with flt procedures. The instructor determined that the winds at an uncontrolled arpt were light from 160 deg. He made 3 calls on the UNICOM…Apr 23, 1983 · N2607B · Substantial damage NTSB CHI83LA079Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Springfield, OHThe acft swerved during landing and the landing gear sheared off. This was a supervised solo flt and the pilot had made one sucessful touch and go landing. During the 2nd landing the acft swerved to the left and the landing gear collapsed.Jan 12, 1983 · N25353 · Substantial damage NTSB CHI82DA065Accident · No injuriesFinal reportPiper PA-38-112 · Elyria, OHDuring the landing flare the student overcorrected with full aft elevator. The aircraft pitched up, the instructor applied full power, and the aircraft bounced and drifted into a snow bank. The instructor was reported to have about 20 hours instructing.Feb 22, 1982 · N25743 · Substantial damage NTSB CHI81FEK14Accident · No injuriesClosedPiper PA-38 · New Concord, OHApr 16, 1981 · N25645 · Substantial damage NTSB CHI81FEI07Accident · Serious injuriesClosedPiper PA-38 · Strongsville, OHNov 12, 1980 · N2580N · Destroyed NTSB CHI80FEK03Accident · No injuriesClosedPiper PA-38 · Marion, OHOct 29, 1979 · N9281T · Substantial damage NTSB CHI79FEK23Accident · No injuriesClosedPiper PA-38 · Chesterville, OHSep 7, 1979 · N2457G · Substantial damage