Skip to content

NTSB investigations: Continental I0-470 series, KY

23 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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" = 'KY' 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')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 'KY' 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'))
  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.

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" = 'KY' 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'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB ERA10LA005Accident · No injuriesLimited investigationFinal reportCessna 210 · Louisville, KYA malfunction of the landing gear extension system due to a fractured hydraulic line. Contributing to the accident was the inadequate inspection and maintenance of the hydraulic line.Oct 4, 2009 · N9443T · Substantial damage NTSB NYC04LA204Accident · No injuriesLimited investigationFinal reportBeech BE-95-A55 · Louisville, KYThe improper refueling of the left auxiliary fuel tank, which resulted in an overflow of fuel, and a subsequent explosion in the left wing during engine start.Sep 4, 2004 · N9779Y · Substantial damage NTSB NYC03FA136Accident · 2 fatalField investigationFinal reportBeech 35-B33 · Harned, KYThe airplane's in-flight collision with terrain for undetermined reasons.Jun 27, 2003 · N8953M · Destroyed NTSB NYC99FA085Accident · 2 fatalField investigationFinal reportCessna 310N · Cecilia, KYThe flight instructor's failure to maintain control of the airplane. A factor was the flight instructor's inexperience instructing in the accident airplane.Apr 3, 1999 · N4159Q · Destroyed NTSB NYC97LA141Accident · No injuriesLimited investigationFinal reportCessna 182 · Springfield, KYthe pilot's misjudgment of distance and speed, and his delay in aborting the landing. Factors relating to the accident were: the pilot's failure to attain a proper touchdown point for landing, and proximity of the fence to the runway.Jul 10, 1997 · N8568T · Substantial damage NTSB ATL87FA168Accident · 4 fatalField investigationFinal reportCessna 205C · Bowling Green, KYShortly after takeoff from Bowling Green, the pilot reported a problem. He did not report the details of the problem, but witnesses heard the aircraft backfiring as it descended. The aircraft had taken on fuel at Bowling Green. The investigation failed to…Jun 16, 1987 · N1823Z · Destroyed NTSB ATL86FA155Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Elizabethtown, KYAcft observed in level flt in IMC just below EST 500 foot ovc. EST viz about 3/4 mi. Lt wing struck 15/16 inch dia steel guy cable 534 feet AGL shearing outer 118 in. Acft impacted earth fill dam 1169 ft from 650 feet tall tv antenna. Tower. Top of tower…Jun 2, 1986 · N3001S · Destroyed NTSB ATL85LA215Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Owensboro, KYThe plt had a single eng land rating & was preparing for a multi-eng check ride. While practicing a touch-&-go landing, the acft bounced. The plt applied power, made a go-around & landed without further incident. However, during a post-flt exam, substantial…Jul 13, 1985 · N3001S · Substantial damage NTSB 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 · Destroyed NTSB ATL82DA131Accident · No injuriesFinal reportCessna 205 · Hopkinsville, KYDuring landing roll the pilot applied right brake and rudder. The application seemed ineffective so he applied more rudder and the aircraft veered off the runway to the right, colliding with a ditch. The aircraft then nosed over. The wind was calm.May 15, 1982 · N124A · Substantial damage NTSB IAD78FA030Accident · 1 fatalClosedBeech 55 · Lexington, KYJan 6, 1978 · N25N · Destroyed NTSB IAD78FLQ04Accident · No injuriesClosedCessna 310J · Paducah, KYNov 6, 1977 · N3166L · Substantial damage NTSB IAD76FLQ01Accident · No injuriesClosedBeech J35 · Sparta, KYJul 1, 1975 · N3066C · Substantial damage NTSB IAD75II046Incident · No injuriesClosedBeech 55 · Hazard, KYJan 29, 1975 · N77RR · Minor damage NTSB IAD74FL025Accident · Minor injuriesClosedCessna 210 · Mt Olivet, KYApr 13, 1974 · N9681T · Substantial damage NTSB IAD74DLQ13Accident · No injuriesClosedBeech 35-A33 · Paducah, KYOct 24, 1973 · N975B · Substantial damage NTSB CHI72FLQ13Accident · No injuriesClosedCessna 310N · Danville, KYSep 14, 1971 · N5030Q · Substantial damage NTSB CHI70D0165Accident · No injuriesClosedCessna 210 · Lexington, KYJul 29, 1969 · N9578T · Substantial damage NTSB CHI66D0320Accident · No injuriesClosedCessna 210 · Munfordville, KYSep 28, 1965 · N3656Y · Substantial damage NTSB UNK65X0183Accident · No injuriesClosedBellanca 1419 · Pikeville, KYOct 7, 1964 · N6853D · Substantial damage NTSB UNK64X4209Accident · No injuriesClosedBeechcraft K35 · Murray, KYSep 29, 1964 · N5008 · Substantial damage NTSB UNK64X1261Accident · No injuriesClosedCessna 210 · Springfield, KYApr 11, 1964 · N7485E · Substantial damage NTSB UNK64X0156Accident · No injuriesClosedBeechcraft B35 · Pikeville, KYJan 4, 1964 · N9766Y · Substantial damage