NTSB investigations: Piper PA-38-112, 1991
16 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\") = 1991
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") = 1991
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 ANC92LA026Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Talkeetna, AKThe pilot's improper flare following an aborted takeoff, which resulted in a hard landing and the subsequent loss of control of the airplane. Contributing to the accident was the pilot's lack of total experience in the type of operation.NTSB CHI92LA217Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Faribault, MNThe pilot's improper starting procedures and the passenger's inattentiveness. A related factor is the pilot's lack of supervision.NTSB BFO91FA087Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Laurel, MDA loss of engine power for undetermined reasons.NTSB ATL91LA181Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lagrange, GAThe J-5 pilot's failure to maintain adequate visual lookout.NTSB NYC91FA235Accident · 1 fatalField investigationFinal reportPiper PA38-112 · Akron, OHThe pilot lost control of the airplane and inadvertently stalled and spun the airplane at too low an altitude to allow recovery. Factors related to the accident were; the pilot's improper preflight and planning, which resulted in fuel exhaustion, a loss of…NTSB CHI91LA289Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kansas City, MOThe pilot's misjudgement of the landing flare and not maintaining directional control during a landing touchdown and roll. A factor was the pilot's lack of total expereince.NTSB LAX91LA365Accident · 2 fatalLimited investigationFinal reportPiper PA-38-112 · Oceano, CAUnknown. The main airplane wreckage and the body of the pilot are presumed lost at sea.NTSB NYC91LA208Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Butler, PAThe pilot failed to maintain control of the airplane, resulting in the airplane departing the runway and impacted with the terrain.NTSB CHI91LA239Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Bridgewater, SDDirectional control was not maintained by the pilot. A factor related to the accident was a fence.NTSB FTW91FA124Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Whitharral, TXPower loss due to fuel exhaustion. Factors were the pilot's operation with the known inoperative landing light and the dark night.NTSB MIA91FA160Accident · 1 fatalField investigationFinal reportPiper PA38-112 · South Port, FLThe pilot in commands failure to maintain a safe altitude resulting in an inflight collision with electrical lines.NTSB LAX91LA240Accident · No injuriesLimited investigationFinal reportPiper PA38-112 · Stockton, CAThat the pilot-in-command used poor preflight planning, inflight decision, and fuel consumption calculations. Contributing to this accident was fuel exhaustion.NTSB CHI91LA276Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Monticello, MNThe pilot in command's (CFI) delayed remedial action. Related factors are the gusty crosswind, the student pilot's lack of total experience, inadequate compensation for crosswind conditions, and the cfi's failure to maintain directional control.NTSB LAX91LA189Accident · No injuriesLimited investigationFinal reportPiper PA 38-112 · Fresno, CAThe pilot-in-command's failure to maintain directional control and inadequate compensation for wind conditions during the landing touchdown. Contributing to the accident was the pilot-in-command's overconfidence in his ability while analyzing the forecast…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 MIA91LA104Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · La Belle, FLFailure of the student pilot to maintain directional control during the landing roll. Contributing to the accident was the fact that the pilot diverted his attention when he pulled the parking brake handle to apply the brakes.