NTSB investigations: Piper PA-38-112, IN
14 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 per year
| 1978 | 1 |
|---|---|
| 1982 | 3 |
| 1985 | 1 |
| 1988 | 1 |
| 1989 | 3 |
| 1993 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2016 | 1 |
Where
Open the mapLatest cases
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.\"eventStateOrRegion\" = 'IN' 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" = 'IN' 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" 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 CEN16FA220Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Madison, INThe pilot’s failure to maintain a proper climb rate after takeoff and the subsequent collision with transmission line structures.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 CHI96LA153Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Layfayette, INthe pilot's improper flare and improper recovery from a bounced landing.NTSB CHI95FA326Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Danville, INthe pilot-in-command's inadequate recovery while maneuvering.NTSB CHI93LA363Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Griffith, INthe improper recovery from a bounced landing by the pilot-in- command.NTSB CHI89LA130Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Indianapolis, INImproper recovery from a bounced landing and failure to maintain directional control by the pilot. The student pilot's lack of flight experience contributed to the accident.NTSB CHI89LA073Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Brazil, INFailure to establish a proper glidepath. Contributing to the accident was the dark night condition, the pilot's overconfidence in his personal ability, and his lack of familiarity with the airplane.NTSB CHI89LA074Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Griffith, INThe student pilot's failure to compensate for the crosswind condition and maintain directional control during the landing. The airplane departed the runway and nosed over in soft terrain. Contributing to the accident was the student's lack of recent…NTSB CHI88LA109Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Indianapolis, INNTSB CHI86FEX01Accident · No injuriesFinal reportPiper PA-38-112 · Terre Haute, INThe acft rt main & nose gear collapsed during a forced landing after a power loss during takeoff. The student plt was at the controls when the eng quit at about 300 ft AGL. The CFI took the controls and turned left toward a taxiway for the landing. The acft…NTSB CHI83LA030Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Boonville, INOn takeoff the pilot reported the aircraft would not climb but kept settling back to the ground. The left wing hit a fence post and the aircraft nosed over.NTSB CHI82DA099Accident · No injuriesFinal reportPiper PA-38 · Fort Wayne, INThe student pilot was practicing landings with a headwind directly down the runway at 7 knots. During touchdown on his third landing, he lost directional control and the plane veered left and skidded off the runway. The nose gear encountered a side load and…NTSB CHI82DA055Accident · No injuriesFinal reportPiper PA-38-112 · Lebanon, INWhile the instructor was demonstrating recovery procedures from a low approach, the main gear struck snow on a small rise about 400 feet short of the runway. Subsequently, the pilot was forced to land in about 18 inches of snow and the gear failed. The…NTSB CHI78FEX39Accident · No injuriesClosedPiper PA-38 · Indianapolis, IN