NTSB investigations: Piper PA-38-112, 1996
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
| 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\") = 1996
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") = 1996
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 IAD97LA040Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Colombia Staton, OHinadequate supervision by the flight instructor (CFI), and his failure to ensure that sufficient altitude and/or clearance was maintain from obstructions (trees) during the approach. Darkness was a related factor.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 SEA96LA199Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Sisters, ORinadequate preflight planning/preparation by the flight instructor (CFI), and his failure to obtain and/or maintain adequate airspeed, which resulted in an inadvertent stall. Excessive gross weight, high density altitude, and improper use of flaps were…NTSB ATL96LA121Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Tuscaloosa, ALThe pilot's failure to see and avoid an antenna during low altitude maneuvering.NTSB CHI96LA298Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Fairbury, NEinadequate airspeed and an inadvertant stall during the initial takeoff climb. Factors associated with the accident were the rough terrain used for takeoff and the ditch at the departure end on the field.NTSB IAD96LA082Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Clinton, MDthe pilot's failure to assure that an adequate supply of fuel was available for the flight. Related factors were the pilot's inadequate airplane preflight inspection and the unsuitable terrain (horses, fence, house, barn, trees) encountered during the landing…NTSB CHI96LA153Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Layfayette, INthe pilot's improper flare and improper recovery from a bounced landing.NTSB FTW96LA185Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Alice, TXthe student pilot's improper landing flare and improper bounced landing recovery.NTSB FTW96LA154Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Slidell, LAthe pilot's failure to maintain aircraft control during the approach, and his failure to execute a go-around. A factor was the gusting wind.NTSB CHI96LA107Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · St. Paul, MNthe pilot's failure to assure an adequate fuel supply for the flight which resulted in fuel exhaustion. A factor associated with the accident was the signs contacted by the airplane during the forced landing.NTSB FTW96LA105Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Falfurrias, TXfuel starvation due to the pilot's improper positioning of the fuel selector. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA087Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Port Mansfield, TXDeer running onto the runway as the student pilot was landing. A factor relating to the accident was: the soft terrain that was encountered as the pilot was maneuvering to avoid a collision.