NTSB investigations: Piper PA-38-112, MO
12 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 | 2 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2012 | 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\" = 'MO' 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" = 'MO' 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 CEN12LA362Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Mt. Vernon, MOThe pilot’s decision to continue the landing on a short grass runway with a tailwind after touching down beyond the touchdown point, and his subsequent failure to stop the airplane before colliding with trees off the end of that runway. Contributing to the…NTSB CHI03LA051Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mansfield, MOThe pilot's failure to use carburetor heat, which resulted in the formation of carburetor ice and the loss of engine power.NTSB CHI02LA164Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · St. Joseph, MOThe pilot's failure to attain proper alignment with the runway.NTSB CHI96LA345Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kearney, MOthe pilot's improper use of carburetor heat, which resulted in a reduction of engine power and subsequent collision with the terrain, during a forced landing.NTSB CHI93LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Festus, MOThe pilot-in-command's failure to maintain a proper glidepath during approach. Factors which contributed to the accident were: the pilot's motion sickness and the effect of the over-the-counter medication on his piloting performance.NTSB CHI91LA289Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kansas City, MOThe pilot's misjudgement of the landing flare and not maintaining directional control during a landing touchdown and roll. A factor was the pilot's lack of total expereince.NTSB MKC89LA171Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Liberty, MOControl interference by the dual student as the instructor tried to recover from the student's bounced landing, and failure to maintain proper runway alignment. Contributing factors were: improper flare by the student, the crosswind, the student's…NTSB MKC87LA097Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Marshfield, MOThe PIC made an uneventful cross country flt and touchdown to his destination arpt. During the rollout aft lndg, the PIC rptd a gust 90 degrees fm the left forced the acft to veer left and off the rwy. Tall grass was encountered aft the acft dptd the rwy…NTSB MKC86FA023Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Orrick, MOThe student plt was briefed to practice stalls, slow flight, 720-degree turns and simulated forced landings with specialinstructions for the plt not to go below 500 ft AGL on the simulated forced landings. During one simulated forced landing, the propeller…NTSB MKC84LA121Accident · No injuriesLimited investigationFinal reportPiper PA-38 · St. Joseph, MOThe acft was landed in a gusty crosswind. The acft ballooned and landed hard which collapsed the nose gear.NTSB MKC81FCA01Accident · No injuriesClosedPiper PA-38 · Chesterfield, MONTSB MKC81DCA26Accident · No injuriesClosedPiper PA-38 · Poplar Bluff, MO