NTSB investigations: Continental I0-470 series
2,580 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, newest first
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.\"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."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 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.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.NTSB CHI07LA036Accident · Minor injuriesLimited investigationFinal reportNavion Navion G · Coalton, OHThe pilot failed to follow the checklist and lower the landing gear. A factor in the accident was the fence post.NTSB DFW07CA031Accident · No injuriesData collectionFinal reportCessna 210 · Baytown, TXThe failure of the main landing gear to fully extend for an undetermined reason during takeoff-initial climb, which resulted in a gear-up landing.NTSB LAX07LA037Accident · 1 fatalLimited investigationFinal reportBeechcraft J35 · Flagstaff, AZThe pilot's inadequate in-flight planning while on approach which lead to a loss of engine power due to fuel starvation.NTSB DEN07IA021Incident · No injuriesIncident investigationFinal reportBeech P35 · Los Alamos, NMthe failure of both pilots to maintain adequate visual lookout during the visual approach. A contributing factor was the failure of N5368E's pilot to communicate his intentions on the Common Traffic Advisory Frequency.NTSB LAX07LA019Accident · No injuriesLimited investigationFinal reportCessna 310N · Lake Havasu Cit, AZthe pilot's failure to extend the landing gear prior to touchdown.NTSB LAX06CA299Accident · Minor injuriesData collectionFinal reportBeech 95-55 · Safford, AZThe pilot's inadequate in-flight planning/decision and inaccurate fuel consumption calculations, which led to fuel exhaustion and total loss of power to both engines.NTSB CHI06FA264Accident · 1 fatalField investigationFinal reportBeech BE-95-B55 · N. Sioux City, SDThe pilot's failure to maintain control of the airplane during cruise flight, and subsequent inadvertent flat spin from which he could not recover. Contributing to the accident were clouds, turbulence, and rain showers.NTSB DEN06FA132Accident · 4 fatalField investigationFinal reportBeech 35-C33 · Telluride, COThe pilot's inadvertent flight into mountain wave turbulence resulting in the airplane's loss of control and subsequent impact into mountainous terrain. Factors contributing to the accident were the mountain wave turbulence and high winds.NTSB CHI06LA262Accident · No injuriesLimited investigationFinal reportCessna 310P · Kennett, MOSeparation of the left main landing gear torque link during landing resulting in a loss of control and runway excursion. Contributing factors were a failure to comply with the airframe manufacturer's service bulletin, and the pilot's inability to maintain…NTSB DFW06FA205Accident · 1 fatalField investigationFinal reportBeech BE95 A-55 · McGregor, TXThe pilot's failure to maintain airspeed resulting in a stall and loss of control of the airplane.NTSB CHI06LA220Accident · Serious injuriesLimited investigationFinal reportBeech 95-B55 · Harmon, ILThe exhaustion of the fuel supply due to the pilot's failure to ensure an adequate suppy of fuel for the flight.NTSB DFW06CA176Accident · No injuriesData collectionFinal reportCessna 210A · Denver City, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ANC06LA084Accident · No injuriesLimited investigationFinal reportBeech P35 · Gustavus, AKThe fracture of an engine connecting rod during cruise flight, which resulted in a forced landing on a beach, a collapsed nose landing gear, and substantial damage to the fuselage.NTSB NYC06FA162Accident · 2 fatalField investigationFinal reportCessna 310D · Sutton, WVThe pilot's failure to maintain sufficient airspeed during takeoff-initial climb to avoid a stall/mush. A factor associated with the accident was the inadvertent stall/mush.NTSB CHI06CA169Accident · Serious injuriesData collectionFinal reportBeech 35-33 · Lincoln, NEA loss of engine power due to fuel exhaustion as a result of inaccurate fuel consumption calculations and inadequate monitoring of the remaining fuel quantity en route. A contributing factor was the inadequate supervision of the instructional flight by the…