NTSB investigations: Continental I0-470 series, 2019
19 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\") = 2019
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") = 2019
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 ERA20LA035Accident · No injuriesClass 3 · LimitedFinal reportBeech 55 · Griffin, GAThe pilot’s failure to ensure that the airplane was properly configured for takeoff, which resulted in the inadvertent retraction of the landing gear during the takeoff roll and the airplane’s subsequent runway excursion.NTSB WPR20LA017Accident · No injuriesClass 3 · LimitedFinal reportCessna 205 · Red Creek, AZThe pilot’s failure to properly configure the flaps for an aborted landing, which resulted in degraded climb performance and impact with vegetation at the end of the runway.NTSB ERA20LA018Accident · No injuriesClass 3 · LimitedFinal reportBeech N35 · Madisonville, TNThe pilot's unstable approach and delayed decision to go-around. Contributing to the accident was the unporting of the fuel supply following a forward slip maneuver during the approach, which resulted in the loss of engine power during the go-around.NTSB ERA20LA052Accident · No injuriesClass 3 · LimitedFinal reportBeech 55 · Grove City, PAThe pilot’s mismanagement of the airplane’s available fuel, which resulted in a partial loss of engine power to the left engine, and his subsequent failure to maintain directional control of the airplane while on final approach to the runway.NTSB ERA19LA268Accident · Minor injuriesClass 3 · LimitedFinal reportBeech K35 · St. Augustine, FLAn unintended brake application of the right main landing gear brake system during the landing rollout due to excessive play between the brake caliper anchor bolts and their bushings.NTSB ERA19FA266Accident · 2 fatalClass 3 · FieldFinal reportCessna 210 · Marathon, FLThe pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation, which resulted in the airplane’s descent into water.NTSB GAA19CA536Accident · Minor injuriesData collectionFinal reportCessna 310 · Tahlequah, OKThe total loss of right engine power due to fuel starvation and the pilot's improper fuel management.NTSB WPR19FA246Accident · 3 fatalClass 3 · FieldFinal reportBeech 33 · St. Ignatius, MTThe pilot’s decision to maneuver the airplane at a low altitude, which resulted in impact with power lines and terrain.NTSB ERA19LA255Accident · No injuriesClass 3 · LimitedFinal reportCessna 310 · Tampa, FLThe failure of the right main landing gear to fully extend and lock for reasons that could not be determined.NTSB CEN19FA236Accident · 3 fatalClass 2 · FieldFinal reportBeech 95B55 · Chadron, NEThe pilot's failure to ensure adequate fuel was on board before departing and his in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR19LA196Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 5(205) · Dallesport, ORThe pilot’s improper pitch control during the aborted takeoff, which resulted in a bounced landing and landing gear collapse.NTSB ERA19TA233Accident · No injuriesClass 3Final reportBeech 95B55 · Sanford, FLThe pilot's failure to extend the landing gear during landing.NTSB GAA19CA427Accident · No injuriesData collectionFinal reportBeech 35 · Caldwell, NJThe pilot's distraction while looking for traffic, which led to his failure to extend the landing gear before landing, and his exceedance of the airplane's critical angle of attack during a subsequent go-around, which resulted in an aerodynamic stall.NTSB GAA19CA332Accident · Minor injuriesData collectionFinal reportBeech 35 · Rose Hill, KSThe pilot's improper trim configuration during the takeoff roll, which resulted in the airplane becoming prematurely airborne, and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB GAA19CA327Accident · No injuriesData collectionFinal reportCessna 185 · Gulkana, AKThe pilot's loss of airplane control just before touchdown in gusting wind conditions, which resulted in ground loop after touchdown.NTSB GAA19CA318Accident · No injuriesData collectionFinal reportBeech 55 · Youngstown, OHThe pilot's improper landing flare, which resulted in a hard landing.NTSB WPR19LA139Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Minden, NVA partial extension of the landing gear due to the poor condition of the electric landing gear motor, which resulted in a gear collapse upon landing.NTSB ERA19LA136Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 95B55 · Clewiston, FLThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to perform the appropriate emergency checklists following the loss of engine power.NTSB WPR19LA064Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 35 · Port Hadlock, WAA total loss of engine power due to fuel starvation and the pilot’s mismanagement of the available fuel.