NTSB investigations: Lycoming 0-320 series, AR
168 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\" = 'AR' 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" = 'AR' 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 FTW93LA227Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Harrison, ARAn inadvertent groundloop by the pilot.NTSB FTW93LA060Accident · No injuriesLimited investigationFinal reportCessna 172P · Little Rock, ARThe certified flight instructor's failure to attain the proper touchdown point.NTSB FTW92LA161Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Walnut Ridge, ARThe inadvertent ground loop. A factor was the pilots total lack of experience in type airplane.NTSB FTW92LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Rector, ARThe pilot's premature liftoff.NTSB FTW92LA114Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Stuttgart, ARThe pilot's failure to compensate for wind conditions. Factors were the crosswind and the downdraft.NTSB FTW92LA102Accident · No injuriesLimited investigationFinal reportR. W. Switzer RV-4 · Rogers, ARLoss of engine due to fuel starvation and unsuitable terrain. Factors were the pilot's failure to follow published procedures.NTSB FTW92LA091Accident · No injuriesLimited investigationFinal reportCessna 172P · West Helena, ARPilot's improper flarea ND improper recovery from a bounced landing.NTSB FTW92LA086Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Harrison, ARThe pilot's failure to attain the proper touchdown point, and his failure to maintain the proper descent rate.NTSB DEN92LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Berryville, ARA power loss for undetermined reasons. Factors were: incorrect fuel, improper maintenance, and inadequate maintenance inspection interval.NTSB FTW91LA116Accident · No injuriesLimited investigationFinal reportCessna 172P · Lakeview, AR(1) The pilot's failure to properly flare the airplane for landing and (2) his subsequent improper recovery from a bounced landing.NTSB DEN91LA060Accident · No injuriesLimited investigationFinal reportCessna 172P · Lehi, ARThe pilot's failure to maintain aircraft control. Factors were: the wet runway and resultant hydroplaning.NTSB FTW91FA060Accident · 2 fatalField investigationFinal reportCessna 172M · Flippin, ARThe pilot's attempted VFR flight in instrument meteorological conditions and his failure to maintain altitude.NTSB FTW91LA018Accident · No injuriesLimited investigationFinal reportCessna 172L · Mount Ida, ARThe pilot in command's failure to compensate for the adverse wind conditions which resulted in a loss of control on touchdown. A factor was the gusty crosswind.NTSB DEN90LA187Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Springdale, ARPilot's loss of control of the aircraft, during landing, due to mechanical malfunction of the tailwheel assembly.NTSB DEN90LA179Accident · No injuriesLimited investigationFinal reportCessna 172N · Lakeview, ARThe pilot's failure to maintain alignment during landing.NTSB MKC90LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Lonoke, ARFailure of the pilot to maintain directional control of the aircraft. His lack of experience in the type of aircraft was a related factor.NTSB MKC90LA027Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Springdale, ARThe banner tow pick up equipment became entangled resulting in a jammed rudder and restricted aircraft control.NTSB MKC89FA063Accident · 2 fatalField investigationFinal reportPiper PA-18 · Jacksonville, ARSevere corrosion of the left forward wing lift strut which resulted in the in-flight separation of the left wing. A contributing factor was inadequacy of the applicable service bulletin.NTSB MKC88FA120Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Beedeville, ARIntentional buzzing performed, visual outlook not maintained and over confidence in personal ability by the pilot in command.NTSB MKC88FA098Accident · 1 fatalField investigationFinal reportBeech A-23-19 · Big Island, ARIncapacitation of the pilot due to a medical event which resulted in loss of aircraft control.NTSB MKC88LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Fort Smith, ARImmediately after takeoff, the student pilot performing his first supervised solo flight, said the aircraft began a left turn. He said the rudder pedals felt inoperative. He reduced power and landed adjacent the runway substantially damaging the acft.…NTSB FTW88FA084Accident · 1 fatalField investigationFinal reportCessna 172M · Hope, ARThe non-instrument rated pilot initiated the flight into known adverse weather after being advised during a preflight weather briefing that VFR flight was not recommended. About 40 minutes before the crash, he called el dorado (Arkansas) radio and requested…NTSB MKC87LA135Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Waldron, ARThe plt said he was on a x-country for his commerical cert. He checked enroute wx for the return trip and was told VMC prevailed. However he rptd that he encountered haze & clouds. He let down to VMC but after he got in the clear all he could see was…NTSB MKC86LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Wrightsville, ARThe PIC of the PA22 was practicing departures fm a confined field. The PIC stated that the acft engine had been operating normally, and that he had been operating fm this area for about the previous 1/2 hr. The PIC stated the eng quit on climbout fm the pvt…NTSB MKC86FA123Accident · 3 fatalField investigationFinal reportCessna 140 · Des Arc, ARNumerous witnesses on a sandbar in the white river observed this collision of two airplanes as they were flying close together, low, over the river. Of the nine witness statements received, five had the Piper PA-28-140 hitting the Cessna 140, three had the…NTSB MKC86LA069Accident · No injuriesLimited investigationFinal reportCessna 172N · Warren, ARThe plt reports that a deer ran in front of the acft during the flare for a night landing. The prop hit and killed the deer and the nose gear and bottom of the eng compartment were damaged. After the collision the plt said he smelled fuel fumes and when the…NTSB MKC86LA007Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Dumas, AROn landing at a pvt sod strip near Dumas, the plt stated he encountered a strong crosswind. The crosswind forced his acft to veer off the side of the rwy. After veering off the rwy the right wing struck the ground sustaining substantial damage to the wing…NTSB MKC84LA268Accident · No injuriesLimited investigationFinal reportCessna 172 M · Heber Springs, ARThe acft ran off the side of the rwy into some brush and a ditch. The plt said the landing seemed normal until she applied the brakes and the acft veered to the right. The lift wheel brake was found to be worn after the accident.NTSB MKC84FPG01Accident · Serious injuriesFinal reportRobinson R22 · Frenchman'Bayou, ARThe acft crashed during autorotation into a soy bean field after the engine lost power. The plt was a student who did not have authorization to fly nor the proper certificate and endorsement from the CFI. The acft engine stopped due to fuel exhaustion. The…NTSB MKC84LA204Accident · No injuriesLimited investigationFinal reportCessna 172M · Colt, ARThe pilot stated that he made his final approach to the rwy at 70 mph and the aircraft floated when he flared for touchdown. He continued to state that after acft touched down, insufficient runway remained to stop before overrunning the runway and impacted a…NTSB MKC84LA233Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · No Little Rock, ARThe pilot-in-command was hired by the student pilot/aircraft owner to perform the passenger flight. No experience or currency records are available on the PIC as he had not held an airman's medical certificate for the last four years. On landing at…NTSB MKC84LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Wilson, ARThe acft nosed over during takeoff after hitting a soft spot in the rwy. The takeoff area was a private grass airstrip 1300 ft long. The plt said he had no control of the acft after hitting the soft dirt.NTSB MKC84LA066Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Russellville, ARAfter landing, the plt taxied to the tie-down area. While turning into a tiedown postion, the right main gear hit a tire, surrounding a tie-down stake, & the acft nosed over.NTSB FTW84FA023Accident · 3 fatalField investigationFinal reportCessna 172M · Redfield, ARAt aprx 1331 CDT, the plt entered the pine bluff fss station & requested a briefing for a VFR flt to springfield, MO. He was advised that VFR flt was not recommended. The plt returned again between 1335 & 1350 & was seen examining the wx charts. At aprx 1420,…NTSB FTW83LA408Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Winslow, ARThe plt stated that his anxiety during the approach delayed his decision to abort a long landing. After touchdown he attempted to turn at the end of the rwy but, the acft collided wth a stump and damaged the rt wing. The plts anxiety was based on another…NTSB FTW83LA352Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Morrilton, ARThe acft collided with trees on the final approach to land at night. The plt had canceled his IFR clearance. During the approach the plt had the rwy in sight and asked memphis center how FAR he was from the arpt. When he was informed he WAS3 miles south he…NTSB FTW83LA120Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Winslow, ARDuring dual instructional flt, the student plt was practicing a short field takeoff. After lifting off into ground effect, he elected to abort the takeoff when he did not think the acft was accelerating fast enough. The instructor pilot (CFI) stated that he…NTSB FTW83LA059Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Solgohachia, ARPilot overran runway and slid on grass into a tree. Pilot says he did not go-around because of rise in terrain.NTSB FTW82DA328Accident · No injuriesFinal reportPiper PA-18-150 · Devalls Bluff, ARThe pilot was flying over his farm and decided to land in a freshly plowed field. During the rollout, the main gear settled in the loose dirt and the plane nosed over.NTSB FTW82DA349Accident · No injuriesFinal reportCessna 172N · Antoine, ARThe pilot stated that during the takeoff run from a private airstrip he allowed the aircraft to veer to the left and struck a drainage ditch.NTSB FTW82DA315Accident · No injuriesFinal reportPiper PA-28-140 · Springdale, ARThe pilot stated taht the aircraft was at 4200 ft descending when the engine suddenly lost power. He was unable to glide to an airport so he landed on a road. During the landing, the right wing hit a road sign and was substantially damaged. After landing, the…NTSB FTW82FRJ08Accident · 2 fatalFinal reportBellanca 7GCBC · Near Texarkana, ARDuring flight, the aircraft struck a powerline about 70 ft above the red river. The aircraft crashed in the river and drifted about 2 miles before it was recovered. The passenger's body was recovered on 03/21/82 and the pilot's body was recovered on 05/15/83…NTSB FTW81FA110Accident · 4 fatalClosedPiper PA-22 · Busch, ARNTSB FTW81FPG04Accident · Serious injuriesClosedPiper PA-28 · Benton, ARNTSB FTW80DPG69Accident · No injuriesClosedPitts S-1 · Dumas, ARNTSB FTW80DPG68Accident · No injuriesClosedCessna 172I · Marianna, ARNTSB FTW80DPG42Accident · Minor injuriesClosedPiper PA-18 · Hazen, ARNTSB FTW80DPG06Accident · No injuriesClosedPitts S-1C · N.Little Rock, ARNTSB FTW80DPD01Accident · No injuriesClosedBellanca 7GCBC · Little Rock, ARNTSB FTW79DPG78Accident · No injuriesClosedCessna 172N · Crossett, AR