NTSB investigations: Piper PA-38-112, IA
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
| 1970 | 1 |
|---|---|
| 1979 | 1 |
| 1981 | 3 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1989 | 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\" = 'IA' 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" = 'IA' 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 CHI91LA114Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Burlington, IADelayed initiation of remedial action by the flight instructor. Factors related to the accident are gusty crosswinds, inadequate compensation for wind conditions and not maintaining airspeed by the student pilot, and complacency by the instructor.NTSB MKC90LA013Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Charles City, IAThe pilot-in-command's failure to maintain adequate control of the aircraft during the landing phase coupled with the cfi's inadequate supervision during the instructional flight. The cfi's lack of familiarity with the accident aircraft was a contributing…NTSB MKC86LA056Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Des Moines, IAThe student pilot stated he was on the takeoff roll for a practice flight when he lost directional control and ran off the left edge of the runway and stayed there until it impacted a taxi/intersection sign.NTSB MKC85LA083Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mechanicsville, IAThe plt attempted a takeoff from a short, wet, soft, alfalfa field in an acft loaded with two occurants and aprx a full load of fuel. The acft collided with a fence and a tree after using the available distance in the flt attempt. Plt recommended a more…NTSB MKC85LA020Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Burlington, IAAccording to the pilot the descent into the traffic pattern was late and the base turn performed early leaving the acft high on final. As a result, an excessive rate of descent developed on short final. The high descent rate and diminishing daylight led the…NTSB MKC83LA154Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Farragut, IAThe acft stalled into an OAT field just past the departure end of the rwy during takeoff. The pilot stated that he took off on a hot day (temperature 86 degrees) from a 1500 ft grass strip. The acft would not fly out of ground effect and fell into an OAT…NTSB MKC82DA060Accident · No injuriesFinal reportPiper PA-38-112 · Dubuque, IAThe student pilot was on a solo cross-country flight. After arriving at Dubuque, he landed on runway 18. The student stated that the wind was from 230 degrees at 16, gusting 23 knots. He reported that during the landing, the plane was lifted off two times by…NTSB MKC81DCD38Accident · No injuriesClosedPiper PA-38 · Burlington, IANTSB MKC81DCD15Accident · No injuriesClosedPiper PA-38 · Moulton, IANTSB MKC81FCD07Accident · No injuriesClosedPiper PA-38 · Cedar Rapids, IANTSB MKC79DCD29Accident · No injuriesClosedPiper PA-38 · Ladora, IANTSB MKC70FCD33Accident · Serious injuriesClosedPiper PA-22 · Atlantic, IA