NTSB investigations: Lycoming 0-320 series, KS
226 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.
Cases, newest first
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\" = 'KS' 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" = 'KS' 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" 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 CHI91LA282Accident · 1 fatalLimited investigationFinal reportPiper PA-22-150 · Emporia, KSThe pilot's VFR flight into instrument meteorological conditions (IMC), and his delay in taking remedial action. The weather (fog) was a related factor.NTSB CHI91DCQ08Accident · No injuriesFinal reportSebly Amateur Built ACRO-SPORT II · Columbus, KSA loss of engine power for undetermined reasons. A factor associated with the accident is soft terrain in the forced landing area.NTSB CHI91LA112Accident · No injuriesLimited investigationFinal reportCessna 172 · Wichita, KSDirectional control was not maintained by the dual student and remedial action was delayed by the CFI. Factors related to the accident were a gusty crosswind and a drainage ditch.NTSB CHI91LA023Accident · No injuriesLimited investigationFinal reportCessna 172 · Fort Scott, KSThe mixture control was set incorrectly resulting in fuel starvation, and the check list was not followed by the cfi/pic.NTSB MKC90LA065Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Herington, KSFailure of the #2 exhaust valve, and improper flare by the pilot during the forced landing.NTSB MKC89LA130Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Ft Leavenworth, KSThe student pilot's failure to maintain directional control of the aircraft during the landing roll. Contributing to the accident was the student's lack of total experience.NTSB MKC89FA096Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Wellsville, KSThe failure of the pilot to use carburetor heat during the descent for landing which resulted in a loss of engine power at a critical time in flight, a go-around.NTSB MKC88LA125Accident · No injuriesLimited investigationFinal reportCessna 172 · Topeka, KSWhile taxiing in from a personal solo training flight, the student pilot taxied into a chain link fence while attempting to park the acft. The right wing spar sustained substantial damage.NTSB MKC88DCQ02Accident · 1 fatalFinal reportPiper PA-25-150 · Chase, KSWitnesses stated they saw the acft spraying a hayfield. They observed the acft strike a powerline as it was making a turn. The pilot stated that his wing clipped the powerline and that the acft went into a flat spin from which he couldn't recover.NTSB MKC87LA136Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Ottawa, KSDuring a night flight the aircraft's engine lost partial power. The pilot elected to make a precautionary landing in a farm field. During landing the aircraft's right wing struck a fence. An engine teardown revealed a failed exhaust valve on the number 3…NTSB MKC87LA110Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Carbondale, KSThe PIC was moving his acft fm one airstrip to another in the LCL area. Wind cond's fm a nearby fss, recorded winds fm the southeast at 18 KTS, gusting to 25 KTS. The PIC rptd departing the sod airstrip to the southwest, and shortly aft establishing a climb,…NTSB MKC87LA073Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Halstead, KSThe PIC rptd lndg long on a 2600 ft sod rwy. During the lndg roll, the PIC rptd encountering a tailwind. The closest fss at wichita, 20 mi fm the accident arpt, rptd no significant wind chg during this period, the PIC, knowing that he had landed long and…NTSB MKC86LA194Accident · No injuriesLimited investigationFinal reportCessna 172M · Arkansas City, KSThe plt was landing on his private sod strip which had tall grass along the edges. During the landing roll, he attempted to pick up some papers that had fallen on the cockpit floor. When he looked back up, the acft had drifted to the left. The left wing…NTSB MKC86LA180Accident · No injuriesLimited investigationFinal reportPiper PA-28-150C · Junction City, KSThe c.f.I. Stated that this flight was to be an aircraft checkout of another instructor. After some air work they proceeded to a nearby airport to practice takeoffs and landings. While on final approach for a practice short field landing the aircraft…NTSB MKC86LA153Accident · Minor injuriesLimited investigationFinal reportStevenson Glasair · Oakley, KSThe PIC stated that he had not visually checked the acft's 4 gallon header tank prior to attempting takeoff. During the takeoff the eng would not produce full power. The takeoff was aborted and the PIC inspected the eng for a mechanical pblm. After the…NTSB MKC86LA110Accident · No injuriesLimited investigationFinal reportMyers EAA BI-PLANE · Winfield, KSThe pilot stated he was landing his taildragger to the north with winds from the north at 12 to 15 knots. He said he was making a three point landing and just before touchdown, the airplane changed directions and after touchdown, it went off the side of the…NTSB MKC86LA079Accident · No injuriesLimited investigationFinal reportCessna 172 · Ness City, KSThe pilot was landing to the north with a wind from the west-northwest at 15 knots, gusting to 20 knots. The pilot stated that he had full aileron into the wind and despite this action, the wing raised up by a strong gust and airplane flipped over to the…NTSB MKC86LA014Accident · No injuriesLimited investigationFinal reportPitts S1C · Goodland, KSThe acft rolled forward unrestrained after the plt hand started the eng. A tie down tied to the tailwheel pulled free from the ground tie down eye used to restrain the acft during the hand start procedure. The acft rolled forward striking several objects. The…NTSB MKC85LA186Accident · No injuriesLimited investigationFinal reportCessna 172 · Hays, KSThe student plt, who was taking his pvt plt chk ride with an faa-designated examiner, reduced power prematurly on final approach for landing at Hays. The acft dropped, striking the ground in a level attitude, which jammed the nose gear upwards, distorting and…NTSB MKC85LA148Accident · No injuriesLimited investigationFinal reportCessna 172B · Valley Center, KSThe pilot had been flying with his young son as passenger during daylight hours. He went solo to get current at night. After two full stop landings, he thought the yoke felt heavy for the trim setting he usually used but he started a takeoff anyway. Halfway…NTSB MKC85LA144Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hays, KSThe plt started the eng & was preparing to taxi from the parking area when he reached back to retrieve a flashlight from his flt case. At that time, the acft began slowly rolling forward. When the plt returned his attention to the front, he applied brakes.…NTSB MKC84LA212Accident · No injuriesLimited investigationFinal reportCessna 172 · Beuamont, KSThe plt was taking off to the north on a sod rwy with a light, northeast wind. The rwy was outlined with old automobile tires. The plt elected to use the left side of the rwy, since it appeared to be smoother. After lift-off, the acft drifted left & the left…NTSB MKC84LA003Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Derby, KSThe plt was pacticing landings & stopped after each touchdown. After aprx the 5th landing, the brakes failed to operate & the acft continued off the end of the rwy. Before stopping, the nose gear went in a ditch & collapsed, and the acft nosed over. The plt…NTSB MKC83LA220Accident · No injuriesLimited investigationFinal reportCessna 172N · Morland, KSWhile landing on a country road, the acft landing gear encounter a sand pit on the road. The plt reported that the plane ground looped on the sand, ran into a ditch & hit a tree.NTSB MKC83LA089Accident · No injuriesLimited investigationFinal reportVarga 2150A · Moline, KSThe aircraft collided with power lines on final approach but a landing was accomplished on the runway. The pilot stated that he had made 2 prior landings on the same runway and did not see the wires. During this approach he saw the wires and tried to fly…NTSB MKC83FA087Accident · No injuriesField investigationFinal reportCessna 172 I · Paola, KSThe acrt crashed in a pasture after fuel exhaustion during an approach to johnson county industrial arpt. The acft had made a missed approach at his destination of Nevada MO. Enroute to a suggested alterate of butler arpt. The weather became worse and johnson…NTSB MKC83LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Oakley, KSDuring landing the aircraft hit a patch of ice, swerved to the left, hit a runway light and slid off the runway.NTSB MKC83FA024Accident · 1 fatalField investigationFinal reportCessna 172 · Wamego, KSA witness observed the acft flying low along the Kansas river for about 2 mi just before the accident. He stated that the acft was flying below the tops of trees bordering the river. The two lower strands of a power line, which crosses the river, were found…NTSB MKC83FA023Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Sharon, KSThe acft crashed 12 mi from the departure point in hilly terrain on a direct route to the destination in a 40 deg nose low & 75 deg right wing low attitude. There are no wx reporting facilities near the accident site. The 1851 wx observation at enid,ok (62 mi…NTSB MKC83LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140B · Emporia, KSThe instructor pilot (ip) and a student were practicing stop-and-go landings in a Cessna 152, N89585, at an uncontrolled airport. The ip reported that they were monitoring the UNICOM frequency and had announced their intentions before each stop-and-go. The ip…NTSB MKC82DA170Accident · No injuriesFinal reportRobinson R-22 HP · Gardner, KSA non-cfi rated plt was giving instruction to an airplane plt that had logged a total of 6 hrs in helicopters. The student plt was lifting to a hover when a gust of wind struck the aircraft from the right side. The student pilot moved the cyclic pitch control…NTSB MKC82DA049Accident · No injuriesFinal reportCessna 172 · Jetmore, KSThe aircraft was flown out to an oil well site to air drop a valve. The pilot stated that after dropping the valve he turned around in his seat to see where the valve hit and he ran the aircraft into the ground.NTSB MKC82FCG15Accident · Serious injuriesClosedVarga 2150A · Topeka, KSNTSB MKC82DCQ07Accident · No injuriesClosedPiper PA-28 · Moscow, KSNTSB MKC81DA047Accident · 1 fatalClosedPitts S-1 · Dodge City, KSNTSB MKC81DCQ37Accident · No injuriesClosedCessna 172L · Sublette, KSNTSB MKC81DCQ31Accident · No injuriesClosedCessna 172 · Manhattan, KSNTSB MKC81DCQ10Accident · Serious injuriesClosedPiper PA-18 · Manhattan, KSNTSB MKC80FA058Accident · 1 fatalClosedCessna 172M · Cassoday, KSNTSB MKC80DCQ32Accident · No injuriesClosedCessna 172 · Wichita, KSNTSB MKC80DCQ20Accident · No injuriesClosedCessna 172 · Coldwater, KSNTSB MKC80DCQ18Accident · No injuriesClosedCessna 172 · Quinter, KSNTSB MKC79FA056Accident · Minor injuriesClosedPiper PA-28 · Chanute, KSNTSB MKC79DCQ46Accident · No injuriesClosedCessna 172 · Wichita, KSNTSB MKC79DCQ43Accident · No injuriesClosedCessna 172N · Wichita, KSNTSB MKC79FCQ37Accident · No injuriesClosedPiper PA-28 · Halstead, KSNTSB MKC79DCG56Accident · No injuriesClosedPiper PA-28 · Leawood, KSNTSB MKC79FCQ35Accident · No injuriesClosedPiper PA-18A · Westfall, KSNTSB MKC79DCQ32Accident · Minor injuriesClosedPiper PA-18 · Great Bend, KSNTSB MKC79DCQ26Accident · Minor injuriesClosedPiper PA-28 · Hope, KS