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 FTW94LA029Accident · No injuriesLimited investigationFinal reportCessna 210 · Monte Vista, COFailure by the pilot in command to follow procedures and directives to lower the landing gear prior to landing.NTSB NYC94FA011Accident · 2 fatalField investigationFinal reportCessna 310Q · Tiro, OHLoss of aircraft control for an undetermined reason, and subsequent flight that resulted in the stress limits of the airplane being exceeded and airframe failure.NTSB FTW94LA006Accident · No injuriesLimited investigationFinal reportCessna 310I · Southlake, TXAircraft control not maintained by the private pilot receiving instruction. Factors were rough runway, runway edge lights inoperative, dark night conditions, brakes restricted due to an out of rig rudder system, and inadequate CFI supervision.NTSB ATL93LA164Accident · No injuriesLimited investigationFinal reportCessna 210 · Smyrna, TNThe inadequate maintenance of the taxiway.NTSB SEA93FA205Accident · 2 fatalField investigationFinal reportCessna 185A · De Borgia, MTThe pilot's poor in-flight planning/decision and his failure to maintain airspeed above a stall.NTSB CHI93LA297Accident · No injuriesLimited investigationFinal reportBeech 95-B55B · Lafayette, INthe loss of engine power for reason or reasons undetermined.NTSB NYC93LA144Accident · No injuriesLimited investigationFinal reportBeech A55 · Norfolk, VAThe pilot's improper compesnation for wind conditions and failure to maintain firectional control. A factor was adverse wind conditions.NTSB FTW93LA223Accident · No injuriesLimited investigationFinal reportBeech 35-33 · Guymon, OKThe pilot's inadequate compensation for wind conditions. Factors were windshear and gusty crosswinds.NTSB LAX93LA363Accident · No injuriesLimited investigationFinal reportCessna 210A · Salinas, CAAn undetermined loss of engine power during the final approach phase of landing resulting in a collision with terrain during the forced landing.NTSB FTW93LA213Accident · No injuriesLimited investigationFinal reportBeech 95-B55B · Ashdown, ARThe pilot's failure to abort the landing. A factor was the wet grassNTSB ANC93LA106Accident · No injuriesLimited investigationFinal reportCessna 185 · Victory, AKThe pilot selected unsuitable terrain for landing.NTSB ANC93LA097Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKSeparation of the right main landing gear wheel.NTSB FTW93LA186Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Edgewood, NMPower loss to the right engine due to the magneto grounding leads being loose and an inadequate annual inspection. A factor was a lack of suitable terrain.NTSB DEN93FA066Accident · Minor injuriesField investigationFinal reportCessna 310J · Broomfield, COFriction of escaping oxygen under high pressure igniting a lubricant in the nosewheel well area, and improper aircraft servicing by maintenance personnel.NTSB SEA93LA120Accident · No injuriesLimited investigationFinal reportCessna 185A · Lowell, IDFatigue of the rocker arm and unsuitable terrain which was encountered during the precautionary landing.NTSB ANC93LA086Accident · No injuriesLimited investigationFinal reportCessna 185 · Barrow, AKThe fatigue fracture of the main landing gear spring.NTSB FTW93LA154Accident · Serious injuriesLimited investigationFinal reportCessna 310D · Roseland, LAThe pilot's failure to refuel resulting in loss of engine power due to fuel exhaustion. The lack of suitable terrain for the forced landing was a factor in the accident.NTSB MIA93LA114Accident · Minor injuriesLimited investigationFinal reportCessna 310Q · Fort Lauderdale, FLThe pilot-in-command's failure to insure the aircraft contained adequate fuel to complete the flight, which resulted in loss of power in both engines due to fuel exhaustion.NTSB MIA93LA077Accident · No injuriesLimited investigationFinal reportBeech N35 · Fort Meade, FLThe collision with a road sign during a forced landing. Contributing to the accident was the total loss of engine power due to fatigue failure of the crankshaft.NTSB LAX93FA118Accident · 1 fatalField investigationFinal reportBeech E33 · Avalon, CAThe pilot's alcoholic impairment of efficiency and judgement which resulted in his attempt to perform aerobatics at night in hilly terrain at an altitude inadequate for terrain clearance.NTSB LAX93LA116Accident · No injuriesLimited investigationFinal reportCessna 210 · Fullerton, CAThe pilot's failure to follow the checklist. A factor relating to this accident was the misadjustment of the landing gear locking mechanism which caused intermittent operation.NTSB LAX93LA108Accident · No injuriesLimited investigationFinal reportCessna 210D · Douglas, AZThe pilot's selection of the wrong runway based on inaccurate wind information.NTSB DEN93LA023Accident · No injuriesLimited investigationFinal reportCessna 310L · Greeley, COPoor in flight planning and decision making by the flight instructor in allowing the student to progress to a point where a safe flight regimen could not be maintained. A factor was: the dual students failure to maintain control of the aircraft.NTSB MIA93WA049Accident · 2 fatalForeign investigationBeech 95-B55B · Walkers Cay, BahamasNTSB MIA93FA035Accident · Serious injuriesField investigationFinal reportCessna 310D · Miami, FLImproper installation of the right outboard torque tube in the right fuel selector valve assembly housing resulting in a total loss of engine power due to fuel starvation.NTSB DEN93LA010Accident · No injuriesLimited investigationFinal reportCessna 310Q · Englewood, COUndetermined.NTSB FTW93LA036Accident · No injuriesLimited investigationFinal reportCessna 210B · Mountain View, ARThe collapsed right main gear due to the gear locking mechanism not being engaged. A factor was the failed crankshaft.NTSB ATL93FA008Accident · 4 fatalField investigationFinal reportCessna 310K · East Point, GAThe pilot's mismanagement of the fuel supply which resulted in fuel stravation of both engines.NTSB CHI92FA290Accident · No injuriesField investigationFinal reportBeech B55 · Joliet, ILThe pilot's inadvertent wheels up landing.NTSB CHI92LA286Accident · No injuriesLimited investigationFinal reportCessna 210C · Peoria, ILThe pilot-in-command's not compensating for wind conditions and his not maintaining directional control.NTSB ANC92FA141Accident · 4 fatalField investigationFinal reportCessna 185 · Whittier, AKPilot in command's intentional flight into known adverse weather conditions. Factors relating to the accident were: the pilot's disregard for adverse weather advisory, weather conditions (clouds) and mountainous terrain.NTSB NYC92LA136Accident · 1 fatalLimited investigationFinal reportBeech N35 · Middletown, NYImproper altitude control by the pilot which resulted in a collision with trees.NTSB CHI92LA187Accident · No injuriesLimited investigationFinal reportBeech M35 · Dekalb, ILThe pilot's failure to use proper nose wheel steering which resulted in a loss of directional control.NTSB CHI92LA179Accident · No injuriesLimited investigationFinal reportCessna 210B · Belleville, ILThe improper fuel pump high end discharge adjustment. A related factor is improper maintenance/annual inspection.NTSB DEN92LA058Accident · No injuriesLimited investigationFinal reportCessna 185 · Durango, COImproper use of brakes. Factors were: poorly planned approach and excessive landing speed.NTSB NYC92LA095Accident · Minor injuriesLimited investigationFinal reportBeech N35 · Delaware, OHA loss of control in flight due to wake tubulence from a preceding helicopter. A factor related to the accident was the failure of the pilot to recoginize the hazards of his close proximity behind the landing helicopter.NTSB DEN92IA046Incident · No injuriesIncident investigationFinal reportCessna 310-L · Hugo, COFailure of the left voltage regulator. Factors were: failure of the pilot/mechanic to properly maintain the aircraft, and failure of the right alternator circuit breaker.NTSB CHI92LA125Accident · No injuriesLimited investigationFinal reportBeech K35 · Valley City, NDFailure by airport personnel to remove the snow ridge.NTSB DEN92LA039Accident · No injuriesLimited investigationFinal reportBeech 55 · Longmont, COThe student pilot's failure to maintain directional control and the flight instructor's inadequate supervision.NTSB NYC92FA067Accident · 1 fatalField investigationFinal reportCessna 310K · Unionville, PAThe pilot did not follow the published IFR procedures and allowed the airplane to descend to an altitude insufficient to clear the terrain. Factors which contributed to the accident were: the pilot's apprehension due to the low fuel state, the dark night,…NTSB CHI92LA089Accident · Minor injuriesLimited investigationFinal reportBeech 55 · Wheeling, ILImproper starting procedure attempted by the pilot. A factor related to the accident was: magneto switch left in the 'on' position.NTSB LAX92LA093Accident · 5 fatalLimited investigationFinal reportCessna 310Q · Honolulu, HIThe pilot's continuation of VFR flight into instrument meteorological conditions resulting in spatial disorientation and loss of aircraft control. Factors which contributed to the accident were: the adverse weather conditions and the pilot's failure to obtain…NTSB ATL92LA038Accident · No injuriesLimited investigationFinal reportBeech J-35 · Knoxville, TNThe manufacturer's failure to provide adequate torque information which resulted in the loss of torque on the cylinder hold down nuts and the complete loss of engine power.NTSB LAX92LA081Accident · No injuriesLimited investigationFinal reportCessna 210 · Bakersfield, CAThe pilot's attempt to restart the engine when there was evidence of a fuel leak. A factor in the accident was the fractured fuel line due to the improper installation and overtorque of the line by company maintenance.NTSB FTW92LA032Accident · Serious injuriesLimited investigationFinal reportCessna 310D · Hamilton, TXThe inadvertend encounter with icing conditions. Factors were the unavailability of an airport weather observation facility and the deteriorated aircraft performance.NTSB LAX92LA009Accident · No injuriesLimited investigationFinal reportCessna 210 · Riverside, CAThe failure of a hydraulic gear return line, which caused the aircraft's main landing gear to collapse during landing touchdown.NTSB FTW92LA004Accident · No injuriesLimited investigationFinal reportCessna 210C · Leander, TXThe pilot's disregard for the hazardous weather advisories received. A factor was the weather.NTSB SEA91LA245Accident · No injuriesLimited investigationFinal reportCessna 210 · Arlington, WAThe pilot's failure to extend the landing gear. A factor contributing to the accident was the pilot's failure to utilize the landing checklist.NTSB ATL91LA170Accident · No injuriesLimited investigationFinal reportBeech B-33 · Asheville, NCThe pilot's selection of unsuitable terrain for takeoff. Factors were tall wet grass, and the failure of airport personnel to maintain the runway surface.NTSB LAX91LA358Accident · No injuriesLimited investigationFinal reportBeech J35 · San Jose, CAThe failure of the crankshaft counterweight retaining clip due to improper maintenance installation of the part.