NTSB investigations: Piper PA-38-112, KS
5 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
| 1983 | 1 |
|---|---|
| 1987 | 1 |
| 1992 | 1 |
| 1994 | 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\" = 'KS' 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" = 'KS' 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 CHI94LA303Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Gardner, KSundetermined. A factor associated with the accident is a fence at the off-airport landing site.NTSB CHI94FA097Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Inman, KSAn unintentional spin which occurred during the maneuvering phase of a biennial flight review. A factor related to the accident was: the airplane's lateral-directional characteristics at or near the stall speed.NTSB CHI92LA180Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Catherine, KSThe pilot's inadequate preflight planning. Factors associated with this accident were unsuitable terrain selected by the pilot and airplane clearance over the fence not attained by the pilot.NTSB MKC87LA149Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Benton, KSWhile practicing soft field take offs, student plt with CFI over rotated acft causing premature flt before attaining vxse airspeed. CFI attempted to correct the situation, but acft settled in uncontrolled descent beyond the airport boundary. Acft struck the…NTSB MKC83LA217Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lawrence, KSThe pilot stated that he was taking off for his fourth touch and go landing when the acft weathervaned and he lost control of the acft. The nose wheel struck a concrete drainage ditch.