Fatal NTSB investigations: Continental I0-470 series, AZ

9 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 per year

19742026
Fatal NTSB investigations: Continental I0-470 series, AZ per year, 1974–2026: 9 cases
19741
19761
19801
19812
19821
20061
20071
20091

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\" = 'AZ' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
    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.

NTSB WPR09FA096Accident · 2 fatalField investigationFinal reportCessna 205 · Flagstaff, AZThe pilot's loss of situational awareness and failure to maintain clearance from hilly terrain while flying in an area of a low cloud ceiling. Contributing to the accident was the pilot's decision to continue flight due to a self-induced pressure.Jan 23, 2009 · N8298Z · Substantial damageNTSB LAX07LA130Accident · 3 fatalLimited investigationFinal reportBeech 35-B33 · Sedona, AZThe pilot's inadequate compensation for the high wind conditions and wind shear encounter on final approach, that led to a failure to maintain an adequate airspeed and a stall.Apr 15, 2007 · N9556Y · DestroyedNTSB LAX07LA037Accident · 1 fatalLimited investigationFinal reportBeechcraft J35 · Flagstaff, AZThe pilot's inadequate in-flight planning while on approach which lead to a loss of engine power due to fuel starvation.Nov 18, 2006 · N8246D · Substantial damageNTSB LAX82FA290Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Palo Verde, AZThe acft took off from a road near the plt's home. It was observed to go around a pickup truck parked alongside the road & then lift off. The acft climbed, turned right briefly & then went wings level. It then started a right descending turn into the ground.…Aug 5, 1982 · N1UR · DestroyedNTSB LAX82FA021Accident · 3 fatalClosedBeech J35 · Lake Havasu, AZNov 25, 1981 · N12LJ · DestroyedNTSB LAX81FA050Accident · 2 fatalClosedBellanca 14-19 · Parker, AZFeb 22, 1981 · N8503R · DestroyedNTSB LAX80FA035Accident · 1 fatalClosedCessna 152 · Mesa, AZJan 16, 1980 · N49002 · 2 aircraft · DestroyedNTSB LAX76AL086Accident · 1 fatalClosedBeech N35 · Tucson, AZJul 2, 1976 · N33BL · Substantial damageNTSB LAX74AL077Accident · 2 fatalClosedBeech 35-B33 · Queen Crk, AZMay 26, 1974 · N1460G · Destroyed