NTSB investigations: Piper J3C-65, 1976
39 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\") = 1976
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") = 1976
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 MIA77FKG12Accident · Serious injuriesClosedPiper J3 · Greensboro, GANTSB NYC77FFA11Accident · Minor injuriesClosedPiper J-3 · Marlboro, NYNTSB MIA77FA014Accident · 1 fatalClosedPiper J3C · Copeland, FLNTSB MKC77DCG04Accident · No injuriesClosedLuscombe 8A · Carthage, MONTSB LAX77DUQ03Accident · No injuriesClosedPiper J-3 · Newhall, CANTSB MKC76DCD67Accident · No injuriesClosedPiper PA-22 · Marion, IANTSB CHI76FET51Accident · Minor injuriesClosedPiper J3C-65 · Dowagiac, MINTSB MIA76FKH05Accident · Minor injuriesClosedPiper J3C-65 · Atlanta, GANTSB FTW76DRD62Accident · Minor injuriesClosedPiper J-3 · Lake Charles, LANTSB FTW76DPA34Accident · No injuriesClosedPiper J3C · Caddo Mills, TXNTSB IAD76AI090Accident · 1 fatalClosedPiper J-3 · Ooltewah, TNNTSB IAD76AI088Accident · 1 fatalClosedPiper J3C · Troy, NCNTSB MIA76FLG43Accident · No injuriesClosedPiper J-3 · Aiken, SCNTSB MKC76FCG88Accident · No injuriesClosedPiper J-3 · Springfield, MONTSB SEA76DYG65Accident · No injuriesClosedPiper J3C · Moses Lake, WANTSB MKC76FTK31Accident · Serious injuriesClosedPiper J3C-65 · Onida, SDNTSB FTW76DQG98Accident · No injuriesClosedPiper J3C · Farwell, TXNTSB MIA76AM076Accident · 1 fatalClosedPiper J3C-65 · Cartersville, GANTSB CHI76DEP34Accident · No injuriesClosedPiper J3C · Cottage Grove, WINTSB NYC76FGM37Accident · No injuriesClosedPiper J-3 · Jeanette, PANTSB IAD76DLQ28Accident · No injuriesClosedCessna 150 · Cynthiana, KYNTSB OAK76DVG92Accident · No injuriesClosedPiper J-3 · Milton, CANTSB FTW76DRA48Accident · No injuriesClosedPiper J3C · Angleton, TXNTSB ANC76AA099Accident · 2 fatalClosedPiper J3C · Otto Lake, AKNTSB FTW76AF100Accident · 1 fatalClosedPiper J3C · Fordyce, ARNTSB NYC76AN103Accident · 1 fatalClosedPiper J3C-65 · Rockhill Furn, PANTSB MKC76DCJ37Accident · No injuriesClosedPiper J3C-65 · Ashland, NENTSB SEA76AS052Accident · 2 fatalClosedPiper J3C-65 · Rock Springs, MTNTSB CHI76FEM42Accident · Serious injuriesClosedPiper J-3 · Sparta, MINTSB MIA76AM082Accident · 1 fatalClosedPiper J3C · New Ellenton, SCNTSB SEA76DYG39Accident · No injuriesClosedPiper J3C · Tonasket, WANTSB NYC76DHD21Accident · No injuriesClosedPiper J-3 · Bridgeton, NJNTSB FTW76AF079Accident · 1 fatalClosedPiper J3C · Reed, OKNTSB IAD76FIG13Accident · Serious injuriesClosedPiper J3C-65 · Mt Airy, MDNTSB MKC76FCJ29Accident · Serious injuriesClosedPiper J3C-65 · Alliance, NENTSB MIA76DKT56Accident · No injuriesClosedPiper J3C · Homestead, FLNTSB MKC76DER51Accident · No injuriesClosedPiper J3C-65 · Lino Lakes, MNNTSB IAD76FKW19Accident · No injuriesClosedPiper J-3 · Elizabethton, TNNTSB SEA76DYI13Accident · No injuriesClosedPiper J-3 · Medford, OR