NTSB investigations: Lycoming O&VO-360 series
200 cases on aircraft whose registry engine model is Lycoming O&VO-360 series, where the first occurrence was “Loss of control - on ground/water”. 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\" = 260))
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" = 260))
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 FTW02CA207Accident · No injuriesData collectionFinal reportGulfstream American AA-5B · Spicewood, TXthe pilot's failure to maintain directional control during landing roll.NTSB ANC02LA027Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Chickaloon, AKThe inadequate supervision of the student pilot by the instructor. Factors associated with the accident are the snow-covered runway and the loss of directional control by the student pilot.NTSB LAX02LA113Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Denio, NVThe pilot's failure to maintain directional control and his inadequate compensation for wind condition. Wind gust is a contributing factor.NTSB DEN02LA022Accident · No injuriesLimited investigationFinal reportCessna 175 · St. George, UTThe student pilot's failure to maintain aircraft directional control during take off roll.NTSB IAD02LA023Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Martinsville, VAThe pilot's premature rotation and his failure to maintain directional control during the takeoff roll.NTSB CHI01LA304Accident · No injuriesLimited investigationFinal reportBeech C23 · St. Helen, MIThe pilot's failure to attain the proper airspeed which resulted in a premature lift-off and subsequent stall/mush. A factor to the accident was the fence.NTSB NYC01LA200Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · West Milford, NJThe student pilot's failure to maintain directional control while landing. Factor’s in this accident were a wind gust and the rocks located off the left side of the runway.NTSB DEN01LA120Accident · No injuriesLimited investigationFinal reportCessna 172Q · Englewood, COthe pilot's failure to properly recover from a bounced landing. A contributing factor were the adverse wind conditions.NTSB LAX01LA170Accident · No injuriesLimited investigationFinal reportAviat A-1B · Apex, NVThe pilot's failure to maintain directional control during landing rollout in a gusty and crosswind condition.NTSB DEN01LA079Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Las Vegas, NMthe pilot's failure to maintain directional control during landing roll. Factors were weather evaluation by the pilot and rough terrain off the side of the runway.NTSB FTW01LA089Accident · No injuriesLimited investigationFinal reportAviat A-1B Husky · Odessa, TXthe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB CHI01LA081Accident · No injuriesLimited investigationFinal reportCessna 172RG · Troy, MIthe excessive touchdown airspeed and the directional control not maintained by the pilot. The snow bank was a contributing factor.NTSB DEN01LA038Accident · No injuriesLimited investigationFinal reportAviat A-1A · Eden, UTthe pilot's failure to maintain aircraft control during a landing attempt. A contributing factor was his failure to check the snow conditions in the field before the flight.NTSB NYC01LA039Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Montauk, NYThe pilot's failure to maintain runway alignment during touchdown and rollout. Factors in the accident were the pilot's inadequate crosswind compensation, and inadequate flare.NTSB MIA01LA025Accident · No injuriesLimited investigationFinal reportMaule MX-7-180A · St. Marys, GAThe pilot's failure to maintain directional control during landing, resulting in a sideward skid, a collapsed main landing gear strut, and wing strike.NTSB DEN00LA162Accident · Minor injuriesLimited investigationFinal reportAviat A-1 · Laramie, WYThe pilot's failure to maintain directional control. A factor was his improper inflight decision in selecting a less-than-favorable runway on which to land that resulted in a ground loop.NTSB MIA00LA216Accident · No injuriesLimited investigationFinal reportAviat Husky · Dayton, TNThe pilot's failure to maintain directional control of the airplane during landing flare into a crosswind, resulting in a runway excursion off the runway edge and collision of the wingtip with the terrain.NTSB LAX00LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tucson, AZThe student pilot's failure to maintain directional control of the airplane during landing.NTSB MIA00LA151Accident · No injuriesLimited investigationFinal reportMooney M20C · Bryson City, NCThe pilot's failure to maintain directional control on landing rollout with a known quartering crosswind, resulting in an on-ground collision with a known fixed object (wooden pallet.)NTSB LAX00LA147Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Herlong, CAThe failure of the pilot to maintain directional control of the airplane during landing in gusting crosswind conditions.NTSB NYC00LA060Accident · No injuriesLimited investigationFinal reportBeech C-23 · Manassas, VAThe pilot's inadequate remedial action to recover the airplane from porpoising during the landing roll out.NTSB FTW99LA210Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Whitewright, TXThe pilot's failure to maintain directional control of the airplane.NTSB ATL99LA097Accident · No injuriesLimited investigationFinal reportCessna 172RG · Sanford, FLThe pilot's failure to maintain directional control during landing.NTSB NYC99LA038Accident · No injuriesLimited investigationFinal reportBeech BE-76 · Cincinnatti, OHThe flight instructor's delay in initiating remedial action. Factors include a wet runway, and the student's inability to maintain airplane directional control during a simulated, on-ground engine failure.NTSB SEA98LA171Accident · No injuriesLimited investigationFinal reportDornbos BD-4 · Kent, WADirectional control was not maintained by the pilot in command.NTSB FTW98LA370Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Hurricane, UTThe pilot inadvertently inducing a porpoise oscillation, and his failure to maintain directional control. A factor was the excessive landing airspeed.NTSB CHI98LA324Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Michigan City, INthe pilot departed into known adverse weather and failed to maintain directional control of the airplane. A factor was the fog.NTSB SEA98LA143Accident · Minor injuriesLimited investigationFinal reportMcCarty Avid Magnum · Kalispell, MTThe pilot's inadequate compensation for the wind conditions. A factor was gusty wind conditions.NTSB NYC98LA139Accident · No injuriesLimited investigationFinal reportRoss RV6A · Hunter, NYthe pilot's inadequate compensation for wind conditions, and failure to maintain directional control of the airplane. The gusty/variable wind condition was a related factor.NTSB LAX98LA203Accident · No injuriesLimited investigationFinal reportCessna 177B · Fallon, NVThe pilot's improper use of rudder controls on a short field takeoff and his failure to maintain runway alignment.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 IAD98LA006Accident · No injuriesLimited investigationFinal reportAviat A-1 · Duxbury, MAFailure of the pilot to maintain control of the airplane. A related factor was the wind gusts.NTSB CHI97LA253Accident · No injuriesLimited investigationFinal reportPiper PA-28-121 · Glencoe, MNfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in an inadvertent ground swerve and subsequent collision with trees. Factors associated with the accident were: the crosswind, and proximity of trees.NTSB ANC97LA057Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Palmer, AKthe pilot's inadequate preflight, and a foreign object (can) that became jammed under the rudder pedal, which resulted in an inadvertent activation of the right brake.NTSB SEA97LA078Accident · No injuriesLimited investigationFinal reportCessna 177B · Everett, WAfailure of the pilot to maintain directional control of the airplane after landing. Factors relating to the accident include: a blown (failed) nose tire, and soft terrain beside the runway.NTSB LAX96LA257Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Redlands, CAthe CFI's delayed remedial action by not preventing the airplane's departure from the runway, and his failure to maintain airspeed sufficient to avoid stalling during an attempted low altitude climbing turn.NTSB ATL96LA082Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Mckenzie, TNThe pilot's improper use of the flight control during a crosswind landing that resulted in a loss of control of the airplane.NTSB FTW96LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Heber Springs, ARFailure of the pilot to maintain directional control of the airplane during transition from landing roll to taxi. A factor relating to the accident was: a soft area in the grass runway.NTSB NYC95LA213Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Meriden, CTthe pilot's failure to maintain directional control during the landing roll which resulted in the aircraft veering off the runway, and a subsequent collision with a fence.NTSB FTW95LA333Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Englewood, COFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. A factor related to the accident was: the crosswind condition.NTSB FTW95LA329Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Englewood, COThe pilot's improper compensation for the 6 knot crosswind. Factors were the pilot's delay in initiating an aborted landing and his lack of total experience.NTSB CHI95LA216Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Chesterfield, MOThe pilot's failure to maintain control of the airplane while landing and his inadequate compensation for wind conditions. A factor in the accident was the gusty crosswind conditions.NTSB ANC95LA081Accident · No injuriesLimited investigationFinal reportCessna 172 · Gustavus, AKThe pilot's failure to maintain directional control. A factor relating to the accident was: the diminished nosewheel steering capability due to an overinflated nosewheel strut.NTSB FTW95LA118Accident · No injuriesLimited investigationFinal reportCessna 177B · Terlingua, TXThe pilot's failure to maintain directional control. Factors were his decision to land on the unlit runway and the dusk light conditions.NTSB LAX95LA010Accident · No injuriesLimited investigationFinal reportBeech C-23 · Kahului, HIthe student pilot's improper recovery from a bounced landing, improper in-flight decision, and his failure to attain the proper climb airspeed during the initial takeoff resulting in an inadvertent stall. The student pilot's lack of total experience,…NTSB SEA94LA126Accident · No injuriesLimited investigationFinal reportChristen Industries Husky · Ogden, UTThe pilot's inadequate compensation for wind condiitons. The wind gusts were a factor.NTSB NYC94LA076Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Danbury, CTThe student pilot's inadequate compensattion for wind conditions. The crosswind was a factor.NTSB BFO94LA059Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Oneonta, NYThe pilot's failure to maintain directional control during takeoff. A related factor was the crosswind component.NTSB SEA94LA090Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Driggs, IDDirectional control was not maintained. A factor to the accident was: inadequate remedial action.