NTSB investigations: Continental I0-470 series, 1995

6 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

19822026
NTSB investigations: Continental I0-470 series, 1995 per year, 1982–2026: 84 cases
19826
19834
19843
19853
19862
19874
19885
19893
19902
19913
19921
19932
19942
19956
19964
19973
19982
19992
20003
20025
20036
20044
20054
20063
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 year(c.\"eventDate\") = 1995
    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 FTW96LA051Accident · Minor injuriesLimited investigationFinal reportCessna 310J · Englewood, COfailure of the pilot to feather the propeller on the inoperative engine in accordance with the emergency procedure. Factors relating to the accident were: loss of power in the left engine for undetermined reason(s), and rough/uneven terrain in the emergency…Nov 24, 1995 · N1147M · Substantial damageNTSB SEA95LA162Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Cody, WYThe pilot's failure to refuel which resulted in a loss of power due to fuel exhaustion.Jul 25, 1995 · N9492T · Substantial damageNTSB 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.Jun 13, 1995 · N1299R · 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 NYC95LA125Accident · 1 fatalLimited investigationFinal reportCessna 310Q · Atlantic Ocean (Atlantic Ocean)the pilot's improper planning/decision, which resulted in fuel exhaustion, loss of engine power, and subsequent ditching at sea. Darkness and the high sea condition (rough water) were related factors.May 22, 1995 · N69786 · DestroyedNTSB ATL95LA035Accident · No injuriesLimited investigationFinal reportCessna 310N · Covington, GAThe pilot's improper fuel management which resulted in fuel starvation and loss of engine power.Jan 10, 1995 · N4104Q · Substantial damage