NTSB investigations: Continental I0-470 series, 2003
26 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\") = 2003
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") = 2003
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 LAX04LA083Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Rialto, CAThe pilot's inadequate in-flight planning/decision by his fuel mismanagement and his delay in initiating remedial action which resulted in fuel exhaustion and the loss of engine power.NTSB CHI04LA046Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · St. Paul, MNThe failure of the worm drive bearing that resulted in the failure of the landing gear extension/retraction gearbox, which ultimately resulted in the extension of the landing gear not being possible. A factor to the accident was the airport sign that the…NTSB MIA04LA036Accident · No injuriesLimited investigationFinal reportCessna 310P · Crystal River, FLInadequate maintenance by company maintenance personnel, which resulted in operation of the airplane with a deflated nose landing gear strut, which resulted in the nose gear failing to lock in position, gear collapse, and damage to the airplane during landing…NTSB FTW04LA042Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Clarendon, TXthe loss of engine power due the separation of the number six cylinder as a result of a fatigue failure from the loosening of the cylinder attachment hardware.NTSB IAD04CA004Accident · No injuriesData collectionFinal reportBeech BE-55 · E. Stroudsburg, PAThe pilot's improper flare, which resulted in a hard landing and collapse of the nose landing gear.NTSB FTW04LA031Accident · No injuriesLimited investigationFinal reportCessna 310-H · Oklahoma City, OKThe pilot's mismanagement of the fuel by which he failed to position the fuel selector on the appropriate fuel tanks resulting in fuel starvation. A contributing factor was the pilot's diverted attention.NTSB NYC04LA027Accident · No injuriesLimited investigationFinal reportBeech M35 · Bellefonte, PAA total loss of engine power during approach for undetermined reasons.NTSB LAX04LA032Accident · Serious injuriesLimited investigationFinal reportBeech 95-B55 · Williams, AZa loss of engine power in the right engine due to fuel exhaustion, caused by the pilot's inadequate preflight inspection and failure to refuel the airplane. Also causal was his failure to feather the right propeller and to maintain directional control of the…NTSB LAX04FA019Accident · 2 fatalField investigationFinal reportBeech 35-C33 · Mesquite, NVfuel starvation due to the pilot's inadequate in-flight planning and fuel system management, and failure to select a fuel tank containing fuel. Also causal was the certified flight instructor's inadequate supervision.NTSB CHI04LA009Accident · No injuriesLimited investigationFinal reportBeech A33 · Grandview, MOSeparation of the fuel selector handle which resulted in fuel exhaustion and the subsequent loss of engine power. A factor was the hay bale that the airplane contacted during the forced landing.NTSB CHI03LA324Accident · No injuriesLimited investigationFinal reportBeech 35-33 · Evansville, INThe pilot not maintaining directional control during the landing roll. A contributing factor was the airport sign.NTSB FTW03FA225Accident · 2 fatalField investigationFinal reportCessna 310J · New Orleans, LAThe pilot's failure to maintain aircraft control of the airplane during a go-around. A contributing factor was the crosswind.NTSB ATL03FA136Accident · 1 fatalField investigationFinal reportBeech BE-55 · Winder, GAThe pilot's inadequate preflight preparation in which he failed to secure the cabin door which diverted his attention and resulted in the failure to maintain directional control.NTSB CHI03LA326Accident · No injuriesLimited investigationFinal reportCessna 210 · St. Paul, MNThe pilot in command performing an improper flare.NTSB LAX03LA270Accident · 1 fatalLimited investigationFinal reportBeech K35 · Gerlach, NVthe pilot's failure to maintain an adequate airspeed resulting in a stall mush and collision with terrain.NTSB CHI03LA288Accident · No injuriesLimited investigationFinal reportBeech M35 · Avon, ILThe pilot's inadequate fuel managemant leading to fuel starvation during cruise flight and the unsuitable terrain she encountered during the forced landing. A factor was her lack of total time in the airplane make and model.NTSB MIA03LA169Accident · No injuriesLimited investigationFinal reportBeech 35J · Avon Park, FLThe failure of the pilot to maintain directional control during landing resulting in the airplane drifting to the right, encountering standing water on the runway edge, and running off the runway where it incurred substantial damage.NTSB CHI03FA234Accident · No injuriesField investigationFinal reportBeech M35 · Oshkosh, WIThe pilot's inadequate in-flight planning/decision and his failure to execute a go-around. Contributing factors were the pilot's failure to attain alignment with the runway centerline, the runway light and the airport sign.NTSB FTW03LA189Accident · Serious injuriesLimited investigationFinal reportBeech 35-A33 · Fort Worth, TXThe loss of engine power due to the pilot's improper use of the mixture control. Contributing factors were the pilot's failure to select the battery/alternator circuit, resulting in a loss of battery power, the pilot's failure to follow a checklist and the…NTSB LAX03LA218Accident · No injuriesLimited investigationFinal reportCessna 210 · Henderson, NVA bolt in the fuel selector that restricted the flow of fuel to the engine, which resulted in fuel starvation and a partial loss of engine power during the final approach to land.NTSB NYC03FA136Accident · 2 fatalField investigationFinal reportBeech 35-B33 · Harned, KYThe airplane's in-flight collision with terrain for undetermined reasons.NTSB MIA03LA131Accident · Serious injuriesLimited investigationFinal reportBeech Be-35-33 · Raymond, MSThe loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed resulting in a stall.NTSB NYC03FA131Accident · 4 fatalField investigationFinal reportCessna 205 · Jeannette, PAThe loss of power caused by fragments of the air filter being ingested in the engine. A factor was the pilot's delayed decision to perform a forced landing after experiencing a partial loss of engine power.NTSB MIA03CA117Accident · No injuriesData collectionFinal reportBeech 95-B55 · Forest, MSthe failure of the pilot-in-command to extend the landing gear, or use the checklist while on landing approach, resulting in a gear up landing.NTSB DEN03FA068Accident · 3 fatalField investigationFinal reportCessna 310D · Provo, UTfailure of the student to maintain aircraft control. Contributing factors were the instructor's inattention to the fuel supply, fuel exhaustion, an inadvertent stall/spin during the turn from base leg to final approach. and the instructor's inadequate…NTSB CHI03LA101Accident · Serious injuriesLimited investigationFinal reportBeech K35 · Richmond, INThe pilot misjudged the fuel supply during the aircraft preflight which resulted in fuel exhaustion. A factor associated with the accident was the wires.