NTSB investigations: Continental I0-470 series, 2014
22 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\") = 2014
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") = 2014
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 ERA15CA086Accident · No injuriesData collectionFinal reportCessna 310N · Liberty, NCThe pilot's improper landing flare, which resulted in a hard landing and collapse of the left main landing gear.NTSB CEN15LA089Accident · No injuriesLimited investigationFinal reportCessna 310J · San Antonio, TXThe retraction of the left main landing gear after landing for reasons that could not be determined during postaccident examinations.NTSB ERA15LA071Accident · Minor injuriesLimited investigationFinal reportCessna 210 5(205) · Sussex, NJMaintenance personnel’s inadequate inspection of the No. 2 cylinder valve area during the most recent annual inspection, which resulted in the in-flight failure of the intake valve springs due to rust on the spring surfaces and subsequent fatigue cracking.NTSB CEN15CA067Accident · No injuriesData collectionFinal reportCessna 210 · Edinburg, TXThe loss of engine power due to fuel exhaustion, which resulted from the non-certificated pilot's inadequate preflight planning and inflight decision making.NTSB CEN15FA056Accident · 1 fatalField investigationFinal reportAero Commander 500A · McDade, TXThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack for reasons that could not be determined based on the available evidence, which resulted in an aerodynamic stall/spin. Contributing to the accident…NTSB WPR15LA038Accident · No injuriesLimited investigationFinal reportCessna 210B · Bullhead City, AZThe failure of the landing gear actuator housing during landing for reasons that could not be determined based on the available evidence.NTSB ERA15CA038Accident · No injuriesData collectionFinal reportCessna 172P · Miami, FLThe failure of the student pilot to achieve a proper touchdown during a touch-and-go landing resulting in a hard landing and substantial damage.NTSB CEN15CA011Accident · No injuriesData collectionFinal reportBeech 35-B33 · Effingham, ILThe pilot's failure to lower the landing gear.NTSB ANC14CA077Accident · No injuriesData collectionFinal reportCessna 185 · Gakona, AKThe pilot's inability to maintain directional control after the airplane's main landing gear tire deflated during takeoff.NTSB CEN14LA461Accident · No injuriesLimited investigationFinal reportCessna 310K · El Dorado, KSA fatigue failure of the left engine’s throttle cable, which resulted in the loss of left engine power.NTSB CEN14CA482Accident · No injuriesData collectionFinal reportBeech 95 B55 (T42A) · Bremond, TXMismanagement of fuel, which resulted in a total loss of power due to fuel starvation.NTSB CEN14CA352Accident · No injuriesData collectionFinal reportBeech 35 33 · Mt. Vernon, ILThe pilot's failure to ensure the landing gear was extended into the fully locked position.NTSB ERA14LA324Accident · No injuriesLimited investigationFinal reportBeech 95 55 · Gulf Shores, ALThe pilot’s improper landing flare, which resulted in a hard landing.NTSB WPR14CA261Accident · No injuriesData collectionFinal reportCessna 210A · Port Angeles, WAThe pilot's failure to maintain directional control during landing, which resulted in a ground-loop.NTSB WPR14CA217Accident · No injuriesData collectionFinal reportCessna 210 · Moab, UTThe pilot's inadequate landing flare, which resulted in a hard landing.NTSB CEN14LA204Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Searcy, ARThe pilot's inadequate preflight inspection of the airplane, which resulted in oil starvation and a subsequent engine failure.NTSB ERA14CA185Accident · No injuriesData collectionFinal reportCessna 205A · Leesburg, VAThe pilot's inadequate compensation for the wind conditions during landing, resulting in a runway excursion and impact with terrain. Contributing to the accident was the pilot's inadequate evaluation of the wind conditions.NTSB CEN14LA165Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Wichita Falls, TXThe loss of engine power due to the misrigging of the fuel mixture control.NTSB CEN14LA159Accident · No injuriesLimited investigationFinal reportCessna 310Q · Wapakoneta, OHA fire due to a fuel leak of the cabin heater system. Contributing to the accident was the inadequate maintenance of the airplane, which failed to identify leaks in the heater system.NTSB ERA14FA128Accident · 3 fatalField investigationFinal reportBeech 95-B55 · LaGrange, GAThe pilot's overreaction to a perceived conflict with a tow plane and glider on an intersecting runway, which resulted in a loss of control during an attempted aborted landing. Contributing to the accident was the failure of the glider tow operator to follow…NTSB CEN14FA141Accident · 3 fatalField investigationFinal reportBeech 35/33 · Telluride, COThe airplane’s failure to obtain a positive climb rate, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s inadequate preflight planning.NTSB CEN14CA125Accident · No injuriesData collectionFinal reportCessna 310I · Aurora, COLoss of engine power due to fuel exhaustion and the pilot's inadequate preflight inspection.