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 CEN23LA399Accident · No injuriesClass 3 · LimitedFinal reportBeech 35-B33 · Ava, MOA loss of engine oil due for undetermined reasons, which resulted in failed connecting rods and total loss of engine power.NTSB CEN23LA407Accident · No injuriesClass 3 · LimitedFinal reportBeech 95-B55 (T42A) · Greeley, COThe pilot’s failure to extend the landing gear. Contributing to the accident was a malfunction of the landing gear warning horn for undetermined reasons.NTSB CEN23LA388Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 210B · Wichita, KSLoss of engine power for reasons that could not be determined.NTSB WPR23LA327Accident · No injuriesClass 4 · LimitedFinal reportCessna 310Q · Santa Fe, NMThe pilot’s improper landing flare following an unstable approach, which resulted in a hard landing.NTSB WPR23FA287Accident · 3 fatalClass 3 · FieldFinal reportBeech P35 · Upland, CAThe pilot’s exceedance of the airplane’s critical angle of attack, for reasons that could not be determined, which resulted in a subsequent aerodynamic stall and impact with a building.NTSB WPR23LA262Accident · Serious injuriesClass 4 · LimitedFinal reportBeech P35 · Shelter Cove, CAA partial loss of engine power for reasons that could not be determined because the airplane was not located and recovered.NTSB WPR23LA224Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Agness, ORThe pilot’s failure to maintain sufficient airspeed and decision to touch down on the surface of the water, resulting in a nose over.NTSB WPR23LA213Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Tacoma, WAA fatigue failure of the left main landing gear hydraulic actuator, which resulted in a loss of hydraulic fluid that prevented the pilot from lowering the landing gear to the fully extended position and maintaining directional control after landing.NTSB WPR23LA226Accident · No injuriesClass 3 · LimitedFinal reportCessna 310I · Sunnyside, WAThe failure of the side brace lock assembly of the right main landing gear due to overstress as a result of a hard landing.NTSB WPR23LA197Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 210 · Redding, CAA fuel leak caused by an age-degraded fuel pressure sender hose, which resulted in fuel starvation and a loss of engine power. Contributing to the accident was inadequate maintenance.NTSB CEN23FA173Accident · 1 fatalClass 3 · FieldFinal reportCessna 310D · Ennis, TXThe partial loss of right engine power due to reduced fuel flow as a result of the contamination of the fuel screen.NTSB ERA23LA151Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 35-B33 · Scottsmoor, FLThe pilot’s inadequate preflight fuel planning, which resulted in fuel exhaustion.NTSB ERA23LA173Accident · No injuriesClass 3 · LimitedFinal reportBeech P35 · Perry, FLMaintenance personnel’s incorrect torquing of the oil filter adapter jam nut, resulting in the failure of the adapter threads, a complete loss of oil, and subsequent total loss of engine power.NTSB ERA23LA128Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Buckhannon, WVA total loss of engine power due to fuel starvation. Contributing was the pilot’s decision to depart on the flight with an inoperative fuel selector valve.NTSB CEN23LA088Accident · No injuriesClass 3 · LimitedFinal reportBeech M35 · Tomball, TXA loss of engine power during cruise flight for undetermined reasons.NTSB CEN23LA080Accident · No injuriesClass 4 · LimitedFinal reportBeech G33 · Bolingbrook, ILThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN23FA074Accident · 1 fatalClass 3 · FieldFinal reportBeech M35 · Fayetteville, ARThe pilot’s mismanagement of the airplane’s fuel system, which resulted in fuel starvation and a loss of engine power.NTSB GAA23WA097Accident · 1 fatalClass 5 · ForeignCessna 310F · Puerto Vallarta, MexicoNTSB CEN23FA057Accident · 2 fatalClass 3 · FieldFinal reportCessna 210-5(205) · Cleburne, TXAn in-flight loss of control as a result of spatial disorientation in night instrument meteorological conditions.NTSB CEN23LA124Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Waco, TXThe nose landing gear retract arm separation for reasons that could not be determined.NTSB CEN23LA049Accident · No injuriesClass 3 · LimitedFinal reportCessna 182A · Durango, COA complete loss of engine power for reasons that could not be determined from the available evidence.NTSB ERA23LA110Accident · No injuriesClass 4 · LimitedFinal reportCessna 310J · Fulton, NYThe pilots failure to slow the airplane down prior to turning off the runway, which resulted in damage to the airplane’s fuselage structure in the vicinity of the nose landing gear.NTSB WPR22LA349Accident · No injuriesClass 3 · LimitedFinal reportBeech M35 · Henderson, NVThe flight instructor’s failure to verify the fuel quantity and improper fuel management, which resulted in fuel starvation and a total loss of engine power.NTSB ERA22FA405Accident · 1 fatalClass 3 · FieldFinal reportBeech 95-B55 · Hartwell, GAThe pilot’s spatial disorientation and subsequent loss of airplane control following a perceived undetermined problem with the airplane’s gyroscopic instrumentation.NTSB WPR22LA319Accident · No injuriesClass 4 · LimitedFinal reportCessna 305C (0-1E) · Rexburg, IDThe pilot's failure to maintain airplane control during the landing roll on a wet airstrip.NTSB CEN22LA378Accident · No injuriesClass 3 · LimitedFinal reportCessna 210B · Clinton, ARA fatigue crack in the hydraulic actuator, which resulted in the loss of hydraulic fluid and the pilot’s inability to fully extend the landing gear.NTSB CEN22LA330Accident · No injuriesClass 3 · LimitedFinal reportBeech N35 · Wardsville, MOEngine failure due to oil starvation resulting from an oil leak at the improperly installed aftermarket oil filter adapter.NTSB ERA22FA314Accident · 2 fatalClass 3 · FieldFinal reportCessna 210C · Shelby, MIThe non-instrument rated pilot’s decision to commence the flight in instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control. Contributing to the accident was the pilot’s self-induced pressure to…NTSB ERA22LA311Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · Livingston, TNThe pilot’s improper flare, which resulted in a hard landing.NTSB CEN22LA252Accident · No injuriesClass 3 · LimitedFinal reportMeyers Industries 200A · Weslaco, TXA total loss of engine power for reasons that could not be determined.NTSB CEN22LA259Accident · No injuriesClass 4 · LimitedFinal reportBeech 35 · Mesquite, TXA collapse of the airplane’s landing gear during the landing roll for reasons that could not be determined based on the available information.NTSB CEN22LA183Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · Wharton, TXThe pilot’s failure to extend the landing gear.NTSB ERA22FA137Accident · 2 fatalClass 3 · FieldFinal reportBeech 35 · Hilltown Township, PAThe pilots’ exceedance of the airplane’s critical angle of attack while practicing maneuvers during an instructional flight, which resulted in an aerodynamic stall and and a loss of airplane control.NTSB WPR22FA087Accident · 2 fatalClass 3 · FieldFinal reportBeech K35 · Salem, ORThe airplane’s excessive nose-up pitch attitude during landing for undetermined reasons.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 WPR22LA062Accident · No injuriesClass 3 · LimitedFinal reportBeech K35 · Temecula, CAThe total loss of engine power for reasons that could not be determined from the available evidence.NTSB WPR22LA086Accident · No injuriesClass 4 · LimitedFinal reportCessna 310Q · Corona, CAThe pilot receiving instruction failure to extend the landing gear before landing due to distraction and the flight instructor’s inadequate supervision.NTSB CEN22FA023Accident · 2 fatalClass 3 · FieldFinal reportBeech P35 · Harrison, NEThe pilot’s decision to continue the flight into instrument and icing conditions, which resulted in loss of control and impact with terrain. Contributing to the accident was the pilot’s failure to obtain a timely weather briefing.NTSB CEN21LA457Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · Lancaster, OHThe loss of engine power due to fuel starvation.NTSB CEN21LA453Accident · No injuriesClass 4 · LimitedFinal reportBeech M35 · Osage Beach, MOThe pilot and flight instructor’s failure to ensure that the landing gear were extended prior to landing.NTSB WPR21LA358Accident · No injuriesClass 3 · LimitedFinal reportBeech 35-B33 · Baker, NVA total loss of engine power during the initial climb due to the failure of the No. 5 connecting rod bearing.NTSB WPR21LA315Accident · No injuriesClass 4 · LimitedFinal reportBellanca 14-19-3 · Whitefish, MTA total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to accomplish a preflight inspection.NTSB ERA21LA312Accident · No injuriesClass 4 · LimitedFinal reportBeech K35 · Readington, NJThe failure of the forward end of the landing gear actuator rod.NTSB CEN21LA473Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 35-A33 · Mineral Wells, TXA partial loss of engine power for reasons that could not be determined based on available evidence.NTSB CEN21LA325Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35-C33 · Longmont, COThe airplane’s lack of climb performance after takeoff in high density altitude conditions 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 WPR21LA261Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-A55 · North Las Vegas, NVThe pilot’s inability to maintain directional control during landing roll due to a flat tire.NTSB CEN21LA289Accident · No injuriesClass 4 · LimitedFinal reportBeech H35 · Watkins, COThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and a subsequent impact with an obstacle.NTSB ERA21LA235Accident · No injuriesClass 4 · LimitedFinal reportMeyers Industries 200A · Marathon, FLThe failure of the right main landing gear to fully extend during landing as a result of the underinflated right main landing gear oleo strut.NTSB CEN21LA205Accident · No injuriesClass 4 · LimitedFinal reportCessna 310N · Carrollton, OHThe pilot’s failure to confirm the landing gear was down before landing due to distraction during the Before Landing checks, which resulted in a gear-up landing.