Skip to content

NTSB investigations: Continental 0-300 series, KY

33 cases on aircraft whose registry engine model is Continental 0-300 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 ('17022')) 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 ('17022'))
  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 ('17022'))
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 ERA14CA291Accident · No injuriesData collectionFinal reportCessna 172B · Frankfort, KYThe pilot's failure to maintain directional control during landing in crosswind conditions, resulting in a loss of control and runway excursion.Jun 13, 2014 · N7540X · Substantial damage NTSB ERA09LA372Accident · No injuriesLimited investigationFinal reportCessna 172D · Shepherdsville, KYThe mechanic's improper inspection of the mixture control cable.Jun 27, 2009 · N172TJ · Substantial damage NTSB ERA09LA132Accident · 1 fatalLimited investigationFinal reportCessna 172 · Hardin, KYThe pilot's failure to maintain aircraft control and his impairment from illegal drug use.Jan 9, 2009 · N28RP · Substantial damage NTSB IAD05LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172B · Princeton, KYA loss of engine power for undetermined reasons over unsuitable terrain.Mar 6, 2005 · N8211X · Substantial damage NTSB IAD05LA028Accident · 2 fatalLimited investigationFinal reportCessna 172 · Knottsville, KYthe pilot's loss of control in flight due to spatial disorientation. Also causal to the accident was the pilot's inadequate preflight planning which resulted in his inadvertent flight into night instrument meteorological conditions.Jan 1, 2005 · N6225E · Destroyed NTSB IAD97LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Germantown, KYimproper maintenance with the installation of an improper oil ring on the number four piston, which led to failure of both the ring and pistion, oil starvation, and subsequent loss of engine power.Oct 13, 1996 · N8299U · Substantial damage NTSB BFO96LA041Accident · No injuriesLimited investigationFinal reportCessna 172D · Rineyville, KYthe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Jan 28, 1996 · N2315U · Substantial damage NTSB BFO94LA136Accident · No injuriesLimited investigationFinal reportCessna 172 · Fisherville, KYThe pilot's failure to maintain airspeed, which resulted in a stall and inflight loss of control.Aug 15, 1994 · N6429B · Substantial damage NTSB BFO93LA168Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Gilbertsville, KYThe pilot's inadequate compensation for wind conditions, which resulted in a loss of directional control. The crosswind was a related factor.Sep 10, 1993 · N4473B · Substantial damage NTSB BFO91LA043Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Morehead, KYThe pilot's operation of his aircraft in exceedingly high wind conditions.Apr 9, 1991 · N3781F · Substantial damage NTSB ATL88LA049Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Paducah, KYAbt 20 mi from Paducah (pah), the plt contacted the fss & said the acft was low on fuel & that he intended to land at pah. He was informed that the FBO at pah was closed for the night & fuel was available only if a $25 call-out fee was paid. Also, he was told…Dec 1, 1987 · N2522L · Substantial damage NTSB ATL85FA237Accident · 1 fatalField investigationFinal reportCessna 172A · Glencoe, KYThe acft crashed in a field next to where a friend of the plt was baling hay. The plt had called the friend earlier in the day & ask the friend to go fly with him. Just prior to the acdnt, the plt flew over & circled a couple of times at low alt. Two…Aug 5, 1985 · N7279T · Substantial damage NTSB ATL80DLQ21Accident · No injuriesClosedCessna 172 · Morgantown, KYJul 8, 1980 · N1618F · Substantial damage NTSB IAD79FLQ23Accident · Minor injuriesClosedCessna 172E · Erlanger, KYAug 13, 1979 · N5470T · Substantial damage NTSB IAD79FA065Accident · 1 fatalClosedCessna 172 · Jenkins, KYJul 26, 1979 · N9138B · Destroyed NTSB IAD79FA048Accident · 2 fatalClosedCessna 172A · Albany, KYMay 5, 1979 · N7687T · Destroyed NTSB IAD77FLQ10Accident · Minor injuriesClosedCessna 172 · Louisville, KYApr 17, 1977 · N1752F · Substantial damage NTSB IAD76FLQ13Accident · No injuriesClosedCessna 172D · Lexington, KYFeb 10, 1976 · N2765U · Substantial damage NTSB IAD76FLQ11Accident · No injuriesClosedCessna 172 · Paris, KYDec 7, 1975 · N5635R · Substantial damage NTSB IAD75DLQ13Accident · No injuriesClosedCessna 172 · Albany, KYJan 17, 1975 · N2315U · Substantial damage NTSB IAD74AI027Accident · 2 fatalClosedCessna 170 · Glasgow, KYNov 18, 1973 · N3556C · Destroyed NTSB CHI73FLQ12Accident · No injuriesClosedCessna 172 · Glencoe, KYSep 10, 1972 · N2339U · Substantial damage NTSB CHI72DLQ31Accident · Minor injuriesClosedCessna 172H · Sandy Hook, KYMar 4, 1972 · N2637L · Substantial damage NTSB CHI71DGA10Accident · No injuriesClosedCessna 172 · Ashland, KYSep 13, 1970 · N5700R · Substantial damage NTSB CHI69D0280Accident · No injuriesClosedCessna 172 · Edmonton, KYOct 3, 1968 · N7714T · Substantial damage NTSB CHI69F0185Accident · No injuriesClosedCessna 172F · Georgetown, KYAug 12, 1968 · N8596U · Substantial damage NTSB CHI69D0124Accident · No injuriesClosedCessna 172G · Allen, KYJul 25, 1968 · N3999L · Destroyed NTSB CHI67F0677Accident · No injuriesClosedCessna 172G · Edmonton, KYApr 26, 1967 · N3609L · Substantial damage NTSB CHI66F0019Accident · No injuriesClosedCessna 172 · Georgetown, KYMay 29, 1965 · N3921S · Destroyed NTSB UNK65X1306Accident · No injuriesClosedCessna 172 · Manchester, KYJan 18, 1965 · N7879T · Substantial damage NTSB UNK64X1805Accident · No injuriesClosedCessna 170B · Tompkinsville, KYMay 17, 1964 · N4308B · Substantial damage NTSB UNK64X1167Accident · No injuriesClosedCessna 172 · Russell Spgs, KYApr 4, 1964 · N8198X · Substantial damage NTSB UNK64X0949Accident · No injuriesClosedCessna 172 · Moorehead, KYMar 16, 1964 · N8342B · Destroyed