NTSB investigations: Lycoming 0-320 series, OK
203 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\" = 'OK' 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" = 'OK' 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 FTW00LA010Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Granite, OKCorrosion failure of the fuselage support tubing below the right wing forward attach fitting due to inadequate maintenance.NTSB FTW99LA057Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Marietta, OKThe failure of the pilot-in-command to maintain clearance with terrain. Factors were the short runway and the dark night light condition.NTSB FTW98LA294Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Tulsa, OKThe airplane's impeded climb performance for undetermined reasons. A factor was the rising terrain.NTSB FTW97LA116Accident · No injuriesLimited investigationFinal reportCessna 172P · Cleveland, OKThe pilot/mechanic's improper installation of the spark plug, resulting in its separation from the engine. A factor was the unsuitable terrain available in the runway's overrun area.NTSB FTW97LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sulphur, OKThe loss of engine power due to fuel starvation and the pilot's improper use of the fuel tank selector. Factors were the pilot's failure to follow the checklist and the lack of suitable terrain for the forced landing.NTSB FTW97LA062Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Ardmore, OKThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the pilot to execute the forced landing.NTSB FTW96LA300Accident · No injuriesLimited investigationFinal reportCessna 172P · Owasso, OKInadequate maintenance by maintenance personnel resulting in inoperative brake system during an aborted takeoff. A factor was the downhill runway condition.NTSB FTW96FA183Accident · 4 fatalField investigationFinal reportPiper PA-28-151 · Vera, OKimproper installation by unknown person(s) of incorrect exhaust system clamps, which led to an exhaust system disconnect and a subsequent engine compartment fire.NTSB FTW96LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Norman, OKthe student pilot's improper level-off during landing.NTSB FTW95LA212Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Owasso, OKThe failures of the landing gear hydraulic pump and the emergency gear extension system as result of inadequate maintenance by maintenance personnel.NTSB FTW94LA194Accident · No injuriesLimited investigationFinal reportCessna 177 · Watonga, OKWas the pilot's failure to maintain the proper glidepath, his failure to compensate for existing wind conditions, and his failure to maintain clearance with the fence. A factor was the weather.NTSB FTW94LA129Accident · No injuriesLimited investigationFinal reportCessna 172P · Tulsa, OKThe pilot's failure to compensate for wind conditions. A factor was the gusting cross wind.NTSB FTW93LA248Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Tulsa, OKThe loss of engine power and engine fire for undetermined reasons.NTSB FTW93LA216Accident · No injuriesLimited investigationFinal reportCessna 172N · Purcell, OKThe lack of suitable terrain onto which to execute the forced landing which was neccesitated by the partial power loss. The power loss was a result of the fatigue failure of the exhaust valve rocker arm attachment stud. A factor was the night conditions.NTSB FTW93LA217Accident · No injuriesLimited investigationFinal reportCessna 172P · Cookson, OKThe pilot's improper flare and his failure to maintain directional control during the aborted landing.NTSB FTW93FA128Accident · 2 fatalField investigationFinal reportCessna 172M · Hobart, OKInadvertent stall. Factors were the instructor pilot's spatial disorientation, his lack of total instrument time, the weather, and the dark night conditions.NTSB FTW93LA098Accident · No injuriesLimited investigationFinal reportCessna 177 · Overbrook, OKThe pilot's improper compensation for wind conditions and his failure to recover from a bounced landing. A factor was turbulenceNTSB FTW92LA220Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sallisaw, OKTotal loss of power from a seized oil pump and resulting oil starvation to the engine. Factors were the noncompliance with an engine service bulletin and the dark night condition.NTSB FTW92LA195Accident · No injuriesLimited investigationFinal reportBeech 19A · Mounds, OKThe student pilot's failure to execute a go around when he realized he was going to land long.NTSB FTW91LA065Accident · No injuriesLimited investigationFinal reportCessna 172N · Weatherford, OKThe inadvertent stalling of the airplane. A factor was the gusty wind.NTSB FTW91LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Tulsa, OKThe pilot's failure to maintain airspeed and altitude on final approach.NTSB FTW91LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · Claremore, OKFailure of pilot in command to insure the aircraft contained enough fuel for the flight resulting in engine failure due to fuel exhaustion.NTSB FTW90LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Kansas, OKStudent pilot's failure to execute a go-around in a timely manner.NTSB FTW90LA006Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Edmond, OKInadequate supervision by the pilot. Factors related to the accident were: darkness and the passenger's impairment from use of a prescription drug (medication).NTSB FTW89FA107Accident · Serious injuriesField investigationFinal reportPitts S-1S · Henryetta, OKAn engine power loss due to the separation and departure of an exhaust stack. The stack failed due to poor weld. Factor(s) was: the terrain conditions of the selected forced landing site.NTSB FTW89LA058Accident · No injuriesLimited investigationFinal reportCessna 172 · Marietta, OKFailure of the pilot to select the proper runway, which resulted in a downwind landing and an overrun of the runway. The gusty tailwind, ditch, and railing (fence) were factors.NTSB FTW88FA104Accident · 2 fatalField investigationFinal reportCessna 172P · Le Flore, OKThe acft was being used to fly over a wooded area & spot cattle for psnl on the ground. After spotting cattle for about 2 hrs, the plt was flying at low alt when the acft suddenly rolled into a steep bank, then the nose dropped & the acft crashed in a steep…NTSB FTW87LA145Accident · No injuriesLimited investigationFinal reportCessna 172 · Yukon, OKOn touchdown the aircraft started to drift to the left. The pilot applied right rudder and lost directional control of the aircraft. The aircraft's right wing contacted the runway and the aircraft nosed over.NTSB FTW87LA138Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Norman, OKWhile performing a touch and go landing, the aircraft landed hard causing a vibration in the engine area, and some loss of rudder control. The pilot flew by the tower and the tower indicated everything looked ok. On landing roll the nose gear failed causing…NTSB FTW86LA042Accident · No injuriesLimited investigationFinal reportCessna 172N · Marietta, OKDuring takeoff roll, at about 45 knots ground speed, the left main landing gear contacted a water eroded spot on the runway. The aircraft bounced and/or was pulled off the ground without sufficient speed to maintain flight. The aircraft settled and struck a…NTSB FTW86LPJ01Accident · No injuriesFinal reportCessna 172 · Kremlin, OKThe acft landed in a wheat field adjacent to the sod rwy. The acft nosed over in a small ditch during rollout. The plt said he mistook the green winter wheat for the sod rwy which was now brown dormant grass from a frost and not green as it was when the plt…NTSB FTW85FPJ02Accident · No injuriesFinal reportRobinson R-22A · Mcalester, OKThe plt was using the helicopter to round up cattle. One cow charged the helicopter and struck the tail rotor. The helicopter pitched nose down, the main rotor blade struck the ground. The helicopter came to rest in an upright position.NTSB FTW85LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Carney, OKPlt attempted to abort takeoff from grass strip mowed in pasture. Plt lost control and acft received substantial damage when it ran off rwy and collided with dirt bank rwy estimated to be between 1,000 ft to 1200 ft long.NTSB FTW85LA026Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hinton, OKDuring takeoff on an instructional flt with a CFI aboard, the acft struck a grain wagon. The CFI stated that on takeoff, the student lifted off prematurely and the acft struck the parked vehicle. The CFI took no corrective action.NTSB FTW84FA408Accident · 2 fatalField investigationFinal reportCessna 172P · Webbers Falls, OKAcft struck electrical transmission line 80' above water while flying under the line during a wildlife survey. The acft's mission was to conduct a duck count along a river in a nat'l wildlife refuge which required low, slow maneuvering. The ex-ag pilot was…NTSB FTW84LA370Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Tahlequah, OKLaw enforcement officers responding to the acft accident found the acft inverted beyond the south end of the runway. Plt stated he and his passengers had been drinking beer and decided to go flying. Plt's statements to officers are not clear on exact events…NTSB FTW84FA344Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Reed, OKArpt manager reported preflight discussion with plt concerning weather to south (intended direction of flight) but plt stated he didn't think there would be any trouble. Mgr observed acft takeoff and disappear into clouds to the south. Witnesses reported…NTSB FTW84LA196Accident · No injuriesLimited investigationFinal reportBeech A23-19 · Guthrie, OKWhile on final approach the acft descended below the desired glidepath. When the plt added pwr, the engine did not respond. The acft touched down hard and short of the rwy after which the left wing contacted a tree. The plt stated he did not use carb heat…NTSB FTW83LA390Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Buffalo, OKThe acft hit the ground while trying to stay VFR under low ceilings at night. The student plt was returning from a x-country, for which he had no briefing on the weather, when the weather became worse. The student plt circumnavigated some of the thunderstorms…NTSB FTW83LA355Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Cashion, OKThe plt was told that the sod strip was 1800 ft long. His calculated takeoff distance to clear a 50 ft obstacle was 1720 ft. however, the actual length of the sod strip ws 1300 ft. during the takeoff roll, the plt realized he would not be able to clear the 30…NTSB FTW83LA265Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tulsa, OKThe acft veered off the rwy & nosed over. The plt stated he had purchased the acft to start taking plt lessons to securehis license which had been revoked 10/3/79.NTSB FTW83LA168Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Mountain Park, OKThe pilot stated that he was taking off to the north on a highway for a crop spraying operation. The aircraft was loaded with 720 pounds of chemical and 36 gal of fuel. He perceived a breeze from the south but took off north because of a hill to the south.…NTSB FTW83LA082Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Mangum, OKThe pilot stated that shortly after takeoff the left engine surged twice and quit. He elected to make a precautionary landing in an open field which was soft from melting snow. During roll out the nose wheel dug in and the drag link broke which collapsed the…NTSB FTW82DA398Accident · No injuriesFinal reportPiper PA-28-140 · Kansas, OKAircraft collided with a hole in a pasture after a precautionary landing due to low fuel state brought on by head winds.NTSB FTW82DA345Accident · No injuriesFinal reportPiper PA-28-140 · Oklahoma City, OKThe student pilot reported that during a landing, the aircraft ballooned and he overcorrected. The nose gear assembly was damaged during touchdown and the rudder pedals became inoperative. The student lost directional control andcollided with a parked…NTSB FTW82DA294Accident · Minor injuriesFinal reportVarga 2150A · Oklahoma City, OKThe student reported that before he began his flight, he visually checked both tanks and estimated that he had two hours of fuel remaining. He flew 1.1 hrs and was on his way home when the engine lost power. While landing in a plowed field, the plane flipped…NTSB FTW82FPJ17Accident · 1 fatalFinal reportPiper 28-140 · Harrah, OKDuring takeoff, the pilot elected to cross under a power line near the end of the runway when he realized he could not fly over. As the plane crossed under the power line, the right main gear struck a steel perimeter fence post. Across the street form the…NTSB FTW82FPJ16Accident · Serious injuriesFinal reportPiper 18 · Gage, OKThe aircraft was being used to spray grasshoppers and was flying in an easterly direction. The right wing struck a high line wire that is oriented north and south. After striking the wire the aircraft struck the ground approximately 190 feet east of the high…NTSB FTW82DA070Accident · No injuriesFinal reportCessna 172 · Hennessey, OKThe pilot reported that he encountered a gust of wind as he was flaring with full flaps about two feet above the strip. He stated that the right wing was blown down (the tail moved to the left) and the right wing collided with a fence beside the airstrip. The…NTSB FTW82DPJ04Accident · No injuriesClosedCessna 172N · Ardmore, OK