Skip to content

NTSB investigations, KY

10 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 352) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 352)
  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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 352)
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 NYC06LA165Accident · 1 fatalLimited investigationFinal reportNorth American Navion · Sturgis, KYA total loss of engine power due to a leaking fuel pump gasket.Jul 2, 2006 · N91686 · Substantial damage NTSB NYC06LA054Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Lexington, KYFailure of the throttle cable. Contributing to the accident was unsuitable terrain for a forced landing.Jan 12, 2006 · N308M · Substantial damage NTSB BFO95LA079Accident · 1 fatalLimited investigationFinal reportHughlett Challenger II · Madisonville, KYan intermittent short of the ignition system, due to improper maintenance/modification of the engine, which resulted in partial loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall and collision…Aug 10, 1995 · N890JH · Destroyed NTSB NYC94LA054Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Mt. Sterling, KYInadequate maintenance which resulted in the disconnection of the throttle cable from the carburetor and the subsequent loss of engine power. Factors were the annual inspection not performed, and complacency.Mar 6, 1994 · N19679 · Substantial damage NTSB ATL90LA005Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Maysville, KYThe improper inspection of the airplanes engine by the pilot/owner resulting in five rocker box cover screws being missing and subsequent loss of engine oil due to the cover vibrating and causing a hole to be worn in it. Subsequent loss of engine power due to…Oct 8, 1989 · N1829N · Substantial damage NTSB ATL87DLQ04Accident · No injuriesFinal reportPiper PA-28-140 · Falmouth, KYThe plt, with a pax, had been making touch and go landings at the LCL apt for about 40 min. The final t.o. was preceded by a full stop ldg. Shortly after lift off, the plt reptd that the acft lost pwr and he was unable to clear a tree at the top of a ridge…Aug 9, 1987 · N15468 · Destroyed NTSB ATL85IA225Incident · No injuriesIncident investigationFinal reportBeech 95-B55 · Gilbertsville, KYThe acft made a precautionary lndg after the plt feathered the left eng because of vibration. Post accident exam showed a failed cylinder in the engJul 26, 1985 · UNK · Minor damage NTSB ATL85LA144Accident · No injuriesLimited investigationFinal reportBellanca 7AC · Germantown, KYDuring cruise flt over hilly terrain, the plt noted a power loss that he described as the eng 'dying back and then catching again.' He was unable to maintain alt & selected a field for a landing. During the apch, the left main gear & prop hit 2 power lines.…Apr 21, 1985 · N85652 · Substantial damage NTSB ATL83LA348Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Clinton, KYThe plt reported that he was spraying a field that was bordered by obstacles. When he was about half way thru a procedure turn, the eng began 'backfiring & losing power.' The plt moved the throttle to about the 1/2 power setting, hoping the condition would be…Aug 31, 1983 · N5256 · Substantial damage NTSB ATL82DA280Accident · No injuriesFinal reportGrumman G-164 · Greenville, KYAccording to the caretaker of muhlenburg airport, N143W was having carburetor problems when it arrived to refuel prior to the accident flight. The caretaker stated that the pilot left the engine running while he refueled because the pilot said it wouldn't…Sep 20, 1982 · N143W · Destroyed