NTSB investigations: Piper PA-38-112, MA
7 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 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 2008 | 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\" = 'MA' 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" = 'MA' 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 MIA08CA071Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Norwood, MAThe failure of the flightcrew to maintain directional control of the airplane.NTSB BFO93LA136Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Pittsfield, MAThe failure of the pilot of the PA-28, N9044J, to properly tune his radios, and his failure to see and avoid the PA-38, N91357.NTSB NYC93LA020Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Newburyport, MAThe pilot's inaccurate fuel consumption calculations and improper preflight planning, resulting in fuel exhaustion.NTSB BFO92FA131Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Conway, MAThe pilot's failure to maintain clearance above the trees. A possible factor related to the accident was the pilot's use of a prescription drug.NTSB NYC86LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Norwood, MAThe plt stated a gust of wind was encountered when the acft was 5 ft from touchdown. The gust turned the acft 90 degs from the rwy heading. The plt applied pwr to avoid trees but was unsuccessful and a collision with the trees occurred. Winds were reportedly…NTSB NYC84LA101Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Norwood, MAThe student plt was practicing touch and go landings. The plt reported that the acft encountered a strong gust of wind about 5 ft AGL during the 2nd landing. The touchdown was made on the right main gear as the acft skidded and bounced. The next landing was…NTSB NYC81FNA14Accident · No injuriesClosedPiper PA-38 · New Bedford, MA