Skip to content

NTSB investigations: Piper PA-38-112, NC

18 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

19652026

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" = 'NC' 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\" = 'NC' 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" = 'NC' 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 ERA23LA089Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-38-112 · Rockingham, NCThe pilot’s improper fuel management, which resulted in fuel exhaustion and a total loss of engine power.Dec 13, 2022 · N498DS · Substantial damage NTSB ERA12LA112Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Merry Hill, NCOperation of the airplane by a non-certificated pilot. Contributing to the accident was the non-certificated pilot’s failure to maintain airspeed while making a forced landing following a total loss of engine power at low altitude, which resulted in an…Dec 16, 2011 · N9279T · Substantial damage NTSB ATL97LA102Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Smithfield, NCan animal (deer) on the runway. Factors associated with the accident were: the light condition at dusk, and failure or inability of the flight crew to see the deer in time to avoid a collision.Jul 1, 1997 · N2600N · Substantial damage NTSB ATL97LA058Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Southern Pines, NCthe student pilot's improper landing flare and the flight instructor's inadequate supervision of the training flight, which led to a hard landing.Mar 22, 1997 · N9221T · Substantial damage NTSB ATL95LA140Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Franklin, NCThe pilot's premature lift-off, which resulted in a stall and collision with the ground.Jul 19, 1995 · N6303A · Substantial damage NTSB ATL88LA224Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Reidsville, NCThe student plt rprtd that while landing, the airplane began to veer to the left. Subsequently, it ran off the left side of the rwy & into a ditch. A crosswind was blowing from the left at the time. The operator rprtd that tire marks from the nose & right…Aug 2, 1988 · N26045 · Substantial damage NTSB ATL87LA264Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Winston Salem, NCThe student pilot was performing touch and go landings as part of his supervised solo training. The aircraft landed hard and bounced twice before coming to rest with a collapsed nose gear. Examination of the airframe disclosed extensive crushing damage to the…Sep 27, 1987 · N2488C · Substantial damage NTSB ATL87LA013Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Winston-Salem, NCWhile conducting touch and go landings, N2373G lost power during a go-around. The flight was instructed to go-around due to another aircraft on runway 03. The pilot reversed his course toward runway 21. The aircraft crashed into trees short of runway 21.…Oct 31, 1986 · N2373G · Substantial damage NTSB ATL85LA196Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mt. Airy, NCWhile nearing completion of a solo x-country flt, the eng quit. The student plt selected an open area, but overshot the intended touchdown point & the acft crashed in the backyard of a single family dwelling. An investigation failed to disclose any system…Jun 25, 1985 · N2395G · Substantial damage NTSB ATL85FA147Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Monroe, NCThe acft collided with rwy 23 (aprx 120 ft from the departure end) following a loss of control during an initial takeoff climb. The acft was observed to enter a steep climb on takeoff after which the right wing dropped. The acft then entered a spin prior to…Apr 26, 1985 · N2490A · Destroyed NTSB ATL85LA015Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Charlotte, NCDuring attempted go-around from a bounced landing, the plt allowed the acft to drift off center line and into trees paralling the runway. Directional control was compromised by low flying speed.Oct 20, 1984 · N2388V · Substantial damage NTSB ATL85FA007Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Morgantown, NCN2553A was in traffic pattern conducting touch and go landings. N32828 was maneuvering below the traffic pattern and was seen climbing in direction of N2553A. N32828 was flying westerly into the sun. N2553A was seen in a shallow left turn from crosswind to…Oct 11, 1984 · N32828 · 2 aircraft · Destroyed NTSB ATL84LA244Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Liberty, NCThe instructor pilot retarted the throttle to simulate an engine failure on daownwind at 800 ft AGL after his student had completed a touch and go landing. The CFI then turned to land in the direction opposite the last takeoff, but was unable to achieve…Aug 6, 1984 · N9549T · Substantial damage NTSB ATL80DKM25Accident · Minor injuriesClosedPiper PA-38 · Morganton, NCAug 1, 1980 · N9362T · Destroyed NTSB ATL80FLJ15Accident · No injuriesClosedPiper PA-38 · Pinehurst, NCJul 17, 1980 · N4248E · Substantial damage NTSB IAD80FLJ05Accident · 1 fatalClosedPiper PA-38 · Aventon, NCNov 21, 1979 · N9310T · Destroyed NTSB IAD79DKM09Accident · No injuriesClosedPiper PA-38 · Charlotte, NCFeb 20, 1979 · N6219A · Substantial damage NTSB MIA66F0342Accident · No injuriesClosedPiper PA-22 · Wendell, NCDec 11, 1965 · N2312P · 2 aircraft · Substantial damage