NTSB investigations: Piper J3C-65, 2007
10 cases on aircraft the registry lists as Piper J3C-65. 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 | 91 |
|---|---|
| 1965 | 62 |
| 1966 | 88 |
| 1967 | 58 |
| 1968 | 56 |
| 1969 | 66 |
| 1970 | 49 |
| 1971 | 44 |
| 1972 | 30 |
| 1973 | 28 |
| 1974 | 23 |
| 1975 | 31 |
| 1976 | 39 |
| 1977 | 28 |
| 1978 | 23 |
| 1979 | 22 |
| 1980 | 18 |
| 1981 | 18 |
| 1982 | 12 |
| 1983 | 14 |
| 1984 | 20 |
| 1985 | 22 |
| 1986 | 19 |
| 1987 | 13 |
| 1988 | 18 |
| 1989 | 7 |
| 1990 | 11 |
| 1991 | 13 |
| 1992 | 12 |
| 1993 | 8 |
| 1994 | 10 |
| 1995 | 10 |
| 1996 | 18 |
| 1997 | 10 |
| 1998 | 11 |
| 1999 | 13 |
| 2000 | 10 |
| 2001 | 10 |
| 2002 | 4 |
| 2003 | 9 |
| 2004 | 5 |
| 2005 | 4 |
| 2006 | 8 |
| 2007 | 10 |
| 2008 | 10 |
| 2009 | 7 |
| 2010 | 9 |
| 2011 | 7 |
| 2012 | 4 |
| 2013 | 3 |
| 2014 | 10 |
| 2015 | 4 |
| 2017 | 7 |
| 2018 | 5 |
| 2019 | 9 |
| 2020 | 4 |
| 2021 | 10 |
| 2022 | 5 |
| 2023 | 7 |
| 2024 | 7 |
| 2025 | 4 |
| 2026 | 7 |
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 ('7100510'))
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 ('7100510'))
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 ANC07CA107Accident · No injuriesData collectionFinal reportPiper J3 · Tyonek, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in an encounter with soft terrain and a loss of control during the takeoff roll.NTSB ANC07LA088Accident · No injuriesLimited investigationFinal reportPiper J-3 · Big Lake, AKThe flight instructor's delayed instructions to apply the carburetor heat, and his inadequate supervision. A factor contributing to the accident was carburetor icing conditions.NTSB NYC07LA192Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Frenchtown, NJA partial loss of engine power for undetermined reasons.NTSB MIA07LA129Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Andersonville, GAThe pilot's improper decision to make a 180-degree turn at low altitude to return to the departure runway following a loss of engine power during takeoff-initial climb. A factor in the accident was contamination in the carburetor.NTSB NYC07CA165Accident · No injuriesData collectionFinal reportPiper J3C-65 · Uxbridge, MAA partial loss of engine power for undetermined reasons.NTSB CHI07CA149Accident · Minor injuriesData collectionFinal reportPiper J3C · Waterford, MIThe pilot's failure to maintain control of the airplane, causing a water loop. A factor in the accident was the water loop encountered.NTSB MIA07CA097Accident · Minor injuriesData collectionFinal reportPiper J3-C-65 · Byron, GAThe pilots failure to maintain directional control of the airplane during takeoff.NTSB LAX07CA166Accident · No injuriesData collectionFinal reportPiper J3C-65 · Quincy, CAThe pilot's excessive use of the brakes, which resulted in a nose over.NTSB LAX07CA145Accident · No injuriesData collectionFinal reportPiper J3C-65 · Redding, CAThe loss of engine power due to fuel exhaustion.NTSB CHI07CA061Accident · No injuriesData collectionFinal reportPiper J3C-65 · White Lake, SDThe pilot's inadequate compensation for the crosswind conditions during the landing roll, which resulted in a loss of control and a nose over. A factor associated with the accident was the crosswind.