NTSB investigations: Continental I0-470 series, TX

9 cases on aircraft whose registry engine model is Continental I0-470 series, where the first occurrence was “Loss of engine power”. 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 per year

19852026
NTSB investigations: Continental I0-470 series, TX per year, 1985–2026: 9 cases
19851
19961
19991
20011
20021
20041
20061
20072

Latest cases

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')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
  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.

NTSB DFW08LA025Accident · Serious injuriesLimited investigationFinal reportBeech J35 · Fort Worth, TXFailure of the operator to ensure that the metering unit's throttle arm and throttle cable were secured using manufacturer approved hardware. A contributing factor to the pilot's injuries was the lack of shoulder retraints.Nov 5, 2007 · N7208B · Substantial damageNTSB DFW07CA064Accident · No injuriesData collectionFinal reportBeech F35 · McKinney, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Feb 4, 2007 · N6XH · Substantial damageNTSB DFW06CA176Accident · No injuriesData collectionFinal reportCessna 210A · Denver City, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Jul 7, 2006 · N9419X · Substantial damageNTSB DFW05LA049Accident · Minor injuriesLimited investigationFinal reportBeech BE35 · Los Fresnos, TXThe loss of engine power for undetermined reasons. A contributing factor was the prevailing dark night ilumination.Dec 29, 2004 · N860R · Substantial damageNTSB FTW02LA208Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Sherman, TXfuel starvation. A contributing factor was the lack of suitable terrain for the forced landing.Jul 16, 2002 · N9466X · Substantial damageNTSB 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.Oct 2, 2001 · N9765R · Substantial damageNTSB FTW00LA051Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Bulverde, TXThe total loss of engine power for an undetermined reason.Dec 21, 1999 · N6561X · Substantial damageNTSB 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.Jan 14, 1996 · N1111Z · Substantial damageNTSB 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…Jul 28, 1985 · N7935K · Substantial damage