NTSB investigations: Lycoming O&VO-360 series, NC
120 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\" = 'NC' 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" = 'NC' 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 ATL91FA046Accident · Minor injuriesField investigationFinal reportPiper PA-28-180 · Greensboro, NCAn encounter with wake turbulence which resulted in an uncontrolled descent. An additional cause was pilot's physiological conditions and his use of medication.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 ATL91LA002Accident · No injuriesLimited investigationFinal reportMooney M20E · Greensboro, NCThe failure of the rubber/metal coupling in the landing gear actuator assembly, which resulted in the inability of the pilot to lower and lock the landing gear.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 ATL89LA126Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Siler City, NCImproper engine overhaul procedures which resulted in the catastrophic failure of the engine crankshaft. Contributing to the accident was the lack of a suitable forced landing area.NTSB ATL89LA011Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Hatteras, NCThe plt reported that he initially flared too high during the landing. He recovered and the acft subsequently touched down 'firmly' on the main gear. The acft then began to veer to the rt 'as if the rt brake was locked'. The plt attempted to abort the ldg &…NTSB ATL88FA219Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Winston-Salem, NCN7942N crashed into a building shortly after liftoff from runway 21. The pilot was cleared for a left turnout over runway 33. A witness estimated that the airplane had reached 300 feet when the pilot lost control and crashed. The investigation failed to…NTSB ATL88DMG03Accident · Minor injuriesFinal reportThorp T-18 · Advance, NCNTSB ATL88LA035Accident · No injuriesLimited investigationFinal reportMooney M20A · Southport, NCThe airplane lost engine pwr shortly after takeoff. A forced ldg was subsequently made in a nearby waterway. Post-crash exam of the airplane revealed that the fuel selector was in the left tank position, and that the left tank contained about 1/2 gallon of…NTSB ATL87LA169Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Franklin, NCA 17 inch portion of one of the prop blades fractured and separated from the 76 inch dia prop while the acft was at cruise. During the forced landing the acft struck a fence post. Examination of the prop revealed the presence of filiform corrosion across the…NTSB ATL87LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · High Point, NCThe plt landed on the wet turf/gravel rwy with a slight quartering tail wind. Rprtdly, the acft touched down about 1/3 of the way down the rwy with an airspeed of 4 to 9 KTS above the recommended speed. The plt was unable to stop on the remaining rwy &…NTSB ATL86LA083Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Hickory, NCDuring cruise flt, plt felt eng vib and diverted to nearest aprt. During the descent the plt heard an explosion, saw the eng cowl pop up and oil covered the windscreen. Established in a glide the acft collided with trees then the ground. Exam of the eng…NTSB ATL85LA217Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Franklin, NCWhile in cruise flt eng RPM decreased. Plt actions to recover RPM were unsuccessful and eng eventually quit. A forced landing was made to an empty fld. On roll out the acft hit a concealed ditch resulting in substantial damage. Later, exmination of the eng…NTSB ATL85LA190Accident · No injuriesLimited investigationFinal reportBeech C-23 · Wilmington, NCThe student plt was making a landing at the second arpt of a x-country flt when a controller in the tower observed the acft bounce and spotted the nose gear lying on the rwy. An ELT signal was also received at that time. The student plt made a go-around and…NTSB ATL85LMG02Accident · No injuriesFinal reportPiper PA-28-180 · Goldsboro, NCWhile landing at night, the acft encountered unfavorable winds & went off the left side of the rwy. After departing the rwy, it hit a drainage ditch & the nose gear collapsed. About 50 mi northwest at the raleigh/durham arpt, the wind was variable from 290 to…NTSB ATL85LA051Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Fremont, NCThe student plt reported that he landed hard & bounced twice before settling to the rwy. He applied full braking & the acft skidded off the end of the rwy.NTSB ATL84LA125Accident · Serious injuriesLimited investigationFinal reportHughes 269 · Supply, NCThe plt and passg stated that as the flt approached Supply, NC, the wx conditions deterioriated and the helicopter encountered a fog bank. The passg recalled that the visibility reduced completely and visual contact with the ground was lost. The plt decided…NTSB ATL83LA307Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Rutherfordton, NCDuring the landing roll, the plt noted that the right brake was ineffective. She requested that the plt in the copilot's seat attempt to regain control, but the copilot confirmed the same problem while using her brakes. Since the rwy was relatively short, the…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 ATL82DA247Accident · Minor injuriesFinal reportCessna 177 · Greensboro, NCThe pilot reported that during a landing on runway 27, he encountered gusty crosswinds from 150 to 160 deg. The said the aircraft drifted right about 30 ft. reportedly, he was slipping the plane back to the runway when the aircraft landed hard. During the…NTSB ATL82DA108Accident · No injuriesFinal reportBeech C23-180 · Greensboro, NCThe pilot stated that he experienced a failure of the right brake system preventing him from maintaining directional control during ground roll after landing on runway 09. The mechanic who removed the aircraft from the accident scene reported that tire tracks…NTSB ATL82FA065Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Taylorville, NCThe aircraft departed akron, NY at 1154 EST on a flight to charlotte,NC. Toward late afternoon, as the sun began to set, one of the passengers (the pilot's daughter), informed the pilot that the aircraft was getting low on fuel. He diverted toward an airport,…NTSB ATL81DKM09Accident · No injuriesClosedMooney M20C · Asheboro, NCNTSB ATL81DKM07Accident · Minor injuriesClosedBeech C23 · Greensboro, NCNTSB ATL81FKM05Accident · No injuriesClosedPiper PA-28 · Long Island, NCNTSB ATL80DKM23Accident · Serious injuriesClosedStarduster SA-300 · Horse Shoe, NCNTSB ATL80DKM22Accident · No injuriesClosedPiper PA-28 · Liberty, NCNTSB IAD79FA026Accident · 2 fatalClosedCessna 177B · Charlotte, NCNTSB IAD78DKM14Accident · No injuriesClosedPiper PA-28 · Greensboro, NCNTSB IAD77FKM31Accident · Minor injuriesClosedAero Comdr 112TC · Charlotte, NCNTSB IAD77DKM23Accident · No injuriesClosedPiper PA-28 · Greensboro, NCNTSB IAD77FLJ11Accident · No injuriesClosedPiper PA-28 · Pinehurst, NCNTSB IAD77DLJ09Accident · Minor injuriesClosedCessna 177 · Wallace, NCNTSB IAD76FLJ31Accident · No injuriesClosedCessna 177 · Wilson, NCNTSB IAD76FLJ18Accident · No injuriesClosedHughes 269A · Pinehurst, NCNTSB IAD76DKM13Accident · No injuriesClosedAero Comdr 100 · Shelby, NCNTSB IAD76ALJ08Accident · No injuriesClosedStarduster SA-300 · Chapel Hill, NCNTSB IAD75DLJ21Accident · No injuriesClosedPiper PA-24 · Burlington, NCNTSB IAD75DKM19Accident · No injuriesClosedPiper PA-28 · Indian Trail, NCNTSB IAD75DKM18Accident · Minor injuriesClosedPiper PA-28 · Walnut Cove, NCNTSB IAD74DKM54Accident · No injuriesClosedMooney M20C · Asheville, NCNTSB IAD74DKM36Accident · No injuriesClosedPiper PA-28 · Lexington, NCNTSB IAD74DKM32Accident · Minor injuriesClosedMooney M20B · Rosman, NCNTSB IAD74DLJ20Accident · No injuriesClosedMooney M20D · Portsmouth, NCNTSB IAD74FLJ12Accident · Serious injuriesClosedPiper PA-28 · Riegelwood, NCNTSB IAD74DKM14Accident · No injuriesClosedPiper PA-28 · Salisbury, NCNTSB IAD73FLJ25Accident · Serious injuriesClosedPiper PA-28 · Bolton, NCNTSB NYC73FFJ11Accident · No injuriesClosedPiper PA-28 · Roanoke Rapids, NCNTSB NYC72FLJ28Accident · No injuriesClosedPiper PA-28 · Morrisville, NCNTSB NYC72DKM22Accident · No injuriesClosedBeech 95 · Asheville, NC