NTSB investigations: Continental I0-470 series, 2004
25 cases on aircraft whose registry engine model is Continental I0-470 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 | 145 |
|---|---|
| 1965 | 162 |
| 1966 | 183 |
| 1967 | 172 |
| 1968 | 94 |
| 1969 | 84 |
| 1970 | 93 |
| 1971 | 62 |
| 1972 | 69 |
| 1973 | 60 |
| 1974 | 56 |
| 1975 | 58 |
| 1976 | 53 |
| 1977 | 42 |
| 1978 | 64 |
| 1979 | 66 |
| 1980 | 49 |
| 1981 | 36 |
| 1982 | 47 |
| 1983 | 41 |
| 1984 | 35 |
| 1985 | 29 |
| 1986 | 26 |
| 1987 | 35 |
| 1988 | 24 |
| 1989 | 19 |
| 1990 | 15 |
| 1991 | 17 |
| 1992 | 20 |
| 1993 | 26 |
| 1994 | 19 |
| 1995 | 20 |
| 1996 | 17 |
| 1997 | 20 |
| 1998 | 19 |
| 1999 | 25 |
| 2000 | 32 |
| 2001 | 27 |
| 2002 | 23 |
| 2003 | 26 |
| 2004 | 25 |
| 2005 | 34 |
| 2006 | 26 |
| 2007 | 21 |
| 2008 | 18 |
| 2009 | 23 |
| 2010 | 28 |
| 2011 | 24 |
| 2012 | 23 |
| 2013 | 18 |
| 2014 | 22 |
| 2015 | 14 |
| 2016 | 18 |
| 2017 | 17 |
| 2018 | 19 |
| 2019 | 19 |
| 2020 | 19 |
| 2021 | 18 |
| 2022 | 17 |
| 2023 | 21 |
| 2024 | 11 |
| 2025 | 25 |
| 2026 | 10 |
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\") = 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 ('17027'))
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 ('17027'))
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 DFW05LA049Accident · Minor injuriesLimited investigationFinal reportBeech BE35 · Los Fresnos, TXThe loss of engine power for undetermined reasons. A contributing factor was the prevailing dark night ilumination.NTSB LAX05LA033Accident · No injuriesLimited investigationFinal reportCessna 210 · Apple Valley, CAloss of engine power due to fuel starvation/exhaustion, which was a result of the pilot's inadequate preflight inspection and failure to ensure there was enough fuel onboard for the flight.NTSB LAX05LA021Accident · No injuriesLimited investigationFinal reportCessna 210A · North Las Vegas, NVloss of engine power for undetermined reasons.NTSB DEN05CA015Accident · Minor injuriesData collectionFinal reportCessna 310I · Draper, UTthe pilot's inadequate in-flight planning and decision making, and his failure to maintain adequate airspeed resulting in a stall.NTSB ATL05FA010Accident · 2 fatalField investigationFinal reportBeech B-55 · Atlanta, GAThe pilot initiated flight into known adverse weather conditions (thunderstorms), which resulted in a loss of control, and subsequent in-flight collision with the ground.NTSB LAX05FA011Accident · 1 fatalField investigationFinal reportCessna 310K · Kula, HIThe failure of the pilot to maintain adequate clearance from mountainous terrain during cruise flight. A factor in the accident was the dark night lighting conditions.NTSB LAX04LA328Accident · Minor injuriesLimited investigationFinal reportCessna 210B · Flagstaff, AZthe pilot's improper leaning procedures and delayed decision to abort the takeoff when it became obvious that the engine was not developing full power. A factor in the accident was the pilot's decision to use a runway with a quartering tailwind.NTSB CHI04LA262Accident · Minor injuriesLimited investigationFinal reportNavion Navion G · Knox, INA loss of engine power for undetermined reasons. Contributing to the accident were the unsuitable terrain encountered, the dark night conditions, and the ditch.NTSB NYC04LA204Accident · No injuriesLimited investigationFinal reportBeech BE-95-A55 · Louisville, KYThe improper refueling of the left auxiliary fuel tank, which resulted in an overflow of fuel, and a subsequent explosion in the left wing during engine start.NTSB DEN04LA128Accident · Minor injuriesLimited investigationFinal reportBeech 95-B55 · Roosevelt, UTthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for a forced landing.NTSB CHI04CA221Accident · No injuriesData collectionFinal reportCessna 310Q · Nappanee, INThe delay in the pilot's performance of an aborted takeoff. A factor was the reported restricted movement of the elevator. Additional factors were the rising easement and roadway the airplane went over before coming to rest in the farmers field.NTSB DEN04LA113Accident · No injuriesLimited investigationFinal reportBellanca 14-19-3A · Estes Park, COthe loss of engine power for undetermined reasons resulting in a forced landing. Factors contributing to the accident were the unsuitable terrain for landing and the mailbox posts.NTSB LAX04LA276Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Minden, NVthe pilot's failure to lower the landing gear during landing approach, which resulted in his inadvertent gear up landing. A factor was his distraction due to a component malfunction.NTSB CHI04LA181Accident · No injuriesLimited investigationFinal reportBeech BE-N35 · Austin, MNThe loss of engine power due to the fatigue fracture of the piston pin plug that lead to engine oil starvation/exhaustion and the subsequent overload fracture of the piston rod and crankcase.NTSB CHI04CA172Accident · No injuriesData collectionFinal reportCessna 310P · Knox, INThe fatigue fracture of the main landing gear assembly.NTSB NYC04LA151Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Morgantown, WVThe pilot's improper fuel management, which resulted in fuel starvation and a subsequent loss of engine power.NTSB DEN04LA084Accident · No injuriesLimited investigationFinal reportCessna 310J · Morgan, UTthe poor friction value on the runway rendering braking action inadequate. Contributing factors include the excessive approach speed, and the pilot's inability to maintain directional control of the aircraft.NTSB CHI04LA144Accident · No injuriesLimited investigationFinal reportBeech M35 · Strafford, MOThe improper installation of the cylinder during the engine overhaul which resulted in the fatigue failure of the cylinder studs and through-bolts and the subsequent separation of the cylinder. Factors associated with the accident were the fence and the guy…NTSB SEA04LA094Accident · No injuriesLimited investigationFinal reportBeech P-35 · Havre, MTA loss of engine power due to fuel starvation during the initial climb after takeoff as a result of an unsecured fuel sender unit which resulted in a false fuel quantity indication.NTSB MIA04WA089Accident · 3 fatalForeign investigationCessna 210B · Marsh Harbour, BahamasNTSB MIA04LA082Accident · Serious injuriesLimited investigationFinal reportBeech K35 · Lake Worth, FLThe loss of engine power for undetermined reasons which resulted in a forced landing, collision with a berm during landing rollout, and the airplane nosing over.NTSB LAX04LA194Accident · No injuriesLimited investigationFinal reportCessna 205 · Page, AZthe fatigue fracture and separation of the pilot's control wheel, which resulted in a momentary loss of control and a hard landing.NTSB LAX04CA179Accident · No injuriesData collectionFinal reportBeech 95-A55 · Montague, CAthe pilot's failure to maintain an adequate airspeed during the takeoff climb, which led to a stall/mush. Factors to the accident were the uneven intersection of the two runways, and the pilot's failure to use all of the available runway, and the premature…NTSB ATL04FA079Accident · 2 fatalField investigationFinal reportCessna 210 · Blountville, TNThe pilot's improper flare, and improper recovery which resulted in a bounced landing, collapse of the left main landing gear, and the pilot's failure to maintain airspeed while maneuvering resulting in a stall, uncontrolled descent, and collision with the…NTSB ANC04FA021Accident · 1 fatalField investigationFinal reportBeech J35 · Pensacola, FLThe pilot's improper decision to conduct flight that exceeded his demonstrated skills/ability. Also causal was his failure to properly execute the instrument approach. Contributing factors were low ceiling, fog, and the pilot's lack of the appropriate…