NTSB investigations: Lycoming O&VO-360 series
5,181 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.\"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."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 FTW97FA269Accident · 1 fatalField investigationFinal reportMooney M20C · Sarepta, LAThe pilot's impairment (drugs) resulting in his becoming disoriented and the ensuing loss of engine power due to fuel exhaustion. Factors were the lack of suitable terrain for the forced landing and the inaccurate navigation chart.NTSB CHI97FA196Accident · 2 fatalField investigationFinal reportMooney M20A · White Bear, MNpilot incapacitation due to a stroke.NTSB CHI97LA180Accident · No injuriesLimited investigationFinal reportCessna 172RG · Chicago, ILthe pilot inadvertently executed a wheels up landing.NTSB ATL97LA089Accident · No injuriesLimited investigationFinal reportCessna 175A · Panama City Bch, FLfailure of the pilot to account for the reduced braking effectiveness on the wet/grass airstrip, which resulted in an overrun and encounter with a ditch. Factors relating to the accident were: failure of the pilot to obtain weather information before…NTSB CHI97LA175Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Wamego, KSinaccurate preflight planning which resulted in an inadequate fuel supply for the flight and ultimately fuel exhaustion. Factors associated with the accident were the powerlines and the parachutists over the runway.NTSB CHI97LA148Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Houghton, MIthe pilot's improper starting procedures and failure to set the parking brakes.NTSB MIA97LA163Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Yakkama City, FLa complete loss of engine power due to the separation of the connecting rod bolts, resulting in a forced landing and impact with a tree. A factor in this accident was improper installation of the rod bolts by a mechanic.NTSB CHI97LA130Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Grayslake, ILthe pilot's misjudgment of the aircraft's speed and runway distance available. Factors were an off-field ditch and a tailwind condition.NTSB SEA97FA105Accident · 3 fatalField investigationFinal reportCessna 182 · Clinton, UTInadequate prior arrangements for formation flight by the pilot-in-command of the Cessna 182, N5434B, and his subsequent failure to see-and-avoid the Piper PA-28R, N5270T. Factors were: the Cessna pilot's visibility of the Piper impaired by the sun;…NTSB MIA97LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Wilgrove, NCthe pilot's improper planning, which resulted in fuel exhaustion and a forced landing short of the intended destination airport.NTSB ANC97LA073Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Togiak, AKfailure of the pilot to properly compensate for crosswind conditions. The crosswind was a related factor.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 FTW97LA157Accident · No injuriesLimited investigationFinal reportBeech BE-95 · San Antonio, TXThe failure of the right main gear due to improper repair by the company maintenance personnel.NTSB NYC97FA069Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Farmingville, NYthe pilot's improper inflight planning/decision, which subsequently resulted in fuel exhaustion and loss of engine power. Related factors were: excessive fuel consumption rate, and obstructions (trees and house) in the emergency landing area.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 ATL97LA051Accident · No injuriesLimited investigationFinal reportMaule MXT-7 · Hampton, GAinadequate compensation for the wind conditions by the pilot, and his failure to maintain directional control of the airplane. The crosswind, the pilot's lack of experience in crosswind conditions, and the proximity of trees were related factors.NTSB FTW97WA133Accident · 3 fatalForeign investigationPiper PA-28-181 · Tejupilco, MexicoNTSB FTW97LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Fort Collins, COThe pilot's failure to remove completely ice/frost from the wing, impeding the airplane's aerodynamic performance. Factors were wing contamination by frost and ice.NTSB LAX97LA095Accident · No injuriesLimited investigationFinal reportCessna 172RG · Corona, CAFailure of the pilot in command to follow the airplane's before landing checklist and verify the landing gear was fully extended before landing. Factors in the accident were anxiety and diversion of the pilot's attention due to fuel gauge readings.NTSB MIA97LA061Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Lincolnton, NCThe student pilot's improper use of flaps and failure to maintain airspeed during a go-around.NTSB NYC97LA032Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Stamford, CTinadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate fuel supply of fuel. Darkness and trees in the emergency landing area were related factors.NTSB FTW97LA060Accident · Minor injuriesLimited investigationFinal reportMooney M-20G · Saginaw, TXThe driver of the vehicle's failure to maintain clearance from the taxiing airplane. A factor was the dark night light condition which resulted in the driver's delayed visual identification of the airplane.NTSB NYC97LA027Accident · No injuriesLimited investigationFinal reportLake LA-4 · Gallipolis, OHthe pilot's improper recovery from a bounced landing, and his failure to maintain directional control, which resulted in a collision with a hangar and parked aircraft. Factors relating to the accident were: the pilot's encounter with rain, sleet, snow, and…NTSB MIA97LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Sugarloaf Key, FLa complete loss of engine power due to a disconnected connecting rod cap.NTSB FTW97LA041Accident · No injuriesLimited investigationFinal reportCessna 172RG · Tulsa, OKThe failure of the main landing gear pivot gear assembly.NTSB CHI97LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Jenison, MIthe pilot's inadequate compensation for the wind conditions. A factor was the crosswind condition.NTSB FTW97LA026Accident · Serious injuriesLimited investigationFinal reportPiper PA-28C-180 · Sterling, COimproper starting procedure used by the airport employee. Factors relating to the accident were: the inoperative starter, and failure of the pilot to seek proper assistance.NTSB IAD97LA010Accident · Minor injuriesLimited investigationFinal reportBellanca BL28 · Ledbetter, KYthe pilot's delay in executing a go-around, and his failure to obtain/maintain adequate airspeed, which resulted in a stall and collision with the ground.NTSB LAX97LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Ely, NVa partial loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed to preclude stalling, while turning toward an emergency landing area. A factor related to the accident was: the high density altitude condition.NTSB MIA96FA233Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Birmingham, ALThe pilot-in-command's improper in-flight planning/decision for electing to continue the flight after observing that the fuel gauges indicated empty. Contributing to the accident was an improperly adjusted economizer jet and an out of adjustment float. Also…NTSB CHI96LA346Accident · No injuriesLimited investigationFinal reportBeech B23 · Viroqua, WIthe pilot's inadequate aircraft preflight which led to fuel exhaustion. A factor was the rough uneven terrain.NTSB LAX96LA336Accident · No injuriesLimited investigationFinal reportPitts S-1S · Reno, NVThe pilot of N230MP inadequate visual lookout while landing on a runway occupied by another known aircraft. A factor in the accident was the procedure to allow simultaneous landings by aircraft on the same runway.NTSB ANC96LA146Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Iliamna, AKthe pilot's inadequate weather evaluation and inadequate compensation for wind conditions. The adverse weather condition was a related factor.NTSB CHI96LA321Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Grant City, MOlow oil level which resulted in the partial loss of engine power, the pilot's intentional operation of the airplane with a known mechanical deficiency, and the hay bale. Factors relating to this accident were the owner/pilot mechanic's failure to comply with…NTSB CHI96LA315Accident · No injuriesLimited investigationFinal reportBeech C-23 · Eden Prairie, MNthe instructor pilot delayed the remedial action and failed to maintain adequate supervision. The slow airspeed maintained by the student pilot was a factor.NTSB ANC96LA124Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKAn engine failure due to an eroded engine piston. Factors in the accident were unsuitable terrain for a forced landing and improperly timed magnetos.NTSB SEA96LA189Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Ephrata, WAfailure of the pilot to maintain proper alignment with the landing area (driveway) during the landing. Factors relating to the accident were: the selection of an unsuitable area for landing, the reported turbulence during landing, and an encounter with a rock…NTSB NYC96LA165Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · West Kingston, RIthe pilot's misjudgment of distance and speed during the approach to land, and his failure to go around while there was still sufficient runway remaining, which resulted in an overrun of the runway and collision with trees. The lack of natural lighting at…NTSB LAX96LA302Accident · No injuriesLimited investigationFinal reportBeech B23 · Modesto, CAfuel starvation due to the pilot's inadequate fuel management and failure to reposition the fuel selector to a tank containing adequate fuel. The power lines were a factor.NTSB FTW96LA343Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Midlothian, TXmaintenance personnel's improper engine overhaul procedures resulting in the installation of the rocker arms in reversed positions, which led to improper lubrication and binding of the exhaust valves. A related factor was the lack of suitable terrain for the…NTSB SEA96LA184Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Rexburg, IDthe pilot's failure to maintain directional control. Factors relating to the accident were: the pilot's failure to verify whether the flaps had raised, the resultant premature lift-off, and trees on the adjacent golf course.NTSB ANC96LA119Accident · No injuriesLimited investigationFinal reportAviat A-1 · King Salmon, AKThe pilot's inadequate weather evaluation, inadequate compensation for the existing wind conditions, and failure to maintain directional control. A factor associated with the accident was the gusty wind.NTSB IAD96LA123Accident · No injuriesLimited investigationFinal reportCessna 172 RG · Union Bridge, MDloss of engine power for undetermined reason(s).NTSB LAX96LA273Accident · Serious injuriesLimited investigationFinal reportBellanca 8GCBC · Pacoima, CAa total loss of engine power for undetermined reasons.NTSB FTW96LA304Accident · No injuriesLimited investigationFinal reportBeech 76 · Falcon, COA loss of engine power due to the pilot's inaccurate fuel consumption calculation, and his failure to properly identify the area of intended landing as an airport. A factor was the misrouting of the fuel line by unknown persons.NTSB FTW96LA306Accident · No injuriesLimited investigationFinal reportSmith RV4 · Mandeville, ARa loss of engine power for undetermined reasons.NTSB CHI96FA237Accident · 1 fatalField investigationFinal reportPiper PA-12 · Roselle, ILthe pilot's improper decision to perform a go-around, while there was restricted rudder movement and the banner was still attached to the airplane, which resulted in a loss of airspeed and an inadvertent stall. Factors relating to the accident were: the…NTSB LAX96LA268Accident · No injuriesLimited investigationFinal reportMooney M20C · Payson, AZanimals on the runway. A factor was the dark night.NTSB LAX96LA264Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Lanai, HIFuel exhaustion due to the pilot's inadequate fuel planning and failure to refuel the aircraft prior to initiating a 280-mile over water nonstop leg of the flight.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.