NTSB investigations: Piper PA-38-112, ID
9 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
| 1979 | 1 |
|---|---|
| 1980 | 1 |
| 1982 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 2004 | 1 |
| 2009 | 2 |
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\" = 'ID' 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" = 'ID' 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 WPR09CA392Accident · Minor injuriesData collectionFinal reportPiper PA-38-112 · Kamiah, IDThe failure of the student pilot to maintain directional control during landing.NTSB WPR09CA274Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Grangeville, IDThe pilot's failure to maintain clearance from an obstacle during taxi.NTSB SEA04LA104Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Jerome, IDThe pilot's failure to refuel the airplane resulting in fuel exhaustion and the loss of power during descent for landing. Factors contributing to the accident were the soft terrain and the forced landing site.NTSB SEA98LA043Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Dubois, IDThe student pilot's misjudgment of altitude/clearance and overloading of the nose gear. A contributing factor was the snow-covered turf runway.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.NTSB SEA93LA077Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Burley, IDLanding on the wrong runway and an improper touchdown. Lack of total experience in type of operation was a factor.NTSB SEA82DA088Accident · No injuriesFinal reportPiper PA-38-112 · Oakley, IDAt about 1045 MDT, the pilot departed ogden, ut on a solo, cross-country flight to jackpot, NV, pocatello, ID and return. While en route to jackpot, he encountered turbulence and decreasing visibility over a mountainous area and descended from 8500 ft MSL to…NTSB SEA80DYP12Accident · No injuriesClosedPiper PA-38 · Sandpoint, IDNTSB SEA79FA046Accident · 1 fatalClosedPiper PA-38 · Bellevue, ID