NTSB investigations: Piper PA-38-112, 1990
17 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\") = 1990
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") = 1990
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 MIA91LA026Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fort Pierce, FLImproper preflight decision of the instructor pilot to allow the student to takeoff from the soft grass runway and his failure to abort the takeoff.NTSB DEN91FA010Accident · 2 fatalField investigationFinal reportPiper PA-38-125 · Levelland, TXInadvertent stall/spin at an altitude insufficient to effect recovery.NTSB MIA91LA013Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Miami, FLInadequate preflight of the airplane by the pilot-in-command.NTSB LAX90LA324Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Watsonville, CAImproper handling of the aircraft by the student pilot, which resulted in his failure to attain sufficient airspeed to climb after takeoff, and the instructor's (cfi's) inadequate supervision.NTSB NYC90LA218Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Quarryville, PAThe pilot in commands failure to maintain airspeed while climbing to avoid wires.NTSB LAX90LA302Accident · No injuriesLimited investigationFinal reportPiper PA38 · Chandler, AZThe student pilot's loss of control during takeoff. His inexperience in the aircraft and improper use of the flight controls were factors in the accident.NTSB CHI90FA193Accident · 2 fatalField investigationFinal reportPiper PA-38 · Hinckley, ILThe instructor pilot's inability to recover from a stall/spin. Factors were: acft wt & balance exceeded, and the instructor's and student pilot's lack of familiarity with acft.NTSB FTW90LA140Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Houston, TXStudent pilot's failure to maintain directional control during landing.NTSB ANC90LA110Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Cantwell, AKThe pilot failed to understand the performance parameters of the airplane and his lack of total experience. A contributing factor to the accident was operating the airplane at a greater than allowable gross weight.NTSB ATL90FA139Accident · 4 fatalField investigationFinal reportPiper PA-38-112 · Florence, ALFailure of the pilot-in-command of N2409K to maintain safe separation from N2437K during unauthorized formation maneuvering. Overconfidence in personal ability and the execution of unauthorized formation flight on the part of both pilots-in-command were…NTSB DEN90LA122Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Belgrade, MTThe inadvertent stall experienced during the attempted forced landing.NTSB SEA90FA072Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Jean, NVSevere downdrafts/windshear which exceeded the airplane's performance capabilities.NTSB FTW90FA106Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Jacksonville, TXA fuel exhaustion induced power loss during the initial climb after takeoff.NTSB MIA90FA106Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Marco Island, FLFuel exhaustion due to improper planning & decision by the pilot, and an inadvertent stall/spin while maneuvering for a forced landing.NTSB CHI90LA103Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Wausau, WIA hard landing resulting from the pilot not taking timely remedial when a stall was encountered.NTSB NYC90FA075Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Smithfield, RIImproper in-flight planning/decision by the pilot, which resulted in insufficient altitude to recover from a stall. Factors related to the accident were: the pilot's lack of total experience and excessive gross weight of the airplane.NTSB FTW90FA079Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Grand Prairie, TXThe CFI pilot failed to maintain flying speed, and the resultant inadvertent stall. Contributing to the accident was the existing low ceiling.