NTSB investigations: Piper PA-38-112
615 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.
Cases, newest first
Query with SQL
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.\"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."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" DESCRun 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 ATL98LA040Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Laurens, SCThe pilot's inadequate weather evaluation that resulted in initiating flight in marginal visual conditions, and resulted in fuel exhaustion.NTSB FTW98FA086Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Tremonton, UTThe pilot's continued VFR flight into instrument meteorological conditions, becoming spatially disoriented and his subsequent loss of aircraft control. Factors were the dark night and weather conditions that included obscuration and snow.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…NTSB CHI97LA295Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Greenwood, INthe student pilot's failure to maintain adequate airspeed during the go-around, which resulted in an inadvertant stall. A factor related to the accident was the raising of flaps.NTSB CHI97LA264Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Glenwood, MNfailure of the student pilot to maintain the correct airspeed for a go-around maneuver, which resulted in a stall/mush and collision with terrain.NTSB NYC97LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Manassas, VAThe pilot's misjudgment of clearance between the aircraft and fuel truck, which resulted in a collision.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.NTSB CHI97LA169Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Minneapolis, MNthe student pilot's improper recovery from a bounced landing and failure to maintain proper runway alignment during a go-around (aborted landing). Factors relating to the accident were: the pilot's improper flare for landing, the reduced light conditions at…NTSB SEA97LA123Accident · Minor injuriesLimited investigationFinal reportPiper PA-38 · Fruitland, UTThe pilot's failure to maintain clearance from mountainous terrain. Factors include his improper inflight decision to attempt to fly through a mountain pass under high density altitude conditions in an aircraft that was operating near the limits of its…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.NTSB MIA97LA148Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Tampa, FLloss of engine for undetermined reason(s), which resulted in a forced landing and subsequent collision with a fence.NTSB IAD97LA068Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Wellsville, NYthe student pilot's improper flare, improper recovery from a bounced landing, and loss of directional control, during the landing.NTSB FTW97LA152Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Stillwater, OKthe pilot's inadequate compensation for the wind conditions, and his failure to maintain directional control, which resulted in a ground swerve and collapse of the nose gear. The crosswind was a related factor.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.NTSB FTW97LA095Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Boswell, OKThe student pilot's improper inflight planning and decision, after becoming lost/disoriented, which resulted in fuel exhaustion, before landing in a suitable landing area. Factors relating to the accident were: the pilot of another aircraft did not accurately…NTSB FTW97LA089Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Brownsville, TXThe pilot's delayed go-around and subsequent inadvertent stall. A factor was the gusty winds.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.NTSB CHI96LA345Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kearney, MOthe pilot's improper use of carburetor heat, which resulted in a reduction of engine power and subsequent collision with the terrain, during a forced landing.NTSB SEA96LA199Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Sisters, ORinadequate preflight planning/preparation by the flight instructor (CFI), and his failure to obtain and/or maintain adequate airspeed, which resulted in an inadvertent stall. Excessive gross weight, high density altitude, and improper use of flaps were…NTSB ATL96LA121Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Tuscaloosa, ALThe pilot's failure to see and avoid an antenna during low altitude maneuvering.NTSB CHI96LA298Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Fairbury, NEinadequate airspeed and an inadvertant stall during the initial takeoff climb. Factors associated with the accident were the rough terrain used for takeoff and the ditch at the departure end on the field.NTSB IAD96LA082Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Clinton, MDthe pilot's failure to assure that an adequate supply of fuel was available for the flight. Related factors were the pilot's inadequate airplane preflight inspection and the unsuitable terrain (horses, fence, house, barn, trees) encountered during the landing…NTSB CHI96LA153Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Layfayette, INthe pilot's improper flare and improper recovery from a bounced landing.NTSB FTW96LA185Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Alice, TXthe student pilot's improper landing flare and improper bounced landing recovery.NTSB FTW96LA154Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Slidell, LAthe pilot's failure to maintain aircraft control during the approach, and his failure to execute a go-around. A factor was the gusting wind.NTSB CHI96LA107Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · St. Paul, MNthe pilot's failure to assure an adequate fuel supply for the flight which resulted in fuel exhaustion. A factor associated with the accident was the signs contacted by the airplane during the forced landing.NTSB FTW96LA105Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Falfurrias, TXfuel starvation due to the pilot's improper positioning of the fuel selector. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA087Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Port Mansfield, TXDeer running onto the runway as the student pilot was landing. A factor relating to the accident was: the soft terrain that was encountered as the pilot was maneuvering to avoid a collision.NTSB LAX95LA349Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Placerville, CAthe student pilot's failure to obtain a proper descent rate and improper remedial by failing to initiate a go-around. The inadvertent stall and the gusty wind conditions were factors in this accident.NTSB CHI95FA326Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Danville, INthe pilot-in-command's inadequate recovery while maneuvering.NTSB MIA95FA224Accident · 3 fatalField investigationFinal reportAerospatiale TB-9 · New Smyrna Bch, FLthe failure of the pilots of both aircraft to see and avoid each other.NTSB CHI95LA315Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Milwaukee, WIthe pilot's premature liftoff which resulted in a stall.NTSB ATL95LA163Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kissimmee, FLThe inadequate visual lookout by the driver of the vehicle. A factor in the accident was the inoperative anti-collision lights of the aircraft.NTSB CHI95LA280Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Champaign, ILthe pilot's failure to maintain directional control of the airplane during takeoff.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.NTSB LAX95LA244Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Rubidoux, CAthe pilot's inadequate preflight planning/preparation in that he attempted to fly an aircraft without first verifying the aircraft's gross weight and published performance capabilities.NTSB MIA95LA167Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Agricola, MSFailure of the pilot-in-command to maintain clearance between the wing and the corn crop at the edge of the runway during the aborted takeoff from the grass runway.NTSB BFO95LA070Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Utica, NYThe pilot's improper retraction of the flaps.NTSB BFO95LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Phillips, MEthe private pilot's failure to obtain/maintain altitude/clearance from obstacles during the takeoff/initial climb. Related factors are the grass/turf runway, the improper weight and balance, and the tailwind.NTSB FTW95LA215Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Corpus Christi, TXThe pilot's inadequate compensation for crosswind conditions.NTSB LAX95LA143Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Torrance, CAthe pilot's improper compensation for the existing wind conditions.NTSB LAX95LA099Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Rosamond, CAFailure of the pilot to maintain directional control. Soft terrain beside the runway was a related factor.NTSB LAX95FA082Accident · Minor injuriesField investigationFinal reportPiper PA-38-112 · Joshua Tree, CAthe operator's inadequate annual inspection by failing to find that the flight control's horizontal section of the 'T' bar was rubbing against the vacuum hoses behind the instrument panel. The jammed 'T' bar and the rough terrain were factors in this accident.NTSB LAX95FA016Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Kettleman City, CAFailure of the student pilot to maintain control of the airplane for an unknown reason. Factors related to the accident were: darkness and the pilot's lack of qualification/instructor endorsement for a cross-country flight at night.NTSB SEA95LA009Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Albany, ORThe failure of the dual student to maintain a proper glidepath and the pilot-in-command's inadequate supervision.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.NTSB CHI94LA303Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Gardner, KSundetermined. A factor associated with the accident is a fence at the off-airport landing site.NTSB LAX94LA329Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Oakdale, CA1) The flight instructor's failure to attain a proper touchdown point on the runway, 2) his failure to initiate a timely go around, and 3) his inadequate supervision of the flight.NTSB LAX94LA312Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Warner Springs, CAthe pilot's inadequate visual lookout for livestock during takeoff.NTSB SEA94LA165Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mccall, IDThe pilot's inadequate preflight planning and attempted operation which exceeded the performance capability of the airplane. Factors include his overconfidence in the aircraft's ability.