NTSB investigations: Continental I0-470 series, TX
232 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.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
AND 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 FTW02LA001Accident · No injuriesLimited investigationFinal reportBeech M35 · Denton, TXthe loss of engine power for an undetermined reason, which resulted in a forced landing. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA118Accident · No injuriesLimited investigationFinal reportCessna 310 · Decatur, TXthe flight instructor's failure to maintain directional control during the landing roll. A contributing factor was the left main wheel brake which was locked for an undetermined reason.NTSB FTW00LA082Accident · Minor injuriesLimited investigationFinal reportBeech BE-35K · Houston, TXThe pilot's failure to refuel resulting in fuel exhaustion and a total loss of engine power. Factors were the low ceilings, mist, and the pilot's inability to fly the ILS approach.NTSB FTW00LA069Accident · No injuriesLimited investigationFinal reportCessna 310Q · Spring Branch, TXThe pilot's delay in aborting the takeoff. A factor was the open cabin door.NTSB FTW00LA051Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Bulverde, TXThe total loss of engine power for an undetermined reason.NTSB FTW99LA050Accident · No injuriesLimited investigationFinal reportBeech BE-95-A55 · Mesquite, TXThe student pilot's failure to maintain directional control during a simulated engine failure during takeoff maneuver and the instructor's inadequate supervision. Factors were; the student's lack of total flight time in multiengine airplanes, and the soft…NTSB FTW98LA226Accident · No injuriesLimited investigationFinal reportCessna 210A · Weatherford, TXThe restricted movement of the elevator control system by a bolt.NTSB FTW98FA056Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Royse City, TXThe pilot's impairment due to drugs, and his ensuing failure to maintain minimum required airspeed for flight, which resulted in a stall/spin. A factors was the loss of power to both engines due to fuel starvation as a result of the pilot's improper use of…NTSB FTW97LA258Accident · Serious injuriesLimited investigationFinal reportAero Commander 500-B · Dallas, TXThe pilot-in-command's failure to follow emergency procedures to reduce drag and maintain best climb airspeed. Factors were the partial loss of engine power due to the cracks in the #1 and #4 cylinders as the result of an unapproved modification of their…NTSB FTW97LA147Accident · No injuriesLimited investigationFinal reportBeech M35 · Iowa Park, TXThe pilot's refueling of the airplane with automotive grade fuel which resulted in engine failure due to detonation. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA129Accident · Serious injuriesLimited investigationFinal reportBeech P35 · Brownwood, TXthe pilot's failure to follow manufacturer's procedures and premature gear retraction.NTSB FTW96LA093Accident · No injuriesLimited investigationFinal reportBeech 35-A33 · Houston, TXa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW95LA242Accident · Minor injuriesLimited investigationFinal reportBellanca 14-19 · Fort Stockton, TXThe pilot's improper positioning of the fuel selector to a tank with unusable fuel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA290Accident · Minor injuriesLimited investigationFinal reportBeech J35 · Crockett, TXThe fuel starvation induced loss of engine power due to the pilot's improper fuel tank selection.NTSB FTW94FA233Accident · 2 fatalField investigationFinal reportCessna 310Q · Greenville, TXThe cfi's failure to maintain airspeed above VMC, resulting in a loss of control during the single engine G0-around. Factors were not attaining runway alignment and the cfi's failure to retract the landing gear for the go-around procedure.NTSB FTW94FA091Accident · 4 fatalField investigationFinal reportCessna 310K · Wichita Falls, TXWas the loss of control due to the pilot's spatial disorientation following a complete electrical system failure. Factors were the dark night and the electrical failure as result of burned out wiring terminal.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 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 FTW92LA004Accident · No injuriesLimited investigationFinal reportCessna 210C · Leander, TXThe pilot's disregard for the hazardous weather advisories received. A factor was the weather.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 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 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 FTW88FA033Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Commerce, TXThe purpose of the flight was to satisfy an insurance requirement that the owner receive 10 hours of dual instruction in this aircraft. The dual controls had been removed and the single control was on the left side. The aircraft was observed in a clockwise…NTSB FTW87LA201Accident · No injuriesLimited investigationFinal reportCessna 185 · San Marcos, TXThe pilot stated that he landed long and downwind on his private strip. In an attempt to stop he applied heavy braking and at the end of the strip the aircraft nosed over and came to rest on a fence.NTSB FTW86FA096Accident · 1 fatalField investigationFinal reportMeyers 200B · Krum, TXThe retired airline captain was returning to a retirement party for another airline captain. He began a barrel roll from a relatively low pass over the party, but collided with the ground on pull out. Alcohol was not a factor.NTSB FTW86FA035Accident · 3 fatalField investigationFinal reportBeech M-35 · Valley View, TXThe non-instrument rated pvt plt received a wx briefing that called for marginal VFR to IFR conditions throughout his route of flt. Destination wx was briefed as 700' ovc, vis 2 miles in haze and fog and the en route wx was considerably worse. Several…NTSB FTW86FA028Accident · 2 fatalField investigationFinal reportBeech B33 · Arlington, TXInspite of an adverse weather forecast, the non-instrument rated pilot took off into pre-dawn fog and low ceilings. The acft impacted the ground in a steep descending turn after being observed maneuvering at a low altitude. No eng, airframe, or instrument…NTSB FTW86LA005Accident · No injuriesLimited investigationFinal reportBeech K35 · El Paso, TXThe plt stated his straight-in landing final apch was smooth. The airspeed had decreased from 80 to 65 KTS & the acft's wheels were only inches above the rwy when the right wing suddenly lifted and caused the acft to veer left and touch down on the dirt…NTSB FTW85LA299Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Alpine, TXThe plt experienced a partial pwr loss when about 50 ft above the rwy, just after liftoff. The acft was about 300 ft down the rwy with some rwy still remaining. He landed the acft but was unable to stop until the acft had run through the perimeter fence. It…NTSB FTW85LA249Accident · No injuriesLimited investigationFinal reportCessna 310F · Midland, TXOn takeoff, the plt heard a loud bang when he cycled the gear up and he got a gear unsafe light. Personnel on the ground advised him that the nose gear was hanging down at a 45 degree angle, but the mains were up. The plt diverted to a nearby arpt that had…NTSB FTW84LA360Accident · No injuriesLimited investigationFinal reportCessna 310Q · Amarillo, TXDuring gear retraction on post-maintenance check flight initial climb, gear unlocked light remained on and gear extend/retract motor circuit breaker popped. Plt reset cb and heard a 'loud pop' from the nose section of the acft. Plt then extended gear but nose…NTSB FTW84LA304Accident · Serious injuriesLimited investigationFinal reportBeech 95-B55 · Lubbock, TXAccording to the plt, the right eng lost power & during the approach to the arpt, the left eng also lost power. Subsequently, he made a wheels up landing in a cotton field & the acft was damaged. The plt indicated that he was distracted in his attempts to…NTSB FTW84LA211Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Roundup, TXThe plt stated after the accident that during the takeoff run the acft would not accelerate beyond 60 KTS. The plt aborted the takeoff and steered the acft into tall grass off the left side of the rwy in an effort to slow the acft at a faster rate. During the…NTSB FTW84FA180Accident · 4 fatalField investigationFinal reportCessna 210-5(205) · Beaumont, TXThe acft was flown into IMC wx after the flt had been advised by the wx service that VFR flt was barely feasible. No wx briefing by FAA was recorded & no flt plan was filed. The accident occurred during the hrs of darkness. A witness near the accident site…NTSB FTW83LA269Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · San Antonio, TXWhile on the takeoff roll, with aprx 1400 ft of rwy remaining, the plt noticed that there was no indication of airspeed. He therefore elected to abort the takeoff, the rwy was a combination of asphalt & turf. Following his decision to abort, the remaining…NTSB FTW83LA268Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Mcallen, TXThe eng quit during climbout. Inspection revealed that the fuel system contained about 50% clear liquid other than gasoline. The acft had sat with its tanks empty for the past 7-10 days.NTSB FTW83FA142Accident · 1 fatalField investigationFinal reportCessna 210-5 · Orange Grove, TXThe plt was believed to have departed hebbronville muni arpt at about 0500 CST. When the acft failed to arrive at its destination, a search was initiated. The wreckage was found where it crashed in an area of mesquite trees & brush, about halfway between the…NTSB FTW83LA130Accident · No injuriesLimited investigationFinal reportCessna 182R · Flatonia, TXThe acft collided with a power line while the plt was making a low apch over a private strip. The top 3 inches of the vertical stabilizer was cut off. The plt did not realize the acft was damaged & landed without further incident.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 FTW81DRG39Accident · Minor injuriesClosedCessna 210B · Port O'Connor, TXNTSB FTW81FA051Accident · Minor injuriesClosedCessna 210B · Graham, TXNTSB FTW81FA038Accident · 1 fatalClosedBeech 95-B55 · Beaumont, TXNTSB FTW80DRA50Accident · No injuriesClosedCessna 185 · New Caney, TXNTSB FTW80DQD15Accident · No injuriesClosedCessna 210 · El Paso, TXNTSB FTW80FRA46Accident · No injuriesClosedCessna 310J · Houston, TXNTSB FTW80DRG63Accident · No injuriesClosedCessna 210C · Corpus Christi, TXNTSB FTW80FQD10Accident · No injuriesClosedCessna 210A · El Paso, TXNTSB FTW80DPD11Accident · No injuriesClosedBeech M35 · Wichita Falls, TXNTSB FTW80FPA06Accident · No injuriesClosedCessna 310Q · Bonham, TX