NTSB investigations: Continental I0-470 series, 2009
23 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
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\") = 2009
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") = 2009
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 CEN10LA085Accident · No injuriesLimited investigationFinal reportCessna 210A · Robert Lee, TXThe collapse of the right main landing gear during landing for unknown reasons.NTSB WPR10LA076Accident · Serious injuriesLimited investigationFinal reportBeech 35-33 · Lehi, UTThe loss of engine power during cruise flight for undetermined reasons.NTSB WPR10LA053Accident · Minor injuriesLimited investigationFinal reportBeech 35-B33 · Chico, CAA loss of engine power during final approach for undetermined reasons.NTSB CEN10LA039Accident · Serious injuriesLimited investigationFinal reportBeech 95-B55 · Brenham, TXThe loss of engine power (right engine) during initial climb for undetermined reasons.NTSB ERA10FA040Accident · 2 fatalField investigationFinal reportCessna 310J · Lawrenceville, GAThe pilot’s loss of aircraft control while maneuvering in instrument meteorological conditions, as a result of spatial disorientation.NTSB CEN10LA032Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Walsh, COA partial loss of engine power due to failure of the No. 2 cylinder as a result of the failure of the repair facility to properly torque the lower four nuts on the cylinder.NTSB ERA10LA005Accident · No injuriesLimited investigationFinal reportCessna 210 · Louisville, KYA malfunction of the landing gear extension system due to a fractured hydraulic line. Contributing to the accident was the inadequate inspection and maintenance of the hydraulic line.NTSB WPR09CA467Accident · No injuriesData collectionFinal reportBeech 35-C33 · Tillamook, ORA loss of engine power due to fuel exhaustion as a result of the pilot's failure to visually verify that sufficient fuel was on board prior to flight. Contributing to the accident was a malfunctioning fuel gage.NTSB ANC09LA100Accident · No injuriesLimited investigationFinal reportGrumman G-44A · Anchorage, AKA fatigue fracture of an unapproved hydraulic brake line fitting, which resulted in a loss of control during the landing roll. Contributing to the accident was the installation of an unapproved part by an unknown maintenance personnel.NTSB CEN09CA559Accident · No injuriesData collectionFinal reportNavion Navion G · Eau Claire, MIA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management.NTSB ERA09TA466Accident · No injuriesFinal reportCessna 180 · Spartanburg, SCThe Cessna pilot's inadequate visual lookout.NTSB WPR09LA355Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Truckee, CAA loss of engine power during initial climb for undetermined reasons.NTSB CEN09CA457Accident · No injuriesData collectionFinal reportCessna 310 · Fort Worth, TXThe failure of the pivot pin in the side brace of the right main landing gear resulting in the gear collapse during taxi for undetermined reasons.NTSB ERA09CA366Accident · Minor injuriesData collectionFinal reportCessna 210-5(205) · Porterdale, GAThe loss of engine power due to fuel exhaustion as a result of the pilot's use of improper fuel caps. Contributing to the accident was the pilot’s selection of an unsuitable area for landing.NTSB WPR09FA248Accident · 3 fatalField investigationFinal reportCessna 172N · Long Beach, CAThe failure of both pilots to see and avoid each other's aircraft.NTSB WPR09FA235Accident · 5 fatalField investigationFinal reportBeech 95 · Minden, NVThe pilot's failure to maintain an adequate airspeed while maneuvering during a low altitude maneuver that resulted in a stall.NTSB CEN09LA274Accident · Serious injuriesLimited investigationFinal reportBeech 35-C33 · Addison, TXA loss of engine power in flight due to fuel starvation as a result of the pilots' inadequate fuel management.NTSB CEN09CA260Accident · No injuriesData collectionFinal reportCessna 210 · Richmond, INThe pilot under instruction's failure to lower the landing gear and the instructor pilot's inadequate supervision.NTSB ERA09LA210Accident · No injuriesLimited investigationFinal reportCessna 310K · Ocala, FLThe right main landing gear collapse as a result of the pilot's improper flare during a previous landing. Contributing to the accident was the flight instructor's inadequate supervision.NTSB CEN09FA164Accident · 2 fatalField investigationFinal reportBeech 95-A55 · Porter, TXThe pilot’s failure to maintain control of the airplane during an aborted landing for undetermined reasons.NTSB WPR09FA096Accident · 2 fatalField investigationFinal reportCessna 205 · Flagstaff, AZThe pilot's loss of situational awareness and failure to maintain clearance from hilly terrain while flying in an area of a low cloud ceiling. Contributing to the accident was the pilot's decision to continue flight due to a self-induced pressure.NTSB WPR09CA092Accident · No injuriesData collectionFinal reportRyan Navion · Three Forks, MTA total loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel system management. Contributing to the accident were the pilot's diverted attention and failure to perform the prelanding checklist.NTSB WPR09LA079Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Corona, CAThe pilot's inadequate compensation for the gusting wind conditions and failure to maintain directional control during the takeoff-initial climb.