NTSB investigations: Continental O-470 series, KY
46 cases on aircraft whose registry engine model is Continental O-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
| 1964 | 2 |
|---|---|
| 1965 | 4 |
| 1967 | 1 |
| 1968 | 4 |
| 1969 | 1 |
| 1970 | 3 |
| 1971 | 1 |
| 1972 | 2 |
| 1973 | 1 |
| 1974 | 2 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 2 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 3 |
| 1983 | 1 |
| 1984 | 1 |
| 1988 | 1 |
| 1994 | 1 |
| 2001 | 4 |
| 2007 | 1 |
| 2008 | 2 |
| 2009 | 1 |
| 2012 | 1 |
| 2021 | 1 |
| 2022 | 1 |
Where
Open the mapLatest 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\" = '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 ('17026'))
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 ('17026'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 ERA22LA225Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182 · Owensboro, KYThe pilot's failure to maintain directional control during takeoff.NTSB ERA21LA185Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Flemingsburg, KYThe pilot’s improper recovery from a bounced landing, which resulted in a subsequent hard landing.NTSB ERA12LA575Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Fort Thomas, KYThe pilot’s failure to periodically add engine power during an extended descent in carburetor icing conditions, which resulted in insufficient carburetor heat, the gradual build-up of carburetor ice, and the subsequent loss of engine power.NTSB ERA09FA215Accident · 1 fatalField investigationFinal reportCessna 182Q · Lexington, KYThe pilot's failure to maintain control of the airplane for undetermined reasons.NTSB MIA08LA180Accident · No injuriesLimited investigationFinal reportCessna 182A · Elizabethtown, KYA loss of engine power due to fuel exhaustion. Contributing to the accident was pressure from the company for the pilot to fly the second load of skydivers without refueling.NTSB MIA08LA097Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Louisville, KYA total fatigue failure of the No. 5 piston during climb.NTSB NYC07LA102Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Russellville, KYA loss of engine power for undetermined reasons, during the initial climb after an aborted landing.NTSB NYC02LA043Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Falmouth, KYThe pilot's continued flight into known adverse weather. A factor was the snow.NTSB NYC01LA216Accident · No injuriesLimited investigationFinal reportCessna 182R · Elizabethtown, KYThe pilot's improper decision to fly the airplane with a known deficiency, and his inflight decision to land with a quartering tailwind. A factor was the wing maintenance officer's concurrence to fly the airplane with the known deficiency.NTSB NYC01LA112Accident · No injuriesLimited investigationFinal reportCessna 182Q · Paintsville, KYThe pilot's inadequate preflight inspection of the aircraft, which resulted in fuel exhaustion during cruise flight.NTSB NYC01FA089Accident · 1 fatalField investigationFinal reportCessna 182Q · Dixon, KYThe pilot's failure to maintain adequate clearance while maneuvering, which resulted in an in-flight collision with trees.NTSB BFO94LA139Accident · No injuriesLimited investigationFinal reportCessna 182L · Hopkinsville, KYThe pilot's failure to maintain proper alignment and adequate obstacle clearance.NTSB ATL88LA157Accident · No injuriesLimited investigationFinal reportCessna 180A · Danville, KYThe plt performed a wheel landing and attempted to hold the tailwheel off the runway surface with nose down elevator. The right wing began to lift and the acft veered to the right. Remedial control inputs were made and the left main landing gear axle…NTSB ATL84LA299Accident · No injuriesLimited investigationFinal reportCessna 182H · Murray, KYThe pilot stated that during taxi from landing, the left wing tip of the aircraft struck the corner of the main hangar building. Daylight hours, clear weather and dry ramp area conditions existed at the time.NTSB ATL84LA015Accident · No injuriesLimited investigationFinal reportCessna 310 · Madisonville, KYAccording to the plt, the acft was being flown on a return flt after being refueled at trenton, NJ. He reported that the acft held 100 gal of usable fuel & had consumed 70 gals on the initial flt on the same route. He reported that the ground speed & fuel…NTSB ATL82DLQ02Accident · Minor injuriesClosedCessna 182P · Hazard, KYNTSB ATL81FA076Accident · 1 fatalClosedCessna 182 · Louisville, KYNTSB ATL81FA044Accident · 1 fatalClosedCessna 182B · Whitesburg, KYNTSB ATL81FLQ06Accident · Minor injuriesClosedCessna 182 · Hazard, KYNTSB IAD79FLQ07Accident · No injuriesClosedCessna 182 · Elkton, KYNTSB IAD78DLQ25Accident · No injuriesClosedCessna 182F · Flemingsburg, KYNTSB IAD78DLQ09Accident · No injuriesClosedCessna 182P · Lexington, KYNTSB IAD77DLQ08Accident · No injuriesClosedCessna 182G · Bronston, KYNTSB IAD76DLQ30Accident · No injuriesClosedCessna 182 · Covington, KYNTSB IAD75DLQ24Accident · No injuriesClosedCessna 182 · Russell Spgs, KYNTSB IAD75DLQ08Accident · No injuriesClosedCessna 180 · Sandy Hook, KYNTSB IAD74FLQ39Accident · No injuriesClosedCessna 180 · Bowling Green, KYNTSB IAD73DLQ25Accident · No injuriesClosedCessna 305A · Bowling Green, KYNTSB CHI73DLQ16Accident · No injuriesClosedCessna 182J · Artemus, KYNTSB CHI72FLQ35Accident · Minor injuriesClosedCessna 182 · Columbia, KYNTSB CHI71FLQ26Accident · No injuriesClosedBeech T-34A · Louisville, KYNTSB CHI71DGJ13Accident · No injuriesClosedCessna 182 · Brandenburg, KYNTSB CHI71DGJ08Accident · No injuriesClosedCessna 182 · Bowling Green, KYNTSB CHI70DGJ07Accident · No injuriesClosedCessna 182 · Campton, KYNTSB CHI70D0124Accident · No injuriesClosedCessna 182 · Fulton, KYNTSB CHI69D0243Accident · No injuriesClosedCessna 182H · Louisville, KYNTSB CHI69F0229Accident · No injuriesClosedCessna 182K · Somerset, KYNTSB CHI69D0273Accident · No injuriesClosedCessna 182 · Carrollton, KYNTSB CHI68D0659Accident · No injuriesClosedCessna 182 · Harlan, KYNTSB CHI68D0009Accident · No injuriesClosedCessna 182 · Somerset, KYNTSB CHI66D0393Accident · No injuriesClosedCessna 182 · Golden Pond, KYNTSB CHI66D0084Accident · No injuriesClosedCessna 182 · Greenville, KYNTSB CHI65D0103Accident · No injuriesClosedCessna 182C · Pikeville, KYNTSB CHI65F0017Accident · Minor injuriesClosedCessna 182 · Lexington, KYNTSB UNK65X0787Accident · 1 fatalClosedCessna 182A · Pikesville, KYNTSB UNK64X2359Accident · No injuriesClosedBeechcraft H35 · Golden Pond, KY