NTSB investigations: Lycoming 0-320 series
14,588 cases on aircraft whose registry engine model is Lycoming 0-320 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 ('41508'))
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 ('41508'))
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 ERA09LA379Accident · No injuriesLimited investigationFinal reportCessna 172M · Princeton, NJThe partial loss of engine power for undetermined reasons.NTSB ANC09CA111Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Homer, AKThe pilot's excessive airspeed during approach to compensate for turbulence, resulting in a hard landing and runway overrun.NTSB CEN09CA422Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Hibbing, MNThe pilot mistakenly using a closed taxiway for takeoff, which resulted in the airplane striking a construction barricade.NTSB CEN09LA396Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Shelbyville, INThe partial loss of engine power due to the failure of the mixture control cable. Contributing to the accident was the inadequate maintenance on the airplane and the pilot's decision to operate the airplane in a condition that was not airworthy.NTSB WPR09FA316Accident · 2 fatalField investigationFinal reportCessna 172M · Rimrock, WAThe pilot's failure to maintain clearance from trees during a go-around. Contributing to the accident was the pilot's lack of flight experience, and his delayed initiation of a go-around.NTSB ERA09CA553Accident · No injuriesData collectionFinal reportChampion 7GCAA · Ware, MAThe pilot's failure to maintain control of the airplane during landing.NTSB CEN09CA459Accident · Minor injuriesData collectionFinal reportCessna 172P · Usafa, COThe pilot's failure to maintain a safe flying airspeed resulting in an inadvertent stall during the go-around.NTSB WPR09CA305Accident · Minor injuriesData collectionFinal reportCessna 172M · McCall, IDA total loss of engine power during descent due to fuel exhaustion as a result of the pilot's failure to determine the fuel quantity prior to departure.NTSB CEN09TA374Accident · Minor injuriesFinal reportPiper PA-18-150 · Alpine, TXThe pilot's failure to maintain control of the aircraft.NTSB CEN09CA376Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Fort Collins, COThe pilot's failure to maintain control of the airplane during a crosswind landing. Contributing to the accident was the instructor's delayed action in regaining control of the airplane.NTSB CEN09CA373Accident · Serious injuriesData collectionFinal reportCessna 172N · Marysville, OHThe pilot's inability to maintain directional control of the airplane during the landing roll for undetermined reasons.NTSB WPR09CA304Accident · No injuriesData collectionFinal reportStucker Virgil A Avid Magnu · Emmett, IDThe pilot's improper landing flare and recovery from a bounced landing.NTSB ERA09LA360Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Del Ray Beach, FLAn in-flight failure of the main drive vee belts.NTSB ERA09LA358Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Plymouth, MAThe CFI's inadequate preflight planning and delay to abort the takeoff from the soft takeoff area.NTSB ANC09CA054Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Tyonek, AKThe pilot's selection of unsuitable terrain for landing.NTSB ERA09CA314Accident · Minor injuriesData collectionFinal reportPiper PA-22 · Aurora, WVThe pilot’s inadequate preflight planning and preparation which resulted in a low fuel condition requiring an off-airport landing.NTSB ERA09LA310Accident · No injuriesLimited investigationFinal reportCessna 172M · Sarasota, FLA loss of engine power for undetermined reasons.NTSB CEN09CA327Accident · No injuriesData collectionFinal reportCessna 177 · Houston, TXA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight fuel planning.NTSB CEN09LA329Accident · Serious injuriesLimited investigationFinal reportJohnston Coyt E T-18 · Granbury, TXThe pilot's failure to maintain directional control during landing.NTSB ERA09LA308Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Jasper, ALA total loss of engine power due to fuel starvation as a result of the flight instructor's improper fuel management.NTSB ERA09CA301Accident · No injuriesData collectionFinal reportCessna 172N · Tunkhannock, PAThe pilot's failure to attain the proper touchdown point while landing with a tailwind.NTSB CEN09CA320Accident · No injuriesData collectionFinal reportBeech B19 · Winsted, MNThe student pilot's improper flare during the soft-field landing. Contributing to the accident was the flight instructor's inadequate supervision during the landing.NTSB WPR09FA248Accident · 3 fatalField investigationFinal reportCessna 172N · Long Beach, CAThe failure of both pilots to see and avoid each other's aircraft.NTSB WPR09FA246Accident · Minor injuriesField investigationFinal reportCessna 172 · Burlington, WAThe failure of the pilot of another airplane to maintain adequate visual lookout during the approach.NTSB CEN09CA301Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Las Cruces, NMThe pilot's failure to maintain directional control while landing in a crosswind. Contributing to the accident was the pilot's decision to land on a runway with a prevailing crosswind.NTSB WPR09LA245Accident · No injuriesLimited investigationFinal reportCessna 172N · Desert Center, CAA partial loss of engine power due to low compression from an obstructed intake valve. Contributing to the accident was the pilot’s decision to shut down the engine while in flight.NTSB ANC09CA043Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Talkeetna, AKThe pilot's failure to maintain directional control during the landing roll, resulting in a ground loop and substantial damage to the airplane.NTSB ANC09CA041Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Kenai, AKThe pilot's failure to maintain clearance from a tree while taxiing.NTSB CEN09CA292Accident · No injuriesData collectionFinal reportCessna 172N · Springdale, ARThe student pilot's failure to maintain control of the airplane during the landing roll and subsequent go-around.NTSB ERA09CA287Accident · Serious injuriesData collectionFinal reportPiper PA-28-140 · Danville, PAThe student pilot's failure to maintain control during a landing.NTSB CEN09CA282Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Seminole, OKThe pilot's failure to maintain directional control during takeoff.NTSB CEN09CA271Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Harlingen, TXThe pilot's decision to leave the helicopter unattended with the engine running in gusty wind conditions.NTSB ERA09LA272Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Chesterfield, SCThe partial loss of engine power due to a broken exhaust valve. Contributing to the accident was the operator's exceedance of the engine manufacturer's recommended time before overhaul.NTSB ERA09LA271Accident · No injuriesLimited investigationFinal reportCessna 177 · Kinston, NCA partial loss of engine power due to the failure of the No. 1 cylinder exhaust valve for undetermined reasons.NTSB WPR09CA206Accident · No injuriesData collectionFinal reportCessna 172M · Corona, CAThe pilot's improper landing flare.NTSB WPR09CA209Accident · No injuriesData collectionFinal reportCessna 172P · Livermore, CAThe student pilot’s improper recovery from a bounced landing.NTSB CEN09CA259Accident · No injuriesData collectionFinal reportZenith CH-250 · Hollister, MOThe pilot's failure to maintain directional control during landing.NTSB CEN09LA250Accident · Minor injuriesLimited investigationFinal reportJordan Don R Vans RV-6A · Arlington, TXA total loss of engine power due to the failure of both magnetos. Contributing to the accident was the lack of preventative maintenance/inspection of the magnetos.NTSB ANC09LA032Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Anchorage, AKThe pilot's inability to maintain directional control due to the pilot's seat sliding back during takeoff as a result of maintenance personnel's incorrect installation of the seat's forward track stop.NTSB WPR09CA193Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Dubois, WYThe pilot's encounter with a windshear/downdraft that exceeded the climb performance capabilities of the airplane.NTSB WPR09CA185Accident · No injuriesData collectionFinal reportCessna 172L · Richland, WAThe pilot's improper landing flare.NTSB CEN09CA237Accident · No injuriesData collectionFinal reportPiper PA-22-160 · North Little Rock, ARThe pilot's inadequate compensation for the wind conditions during takeoff.NTSB WPR09CA182Accident · No injuriesData collectionFinal reportCessna 172S · Snohomish, WAAn in-flight collision with a crow.NTSB ERA09LA229Accident · 1 fatalLimited investigationFinal reportGaynor Donald J RV6A · Englewood, FLThe pilot's operation of the airplane while impaired (alcohol) and his decision to attempt aerobatic maneuvers at a low altitude resulting in the loss of aircraft control and subsequent collision with trees.NTSB ANC09CA028Accident · No injuriesData collectionFinal reportPiper PA-12 · Skwentna, AKThe pilot's selection of an unsuitable landing/takeoff area with an unfavorable wind.NTSB WPR09FA175Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Sherwood, ORThe pilot’s continued visual flight into instrument meteorological conditions, resulting in spatial disorientation and a loss of control.NTSB ERA09CA219Accident · Minor injuriesData collectionFinal reportParks Jerry R Lancair · Milton, FLThe pilot's failure to maintain aircraft control during landing.NTSB WPR09CA163Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Chowchilla, CAThe pilot's failure to maintain clearance from the power lines.NTSB ERA09CA205Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Richmond, VAA loss of engine power due to the pilot inadvertently shutting down the engine.NTSB WPR09CA162Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Jackson, WYThe pilot's failure to maintain directional control during the landing roll.