NTSB investigations: Continental I0-470 series, OK
44 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 | 3 |
|---|---|
| 1965 | 1 |
| 1966 | 4 |
| 1967 | 2 |
| 1968 | 2 |
| 1969 | 2 |
| 1972 | 2 |
| 1973 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 2 |
| 1984 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1996 | 2 |
| 1997 | 1 |
| 1999 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2013 | 2 |
| 2018 | 1 |
| 2019 | 1 |
| 2021 | 2 |
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 c.\"eventStateOrRegion\" = 'OK' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'OK' AND c."eventCountry" = 'USA'
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 CEN22FA070Accident · 1 fatalClass 3 · FieldFinal reportCessna 310J · Inola, OKThe loss of airplane control for reasons that could not be determined based on the available evidence.NTSB CEN21FA300Accident · 2 fatalClass 3 · FieldFinal reportBeech 35-33 · Roff, OKThe pilot’s loss of airplane control due to spatial disorientation during low-level nighttime flight.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 ERA19LA006Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 205 · Wagoner, OKMaintenance personnel’s improper maintenance of the magnetos, which resulted in a loss of engine power.NTSB CEN13LA565Accident · No injuriesLimited investigationFinal reportCessna 210-5(205) · Weatherford, OKThe pilot’s inadequate preflight inspection and fuel planning, which resulted in fuel exhaustion and a total loss of engine power during descent.NTSB CEN13FA137Accident · 3 fatalField investigationFinal reportBeech 95-B55 (T42A) · Mangum, OKThe airplane's aerodynamic stall/spin at low altitude and subsequent impact with terrain for reasons that could not be determined during postaccident examinations. Contributing to the accident was the pilot's lack of currency/proficiency.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 DFW06CA165Accident · No injuriesData collectionFinal reportCessna 210 · Lawton, OKThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05CA104Accident · Minor injuriesData collectionFinal reportBeech J35 · Bartlesville, OKA loss of engine power due to the pilot's inadvertent and improper positioning of the fuel tank selector, which resulted in fuel starvation. A factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA031Accident · No injuriesLimited investigationFinal reportCessna 310-H · Oklahoma City, OKThe pilot's mismanagement of the fuel by which he failed to position the fuel selector on the appropriate fuel tanks resulting in fuel starvation. A contributing factor was the pilot's diverted attention.NTSB FTW03LA035Accident · Serious injuriesLimited investigationFinal reportBeech J35 · Newcastle, OKThe loss of engine power due to fuel starvation. Contributing factors were the pilot's improper positioning of the fuel selector and the lack of suitable terrain for landing.NTSB FTW99LA248Accident · Serious injuriesLimited investigationFinal reportBeech 95-A55 · Ada, OKThe pilot's failure to maintain directional control of the airplane during the landing flare/touchdown. Factors were the pilot's excessive approach speed and the partial failure of the seat guides for the pilot's seat.NTSB FTW97LA146Accident · No injuriesLimited investigationFinal reportBeech G33 · Bixby, OKfailure of a number two connecting rod bolt, possibly from being either over-torqued or under-torqued during installation, and failure of the pilot to see-and-avoid the transmission line, while performing a forced landing.NTSB FTW96LA345Accident · No injuriesLimited investigationFinal reportCessna 210-5 · Muskogee, OKloss of engine power due to fuel contamination. The lack of suitable terrain for a forced landing was a related factor.NTSB FTW96LA298Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Ardmore, OKThe pilot's inadvertent premature retraction of the landing gear during takeoff roll. A factor was inadequate supervision by the safety pilot/flight instructor.NTSB FTW93LA223Accident · No injuriesLimited investigationFinal reportBeech 35-33 · Guymon, OKThe pilot's inadequate compensation for wind conditions. Factors were windshear and gusty crosswinds.NTSB DEN91LA107Accident · Minor injuriesLimited investigationFinal reportBeech J35 · Tulsa, OKThe engine ailure for undetermined reasons. Factors were the light condition and the lack of suitable terrain.NTSB FTW91LA026Accident · No injuriesLimited investigationFinal reportCessna 205 · Medford, OKThe pilot's use of improper starting procedures which resulted in the loss of control of the airplane. A factor in the accident was the airplane's encounter with rough terrain during the unmanned taxi.NTSB FTW89DPJ07Accident · 2 fatalFinal reportBeech T-34 · Haskell, OKFailure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall. Factors related to the accident were: a leak in the pitot system, failure of the pilot to obtain adequate maintenance/inspection of the pitot system, and his lack of…NTSB FTW84LA386Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Altus, OKAccording to the plt, with full flaps extended the acft encountered a windshear during the flare causing an excessive rate of descent on touchdown. Rwy contact collapsed the left main landing gear allowing the left wing to scrape on the rwy. Shortly before…NTSB FTW84FA045Accident · 2 fatalField investigationFinal reportCessna 310L · Bartlesville, OKThe acft was observed at 300-500 ft on a downwind leg over the brightly lighted city. After passing the city the acft entered a very dark & hilly area immediately north of the city. He then made a left turn onto base leg & remained over unlighted & hilly…NTSB FTW83LA197Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Gage, OKThe acft made a forced landing off arpt after the engine quit. The weather was VMC and no flt plan was filed. This was across-country flt from los angeles, CA to bolivar, MO with a fuel stop at Gage, OK. The flt crashed 900 ft short of the rwy at Gage, OK.…NTSB FTW82DA107Accident · No injuriesFinal reportBeech 95-B55 · Afton, OKDuring landing the aircraft bounced on the nose gear three times before the nose gear collapsed. The aircraft slid 60 yards on its nose and stopped midway down the runway.NTSB FTW81FPJ10Accident · No injuriesClosedBeech 95-B55 · Oklahoma City, OKNTSB FTW79DPJ10Accident · No injuriesClosedCessna 210C · Seiling, OKNTSB FTW79FPM03Accident · Serious injuriesClosedCessna 185A · Tulsa, OKNTSB FTW76DPJ42Accident · Minor injuriesClosedBellanca 14-19 · Duncan, OKNTSB FTW73FPJ25Accident · Minor injuriesClosedCessna 310Q · El Reno, OKNTSB FTW72DPM32Accident · No injuriesClosedBeech 35 · Talihina, OKNTSB FTW72DPJ29Accident · No injuriesClosedBeech 35-33 · Bethany, OKNTSB FTW70D0225Accident · No injuriesClosedCessna 310L · Newkirk, OKNTSB FTW70F0021Accident · Minor injuriesClosedCessna 210B · Ardmore, OKNTSB FTW69F0277Accident · Minor injuriesClosedCessna 310F · Stroud, OKNTSB FTW69D0018Accident · No injuriesClosedCessna 310 · Daisy, OKNTSB FTW68F0288Accident · Minor injuriesClosedCessna 310D · Stilwell, OKNTSB FTW67D0578Accident · No injuriesClosedBeech N35 · Wagoner, OKNTSB FTW67D0346Accident · No injuriesClosedBeech J35 · Lawton, OKNTSB FTW67D0338Accident · No injuriesClosedCessna 210 · Enid, OKNTSB FTW67F0222Accident · No injuriesClosedCessna 210 · Oklahoma Cty, OKNTSB FTW67D0217Accident · No injuriesClosedBeech 35 · Guymon, OKNTSB FTW66F0434Accident · No injuriesClosedCessna 210 · El Reno, OKNTSB UNK64X2712Accident · No injuriesClosedCessna 310G · Stillwater, OKNTSB UNK64X1533Accident · No injuriesClosedPiper PA22 · Enid, OKNTSB UNK64X1175Accident · No injuriesClosedCessna 210 · Webber Falls, OK