NTSB investigations: Continental A&C65 series, 2017
21 cases on aircraft whose registry engine model is Continental A&C65 series. 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 | 192 |
|---|---|
| 1965 | 152 |
| 1966 | 155 |
| 1967 | 134 |
| 1968 | 139 |
| 1969 | 145 |
| 1970 | 116 |
| 1971 | 89 |
| 1972 | 103 |
| 1973 | 78 |
| 1974 | 72 |
| 1975 | 86 |
| 1976 | 86 |
| 1977 | 80 |
| 1978 | 54 |
| 1979 | 60 |
| 1980 | 40 |
| 1981 | 58 |
| 1982 | 42 |
| 1983 | 34 |
| 1984 | 43 |
| 1985 | 56 |
| 1986 | 42 |
| 1987 | 30 |
| 1988 | 38 |
| 1989 | 35 |
| 1990 | 23 |
| 1991 | 29 |
| 1992 | 30 |
| 1993 | 25 |
| 1994 | 25 |
| 1995 | 29 |
| 1996 | 38 |
| 1997 | 18 |
| 1998 | 23 |
| 1999 | 31 |
| 2000 | 33 |
| 2001 | 25 |
| 2002 | 22 |
| 2003 | 20 |
| 2004 | 18 |
| 2005 | 27 |
| 2006 | 25 |
| 2007 | 33 |
| 2008 | 15 |
| 2009 | 33 |
| 2010 | 28 |
| 2011 | 28 |
| 2012 | 17 |
| 2013 | 16 |
| 2014 | 16 |
| 2015 | 17 |
| 2016 | 27 |
| 2017 | 21 |
| 2018 | 26 |
| 2019 | 22 |
| 2020 | 12 |
| 2021 | 18 |
| 2022 | 25 |
| 2023 | 16 |
| 2024 | 18 |
| 2025 | 20 |
| 2026 | 14 |
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\") = 2017
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17003'))
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") = 2017
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17003'))
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 CEN18LA038Accident · Serious injuriesLimited investigationFinal reportPiper / Laudeman J3C 65 · Palmyra, WIThe pilot’s inadvertent pulling of the fuel shutoff valve, which resulted in a total loss of engine power and a subsequent forced landing into trees. Contributing to the pilot’s inadvertent pulling of the fuel shutoff valve were habit patterns he had…NTSB GAA18CA018Accident · No injuriesData collectionFinal reportAeronca 7DC · Salinas, CAThe pilot’s failure to maintain directional control during landing with a tailwind.NTSB GAA18CA001Accident · No injuriesData collectionFinal reportPiper J3C · Yakima, WAThe flight instructor's failure to maintain directional control during the takeoff roll.NTSB ERA17LA328Accident · Minor injuriesLimited investigationFinal reportPiper J3C · Hanover Township, PAThe pilot's failure to maintain roll control while maneuvering, which resulted in a collision with trees and terrain.NTSB GAA17CA544Accident · No injuriesData collectionFinal reportPiper PA 11 · Petersville, AKThe pilot’s overapplication of brakes, which resulted in a nose-over.NTSB GAA17CA523Accident · No injuriesData collectionFinal reportTaylorcraft BC12 · Redgranite, WIThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA522Accident · No injuriesData collectionFinal reportLuscombe 8 · Westminster, TXThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB GAA17CA498Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Perryville, MOThe pilot’s failure to maintain directional control during takeoff.NTSB GAA17CA510Accident · No injuriesData collectionFinal reportLuscombe 8 · Angleton, TXThe pilot’s failure to maintain directional control during landing.NTSB ERA17LA275Accident · Minor injuriesLimited investigationFinal reportPiper J3C · Salisbury, CTAn improper replacement of the crankshaft by maintenance personnel, which resulted in a failure of the crankshaft gear and total loss of engine power.NTSB GAA17CA506Accident · No injuriesData collectionFinal reportPiper J3C · Camas, WAThe pilot receiving instruction’s failure to maintain directional control during landing.NTSB ERA17LA262Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11BC · Gilbert, SCThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion.NTSB GAA17CA403Accident · No injuriesData collectionFinal reportLuscombe 8 · Grand Island, NEThe student pilot’s failure to maintain directional control during the takeoff roll and the flight instructor’s delayed remedial action.NTSB ERA17FA226Accident · 1 fatalField investigationFinal reportLuscombe 8 · Remsen, NYThe pilot's failure to maintain the proper airspeed and his exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall at an altitude too low for him to recover.NTSB CEN17LA234Accident · 1 fatalLimited investigationFinal reportAeronca 65 CA · Mount Vernon, OHThe pilot's improper starting procedure before hand propping the engine, and his subsequent attempt to stop the moving airplane, which resulted in him being struck by the propeller.NTSB GAA17CA347Accident · Minor injuriesData collectionFinal reportAeronca 11AC · Watervliet, MIThe flight instructor's inadequate preflight planning, which resulted in a takeoff over maximum gross weight from a turf runway in high density altitude conditions and the airplane’s inability to attain a climb rate and subsequent collision with trees.NTSB GAA17CA381Accident · No injuriesData collectionFinal reportAeronca 7AC · Soldotna, AKThe pilot’s abrupt maneuver to avoid a moose cow and calf during taxi, which resulted in an impact with a tree.NTSB GAA17CA223Accident · No injuriesData collectionFinal reportPiper J3C · New Carlisle, OHThe other pilot’s decision to land on an occupied runway and his failure to see and avoid the airplane.NTSB GAA17CA203Accident · No injuriesData collectionFinal reportAeronca 11AC · Warroad, MNThe pilot’s improper landing flare and his subsequent failure to maintain directional control during the landing in tailwind conditions.NTSB CEN17LA093Accident · No injuriesLimited investigationFinal reportPiper J3C · Brenham, TXThe reciprocating engine's exhaust valve being stuck in the “open” position, which resulted in a partial loss of engine power during initial climb.NTSB GAA17CA113Accident · No injuriesData collectionFinal reportAeronca 7AC · Compton, CAThe pilot’s failure to maintain runway alignment during landing in gusting crosswind conditions, which resulted in an off-runway landing in soft dirt and a nose-over.