Skip to content

NTSB investigations: Piper PA-38-112, MN

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

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" = 'MN' 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\" = 'MN' 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" = 'MN' 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 CHI01LA228Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Tracy, MNThe inadvertent stall during the initial takeoff. Factors relating to the accident were the student pilot's premature lift-off of the airplane during the initial takeoff, the instructor pilot's inadequate supervision, and the fences.Jul 23, 2001 · N23475 · Destroyed 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.Aug 17, 1997 · N23236 · Substantial damage 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…Jun 17, 1997 · N2455F · Substantial damage 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.Mar 15, 1996 · N2503B · Substantial damage NTSB CHI94LA084Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Eden Prairie, MNThe pilot's poorly planned approach and remaining below a proper glide path during final approach. The pilot's lack of total expereince was a factor.Feb 13, 1994 · N23797 · Destroyed NTSB CHI92LA217Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Faribault, MNThe pilot's improper starting procedures and the passenger's inattentiveness. A related factor is the pilot's lack of supervision.Nov 10, 1991 · N9296T · No damage NTSB CHI91LA276Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Monticello, MNThe pilot in command's (CFI) delayed remedial action. Related factors are the gusty crosswind, the student pilot's lack of total experience, inadequate compensation for crosswind conditions, and the cfi's failure to maintain directional control.May 10, 1991 · N2587N · Substantial damage NTSB MKC89LA124Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Buffalo, MNMisjudgement of altitude and distance by the student and inadequate supervision of flight by the instructor (CFI). Contributing factors were: unfavorable wind conditions, high vegetation (grass), and a ditch.Jun 4, 1989 · N38329 · Substantial damage NTSB CHI88FA153Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Hamm Lake, MNLoss of control in flight, either by the student or by the instructor, at an altitude insufficient to allow for a recovery, by the flight instructor, before the resulting out of control descent caused the accident airplane to strike the terrain.Jul 3, 1988 · N2485N · Destroyed NTSB CHI88LA069Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Minneapolis, MNStudent pilot stated that airplane went off runway at 50 KIAS after losing control during landing rollout. Airplane sustained substantial damaged when nose gear collapsed.Feb 25, 1988 · N2359K · Substantial damage NTSB CHI84LA399Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lake Elmo, MNPilot stated that he landed near the approach end of runway 13 and 'right side of aircraft collapsed.' The investigation revealed that the aircraft landed 50 feet to the right side of runway 13. The pilot recorded only a total of 4 hours of night time, 2…Sep 22, 1984 · N25687 · Substantial damage NTSB CHI82DER17Accident · No injuriesClosedPiper PA-38 · Albert Lea, MNDec 4, 1981 · N2393G · Substantial damage NTSB CHI81FER32Accident · No injuriesClosedPiper PA-38 · Blaine, MNApr 8, 1981 · N2359K · Substantial damage NTSB MKC80DER20Accident · No injuriesClosedPiper PA-38 · Anoka, MNJan 20, 1980 · N2536A · Substantial damage NTSB MKC80DER22Accident · No injuriesClosedPiper PA-38 · Fergus Falls, MNJan 13, 1980 · N107WC · Substantial damage NTSB MKC79FER52Accident · Serious injuriesClosedPiper PA-38 · St.Paul, MNJul 7, 1979 · N4324E · Destroyed NTSB MKC79DER23Accident · No injuriesClosedPiper PA-38 · Eden Prairie, MNFeb 7, 1979 · N2359D · Substantial damage NTSB MKC78FER84Accident · No injuriesClosedPiper PA-38 · Eden Prairie, MNAug 5, 1978 · N6291A · Substantial damage