NTSB investigations: Piper PA-38-112, NM
10 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 | 2 |
|---|---|
| 1979 | 3 |
| 1982 | 1 |
| 1986 | 2 |
| 1987 | 1 |
| 1992 | 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\" = 'NM' 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" = 'NM' 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 FTW92LA234Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Roswell, NMThe pilot failed to maintain the correct airspeed on final approach and allowed the aircraft to stall.NTSB DEN88LA039Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Las Cruces, NMWhile practicing crosswind landings the instructor stated that the student touched down normally with aprx 5 knot crosswind. Upon touch down, the right main landing gear separated from the acft causing substantial damage. There were no injuries and no fire.…NTSB DEN86LA237Accident · Minor injuriesLimited investigationFinal reportPiper PA-38 · Santa Fe, NMWhile flying through a mountain pass at an alt of 1,000 ft AGL, the plt encountered downdraft wind currents. The acft entered an uncontrollable descent and impacted in an alpine meadow.NTSB DEN86LA190Accident · Minor injuriesLimited investigationFinal reportPiper PA-38 · Cimarron, NMThe plt received a checkout in the acft prior to the accident and then flew to the philmont scout ranch located at approximately 9,000 foot MSL elevation. Ground witnesses stated that the acft was 'buzzing the area' and flew into an area of high terrain. The…NTSB FTW82DA096Accident · Minor injuriesFinal reportPiper PA-38-112 · Farmington, NMThe aircraft lost power during a cross country flight. During the subsequent forced landing on a dirt road the aircraft collided with a ditch and nosed over.NTSB DEN80FQA01Accident · No injuriesClosedPiper PA-38 · Gallup, NMNTSB DEN79FQA26Accident · No injuriesClosedPiper PA-38 · Albuquerque, NMNTSB DEN79FQD04Accident · No injuriesClosedPiper PA-38 · Hatch, NMNTSB DEN79FA009Accident · 2 fatalClosedPiper PA-38 · Las Cruses, NMNTSB DEN78FQA27Accident · No injuriesClosedPiper PA-38 · Aztec, NM