NTSB investigations: Continental I0-470 series

57 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, newest first

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.\"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 DEN85LA058Accident · Minor injuriesLimited investigationFinal reportCessna 210B · Lordsburg, NMPlt stated that during the flt the rt fuel tank was used until empty at which time the left tank was selected. Aprx 20 minutes after switching tanks and 2 hrs 35 minutes after departure, the engine backfired and subsequently quit. A forced landing was made…Jan 2, 1985 · N101PQ · Substantial damageNTSB MIA84LA118Accident · Serious injuriesLimited investigationFinal reportCessna 310C · Key West, FLWhile en route, the plt had switched from the main tanks to the aux tanks, then back to the main tanks. About 10 min later, both engs lost power. He was able to restart the right eng, but it lost power again. Subsequently, he ditched the acft at sea. Both…Mar 19, 1984 · N12T · DestroyedNTSB NYC84LA063Accident · No injuriesLimited investigationFinal reportNavion G · Spring Valley, NYThe eng lost power during takeoff & the acft crashed beyond the perimeter of the arpt. During an exam of the acft, only a few drops of water & a slight amount of sediment were found in the fuel. No preimpact/mechanical problem was found.Dec 30, 1983 · N2459T · Substantial damageNTSB FTW84LA033Accident · No injuriesLimited investigationFinal reportCessna 210 · Truth Or Cons, NMThe plt reported that while the acft was cruising at 10,500 ft MSL, the eng lost power & he was unable to restart it. During an emergency landing, the nose gear hit a rock & collapsed. The acft was checked, but the eng could not be started, when 1st…Oct 22, 1983 · N7400E · Substantial damageNTSB ATL83LA199Accident · No injuriesLimited investigationFinal reportSIAI-Marchetti FN333 · Lexington, KYThe acft was being taxied in from landing when the engine quit. The pilot cranked the engine to restart, an explosion was heard and flames appeared in the cabin area. The pilot evacuated the acft as flames totally destroyed it. The engineis mounted above and…May 26, 1983 · N591W · DestroyedNTSB SEA83FA041Accident · No injuriesField investigationFinal reportBeech 35-B33 · Redmond, ORThe pilot stated that the engine lost power at about 200 ft AGL during takeoff. He was unable to land straight ahead, so he tried to land back on the runway. The aircraft was landed on the airport property with the gear up. The pilot believed there was a fuel…Jan 12, 1983 · N9751Y · Substantial damageNTSB FTW82FQA25Accident · Minor injuriesFinal reportBeech P35 · Albuquerque, NMAfter takeoff engine reportedly lost power. The pilot flew it between trees but one wing was separated in the collision with a tree during the forced landing. No reason for the power loss was found.Aug 13, 1982 · N1555Z · Substantial damage