NTSB investigations: Piper J3C-65, 1994
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
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\") = 1994
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") = 1994
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 NYC95LA036Accident · No injuriesLimited investigationFinal reportPiper J3C · Waldoboro, METhe pilot's premature lift off which resulted in insufficient climb performance and collision with trees.NTSB SEA94FA237Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Dixon, MTThe pilot in command's allowing the aircraft airspeed to decrease below the stall speed.NTSB BFO94LA142Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Leesburg, OHThe pilot misjudged his altitude and airspeed during landing resulting in an overrun and collision with a fence. A related factor was the wet runway.NTSB NYC94LA141Accident · No injuriesLimited investigationFinal reportBoeing Stearman PT-13 · Readington, NJThe failure of both pilots to maintain adequate visual lookout.NTSB LAX94LA295Accident · No injuriesLimited investigationFinal reportPiper J-3C-65 · Jackson, CAthe pilot's inadequate compensation for the gust of wind and subsequent loss of directional control.NTSB FTW94LA252Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Waller, TXThe pilot's failure to maintain proper clearance during takeoff.NTSB SEA94FA163Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Seeley Lake, MTThe pilot in command's failure to maintain flying airspeed.NTSB MIA94LA138Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Belleair, FLImproper maintenance inspection of the crankcase breather tube resulting in failure to detect blockage of the tube.NTSB SEA94LA108Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Snohomish, WAPoor in-flight planning/decision. A factor to the accident was: high vegetation.NTSB ANC94LA044Accident · No injuriesLimited investigationFinal reportPiper J3 · Denali Nat'L Pk, AKThe failure of the landing gear bolt attachment fitting due to fatigue.