NTSB investigations: Continental I0-470 series, AK

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

19872026
NTSB investigations: Continental I0-470 series, AK per year, 1987–2026: 5 cases
19871
19911
19941
19951
20051

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\" = 'AK' 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\" = 353))
  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 ANC06LA001Accident · No injuriesLimited investigationFinal reportCessna 185 · Iliamna, AKThe pilot's inadequate preflight inspection, which failed to detect water-contaminated fuel, resulting in a loss of engine power during cruise flight, and subsequent in-flight collision with terrain.Oct 3, 2005 · N9950X · Substantial damageNTSB ANC95LA071Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Dillingham, AKThe pilot's failure to refuel the airplane, and his improper remedial action(s) which lead to fuel starvation.Jun 11, 1995 · N139F · Substantial damageNTSB ANC94LA053Accident · No injuriesLimited investigationFinal reportBeech 35 · Gustavus, AKThe pilot-in-command's delay in selecting the main fuel tank position. The lack of suitable terrain for a forced landing was a factor.May 2, 1994 · N441B · Substantial damageNTSB ANC91LA098Accident · No injuriesLimited investigationFinal reportCessna 185A · Wood River, AKThe pilot's improper in-flight planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel. Soft sand in the emergency landing area was a related factor.Jul 13, 1991 · N1689Z · Substantial damageNTSB ANC87LA027Accident · No injuriesLimited investigationFinal reportCessna 185D · North Pole, AKThe pilot stated that during the right downwind approach to the airstrip the aircraft ran out of fuel; the engine quit and then he attempted an emergency landing. The plt attempted to land on the rwy. Inspection revealed no fuel in the acft and the fuel…Jan 27, 1987 · N75LE · Substantial damage