NTSB investigations: Continental I0-470 series, 2007
21 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\") = 2007
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") = 2007
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 MIA08CA031Accident · No injuriesData collectionFinal reportCessna 310P · Dunnellon, FLThe improper installation of the right main landing gear scissors by company maintenance personnel, resulting in the collapse of the right main landing gear during takeoff.NTSB NYC08LA061Accident · No injuriesLimited investigationFinal reportCessna 310J · Hilton Head Island, SCThe pilot's failure to maintain aircraft control during a go-around.NTSB SEA08LA040Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Carlsbad, CAThe pilot's improper flare resulting in a porpoise and hard landing.NTSB DFW08LA025Accident · Serious injuriesLimited investigationFinal reportBeech J35 · Fort Worth, TXFailure of the operator to ensure that the metering unit's throttle arm and throttle cable were secured using manufacturer approved hardware. A contributing factor to the pilot's injuries was the lack of shoulder retraints.NTSB DEN08LA014Accident · No injuriesLimited investigationFinal reportCessna 210 · Canon City, COThe failure of the engine throttle cable resulting in a lack of engine power when commanded.NTSB SEA08FA006Accident · 2 fatalField investigationFinal reportCessna 310N · Ekalaka, MTThe pilot's improper in-flight planning/decision, his continued flight into adverse weather (icing conditions), and failure to maintain an adequate airspeed during the emergency descent for landing. Contributing to the accident were the forecast icing…NTSB CHI08CA012Accident · No injuriesData collectionFinal reportCessna 210C · Columbus, OHThe hydraulic system pump leak which resulted in the failure of the emergency landing gear system to extend and lock the landing gear for landing and the flap system.NTSB CHI08CA010Accident · No injuriesData collectionFinal reportBeech N35 · Elyra, OHThe directional control not maintained by the dual student and the inadequate supervision by the certified flight instructor during takeoff roll. Contributing factors were the precision approach path indicator and the ditch.NTSB NYC07CA223Accident · No injuriesData collectionFinal reportBeech BE-55 · Gainesville, GAThe pilot's failure to attain the proper touchdown point.NTSB CHI07LA289Accident · No injuriesLimited investigationFinal reportCessna 310Q · Brownsburg, INThe pilot's poor in-flight planning to make an off airport precautionary landing and his failure to maintain clearance from the construction equipment during the landing roll. Contributing to the accident was the construction equipment.NTSB NYC07LA136Accident · No injuriesLimited investigationFinal reportBeech K35 · Cross Junction, VAThe loss of engine power for undetermined reasons.NTSB SEA07FA148Accident · 2 fatalField investigationFinal reportCessna 210-5 (205) · Quilcene, WAThe pilot's continued flight into instrument meteorological conditions, which resulted in controlled flight into mountainous terrain. Factors contributing to the accident included the low clouds which obscured the rising, mountainous terrain.NTSB SEA07LA129Accident · 1 fatalLimited investigationFinal reportSIAI-Marchetti FN-333 · Minden, NVThe loss of engine power as a result of fuel starvation due to the pilot's improper positioning of the fuel selector and failure to select a tank containing fuel.NTSB ANC07CA033Accident · No injuriesData collectionFinal reportCessna 185 · Cantwell, AKThe pilot's inadequate compensation for wind conditions during takeoff initial climb, which resulted in a descent into high vegetation, and a nose over. Factors contributing to the accident were the pilot's inadequate weather evaluation and a downdraft.NTSB CHI07LA129Accident · No injuriesLimited investigationFinal reportCessna 210 · Vienna, OHLoss of engine power during approach for undetermined reasons. Unsuitable terrain encountered during the forced landing and a vehicle were factors.NTSB NYC07FA096Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Saranac Lake, NYThe pilot's failure to maintain adequate airspeed during initial climb after takeoff, which resulted in an inadvertent stall.NTSB LAX07LA130Accident · 3 fatalLimited investigationFinal reportBeech 35-B33 · Sedona, AZThe pilot's inadequate compensation for the high wind conditions and wind shear encounter on final approach, that led to a failure to maintain an adequate airspeed and a stall.NTSB ATL07LA057Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Atlanta, GAThe improper maintenance of the "B-nut" fitting adjacent to the fuel pump by maintenance personnel, resulting in a fuel leak and wing explosion.NTSB DFW07LA080Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Ponca City, OKThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07CA064Accident · No injuriesData collectionFinal reportBeech F35 · McKinney, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA07LA048Accident · Serious injuriesLimited investigationFinal reportNavion G Model · El Centro, CAThe loss of engine power for undetermined reasons. Contributing factors were the lack of suitable terrain for the forced landing and the glare from the sun.