NTSB investigations: Continental O-470 series, AZ

6 cases on aircraft whose registry engine model is Continental O-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 O-470 series, AZ per year, 1982–2026: 6 cases
19821
19852
19881
19901
20071

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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17026')
      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 SEA07CA076Accident · No injuriesData collectionFinal reportCessna 182H · Phoenix, AZThe pilot's inadequate preflight inspection, resulting in fuel exhaustion and the loss of power. A factor was the sign.Mar 14, 2007 · N1903X · Substantial damageNTSB LAX90LA159Accident · No injuriesLimited investigationFinal reportCessna 182L · Bullhead City, AZThe pilot's preflight planning/preparation and fuel calculations were poor.Apr 30, 1990 · N42748 · Substantial damageNTSB LAX88LA167Accident · No injuriesLimited investigationFinal reportCessna 182D · Coolidge, AZAt the end of a pleasure cross country flight, while on final approach, the engine quit. Unable to land on the runway, the aircraft was landed in a soft field where during the landing roll the aircraft nosed over. The pilot had selected the right fuel tank…Apr 20, 1988 · N8847X · Substantial damageNTSB LAX86FA039Accident · 1 fatalField investigationFinal reportCessna 182P · Cottonwood, AZWitnesses saw the plt depart with frost covering the acft & without either a runup or warmup. The witnesses reported that the plt 'scraped the frost from a small square directly in front of him on the windshield' just prior to takeoff. Temp & dew point were…Nov 14, 1985 · N7036S · DestroyedNTSB LAX85LA313Accident · No injuriesLimited investigationFinal reportCessna 182 · Sawmill, AZDuring the plt's preflight inspection of his acft, he removed the fuel caps to examine the quantity of fuel in the acft's tanks. Thereafter, he failed to securely refasten the caps. At 0700 MST the plt & his 2 pax departed for a planned flt from AZ to co. 56…Jul 11, 1985 · N5706B · Substantial damageNTSB LAX82FUJ29Accident · Minor injuriesFinal reportCessna 182C · Eloy, AZThe aircraft crashed near the end of a runway on a dark night. The pilot stated to the police that he had run out of fuel. The police found weapons, drugs, and liquor in the pilot's possession. An estimated 3 gallons of fuel was found in each tank. According…Feb 27, 1982 · N8588T · Substantial damage