NTSB investigations: Piper PA-38-112, AK
6 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
| 1981 | 1 |
|---|---|
| 1982 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 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\" = 'AK' 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" = 'AK' 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 ANC92LA026Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Talkeetna, AKThe pilot's improper flare following an aborted takeoff, which resulted in a hard landing and the subsequent loss of control of the airplane. Contributing to the accident was the pilot's lack of total experience in the type of operation.NTSB ANC90LA110Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Cantwell, AKThe pilot failed to understand the performance parameters of the airplane and his lack of total experience. A contributing factor to the accident was operating the airplane at a greater than allowable gross weight.NTSB ANC89FA133Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Anchorage, AKLoss of engine power for an unknown reason, and the pilot's failure to maintain adequate airspeed, while turning back toward the airport, which resulted in an inadvertent stall/spin.NTSB ANC82DAG45Accident · No injuriesFinal reportPiper PA-38-112 · Eagle River, AKDuring a local flight, the pilot elected to fly into the mouth of peter's creek valley to look at a friend's cabin. He stated that after he flew over the cabin at about 1500 ft MSL, he "initiated power and a 180 deg turn." He stated that on application of…NTSB ANC82DA024Accident · No injuriesFinal reportPiper PA-38-112 · Anchorage, AKStudent pilot rounded out too high,aircraft bounced and became airborne. The student did not apply power and the CFI added power for a go-around. However he stated he waited too long before applying power and the right wing stalled. The aircraft veered right…NTSB ANC82DAG03Accident · No injuriesClosedPiper PA-38 · Anchorage, AK