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 FTW91FA147Accident · 3 fatalField investigationFinal reportBeech 35-C33 · Dalhart, TXThe pilot's flight into known adverse weather. Factors were the pilot's lack of instrument experience and existing weather conditions.NTSB FTW91LA140Accident · Minor injuriesLimited investigationFinal reportBeech K35 · Laredo, TXThe improper installation of the oil filter adaptor 'o' ring (seal) by other maintenance personnel who distorted it. A factor was the rough, uneven terrain.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 ANC91LA098Accident · No injuriesLimited investigationFinal reportCessna 185A · Wood River, AKThe pilot's improper in-flight planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel. Soft sand in the emergency landing area was a related factor.NTSB MIA91LA179Accident · No injuriesLimited investigationFinal reportCessna 182C · Keystone Hghts, FLTotal loss of engine power due to fuel exhaustion due to fuel siphoning overboard, and failure of the pilot to perform an adequate preflight inspection to insure the fuel caps were secured. Contributing to the accident was incorrect fuel tank quantity gauges…NTSB ATL91FA116Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Irmo, SCThe loss of control of the aircraft for undetermined reason(s).NTSB CHI91LA182Accident · No injuriesLimited investigationFinal reportCessna 310L · Fort Wayne, INThe improper installation of a bearing by maintenance personnel.NTSB LAX91LA235Accident · No injuriesLimited investigationFinal reportBeech B95-B55 · Glendale, AZThe pilot's failure to secure the fuel cap during his preflight inspection. As a result, fuel leaked out of the wing tank onto the wing and ignited during the engine start procedures.NTSB CHI91DEE04Accident · No injuriesFinal reportBeech 35-A33 · Vernon Hills, ILWater contamination of the fuel, and the pilot's inadequate preflight inspection.NTSB CHI91LA107Accident · No injuriesLimited investigationFinal reportBeech 55 · Forest Lake, MNAn aborted landing not performed by the pilot. Factors related to the accident were a runway that was wet and ice covered.NTSB DEN91LA041Accident · Minor injuriesLimited investigationFinal reportBeech P-35 · Durango, COEngine failure due to oil starvation caused by turbocharger oil feed line failure and subsequent loss of lubricating oil to the engine.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 NYC91LA052Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Concord, NHThe improper starting procedure used by the pilot.NTSB FTW91FA017Accident · 1 fatalField investigationFinal reportBeech B55 · England, ARThe pilot's misjudgement of altitude, which resulted in his failure to arrest descent from a dive. The pilot's impaired judgment from consumption of ethanol (alcohol) was a factor.NTSB DEN91IA019Incident · No injuriesIncident investigationFinal reportBeech J-35 · Brighton, COThe failure of the engine fuel feed line resulting in a complete loss of power. Contributing to the incident was improper installation of the fuel feed transducer.NTSB ANC91LA002Accident · No injuriesLimited investigationFinal reportCessna 185B · Koyuktolik, AKPilot-in-command's failure to properly execute a stabilized approach to the first 1/3 of the runway. Contributing to the accident was the excessive airpseed maintained during the approach and landing.NTSB DEN90LA193Accident · Serious injuriesLimited investigationFinal reportCessna 310J · Colorado Spring, COThe loss of power on one engine due to excessive fuel pressure and the pilot's feathering of the wrong propeller. Factor(s) were: operation of aircraft with known deficiencies by pilot and operator.NTSB ATL90TL#03Accident · No injuriesClass 3Final reportCessna 185A · Americus, GANTSB FTW90LA131Accident · Minor injuriesLimited investigationFinal reportCessna 310Q · College Station, TXThe pic's improper fuel tank selection, allowing both engine to quit due to fuel starvation.NTSB ANC90LA092Accident · No injuriesLimited investigationFinal reportCessna 185-A · Anchorage, AKFailure of the right main gear torque plate causing an uncontrollable landing roll out.NTSB CHI90LA147Accident · No injuriesLimited investigationFinal reportCessna C205 · Anderson, INThe pilot's encounter with unsuitable terrain during the landing roll after a forced landing. Contributing factors in this accident were the total powerplant failure and the IFR weather conditions which limited the landing site selection.NTSB MIA90LA133Accident · No injuriesLimited investigationFinal reportCessna 210A · Palm Harbor, FLThe improper leaning of the fuel/air mixture resulting in the loss of engine power due to excessive internal engine temperature.NTSB CHI90LA132Accident · Minor injuriesLimited investigationFinal reportCessna 205A · Piqua, OHThe pilot-in-command's inadequate compensation for wind conditions, and his failure to maintain directional control.NTSB LAX90LA173Accident · No injuriesLimited investigationFinal reportBeech N35 · Los Banos, CAThe pilot's failure to maintain directional control of the aircraft during the takeoff roll.NTSB DEN90LA107Accident · Minor injuriesLimited investigationFinal reportBeech B-55 · Watkins, COExecuting of a simulated single engine approach in wind conditions that exceeded the demonstrated crosswind capability of the airplane with both engines operating.NTSB MKC90LA078Accident · Minor injuriesLimited investigationFinal reportCessna 310 · Belleville, KSThe pilot's inadequate remedial action in response to the loss of power in the right engine, which resulted in his failure to attain the proper touchdown point for landing.NTSB FTW90FA032Accident · 4 fatalField investigationFinal reportBeech 95-B55 · Arlington, TXThe pilot-in-command's loss of control in flight because of spatial disorientation. A factor was the dark night.NTSB NYC90LA028Accident · No injuriesLimited investigationFinal reportCessna 205 · Morristown, NJIn-flight collision with object.NTSB DEN90LA007Accident · No injuriesLimited investigationFinal reportCessna 210 · Ogden, UTAn engine stoppage for undetermined reasons.NTSB SEA90LA004Accident · No injuriesLimited investigationFinal reportCessna 310C · Redmond, ORPoor inflight planning, and the pilot did not maintain a proper glide path on final approach, nor perform proper corrective action. Factors related to the accident were: the pilot's attention was diverted due to an open cabin door and the partial loss of…NTSB CHI89IA180Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-80 · Chicago, ILThe failure of the controller to clarify the confusing communications, to correct the pilot's misinterpretation of the instructions being given, and the failure of the supervisor to properly monitor the situation. Factors related to the incident were the…NTSB CHI89LA170Accident · No injuriesLimited investigationFinal reportBeech A33 · Bloomington, ILA loss of engine power due to contamination (water, debris, and rust-like particles) in the fuel and the pilot's failure to detect the contamination during the pre-flight inspection.NTSB ATL89LA195Accident · Minor injuriesLimited investigationFinal reportCessna 210C · Millington, TNA loss of engine power, due to contamination in the fuel flow manifold. The contamination in the fuel system was due to inadequate maintenance.NTSB DEN89LA188Accident · No injuriesLimited investigationFinal reportCessna 185 · Durango, COImproper planning/decision by the pilot. The wind condition was considered to be a contributing factor.NTSB LAX89LA250Accident · No injuriesLimited investigationFinal reportCessna 210 · Thermal, CAA twisted nose gear uplock due to an elongated bolt hole which prevented the nose gear from extending.NTSB ANC89LA111Accident · No injuriesLimited investigationFinal reportCessna 185 · Fairbanks, AKThe pilot's inadequate compensation for wind conditions. The crosswind and gusts were contributing factors.NTSB MKC89LA144Accident · No injuriesLimited investigationFinal reportCessna 210 · Kaiser, MOFailure of the pilot to extend the landing gear. A factor in the accident was the pilot's failure to use the checklist.NTSB SEA89LA119Accident · No injuriesLimited investigationFinal reportBeech B35 · Dallesport, WAThe premature rotatiion and liftoff by the pilot, which resulted in an inadvertent stall. A factor related to the accident was: the tailwind.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 BFO89LA046Accident · No injuriesLimited investigationFinal reportCessna 210A · Ocean City, MDFailure of the pilot to go around after landing long & recovering from a bounced landing. Contributing factors were: the pilot's excessive airspeed on the apch, his improper flare for the landing, his failure to attain the proper touchdown point, and the…NTSB MIA89LA147Accident · No injuriesLimited investigationFinal reportCessna 310P · Fort Myers, FLCollapse of the left main landing gear due to overload failure of the trunnion and bellcrank assembly.NTSB LAX89LA177Accident · No injuriesLimited investigationFinal reportCessna 310C · Jackson, CAThe failure of the instructor pilot (pilot in command) to reject the takeoff after the loss of power on one engine when sufficient runway remained to stop the aircraft. Contributing to the accident was the disregard of the aircraft manual, failure to use the…NTSB MKC89LA095Accident · No injuriesLimited investigationFinal reportBeech BE-55 · Hot Springs, ARA wheels up landing was performed by the pilot in command, due to the interrupted landing and go-around. A psychological traffic pattern habit interference mind set interfered with the pilots ability to perform the normal functions required by the landing…NTSB CHI89LA063Accident · Minor injuriesLimited investigationFinal reportBeech 95-B-55 · Crothersville, INA failure of the engine due to a crankshaft counterweight failure. The pilot performed emergency procedures and executed a forced landing in an open field, where the aircraft encountered a large muddy area, bogged down and nosed over.NTSB ATL89FA095Accident · 1 fatalField investigationFinal reportBeech 95-B55 · St Marys Island, GAThe pilot continued into IMC conditions where he collided with trees.NTSB LAX89LA061Accident · Minor injuriesLimited investigationFinal reportBeech K35 · Arbuckle, CADuring cruise flight, the pilot noted oil on the windshield. The pilot diverted to a nearby airport. Enroute the windshield became covered with oil. The pilot opted to make an emergency landing on a road. Due to power lines, he diverted to an open field. Just…NTSB LAX89FA057Accident · 1 fatalField investigationFinal reportBeech N35 · Hanford, CAThe pilot failed to maintain sufficient altitude and descended below the minimum descent altitude while executing the missed approach. Contributing to this accident was the deteriorating weather conditions and the pilot's wish to return the airplane to its…NTSB MKC89LA025Accident · No injuriesLimited investigationFinal reportCessna 310 · St. Louis, MOArriving over his destination airport, the pilot said he had an unsafe right main gear light indication. After circling about two hours to lighten the fuel load, and attempting to lower the gear by emergency procedures, a landing was attempted. After…NTSB ATL89LA034Accident · Minor injuriesLimited investigationFinal reportCessna 210B · Uriah, ALWhile cruising at 6500 ft, the eng lost power & the prop stopped windmilling. The plt elected to land on a highway. Drg the landing, the right wing hit overhanging tree limbs which yawed the acft off the right side of the road & down an embankment. The eng…NTSB ATL89LA032Accident · Minor injuriesLimited investigationFinal reportBeech 35-A33 · Marietta, GADuring preflt 'run-up' at the end of the active rwy, the right brake failed and the airplane pivoted left while the engine was at a high power setting. The plt rpted that things happened so fast that he may have added power while attempting to reduce power.…