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 CEN10CA550Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Carthage, TXA total loss of engine power during cruise flight due to fuel exhaustion as a result of the pilot’s improper fuel planning.NTSB CEN10CA547Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Houma, LAThe pilot’s inadequate compensation for the crosswind while landing, which resulted in a loss of directional control.NTSB ANC10CA095Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Coal Creek, AKThe pilot's improper recovery from a bounced landing.NTSB ANC10LA094Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Dillingham, AKBoth pilots’ failure to see and avoid each other during initial climb, resulting in a midair collision. Contributing to the accident was the pilot of N9699P’s inability to use his airplane's radio for air traffic advisories.NTSB CEN10CA552Accident · No injuriesData collectionFinal reportCessna 172P · Stow, OHThe pilot's inadequate landing flare, which resulted in a hard landing.NTSB CEN10CA544Accident · No injuriesData collectionFinal reportPiper PA22 · Atkinson, NEThe pilot's failure to maintain directional control while landing with a crosswind.NTSB ANC10CA085Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Coldfoot, AKThe pilot's selection of an unsuitable (short) off-airport site for takeoff.NTSB CEN10LA531Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Buchanan, MIA failure of the engine's No. 3 and No. 4 cylinder valve lifters for undetermined reasons, which resulted in a total loss of engine power.NTSB ANC10CA096Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chicken, AKThe pilot's decision to fly at a low altitude in terrain and weather conditions conducive to turbulence and downdrafts.NTSB ANC10CA088Accident · No injuriesData collectionFinal reportPiper PA-18-160 · Arctic Village, AKThe pilot's failure to maintain control of the airplane during an off-airport landing.NTSB CEN10CA525Accident · Minor injuriesData collectionFinal reportWeber Acro Sport II · Plum City, WIThe pilot’s improper fuel planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB ANC10CA082Accident · No injuriesData collectionFinal reportPiper PA-20 · Akhiok, AKThe pilot's failure to maintain directional control while maneuvering at a low altitude.NTSB CEN10CA518Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Anderson, INThe pilot’s failure to abort the takeoff due to degraded airplane performance.NTSB ERA10CA451Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5 · Montauk, NYThe pilot's delay in aborting the landing, which resulted in a collision with a fence.NTSB CEN10CA513Accident · No injuriesData collectionFinal reportCessna 172P · Bartlesville, OKThe student pilot's loss of directional control during takeoff due to an improper flap setting.NTSB ERA10LA446Accident · 1 fatalLimited investigationFinal reportPiper PA-28-161 · Beverly, MAThe flight instructor's decision to exit the airplane on the taxiway with the engine still operating, and his failure to avoid the rotating propeller.NTSB ANC10CA077Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Wasilla, AKThe pilot's failure to maintain directional control during landing, resulting in a runway excursion and nose over.NTSB WPR10LA429Accident · 2 fatalLimited investigationFinal reportFinney Thorp T-18 · Willcox, AZThe pilot’s failure to maintain sufficient airspeed during a steep turn and at a low altitude in the traffic pattern, which resulted in an aerodynamic stall.NTSB ANC10CA079Accident · No injuriesData collectionFinal reportPiper PA-14 · Talkeetna, AKA faulty fuel quantity indication in-flight, which precipitated a precautionary off-airport landing, and collision with a road sign.NTSB WPR10LA424Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA-5A · Lakeview, ORA partial loss of engine power during the initial climb due to a stuck exhaust valve.NTSB ERA10LA439Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tunkhannock, PAA total loss of engine power during the initial climb due to the pilots' inadequate in-flight fuel management.NTSB WPR10LA406Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Douglas, WYThe pilot's failure to maintain clearance from the terrain while maneuvering during an aerial observation flight.NTSB ERA10LA426Accident · Minor injuriesLimited investigationFinal reportCessna 172NA total loss of engine power for undetermined reasons.NTSB CEN10CA479Accident · No injuriesData collectionFinal reportBeech A23-19 · Wichita, KSThe pilot’s loss of airplane control while landing with a gusting wind.NTSB WPR10CA372Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Garberville, CAThe pilot’s improper airspeed, misjudged approach, and failure to attain the proper touchdown point. Contributing to the accident was the pilot’s lack of familiarity with the airport.NTSB ERA10FA414Accident · 2 fatalField investigationFinal reportCessna 172 · Orange, MAThe pilots did not maintain control of the airplane during a flight in dark night conditions due to spatial disorientation.NTSB WPR10LA393Accident · Minor injuriesLimited investigationFinal reportPiper PA18A · Billings, MTThe pilot's inadequate compensation for the wind conditions and failure to maintain lateral and directional control of the airplane during landing.NTSB ERA10CA411Accident · No injuriesData collectionFinal reportPiper PA28 · Marshfield, MAThe pilot's failure to maintain clearance from a vehicle while taxiing. Contributing to the accident was his inadequate visual lookout.NTSB WPR10CA392Accident · No injuriesData collectionFinal reportCessna 172P · San Jose, CAThe pilot’s improper flare and inadequate recovery from a bounced landing.NTSB ERA10CA406Accident · Minor injuriesData collectionFinal reportCessna 172 · Chattanooga, TNThe student pilot's improper execution of the go-around procedure.NTSB CEN10LA227Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Glenwood, NMThe pilot's decision to attempt a takeoff from an unimproved airstrip with a high density altitude.NTSB WPR10FA384Accident · Minor injuriesField investigationFinal reportCessna 172 · Roche Harbor, WAThe pilot’s failure to attain an adequate climb airspeed due to his use of flaps for takeoff, and his selection of a runway, which resulted in an uphill, and possibly downwind, takeoff and subsequent collision with a known obstacle. Contributing to the…NTSB CEN10CA473Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Watkins, COThe pilot's failure to maintain aircraft control during the landing, resulting in a ground-loop.NTSB ERA10LA395Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Blossvale, NYA total loss of engine power for undetermined reasons.NTSB CEN11CA018Accident · Minor injuriesData collectionFinal reportCessna 172M · Newton, KSThe pilot’s inadequate flare, which resulted in a hard landing.NTSB CEN10LA449Accident · No injuriesLimited investigationFinal reportCessna 172P · Santa Fe, NMA total loss of engine power following a loss of oil pressure for undetermined reasons.NTSB WPR10CA382Accident · No injuriesData collectionFinal reportBoeing PT-13B · Santa Rosa, CAThe failure of the pilot of another airplane to maintain clearance while taxiing.NTSB ERA10CA392Accident · No injuriesData collectionFinal reportCessna 172N · Elk Creek, VAThe student pilot’s continued visual flight into instrument meteorological conditions, which resulted in an off-airport landing.NTSB CEN10FA448Accident · 2 fatalField investigationFinal reportAmerican Champion Aircraft Cor 7GCBC · Midlothian, TXThe flight instructor’s incapacitation due to preexisting but unrecognized coronary disease, and the student pilot’s distraction and inability to recover the airplane from a stall/spin at low altitude.NTSB ERA10CA402Accident · No injuriesData collectionFinal reportCessna 172N · Perry, GAThe pilot's failure to maintain clearance from a pole while taxiing.NTSB ERA10CA381Accident · No injuriesData collectionFinal reportCessna 172N · Stonington, METhe pilot's failure to maintain directional control during a crosswind landing.NTSB ERA10LA377Accident · No injuriesLimited investigationFinal reportCessna 172N · Waynesboro, VAThe pilot's failure to follow the short-field takeoff procedures published in the Pilot's Operating Handbook.NTSB CEN10LA430Accident · 1 fatalLimited investigationFinal reportPiper PA-28-151 · Spearfish, SDThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB CEN10LA429Accident · 1 fatalLimited investigationFinal reportWarth Dennis J Classic Sport S-18 · Tea, SDA loss of engine power for undetermined reasons and the pilot's loss of airplane control, which led to an aerodynamic stall.NTSB ANC10CA063Accident · No injuriesData collectionFinal reportCessna 172P · New Stuyahok, AKThe pilot's selection of unsuitable terrain for takeoff, resulting in a collision with trees.NTSB CEN10LA403Accident · Minor injuriesLimited investigationFinal reportGrumman American Avn. AA-5 · Hutto, TXThe loss of engine power due to fuel starvation as a result of the pilot's failure to visually verify his fuel quantity prior to the flight.NTSB ANC10CA060Accident · No injuriesData collectionFinal reportCessna 172N · Palmer, AKThe pilot's decision to fly towards rising terrain that exceeded the climb capability of the airplane.NTSB CEN10CA405Accident · No injuriesData collectionFinal reportCessna 172K · Boyne City, MIThe pilot's failure to attain the proper touchdown point and delayed go-around.NTSB WPR10TA335Accident · No injuriesFinal reportPiper PA-18-150 · Dillon, MTThe pilot's failure to maintain directional control during landing.NTSB ERA10FA346Accident · 1 fatalField investigationFinal reportCessna 172P · Chesapeake, VAThe airplane's impact with terrain for undetermined reasons following the pilot's report of a flight control malfunction.