NTSB investigations: Piper PA-38-112, 1995
15 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
| 1964 | 2 |
|---|---|
| 1965 | 1 |
| 1970 | 1 |
| 1971 | 2 |
| 1978 | 12 |
| 1979 | 40 |
| 1980 | 40 |
| 1981 | 43 |
| 1982 | 42 |
| 1983 | 37 |
| 1984 | 28 |
| 1985 | 21 |
| 1986 | 28 |
| 1987 | 20 |
| 1988 | 36 |
| 1989 | 38 |
| 1990 | 17 |
| 1991 | 16 |
| 1992 | 22 |
| 1993 | 14 |
| 1994 | 12 |
| 1995 | 15 |
| 1996 | 12 |
| 1997 | 14 |
| 1998 | 7 |
| 1999 | 6 |
| 2000 | 10 |
| 2001 | 6 |
| 2002 | 5 |
| 2003 | 8 |
| 2004 | 9 |
| 2005 | 3 |
| 2006 | 4 |
| 2007 | 6 |
| 2008 | 6 |
| 2009 | 5 |
| 2011 | 6 |
| 2012 | 3 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 1 |
| 2019 | 2 |
| 2020 | 5 |
| 2022 | 2 |
| 2023 | 1 |
| 2024 | 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 year(c.\"eventDate\") = 1995
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 year(c."eventDate") = 1995
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 LAX95LA349Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Placerville, CAthe student pilot's failure to obtain a proper descent rate and improper remedial by failing to initiate a go-around. The inadvertent stall and the gusty wind conditions were factors in this accident.NTSB CHI95FA326Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Danville, INthe pilot-in-command's inadequate recovery while maneuvering.NTSB MIA95FA224Accident · 3 fatalField investigationFinal reportAerospatiale TB-9 · New Smyrna Bch, FLthe failure of the pilots of both aircraft to see and avoid each other.NTSB CHI95LA315Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Milwaukee, WIthe pilot's premature liftoff which resulted in a stall.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 CHI95LA280Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Champaign, ILthe pilot's failure to maintain directional control of the airplane during takeoff.NTSB ATL95LA140Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Franklin, NCThe pilot's premature lift-off, which resulted in a stall and collision with the ground.NTSB LAX95LA244Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Rubidoux, CAthe pilot's inadequate preflight planning/preparation in that he attempted to fly an aircraft without first verifying the aircraft's gross weight and published performance capabilities.NTSB MIA95LA167Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Agricola, MSFailure of the pilot-in-command to maintain clearance between the wing and the corn crop at the edge of the runway during the aborted takeoff from the grass runway.NTSB BFO95LA070Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Utica, NYThe pilot's improper retraction of the flaps.NTSB BFO95LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Phillips, MEthe private pilot's failure to obtain/maintain altitude/clearance from obstacles during the takeoff/initial climb. Related factors are the grass/turf runway, the improper weight and balance, and the tailwind.NTSB FTW95LA215Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Corpus Christi, TXThe pilot's inadequate compensation for crosswind conditions.NTSB LAX95LA143Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Torrance, CAthe pilot's improper compensation for the existing wind conditions.NTSB LAX95LA099Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Rosamond, CAFailure of the pilot to maintain directional control. Soft terrain beside the runway was a related factor.NTSB LAX95FA082Accident · Minor injuriesField investigationFinal reportPiper PA-38-112 · Joshua Tree, CAthe operator's inadequate annual inspection by failing to find that the flight control's horizontal section of the 'T' bar was rubbing against the vacuum hoses behind the instrument panel. The jammed 'T' bar and the rough terrain were factors in this accident.