NTSB investigations: Piper J3C-65, 1975
31 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
Latest 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\") = 1975
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") = 1975
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 CHI76AC042Accident · 1 fatalClosedPiper J-3 · Hopedale, OHNTSB OAK76FVM19Accident · No injuriesClosedPiper J-3 · Saratoga, CANTSB DEN76FTC22Accident · Serious injuriesClosedPiper J-3 · Gillette, WYNTSB FTW76FRD20Accident · No injuriesClosedPiper J3C-65 · Melville, LANTSB MIA76FLT02Accident · No injuriesClosedPiper J3C · Southhaven, MSNTSB SEA76AS026Accident · 1 fatalClosedPiper J3C-65 · Carbonado, WANTSB MKC76FCG30Accident · Minor injuriesClosedPiper J-3 · Grain Valley, MONTSB MIA76FKT24Accident · Minor injuriesClosedPiper J-3 · Indiantown, FLNTSB MKC76DTG08Accident · No injuriesClosedPiper J-3 · Rolette, NDNTSB MKC76FCG20Accident · Serious injuriesClosedPiper J3C · Cameron, MONTSB MIA76FKT14Accident · Serious injuriesClosedPiper J-3 · Clewiston, FLNTSB MKC76DCG16Accident · Minor injuriesClosedPiper J-3 · Sedalia, MONTSB NYC76FNE03Accident · Minor injuriesClosedPiper J-3 · S Deerfield, MANTSB SEA76AS008Accident · 2 fatalClosedPiper J-3 · Quincy, WANTSB CHI76FEM02Accident · Serious injuriesClosedPiper J3-85C · Acme, MINTSB OAK75DVG05Accident · Minor injuriesClosedPiper J-3 · Colusa, CANTSB NYC76AN001Accident · 1 fatalClosedPiper J3 · Stow, MANTSB NYC75FFJ24Accident · Serious injuriesClosedPiper J-3 · Gasport, NYNTSB CHI75FEC54Accident · No injuriesClosedPiper J3 · Ann Arbor, MINTSB MKC75DTK20Accident · No injuriesClosedPiper J3C-65 · Scenic, SDNTSB CHI75DEG23Accident · No injuriesClosedPiper J-3 · Minford, OHNTSB MIA75AM080Accident · 2 fatalClosedPiper J3C-65 · Damascus, GANTSB MIA75FLD72Accident · No injuriesClosedPiper J-3 · Vero Beach, FLNTSB MKC75FCD44Accident · No injuriesClosedPiper J3C-65 · Clarinda, IANTSB CHI75DEE57Accident · No injuriesClosedPiper J3C-65 · Bradford, ILNTSB SEA75AS038Accident · 2 fatalClosedPiper J-3C · Ellensburg, WANTSB FTW75DRJ26Accident · No injuriesClosedPiper J3C-65 · Texarkana, ARNTSB FTW75FPG45Accident · Serious injuriesClosedPiper PA-18A · Pine Bluff, ARNTSB ANC75DAG78Accident · No injuriesClosedPiper J-3 · Talkeetna, AKNTSB OAK75FJA09Accident · Serious injuriesClosedPiper J3C-65 · Honolulu, HINTSB FTW75FPD25Accident · No injuriesClosedPiper J3C-65 · Santos, TX