NTSB investigations: Continental I0-470 series, 2008
18 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\") = 2008
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") = 2008
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 CEN09CA102Accident · Serious injuriesData collectionFinal reportBeech 95-B55 · Batesville, ARThe pilot's improper decision to land with a tailwind which resulted in the overrun landing. Factors contributing to the accident include the culvert and the tailwind.NTSB WPR09CA059Accident · No injuriesData collectionFinal reportCessna 210 · Sheridan, WYMaintenance personnel's failure to reinstall the left front pilot's seat correctly, which resulted in the pilot's loss of control and subsequent impact with a taxiway sign.NTSB ERA09FA074Accident · 2 fatalField investigationFinal reportBeech 35-B33 · Homosassa Spgs., FLThe pilot’s continued flight into known adverse weather conditions.NTSB WPR09CA101Accident · No injuriesData collectionFinal reportBeech K35 · Port Townsend, WAThe pilot's failure to lower the landing gear prior to landing. Contributing to the accident was the pilot's failure to use a checklist and the distraction caused by the discussion with the passenger.NTSB ERA09CA038Accident · No injuriesData collectionFinal reportBeech 35-C33 · Atlanta, GAThe pilot’s failure to maintain a proper glide path during the final approach, resulting in a collision with the airport approach lights.NTSB WPR09LA009Accident · No injuriesLimited investigationFinal reportCessna 210 · Placerville, CAThe loss of engine power for undetermined reasons.NTSB WPR09CA006Accident · No injuriesData collectionFinal reportCessna 210-5(205) · Payson, UTThe total loss of engine power during cruise flight for undetermined reasons. Contributing to the accident were a dark night and a cherry orchard at the location where the pilot executed the forced landing.NTSB DEN08LA153Accident · No injuriesLimited investigationFinal reportCessna 210 · Pagosa Springs, COThe failure of the landing gear to extend for undetermined reasons.NTSB LAX08LA304Accident · No injuriesLimited investigationFinal reportBeech N35 · The Dalles, ORA collapse of the right main landing gear for undetermined reasons.NTSB NYC08FA231Accident · 4 fatalField investigationFinal reportBeech 95-B55 · Jasper, ALThe pilot's intentional visual flight into known instrument meteorological conditions, resulting in spatial disorientation and a subsequent loss of control in flight. Contributing to the accident was the overweight and aft-center-of-gravity condition of the…NTSB DFW08FA153Accident · 2 fatalField investigationFinal reportCessna 310Q · Steamboat, COThe pilot's failure to maintain clearance from mountainous terrain in day visual conditions. Contributing to the accident was the pilot's impairment due to marijuana and inadequate medical oversight of the pilot by the Federal Aviation Administration.NTSB DEN08LA095Accident · No injuriesLimited investigationFinal reportDowner Bellanca 14-19-3 · N. Little Rock, ARThe loss of engine power due to the incorrect and improper installation of throttle and mixture cables by unknown maintenance personnel.NTSB DFW08CA149Accident · No injuriesData collectionFinal reportBellanca 14-13-3A · San Marcos, TXThe failure of the throttle cable clevis swage. Contributing to the accident was the uneven terrain available for landing.NTSB CHI08CA110Accident · No injuriesData collectionFinal reportBeech 95-B55 · Lansing, MIThe pilot's inadvertent raising of the landing gear during rollout.NTSB LAX08FA101Accident · Serious injuriesField investigationFinal reportCessna 310Q · Compton, CAThe loss of both engines' power during approach due to fuel exhaustion that resulted from the pilot's inadequate preflight inspection and failure to verify the quantity of fuel on board the airplane.NTSB DFW08CA099Accident · No injuriesData collectionFinal reportCessna 310Q · Roswell, NMThe airframe and powerplant mechanic's incorrect reassembly of the landing gear.NTSB LAX08LA064Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Willcox, AZA loss of engine power while on final approach due to multiple grounding faults in the ignition system as a result of poor ignition system maintenance.NTSB CHI08FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 310N · Keflavík, IcelandThe reported loss of both engines' power during cruise for undetermined reasons.