NTSB investigations: Piper PA-38-112, NY

15 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

NTSB investigations: Piper PA-38-112, NY per year, 1978–2026: 15 cases
1978	1
1980	2
1981	3
1982	2
1983	1
1986	2
1989	1
1995	1
1997	1
2005	1

Where

Open the map

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" = 'NY' 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\" = 'NY' 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" = 'NY' 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 NYC05LA063Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Hamburg, NYThe pilot's failure to maintain directional control while landing.Mar 26, 2005 · N2368E · Substantial damage 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.Apr 20, 1997 · N2477K · Substantial damage NTSB BFO95LA070Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Utica, NYThe pilot's improper retraction of the flaps.Jun 21, 1995 · N2423A · Substantial damage NTSB NYC89LA065Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Albany, NYFuel exhaustion resulting from the pilot's inadequate in-flight planning and misjudged fuel consumption.Jan 14, 1989 · N2361K · Substantial damage NTSB NYC87LA019Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Leroy, NYFlight instructor simulating an emergency landing, landed on main landing gears and tail. Aircraft veered to the right off the runway and collided with bushes.Oct 15, 1986 · N60CS · Substantial damage NTSB NYC86LA198Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Farmingdale, NYThe Piper PA-38-112 had just taken off and was on crosswind when it experienced a power loss. The pilot landed in a cemetary and both the pilot and passenger received minor injuries. The aircraft received substantial damage. Examination of the acft revealed…Aug 5, 1986 · N9359T · Substantial damage NTSB NYC83FA105Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Farmingdale, NYBefore the acft took off, the tower received a radio call from the plane requesting 'is there anyway we can get a simulated eng failure after takeoff & land downwind.' The aircrew indicated they would climb to 600 ft, then begin the simulated emergency. The…Apr 30, 1983 · N2580L · Destroyed NTSB NYC82DA191Accident · No injuriesFinal reportPiper PA-38-112 · Poestenkill, NYDuring a touch & go the plt retracted the flaps & applied full power, but the acft seemed sluggish in gaining speed. The plt applied brakes & cut the throttle, but the acft ran off the end of the rwy coming to rest at the edge of a swamp.Aug 6, 1982 · N2361K · Substantial damage NTSB NYC82DA093Accident · No injuriesFinal reportPiper PA-38-112 · Endicott, NYDuring takeoff roll the aircraft veered to the left. The pilot stated that he applied right rudder and aileron into the wind, however; the aicraft continued to the left. The pilot then closed the throttle and the aircraft collided with runway lights causing…May 10, 1982 · N2483A · Substantial damage NTSB NYC81FHJ09Accident · No injuriesClosedPiper PA-38 · Shirley, NYJun 21, 1981 · N23738 · Substantial damage NTSB NYC81DFA15Accident · No injuriesClosedPiper PA-38 · Newcomb, NYApr 30, 1981 · N2329P · Substantial damage NTSB NYC81FFA14Accident · No injuriesClosedPiper PA-38 · Knox, NYMar 28, 1981 · N2565D · Substantial damage NTSB NYC80DA072Accident · No injuriesClosedPiper PA-38 · W Hampton Bch, NYAug 17, 1980 · N2360P · Substantial damage NTSB NYC80FFJ07Accident · No injuriesClosedPiper PA-38 · Weedsport, NYMay 18, 1980 · N2483A · Substantial damage NTSB NYC79FFA07Accident · No injuriesClosedPiper PA-38 · Oneonta, NYDec 23, 1978 · N2483A · Substantial damage