NTSB investigations: Piper PA-38-112, 2007
6 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\") = 2007
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") = 2007
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 NYC07LA138Accident · No injuriesLimited investigationFinal reportPiper PA38 · Jacksonville, FLThe pilot's failure to perform adequate pre-flight fuel consumption calculations, which resulted in a loss of power due to fuel starvation.NTSB LAX07CA157Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Mariposa, CAThe pilot's failure to maintain clearance from a vehicle while taxiing.NTSB NYC07FA109Accident · Serious injuriesField investigationFinal reportPiper PA38-112 · Odenton, MDThe pilot's mismanagement of the airplane's fuel supply, which resulted in fuel starvation and a total loss of engine power.NTSB ATL07FA081Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Dawsonville, GAThe pilot’s improper decision to continue visual flight rules flight into instrument meteorological conditions, with a low cloud ceiling, over mountainous terrain.NTSB LAX07CA105Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Groveland, CAthe pilot's failure to maintain directional control.NTSB SEA07CA057Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Ontario, ORThe pilot's failure to obtain and maintain an airspeed above Vs after lifting off of a remote gravel airstrip. Factors include the pilot's failure to correctly understand the procedure to use for a soft-field takeoff.