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 CHI82DA317Accident · No injuriesFinal reportBeech BE-33 · New Carlisle, OHThe pilot undershot the runway during a night landing on a lighted sod runway. The aircraft collided with a dirt mound 40 yards east of the runway.NTSB FTW82FQA25Accident · Minor injuriesFinal reportBeech P35 · Albuquerque, NMAfter takeoff engine reportedly lost power. The pilot flew it between trees but one wing was separated in the collision with a tree during the forced landing. No reason for the power loss was found.NTSB LAX82FA290Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Palo Verde, AZThe acft took off from a road near the plt's home. It was observed to go around a pickup truck parked alongside the road & then lift off. The acft climbed, turned right briefly & then went wings level. It then started a right descending turn into the ground.…NTSB NYC82DA182Accident · No injuriesFinal reportCessna 310C · Schroon Lake, NYThe brakes failed during landing roll and the aircraft went off the end of the runway damaging the prop and nose gear. The left brake was found inoperative and the right brake had excessively worn pucks.NTSB CHI82DA285Accident · No injuriesFinal reportCessna 310P · Marion, ILThe aircrafts right main landing gear collapsed during landing. The instructor and student were practicing touch and go landings when the accident occurred. Examination of the gear revealed the torque tube assembly (p/n 504-5010-8) was broken at the forward…NTSB LAX82DA281Accident · No injuriesFinal reportBeech 95-B55 · Henderson, NVPilot raised landing gear instead of flaps on a touch and go landing. Pilot owns a C-411 and a BE-B55. Switches are reversed on these aircraft.NTSB MKC82DA122Accident · Minor injuriesFinal reportBeech 95-A55 · Laurens, IAThe pilot had no current medical certificate or FAA pilot license. He stated that most of the time, he had a pilot in the company, but on this day, he was unable to obtain a pilot and conducted the flight himself. He stated that during his landing approach at…NTSB ANC82DA058Accident · No injuriesFinal reportCessna 310 · Elim, AKAccording to the plt, he was at VMC when he saw the right eng fuel flow needle split away from the left fuel flow needle & the acft started to swerve right. The takeoff was aborted & the acft ran off the end of the rwy. The rwy was heavily rutted & acft had…NTSB CHI82DA227Accident · No injuriesFinal reportCessna 310K · Bluffton, OHThe pilot stated the right gear started to skid during landing. The aircraft slid off the runway into a ditch and the right main landing gear collapsed. No preimpact malfunction or failure of the gear assembly was determined.NTSB LAX82DA210Accident · Minor injuriesFinal reportCessna 210 · Lovelock, NVDuring arrival, the pilot was unable to contact the fss. He was unaware that the fss station had already closed. He observed the wind sock and elected to land on runway 01 with a wind from 325 degrees at 30 knots. On final approach, a distinct crab of about…NTSB CHI82DA173Accident · No injuriesFinal reportCessna 210 · Loganville, WIDuring landing approach the engine lost power and the pilot attempted to land in an open field. The aircraft failed to clear a terrace and the nose gear separated from the airplane. The pilot stated, "while concentrating on the various aspects of operation in…NTSB SEA82DA071Accident · No injuriesFinal reportCessna 180K · Jordan Valley, ORThe aircraft landed 1/3 of the way down the runway and continued off the end into a fence. The pilot stated that the wet sod runway surface hindered adequate braking.NTSB ATL82DA131Accident · No injuriesFinal reportCessna 205 · Hopkinsville, KYDuring landing roll the pilot applied right brake and rudder. The application seemed ineffective so he applied more rudder and the aircraft veered off the runway to the right, colliding with a ditch. The aircraft then nosed over. The wind was calm.NTSB ATL82DA132Accident · No injuriesFinal reportCessna 310 · Allendale, SCThe pilot reported that before landing, the landing gear indicators showed that all gear were down and locked. However, on the landing roll-out, the left main gear collapsed as the nosewheel was lowered to the runway. Subsequently, the left wing, left…NTSB NYC82DA084Accident · No injuriesFinal reportBeech 35-33 · Altoona, PAThe pilot stated that before landing, he performed his cockpit duties and put the gear in the down position. However, he lost sight of another aircraft in the traffic pattern and became preoccupied with trying to locate the aircraft. He was also preoccupied…NTSB MKC82IA070Incident · No injuriesIncident investigationFinal reportBeech M35 · Ava, MODuring a night cross-country from pryor, ok to Ava, MO, the aircraft experienced a total electrical failure as a result of a loose alternator belt and a depleted battery. On arrival at his destination, the pilot selected gear down with the normal extension…NTSB MKC82DA068Accident · Minor injuriesFinal reportBeech M35 · Ottumwa, IADuring flight, the engine RPM exceeded its maximum limit. The pilot attempted to reduce the RPM by using the propeller control, but this had no effect. The pilot was in the process of shutting down the engine when engine oil sprayed out the cowling and onto…NTSB MIA82DA112Accident · No injuriesFinal reportBeech 95-B55 · Gainesville, FLThe purpose of the flight was to give dual instruction to the owner/student whose multi-engine rating was limited to centerline thrust models. The student was flying the aircraft on the takeoff roll when the cockpit door became ajar. The aircraft was near…NTSB FTW82DA133Accident · No injuriesFinal reportCessna 205 · Albuquerque, NMThe pilot stated that the landing was normal and that he applied light braking for passenger comfort while keeping the aircraft on the runway centerline and looking for the runway end. Heavy braking was applied when the runway end lights were observed. The…NTSB ATL82FA104Accident · 4 fatalField investigationFinal reportCessna 210-5 · Hendersonville, NCThe aircraft crashed on tree covered/rising terrain after the pilot was cleared for a night ILS approach to runway 34 at the asheville regional airport. The crash occurred about 1 to 2 mi south of the final approach fix while the aircraft was on an outbound…NTSB FTW82DA120Accident · No injuriesFinal reportCessna 210A · Rock Springs, TXThe pilot became disoriented during a cross country flight. He decided to make a precautionary landing in a clearing. During the landing roll the left wing collided with a tree.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 ANC82DA028Accident · No injuriesFinal reportCessna 310D · Anchorage, AKJust prior to the mishap, maintenance on the aircraft had been performed. This included work on the cabin heater in the nose wheel well area. After takeoff to ferry the plane to a nearby airport, the nose wheel became jammed as the gear was retracted. The…NTSB LAX82DA122Accident · No injuriesFinal reportCessna 310Q · Yuba City, CAThe pilot reported that he forgot to put the gear down before landing.NTSB ATL82DKW06Accident · No injuriesFinal reportCessna 310 · Nashville, TNThe aircraft collided with a Cessna 310, N5253J at night after both planes had been cleared to the same runway. The other pilot stated that the Beech 95-55 was taxiing without lights. Reportedly, the Cessna pilot did not see the Beech 95-55 approaching from…NTSB CHI82DA089Accident · No injuriesFinal reportCessna 310 · Freemont, MIThe student was a rated pilot on his first instructional flight in this aircraft. After a practice aborted takeoff, the student applied power to start another takeoff. At about this time, the aircraft veered to the right. The instructorapplied left rudder and…NTSB NYC82DA040Accident · No injuriesFinal reportCessna 310Q · Doylestown, PAWhile descending ice began to accummulate on the windshield and leading edges of the wings. The pilot stated that the windshield was covered with 1/2 to 3/4 inch of ice but he was able to clear a small strip large enough for him to see out. Upon reducing…NTSB MIA82DA056Accident · No injuriesFinal reportCessna 210A · Florida City, FLThe aircraft was found inverted in 5 feet of water. Only one seat was installed and an auxiliary fuel pump was inside the aircraft. It appeared that the aircraft landed on the adjacent canal bank and then purposely run into the water. Police suspect a drug…NTSB DEN82FA062Accident · 2 fatalField investigationFinal reportBellanca 14-19-3A · Selfridge, NDOn the previous day the plt received a wx briefing for the flt. He was advised the wx would be marginal VFR in the bismarck area in the morning due to low ceilings & snow. There is no record that the plt received an updated wx briefingprior to departure. The…NTSB FTW82DA059Accident · No injuriesFinal reportCessna 310D · Farmerville, LABefore this flight, the aircraft had not been flown for a period of time. The pilot was the owner of a maintenance facility and was preparing to perform an annual inspection of the aircraft. He elected to fly it around the airport to warm up the engines…NTSB LAX82FA071Accident · 4 fatalField investigationFinal reportBeech J35 · Gilroy, CAThe plt was advised during the wx briefing that VFR flight was not recommeded across the mountains & that san jose was reporting 3,000 ft scattered; 4,000 ft broken; 9,000 ft overcast with 10 mi visibility with light rain. Approximately 36 min after takeoff…NTSB ATL82DKJ09Accident · No injuriesFinal reportCessna 310L · Auburn, ALThe pilot tookoff from north huntsville on a runway that was wet from melted snow. After takeoff, the gear would not retract, so he returned and landed. A mechanic found ice on the anti-retraction switch on the left main gear. A ground heater was used to melt…NTSB NYC82DFJ10Accident · No injuriesClosedBeech 95-B55 · Fulton, NYNTSB CHI82FET03Accident · No injuriesClosedBeech 95-B55 · Dowagiac, MINTSB CHI82FEP13Accident · No injuriesClosedCessna 210C · Baraboo, WINTSB ATL82FA023Accident · 2 fatalClosedCessna 310K · Gainsville, GANTSB LAX82FVM02Accident · No injuriesClosedBeech 95-B55 · King City, CANTSB LAX82FA021Accident · 3 fatalClosedBeech J35 · Lake Havasu, AZNTSB MKC82FCG08Accident · Minor injuriesClosedBeech J35 · Sedalia, MONTSB ATL82FLG02Accident · No injuriesClosedCessna 310Q · Clemson, SCNTSB MKC82FA004Accident · 2 fatalClosedBeech G33 · Rushville, MONTSB LAX82FUA03Accident · No injuriesClosedBeech J35 · Torrance, CANTSB CHI82FA003Accident · 4 fatalClosedCessna 310I · Hainesville, ILNTSB MKC82FCQ01Accident · Minor injuriesClosedBeech M35 · Garden City, KSNTSB DEN82FA002Accident · 3 fatalClosedCessna 310 · Eureka, UTNTSB CHI81FA104Accident · 3 fatalClosedCessna 210 · Mosinee, WINTSB MIA81FA123Accident · 1 fatalClosedBeech M35 · Lake Worth, FLNTSB ATL81FKJ35Accident · No injuriesClosedBellanca 14-19 · Weaver, ALNTSB CHI81FER67Accident · No injuriesClosedBeech P35 · Stephen, MNNTSB LAX81FUG46Accident · No injuriesClosedBeech K35 · Temecula, CA