NTSB investigations: Lycoming O&VO-360 series
92 cases on aircraft whose registry engine model is Lycoming O&VO-360 series, where the first occurrence was “In flight collision with object”. 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41514')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41514')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
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 NYC95FA033Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Doylestown, PAthe pilot's descent below the published minimum circling altitude, and his failure to execute the published missed approach procedure during a night IFR instrument approach, which resulted in an in-flight collision with trees.NTSB MIA94LA210Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Panama City Bch, FLThe pilot's failure to see and avoid the banner.NTSB BFO94LA106Accident · No injuriesLimited investigationFinal reportMooney M20C · Leesburg, VAThe pilot's failure to maintain the minimum descent altitude until the published approach fix. Factors related to the accident was pilot fatigue, low ceilings, obscuration, and fog.NTSB SEA94LA145Accident · No injuriesLimited investigationFinal reportMooney M20C · Wamsutter, WYClearance not maintained. A factor to the accident was: transmission wire.NTSB NYC94LA030Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Hopkinsville, KYthe pilot's improper IFR procedure by conducting flight below minimum descent altitude (MDA) without visual referece which resulted in an inflight collision with wires. A factor was the wire.NTSB BFO93FA129Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · California, MDThe pilot initiating VFR flight in instrument meteorological conditions. Factors which contributed to the accident were: the pilot's failure to obtain a weather briefing, his lack of sleep, and the existing weather conditions.NTSB NYC92LA023Accident · No injuriesLimited investigationFinal reportBeech B23 · Bombay, NYFailure of the pilot to use all the available take off area.NTSB SEA91LA204Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Sunriver, ORThe pilot's inadequate compensation for wind conditions, which resulted in a failure to maintain runway alignment. The gusty crosswind was a related factor.NTSB ATL91LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Hickory, NCThe pilots's inadequate visual lookout during flight. A factor in the accident was the pilot's failure to maintain a safe altitude.NTSB CHI91LA030Accident · No injuriesLimited investigationFinal reportCessna 177 · Mount Ayr, IAProper touch-down point not attained and go-around delayed by the PIC. Contributing factors were a downwind, crosswind, weather evaluation misjudged, wrong runway selected and lack of total experience by the PIC.NTSB NYC91LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Columbia, PAThe failure of the pilot to maintain a proper altitude on final approach and compensate for the headwind. A factor to the accident was the failure of the pilot to recognize his low altitude and execute a go-around.NTSB CHI90LA275Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Amana, IAProper touchdown point not attained and go-around delayed by the pilot in command. Contributing factors were ATC communications inadequate and wet, grass runway with a tailwind environment plus a fence.NTSB LAX90LA236Accident · No injuriesLimited investigationFinal reportCessna 172RG · Concord, CAThe student pilot's initiating an excessive descent and the cfi's inadequate remedial action.NTSB BFO90LA005Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Churchville, MDThe pilot not maintaining adequate clearance from the wind sock during an aborted landing. A contributing factor was the presence of another aircraft.NTSB LAX89LA300Accident · No injuriesLimited investigationFinal reportBeech C23 · Selma, CAThe pilot's failure to maintain proper clearance from the power line, while maneuvering at low altitude. The power line was a related factor.NTSB ATL89LA152Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Indian Trail, NCThe pilot's delay in aborting the landing after a bounced landing. Contributing factors were: improper flare by the pilot and the transmissions lines.NTSB MKC89LA113Accident · Minor injuriesLimited investigationFinal reportAmerican AA5-B · Valentine, NEThe pilot delayed initiating a go-around after not attaining a proper touchdown point during the approach to land. Contributing factors were the high density altitude and the trees off the departure end of the runway.NTSB CHI88LA247Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Orleans, INThe pilot failed to maintain an adequate visual lookout and to maintain adequate clearance from the utility pole and transmission wire. Contributing to the cause were the pilot's total lack of experience, task overload, and anxiety, stemming from a partial…NTSB CHI88LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140E · Glidden, WIWhile attempting to takeoff from a 2,175' grass strip, with the aircraft loaded near maximum gross weight, the pilot approached the end of the runway without having attained liftoff airspeed. The pilot lifted the aircraft off the ground prematurely and was…NTSB NYC88LA023Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Morristown, NJThe Gulfstream-american AA5B was making a takeoff with a flight instructor and student pilot on board. At 65 knots during the takeoff, a deer was struck on the runway and killed. The takeoff was aborted on the runway. The student pilot and flight instructor…NTSB NYC87LA242Accident · Minor injuriesLimited investigationFinal reportMooney M20B · Marlboro, NJDuring the plt's 1st apch to land, he noted a wind shift & made a go-around. He said the wind shifted back in favor of rwy 27, so he attempted another landing with a longer, lower apch to accommodate the winds. Also, he noted there were trees near the apch…NTSB ATL87FA189Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Jesup, GAWitnesses rprtd the acft 'buzzed' (flew low) over a factory, where the plt used to work, then it went over the altamaha river, flew under a bridge & continued up the river at low alt. About 2 to 3 mi upstream, the acft was maneuvering when it struck trees &…NTSB ATL87LA110Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Branchville, ALThe plt was ldg at the private airstrip to the north with a tailwind, because trees located on the north end of the rwy precluded ldg to the south into the wind. He made three attempts to land on the 1,754 ft runway; witnesses reported that a 7-12 kt tailwind…NTSB CHI87LA092Accident · No injuriesLimited investigationFinal reportMooney M-20G · Kenosha, WIWhile on downwind leg the pilot heard another aircraft call downwind. When he turned to final the other aircraft turned base. As he descended on final approach the other aircraft turned sharply inside the acft on final and landed. The following aircraft…NTSB FTW86LQG17Accident · No injuriesFinal reportMcculloch J-2 · Stanton, TXPilot attempted take off from pasture. Just after lift off the nose gear caught on a single strand electric fence and brought aircraft to a stop where it rolled over. The plts flt time was not reported or available.NTSB LAX86LA169Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Hesperia, CADuring a solo instructional flight the student plt attempted to land on a 3910-foot-long rwy which had its landing threshold displaced by 550 feet. The wind was light & variable, & the student plt was low on short final approach. The acft collided with the…NTSB NYC86LA055Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Ellington, CTWhile on apch for landing, about 50 ft from the rwy, the landing gear contacted a bridge and the acft bounced into the air. Pwr was added at this time and again the acft bounced. The acft was then landed on the rwy and it skidded to a stop. The plt stated she…NTSB NYC86LA010Accident · No injuriesLimited investigationFinal reportMooney M20C · Ocean City, NJThe acft collided with a bird while descending for an apch to landing at Ocean City. Substantial damage resulted to the right horizontal stabilizer. The plt was able to maintain control of the acft with difficulty. A successful landing was accomlished. .NTSB MKC85LA136Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Belgrade, NEFlight instructor giving private pilot a bfr. Bfr was nearly completed when ip gave pilot a simulated forced landing over his own farm strip. Pilot was making an excellent approach until the landing gear hit the barbed wire hidden in the high grass.NTSB SEA85FA028Accident · 1 fatalField investigationFinal reportPiper PA-44-180 · Gig Harbor, WAThe plt departed in the early morning hours from salem, OR, destined for Gig Harbor. Upon arrival in the destination area the plt was in radio contact with seattle apcon. The plt reported he was unable to aquire visual contact with the arpt. Vectors were…NTSB ATL85LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Luray Caverns, VAThe acft was landed on a inadequate field during a simulated forced landing that became a real emergency because the fltinstructor cut the mixture to off. The CFI took over the landing at the last part of the approach and told the student to restart the…NTSB MKC84LA230Accident · No injuriesLimited investigationFinal reportMooney M20C · Hannibal, MON7702M experienced an electrical failure en route & diverted to Hannibal. Plt stated he circled the arpt, saw no traffic& decided to land to the south. N38455 had just landed to the north and was on the rwy when the plt saw N7702M attempting to land in the…NTSB NYC84FA117Accident · 4 fatalField investigationFinal reportBeech C23 · Champion, PAN23968, crashed into trees shortly after takeoff from rwy 27 at seven springs airport. Plt told the resort manager of seven springs that he could not seem to get airborne & after he did get airborne he could not clear the trees. Investigation revealed the…NTSB ATL84LA048Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Clemson, SCThe pilot failed to lower the landing gear stating that he was distracted by an acft on the ground & diverted his attention from the landing checklist.NTSB FTW84LA029Accident · Minor injuriesLimited investigationFinal reportMooney M20D · Ama, LAAfter takeoff the plt made two low passes over the rwy, & was turning to make a third when the acft struck trees.NTSB ATL83LA268Accident · No injuriesLimited investigationFinal reportEames Acro Sport · Huntersville, NCThe acft collided with a tree during inverted flt over an arpt. The pilot had made several aerobatic maneuvers over the airfield. On the last pass the acft was inverted at low alt as it proceeded down the rwy it drifted west about 200 ft and hit a tree near…NTSB LAX83LA180Accident · No injuriesLimited investigationFinal reportHughes 269A · Lindsay, CAThe plt was rounding up cattle for a bbq. One of the steer in the herd charged the helicopter & struck its skid. The main rotor deflected & severed the tail boom. The plt lost control of the acft which impacted the ground & rolled over.NTSB NYC83FA034Accident · 2 fatalField investigationFinal reportBeech C23 · Hazleton, PAOn 11/28/82, the pilot encountered icing conditions and landed at Hazleton, PA. The aircraft was not deiced at Hazleton and icing conditions continued until the morning of 11/29/82. While departing on 11/29/82, the aircraft was observed to use more than two…NTSB MKC83LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Marengo, IAPilot overflew the area and saw no obstructions. Planned to land well down the runway. Saw wires 75 feet from runway. He says wires were 70 feet high and 50 feet from runway.NTSB LAX82DA340Accident · Serious injuriesFinal reportBeech C23 · Bear Valley, CAThe pilot landed long and fast on the runway. He was using runway 19 and the wind was from the north at 15-20 KTS. He landed and while still rolling at 65 KTS initiated a go-around. He did not climb high enough to clear small tree and after colliding with…NTSB FTW82DA362Accident · No injuriesFinal reportPiper PA-28-180 · Weslaco, TXThe plt overshot an approach to rwy 13 & went around. The crosswind leg was extended to give the plt more room. The plt turned on final & lined up on a street paralleling the rwy. Just prior to touchdown the plt saw the "x" painted on the street & executed a…NTSB SEA82DA108Accident · No injuriesFinal reportGrumman AA-5B · Corvallis, ORThe aircraft contacted the surface while the pilot was making a low pass over the private airport. Fresh cut hay was windrowed at the edge of the strip. The hay caught on the landing gear and blew up into the elevators and the aircraft was damaged when it…