NTSB investigations: Continental I0-470 series, 2005

5 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

19822026
NTSB investigations: Continental I0-470 series, 2005 per year, 1982–2026: 57 cases
19821
19834
19841
19853
19862
19891
19902
19911
19921
19931
19962
19971
19981
19992
20004
20014
20025
20033
20045
20055
20063
20075

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 year(c.\"eventDate\") = 2005
    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 CHI05CA266Accident · No injuriesData collectionFinal reportRyan Navion G · Lake Geneva, WIThe loss of engine power due to water contamination of the fuel and the pilot's inadequate preflight. A factor was the fence.Sep 14, 2005 · N2401T · Substantial damageNTSB DEN05LA117Accident · 1 fatalLimited investigationFinal reportBellanca 14-19-3 · Grand Junction, COA loss of engine power due to fuel starvation as a result of the improper fuel selector position. Factors contributing to the accident were the inadvertent stall, the ravine, and the steep drop off embankment.Jul 30, 2005 · N8870R · Substantial damageNTSB CHI05LA140Accident · Serious injuriesLimited investigationFinal reportCessna 310C · Ray, MIThe loss of power on the left engine for undetermined reasons and the flightcrew's failure to maintain aircraft control following the loss of power.Jun 11, 2005 · N311V · Substantial damageNTSB CHI05LA129Accident · No injuriesLimited investigationFinal reportCessna 210B · Friendship, WIThe loss of engine power for an undetermined reason. Contributing factors to the accident were the trees and the dark night light condition.May 30, 2005 · N9623X · Substantial damageNTSB DFW05FA055Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Patterson, LAThe pilot's failure to follow check-list procedures and the required placard instructions, which resulted in the fuel selectors being selected to the improper fuel tanks for take-off, resulting in a loss of engine power to the left engine. Also causal was the…Jan 14, 2005 · N7912R · Substantial damage