Skip to content

NTSB investigations: Lycoming 0-235 series, KY

24 cases on aircraft whose registry engine model is Lycoming 0-235 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 ('41505')) 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 ('41505'))
  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 ('41505'))
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 ERA23LA353Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7ECA · Hopkinsville, KYThe pilot’s inadvertent encounter with helicopter wake turbulence during initial climb, which resulted in a loss of airplane control.Aug 28, 2023 · N8679V · Substantial damage NTSB ERA18LA158Accident · No injuriesClass 3 · LimitedFinal reportBellanca 7ECA · Warsaw, KYThe pilot’s inadequate preflight performance planning, and his delayed decision to abort the takeoff, which resulted in a ground loop.Jun 3, 2018 · N8698 · Substantial damage NTSB ERA17LA268Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Mount Sterling, KYA total loss of engine power for reasons that could not be determined based on the available information.Aug 5, 2017 · N89738 · Substantial damage NTSB ERA12FA280Accident · 1 fatalField investigationFinal reportManzitto Michael A Mwlancair 235 · Hudson, KYThe pilot's decision to operate the airplane with known electrical system problems, which resulted in the in-flight failure of the electrical wiring interconnect system, loss of electrical power, and subsequent fuel starvation and loss of engine power.Apr 14, 2012 · N235MW · Substantial damage NTSB NYC04LA154Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Lawrenceburg, KYThe pilot's decision to perform a negative g maneuver, which resulted in a loss of engine power due to fuel starvation.Jun 30, 2004 · N2364A · Substantial damage NTSB NYC04LA090Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenville, KYThe total loss of engine power due to a total loss of engine oil for undetermined reasons, which resulted in a forced landing and subsequent collision with trees.Mar 21, 2004 · N4468V · Substantial damage NTSB BFO96LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Stanton, KYwas the student pilot's failure to maintain directional control of the aircraft. The student pilot's lack of experience was a related factor.Dec 2, 1995 · N89188 · Substantial damage NTSB BFO93LA013Accident · No injuriesLimited investigationFinal reportCessna 152 · Danville, KYThe student pilot's inadequate flare. A factor was the gusty wind.Nov 18, 1992 · N4840H · Substantial damage NTSB ATL90LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Peewee Valley, KYThe pilot's improper precautionary landings. The pilot's improper planning/decisions, the low fuel level, and the terrain conditions at the airstrip were related factors.Feb 18, 1990 · N95445 · Substantial damage NTSB ATL87LA096Accident · No injuriesLimited investigationFinal reportCessna 152 · Owensboro, KYDuring a solo practice flight, the 16 hour student pilot touched down on rwy 23 at 70 KIAS and allowed the aircraft to bounce out of control and land hard on the nose landing gear. After the third bounce, the nose gear collapsed and the acft skidded to a…Mar 26, 1987 · N757LM · Substantial damage NTSB ATL87FA010Accident · 2 fatalField investigationFinal reportCessna 152 II · Pembroke, KYThe acft was observed shortly after departing the owner/operator's private landing strip. Witnesses rprtd hearing a sudden decrease in eng power, then a short time later, they heard the eng 'fire' or restart momentarily, but decrease in power again. The acft…Oct 22, 1986 · N5083L · Destroyed NTSB ATL85LA220Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mt Sterling, KYThe insturctor (CFI) was demonstrating a soft field takeoff from a grass area beside the rwy. At that time, the acft lifted off, then settled back onto the grass. The CFI reported that the right main gear touched down in a hole which caused the acft to veer…Jul 18, 1985 · N67825 · Destroyed NTSB IAD80FLQ16Accident · Minor injuriesClosedBellanca 7ECA · Lexington, KYApr 2, 1980 · N11857 · Substantial damage NTSB IAD80FLQ05Accident · No injuriesClosedPiper PA-38 · Louisville, KYNov 29, 1979 · N2459G · Substantial damage NTSB IAD78DLQ19Accident · No injuriesClosedPiper PA-12 · Bowling Green, KYMay 10, 1978 · N3052M · Substantial damage NTSB IAD77FLQ17Accident · Minor injuriesClosedAmerican AA-1A · Elliotville, KYJul 4, 1977 · N9257L · Substantial damage NTSB CHI73DLQ03Accident · No injuriesClosedPiper PA-22 · Hindman, KYJul 14, 1972 · N5440Z · Substantial damage NTSB CHI72FLQ42Accident · Serious injuriesClosedAmer Avco AA-1 · Ivel, KYJun 3, 1972 · N9352L · Substantial damage NTSB CHI72FLQ36Accident · No injuriesClosedPiper PA-22 · Georgetown, KYMay 7, 1972 · N5204Z · Substantial damage NTSB CHI72DLQ30Accident · No injuriesClosedChampion 7ECA · Creswell, KYFeb 25, 1972 · N9087L · Substantial damage NTSB CHI71DGJ02Accident · Minor injuriesClosedPiper PA-22 · Georgetown, KYJul 18, 1970 · N5177Z · Substantial damage NTSB CHI68F0688Accident · Serious injuriesClosedPiper PA-22 · Midway, KYApr 6, 1968 · N4838Z · Destroyed NTSB CHI68F0545Accident · No injuriesClosedPiper PA-22 · Lexington, KYJan 16, 1968 · N5927Z · Substantial damage NTSB UNK64X3271Accident · No injuriesClosedPiper PA18 · Cynthiana, KYAug 8, 1964 · N248T · Substantial damage