NTSB investigations: Continental A&C65 series, 2004
18 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\") = 2004
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") = 2004
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 MIA05LA033Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Cocoa Beach, FLThe pilot's failure to maintain altitude resulting in flight collision with ground and subsequent collision with fence.NTSB CHI05LA023Accident · 1 fatalLimited investigationFinal reportTaylorcraft BC12-D · Wasta, SDThe pilot inadvertently pulled the fuel shut off valve resulting in fuel starvation and a subsequent loss of engine power. The pilot also failed to maintain adequate airspeed which resulted in the airplane stalling.NTSB ANC05LA006Accident · No injuriesLimited investigationFinal reportPiper J-3 · North Pole, AKAn inadequate annual inspection by other maintenance personnel, which resulted in a loss of engine power during takeoff-initial climb, and subsequent collision with trees during the ensuing emergency landing. Factors associated with the accident are a…NTSB SEA04CA174Accident · No injuriesData collectionFinal reportLuscombe 8A · Nampa, IDThe pilot's failure to maintain directional control during the landing roll. Factors include the pilot's very low total time in this make and model aircraft (one hour), and the soft terrain the aircraft encountered along the side of the runway.NTSB NYC04LA195Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Pittsfield, PAImproper installation of the tailwheel assembly and the inadequate annual inspection which resulted in a loss of directional control during landing.NTSB SEA04LA156Accident · Serious injuriesLimited investigationFinal reportTaylorcraft DC-65 · Wamic, ORThe pilot's inadequate compensation for wind conditions and his failure to maintain airspeed, resulting in a stall. The pilot's failure to use all of the available runway, and the high-gusty winds were factors.NTSB FTW04LA175Accident · No injuriesLimited investigationFinal reportAeronca/Bubeck Bubeck-Aeronca · Burleson, TXThe pilot's inadequate preflight planning/preparation for the flight. Contributing factors were the night visual conditions, and the lack of suitable terrain for landing.NTSB DEN04CA100Accident · No injuriesData collectionFinal reportAeronca 7AC · Limon, COthe pilot's inadequate preflight planning/preparation. A contributing factor was the soft terrain in the takeoff area.NTSB MIA04LA096Accident · Serious injuriesLimited investigationFinal reportAeronca 11AC · Williston, FLThe pilot's failure to maintain airspeed (Vso) while maneuvering, which resulted in a stall/mush, an uncontrolled descent, and impact with terrain.NTSB LAX04LA239Accident · 1 fatalLimited investigationFinal reportChampion 7AC · La Porte, CAthe student pilot's failure to maintain clearance with trees while flying along a mountainous ravine.NTSB ATL04CA125Accident · Serious injuriesData collectionFinal reportTaylorcraft DC-65 · Savannah, TNThe pilot's inadequate preflight planning of fuel required for the flight, which resulted in fuel exhaustion, and the subsequent loss of engine power.NTSB IAD04LA020Accident · No injuriesLimited investigationFinal reportTaylorcraft BC · Cumberland, MDThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall into transmission lines.NTSB FTW04LA124Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Fort Stockton, TXThe pilot's improper leaning of the fuel/air mixture in-flight, which resulted in a loss of engine power. Factor were the wind gusts and the crosswind.NTSB ATL04CA095Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Carthage, TNThe pilot's failure to maintain visual lookout and clearance while maneuvering resulting in an in-flight collision with wires and subsequent collision with water.NTSB LAX04CA185Accident · No injuriesData collectionFinal reportAeronca 65-TAC · Grass Valley, CAthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. Factors in the accident were wind gusts and tailwind/crosswind conditions.NTSB FTW04FA083Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Wrightsville, ARThe pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin on the downwind leg of the traffic pattern.NTSB NYC04CA074Accident · No injuriesData collectionFinal reportDanbrook Corbin Jr Ace · Pittsgrove, NJThe pilot's improper flare and his failure to maintain adequate airspeed which resulted in a stall and a hard landing.NTSB CHI04LA061Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Prairieville, MIThe pilot's failure to maintain altitude/clearance from the transmission wires during final approach. Factors to the accident were the unmarked transmission wires and their support poles.