NTSB investigations: Piper PA-38-112
21 cases on aircraft the registry lists as Piper PA-38-112, where the first occurrence was “On ground/water collision with object”. 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
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1984 | 3 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 1997 | 2 |
| 2000 | 2 |
| 2004 | 1 |
| 2006 | 1 |
| 2007 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103812')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 310))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103812')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 310))
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 LAX07CA157Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Mariposa, CAThe pilot's failure to maintain clearance from a vehicle while taxiing.NTSB NYC06CA212Accident · No injuriesData collectionFinal reportPiper PA 38-112 · Chesapeake, VAThe presence of deer on the runway during the landing roll, which resulted in a collision. A factor in the accident was the dark night.NTSB FTW04LA114Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Seminole, OKThe pilot's inadequate pre-flight planning. A contributing factor was the pilot's use of unsuitable terrain for takeoff.NTSB LAX00LA270Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Luis Obispo, CAThe pilot's inadequate visual lookout while taxiing to the runway, which resulted in his failure to see and avoid the fuel truck.NTSB MIA00LA182Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Steens, MSthe flight instructor failed to maintain control of the airplane after landing, which resulted in an on ground collision with a tree. Factors in this accident were the flight instructor allowed the student to get too fast and high on the approach.NTSB NYC97LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Manassas, VAThe pilot's misjudgment of clearance between the aircraft and fuel truck, which resulted in a collision.NTSB ATL97LA102Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Smithfield, NCan animal (deer) on the runway. Factors associated with the accident were: the light condition at dusk, and failure or inability of the flight crew to see the deer in time to avoid a collision.NTSB ATL95LA163Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kissimmee, FLThe inadequate visual lookout by the driver of the vehicle. A factor in the accident was the inoperative anti-collision lights of the aircraft.NTSB CHI92LA248Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lincoln, ILA premature liftoff and failure to maintain directional control during a takeoff ground run by the pilot in command. A delay in taking remedial action by the designated pilot examiner is an additional cause.NTSB ATL91LA181Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lagrange, GAThe J-5 pilot's failure to maintain adequate visual lookout.NTSB CHI90LA014Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lincoln, ILImproper planning/decision by the pilot, which resulted in his failure to attain sufficient airspeed. Factors related to the accident were: the runway condition & obstructions.NTSB FTW87LA182Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Benito, TXDrg the landing roll, the acft's left wing struck a tv camera man, who was standing at the left edge of the rwy, aprx 1200' from the threshold. The acft then veered off the left side of the rwy & the right main gear collapsed. Witnesses stated the camera man…NTSB MIA86LA061Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe plt stated that he was completing his run-up prior to takeoff, looked up & was only able to pull the power off before he was struck by N2361D.NTSB LAX85LA219Accident · No injuriesLimited investigationFinal reportPiper PA 38-112 · Prescott, AZThe acft departed rwy 21. The reported surface winds were 190 degs at 12 KTS gusting to 29 KTS. The acft was climbing at 200 fpm until reaching 800 ft AGL. The plt reported that he considered the climb rate as being too slow and elected to negotiate a…NTSB LAX85LA148Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Sahuarita, AZAcft veered to the right during landing roll on an abandoned airstrip. Right wing contacted a tree aprx 1 ft inboard on right wing tip deforming the main spar. Trees lined both sides of the airstrip.NTSB MIA84LA243Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Miami, FLWhile taxiing for takeoff the acft veered to the left and collided with a parked acft. The plt stated a gust of wind caused the acft to veer. The acft operator reported the plt was helping the pax with a seatbelt when the accident occurred.NTSB DEN84LA257Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Cheyenne, WYFollowing an uneventful solo flight the student plt began to follow a parking vehicle to a parking spot. The spot that the parking vehicle driver selected necessitated that the acft execute a 180 deg turn just priop to stopping. During this turn the right…NTSB NYC84LA100Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · New Haven, CTWhile taxiing in from landing and maneuvering for parking the acft contacted a light pole. The CFI was reportedly at theacft controls at the time of the collision. The right wing was damaged in the collision.NTSB LAX83LUQ05Accident · No injuriesFinal reportPiper PA-38-112 · Rosamond, CAA Piper PA-38, N9905T, and a Bellanca 8GCBC, N8667V, collided at the intersection of rwys 22 & 25, while the acft were landing. The Piper PA-38 was on a dual instructional flt while the Bellanca was being used to tow gliders. The aircrew in the PA-38 saw the…NTSB CHI83LA030Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Boonville, INOn takeoff the pilot reported the aircraft would not climb but kept settling back to the ground. The left wing hit a fence post and the aircraft nosed over.NTSB NYC82DA231Accident · No injuriesFinal reportPiper PA-38-112 · Pomona, NJWhile taxiing from landing, the pilot attempted to pass between a parked aircraft and a parked fuel truck. The wingtip of the taxiing aircraft hit a fender on the truck.