NTSB investigations: Lycoming O&VO-360 series, MO
128 cases on aircraft whose registry engine model is Lycoming O&VO-360 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\" = 'MO' 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 ('41514'))
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" = 'MO' 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 ('41514'))
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 MKC88LA063Accident · No injuriesLimited investigationFinal reportBeech C23 · Sullivan, MOWhen the PIC arrived at his destination, during a personal cross country flight, he circled the unfamiliar arpt three times, observing trees on both ends, and a crosswind of about 60 degrees to the active runway. After landing, and during the ldg roll out, he…NTSB MKC88LA038Accident · No injuriesLimited investigationFinal reportCessna 177 · St. Charles, MOWhile practicing touch and go ldgs, PIC noted a significant increase in sink rate. Additional power failed to arrest the descent, and the acft struck the terrain short of the rwy causing substantial damage to the acft, and no injuries to plt and pax.NTSB MKC87LA184Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Ozark, MODuring a ldg, the acft touched down long, ran off the end of the airstrip and struck a fence and then a ditch. The rwy was 2100 feet long, downsloping, and the grass surface was wet.NTSB MKC87LA021Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Chillicothe, MOThe PIC rptd that he was taxiing out fm the ramp area to the runup area of the airport to prepare for takeoff. He stated he had noticed ground equipment operating on the arpt as he taxied out. He had also stated that the windshield had become fogged during…NTSB MKC85LA188Accident · No injuriesLimited investigationFinal reportCessna 172RG · Lee'S Summit, MOThe plt reported that the eng start & run-up were normal before he took off on a night currency & proficiency flt. After 2 normal takeoffs & full stops, he made a 3rd takeoff. He climbed to 1000 ft AGL on a x-wind leg, reduced power to 20' manifold pressure &…NTSB MKC84LA270Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Grain Valley, MOThe landing gsar collapsed as a result of a hard landing in gusty wind conditions. Although the airport wind sock was tattered, sufficient wind information was available from fss and UNICOM to alert the pilot to the need for compensation on approach. 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 MKC84LA086Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Jefferson City, MOThe acft drifted left due to a crosswind during landing. The drift put the acft into snow which had been plowed along the rwy side. The collision pulled the acft off the rwy.NTSB MKC84LA055Accident · No injuriesLimited investigationFinal reportMooney M20C · Pittsburg, MOThe acft ran off of the snow covered rwy into trees after an attempted downwind takeoff. The plt had packed the 8 inch snow by driving his car on the rwy. During the aborted takeoff the plt was unable to stop the acft before tree contact.NTSB MKC83LA144Accident · No injuriesLimited investigationFinal reportBeech C-23 · Osage Beach, MOThe acft ran off the side of the runway and continued to overrun the departure end of the runway where collision with a ditch occurred. There was evidence that the brakes were used but were not effective in stopping the acft. An FAA inspector inspected the…NTSB MKC83LA031Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Near Vichy, MOWhile enroute from cape girardeau, MO to rolla, MO, the pilot encountered an area of low ceilings and fog. While he was trying to remain VFR at low altitude, the aircraft struck trees on top of a hill. The pilot climbed abruptly, but the plane stalled,…NTSB MKC82FCA07Accident · No injuriesClosedBrantly B-2 · Kennett, MONTSB MKC81FCA23Accident · No injuriesClosedGrumman AA-5B · Wentzville, MONTSB MKC81DCA04Accident · No injuriesClosedPiper PA-24 · Des Arc, MONTSB MKC81FA006Accident · Minor injuriesClosedPiper PA-28 · Independence, MONTSB MKC80FCG47Accident · Minor injuriesClosedBeech C23 · Ozark, MONTSB MKC80FA057Accident · 3 fatalClosedGulf-Amer AA-5B · Chesterfield, MONTSB MKC80FCG37Accident · No injuriesClosedMooney M21 · Lee'S Summit, MONTSB MKC80FCA21Accident · Serious injuriesClosedBeech C23 · St Charles, MONTSB MKC80FA028Accident · Serious injuriesClosedCessna 177B · Edwards, MONTSB MKC79DCG80Accident · No injuriesClosedPiper PA-28 · Lamar, MONTSB MKC79DA053Incident · No injuriesClosedBeech 95 · St Charles, MONTSB MKC79FCG69Accident · Serious injuriesClosedPiper PA-28 · Gainesville, MONTSB MKC79DCG53Accident · No injuriesClosedMooney M20C · Ava, MONTSB MKC79FCA16Accident · Serious injuriesClosedGrumman AA-5B · Owensville, MONTSB MKC79FCG41Accident · Serious injuriesClosedPiper PA-25 · Camdenton, MONTSB MKC78FCG12Accident · 1 fatalClosedCessna 177B · Grain Valley, MONTSB MKC78FA005Accident · 1 fatalClosedPiper PA-28 · Lamar, MONTSB MKC77FCA03Accident · No injuriesClosedCessna 177B · Union, MONTSB MKC77FCA12Accident · No injuriesClosedPiper PA-24 · Houston, MONTSB MKC76DCG82Accident · No injuriesClosedPiper PA-28 · Lamar, MONTSB MKC76DCG76Accident · No injuriesClosedCessna 177B · Kansas City, MONTSB MKC76FCG66Accident · No injuriesClosedMooney M20A · Gravois Mills, MONTSB MKC76FCG54Accident · No injuriesClosedCessna 177 · California, MONTSB MKC76FCG32Accident · No injuriesClosedPiper PA-28 · Grain Valley, MONTSB MKC76DCG14Accident · No injuriesClosedCessna 177A · Cassville, MONTSB MKC75DCG48Accident · No injuriesClosedGrum Amer AA-5B · Edwards, MONTSB MKC75FCG29Accident · Minor injuriesClosedAero Comdr 100 · Odessa, MONTSB MKC75DCG28Accident · No injuriesClosedMooney M21 · Joplin, MONTSB MKC74FCA29Accident · No injuriesClosedPiper PA-28 · Fenton, MONTSB MKC74DCG26Accident · No injuriesClosedPiper PA-28 · Warrensburg, MONTSB MKC74FCA22Accident · No injuriesClosedPiper PA-28 · Bowling Green, MONTSB MKC73DCA23Accident · No injuriesClosedLake LA-4 · St Charles, MONTSB MKC72DCG52Accident · No injuriesClosedPiper PA-28 · Camdenton, MONTSB MKC72AK032Accident · 2 fatalClosedPiper PA-28 · Rutledge, MONTSB MKC71FCA38Accident · Minor injuriesClosedPiper PA-28 · Newburg, MONTSB MKC71FCA35Accident · No injuriesClosedPiper PA-28 · Jefferson City, MONTSB MKC71DCG32Accident · Minor injuriesClosedMooney M20C · Maryville, MONTSB MKC70DCG32Accident · No injuriesClosedPiper PA-28 · Columbia, MONTSB MKC70FCA03Accident · Serious injuriesClosedMooney M20C · Morehouse, MO