Skip to content

NTSB investigations: Lycoming 0-320 series, KY

123 cases on aircraft whose registry engine model is Lycoming 0-320 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, newest first

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 ('41508')) 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 ('41508'))
  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 ('41508'))
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 BFO93LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Canton, KYThe pilot's inadequate preflight planning when determining his fuel load, which led to an exhaustion of the airplane's fuel supply.May 17, 1993 · N6943W · Substantial damage NTSB BFO93LA075Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Falmouth, KYThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent swerve, and his delayed remedial action.May 8, 1993 · N1329E · Substantial damage NTSB BFO90LA080Accident · No injuriesLimited investigationFinal reportCessna 172 · Maryville, KYThe failure of a hydraulic brake line which resulted in a loss of fluid, and an inoperative brake system during landing roll.Sep 26, 1990 · N96839 · Substantial damage NTSB ATL88LA071Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Springfield, KYOne witness stated that the eng misfired during the takeoff roll, others stated that the acft was about 75 ft high when it lost power. There were several interruptions of power before it quit totally. The pilot attempted to return to the departure airfield.…Jan 2, 1988 · N2906X · Substantial damage NTSB ATL87LA216Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Eubank, KYThe plt reptd that he was planning a refuel stop at short airport near Eubank, KY. Short is a private strip and the owner stated that he did not have fuel available. The pilot reptd that when he was about five minutes away, the engine 'quit and he was unable…Jul 18, 1987 · N1324T · Substantial damage NTSB ATL86LA252Accident · No injuriesLimited investigationFinal reportCessna 177 · Harrodsburg, KYThe plt reported experiencing a loss of power at an alt of aprx 100 ft AGL shortly after takeoff. A forced landing was made into a small field during which the nose gear collapsed. Cause of the power loss was not determined.Sep 6, 1986 · N3150T · Substantial damage NTSB ATL86LLQ01Accident · Minor injuriesFinal reportCessna 172 · London, KYThe acft crashed during a forced landing after fuel exhaustion during a x-country flt. The plt had encountered wx and in attempting to reach an alternate arpt the acft ran out of fuel. The plt was not instrument rated and the wx at London was 600 ft overcast…Oct 3, 1985 · N20273 · Substantial damage NTSB ATL85LA218Accident · No injuriesLimited investigationFinal reportCessna 177 · Stanton, KYThe pilot reported that during takeoff, he believed that the flight controls were not responding to control inputs. Moments after lift-off, he aborted the takeoff. The airplane continued off the departure end of the runway, where the nose gear and engine…Jul 17, 1985 · N3150T · Substantial damage NTSB ATL85LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Nicholasville, KYThe acft crashed into a sewage treatment plant during an emergency landing after fuel exhaustion while on a personal flt. The plt indicated that the flt was 4 hours 10 minutes long. The acft fuel capacity is listed as 38 gals usable. The acft is certified for…Nov 26, 1984 · N4343F · Substantial damage NTSB ATL84LA280Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Somerset, KYDuring a x-wind landing the acft veered off the left side of the rwy contacting a wind sock tower with the left wing. The plt reported the airspeed on final was excessive and an over compensation was made for the x-wind during the landing. The plt reported…Sep 5, 1984 · N4825T · Substantial damage NTSB ATL83LA353Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCAA · Dayton, KYThe acft was modified to tow banners & was being used for that purpose. After the acft had been flown about 3 hrs & 20 min, the plt took off on his 4th banner tow flt. He stated that he had used the fuel gages to estimate the amount of fuel remaining. The…Sep 4, 1983 · N88223 · Substantial damage NTSB ATL83LA221Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 · Jackson, KYThe pilot reported that when he exited the helicopter for the purpose of retrieveing a map from below the plt's seat, the acft began to lift and move laterally. The acft then tipped over trapping his leg and hip beneath it. He stated that he had not fully…Jun 8, 1983 · N90672 · Substantial damage NTSB ATL83LA055Accident · No injuriesLimited investigationFinal reportPitts Special 51C · London, KYThe aircraft ground looped during landing. Investigation revealed there was slight crosswind and the tail wheel steering spring failed.Dec 8, 1982 · N2148 · Substantial damage NTSB ATL82DA115Accident · No injuriesFinal reportPiper PA-23 · Louisville, KYThe pilot stated that during level flight at 9000 ft, he noticed smoke coming from under the instrument panel, followed by a vibration for 15 to 20 seconds. He diverted and landed at Louisville, KY without further incident. An examination revealed that the…Apr 25, 1982 · N1227P · Substantial damage NTSB ATL82DA049Accident · Minor injuriesFinal reportCessna C-172 · Brownsville, KYWhile climbing after takeoff, the pilot noticed smoke in the cockpit. He reported that flames started to come in as he was turning back to the airstrip. When he saw that he could land back on the strip, he reportedly shut- off the fuel, master switch and…Feb 8, 1982 · N13165 · Destroyed NTSB ATL81FA015Accident · Minor injuriesClosedCessna 172N · Hazard, KYNov 4, 1981 · N738KH · Destroyed NTSB ATL81FLQ13Accident · Serious injuriesClosedPiper PA-28 · Providence, KYMar 28, 1981 · N7241F · Substantial damage NTSB ATL81DLQ08Accident · No injuriesClosedAmer Avco AA-5A · Murry, KYDec 27, 1980 · N26930 · Substantial damage NTSB ATL81DLQ03Accident · Serious injuriesClosedCessna 172M · Waddy, KYOct 13, 1980 · N64517 · Substantial damage NTSB ATL80FLQ28Accident · Minor injuriesClosedPiper PA-28 · Morehead, KYSep 14, 1980 · N6481W · Destroyed NTSB ATL80FA058Accident · 4 fatalClosedCessna 172N · West Liberty, KYJun 20, 1980 · N734YT · Destroyed NTSB IAD80FLQ17Accident · No injuriesClosedPiper PA-28 · Anchorage, KYApr 20, 1980 · N1744J · Substantial damage NTSB IAD80DLQ09Accident · Minor injuriesClosedCessna 172M · Gilbertsville, KYJan 4, 1980 · N4493R · Substantial damage NTSB IAD79FA088Accident · No injuriesClosedCessna 172 · Paducah, KYSep 22, 1979 · N739CZ · Substantial damage NTSB IAD78FLQ20Accident · Serious injuriesClosedPiper PA-22 · Hazard, KYJun 22, 1978 · N6117D · Substantial damage NTSB IAD77FLQ19Accident · Minor injuriesClosedPiper PA28 · Glasgow, KYJul 8, 1977 · N32285 · Substantial damage NTSB IAD77FA014Accident · 4 fatalClosedPiper PA-23 · Lexington, KYNov 28, 1976 · N4423P · Destroyed NTSB IAD76DLQ27Accident · No injuriesClosedPiper PA-28 · Williamsburg, KYJul 8, 1976 · N44534 · Substantial damage NTSB IAD76FLQ21Accident · No injuriesClosedPiper PA-28 · Jeffersontown, KYMay 1, 1976 · N7214F · Substantial damage NTSB IAD76FLQ12Accident · No injuriesClosedPiper PA-28 · Elizabethtown, KYJan 3, 1976 · N32288 · Substantial damage NTSB IAD76DLQ06Accident · Minor injuriesClosedPiper PA-28 · Lake City, KYAug 4, 1975 · N9621W · Substantial damage NTSB IAD75FLQ22Accident · Serious injuriesClosedPiper PA-28 · Berea, KYMay 13, 1975 · N32519 · Substantial damage NTSB IAD75FLQ21Accident · No injuriesClosedPiper PA-25 · Skylight, KYApr 26, 1975 · N6062Z · Substantial damage NTSB IAD74FLQ40Accident · Minor injuriesClosedPiper PA-22 · Elizabethtown, KYJun 29, 1974 · N1928P · Substantial damage NTSB IAD74FL043Accident · No injuriesClosedPiper PA-28 · Cynthiana, KYJun 22, 1974 · N563FL · Substantial damage NTSB IAD74FLQ35Accident · No injuriesClosedAmer Avco AA-5 · Louisville, KYMay 29, 1974 · N5442L · Substantial damage NTSB IAD74DLQ37Accident · No injuriesClosedPiper PA-28 · Monticello, KYMay 27, 1974 · N55605 · Substantial damage NTSB IAD74FLQ26Accident · No injuriesClosedAmer Avco AA-5 · Fulton, KYFeb 11, 1974 · N71PP · Substantial damage NTSB IAD74FLQ17Accident · No injuriesClosedCessna 177 · Dycusburg, KYDec 11, 1973 · N3250T · Substantial damage NTSB IAD74FLQ12Accident · No injuriesClosedCessna 172K · Williamsburg, KYOct 10, 1973 · N7042G · Substantial damage NTSB IAD74FLQ11Accident · No injuriesClosedPiper PA-28 · Louisville, KYOct 10, 1973 · N5253W · Substantial damage NTSB CHI73FLQ04Accident · Minor injuriesClosedCessna 172K · Maysville, KYJul 1, 1972 · N7363G · Substantial damage NTSB CHI72FLQ38Accident · No injuriesClosedPiper PA-28 · Georgetown, KYMay 18, 1972 · N2682T · Substantial damage NTSB MIA72DKW23Accident · Minor injuriesClosedPiper PA-23 · Middlesboro, KYMar 4, 1972 · N3342P · Substantial damage NTSB CHI72FLQ21Accident · No injuriesClosedPiper PA-22 · Albany, KYNov 23, 1971 · N4440A · Substantial damage NTSB CHI72FLQ20Accident · No injuriesClosedPiper PA-28 · Elizabethtown, KYNov 14, 1971 · N7254F · Substantial damage NTSB CHI72FLQ17Accident · No injuriesClosedCessna 172 · Sturgis, KYOct 19, 1971 · N78799 · Substantial damage NTSB CHI72FLQ16Accident · Minor injuriesClosedChampion 7GCBC · Independence, KYOct 6, 1971 · N9118L · Substantial damage NTSB CHI71DGJ04Accident · No injuriesClosedPiper PA-22 · Somerset, KYSep 7, 1970 · N2815P · Substantial damage NTSB CHI70F0378Accident · Serious injuriesClosedCessna 172 · Ford, KYNov 20, 1969 · N84173 · Destroyed