NTSB investigations: Lycoming O&VO-360 series, 1998
67 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 year(c.\"eventDate\") = 1998
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 year(c."eventDate") = 1998
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 LAX98LA176Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Fresno, CAThe dual's student improper flare that led to the right main landing gear collapsing. A related factor in the accident was the instructor pilot's inadequate supervision.NTSB MIA98LA165Accident · No injuriesLimited investigationFinal reportCessna 172RG · Roberta, GAThe pilot's inadequate compliance with the emergency procedures for his failure to completely pump the main landing gear into the down and locked position. Contributing to the accident was the reported loss of electrical power for undetermined reasons.NTSB MIA98LA146Accident · No injuriesLimited investigationFinal reportCessna 172RG · Greenville, SCThe pilot's use of full flaps while landing in a strong crosswind resulting in loss of directional control during the landing roll.NTSB LAX98LA142Accident · No injuriesLimited investigationFinal reportBeech C23 · Tulare, CAThe malfunction of the nose wheel steering for undetermined reasons.NTSB LAX98LA137Accident · No injuriesLimited investigationFinal reportGrumman American AA5B · Aguanga, CAthe lack of available published information regarding obstructions and nonstandard lighting at the private airport, and the lack of a lighted and properly marked displaced threshold.NTSB MIA98LA119Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Charlotte, NCthe pilot's failure to follow proper starting procedures.NTSB NYC98LA087Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Warren, PAThe pilot's failure to obtain the proper touchdown point.NTSB FTW98LA162Accident · Minor injuriesLimited investigationFinal reportCarter LONG-EZ · Lebanon, OKThe pilot's inadequate compensation for the tailwind and his ensuing failure to attain the proper touchdown point. Factors were the tailwind and the pilot's failure to adequately preflight the airplane which resulted in a partial loss of engine power due to…NTSB MIA98LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Punta Gorda, FLThe total loss of engine power due to fuel starvation.NTSB SEA98LA049Accident · No injuriesLimited investigationFinal reportCessna 177A · Laurel, MTThe pilot's excessive descent rate on final, and improper recovery from a bounced landing.NTSB MIA98FA101Accident · 1 fatalField investigationFinal reportPiper PA-28-180D · Advance, NCThe pilot's improper planned visual approach and glide path in diminished visual conditions due to sun-glare and his delayed go-around resulting in the aircraft colliding with trees on final approach.NTSB LAX98GA110Accident · 1 fatalFinal reportChristen Industries A-1 · Lebec, CAThe trainee-pilot's failure to maintain altitude during a low level turn. Contributing factors were the pilot-in-command's diverted attention inside the airplane, his failure to report the trainee's deficient airplane handling abilities, and the shoulder…NTSB CHI98LA104Accident · No injuriesLimited investigationFinal reportMooney M20C · White River, SDthe pilot's delay in applying carburetor heat. A factor associated with the accident was the low altitude at which the pilot was flying which limited his landing site selections when the loss of power occurred.NTSB FTW98LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Monroe, LAThe pilot's improper decision to continue the flight after noting the low fuel quantity indication, which resulted in the loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB ATL98LA052Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Fayetteville, NCfuel system contamination (rubber shavings), which led to blockage of a fuel line, fuel starvation, loss of engine power, and a collision with terrain.NTSB ATL98LA042Accident · No injuriesLimited investigationFinal reportAviat A-1 · Clearwater, FLfailure of the pilot to maintain adequate airspeed, while maneuvering to pick up a banner, which led to a stall, loss of altitude, and collision with the water.NTSB CHI98LA092Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Eden Prairie, MNthe pilot's improper raising of flaps and not maintaining directional control of the aircraft during the go-around sequence.