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 WPR12CA343Accident · Minor injuriesData collectionFinal reportPiper PA-22-160 · White City, ORThe student pilot's attempt to keep the airplane airborne and continue the takeoff after the airplane bounced off the turf runway prematurely during the takeoff roll.NTSB WPR12CA342Accident · Serious injuriesData collectionFinal reportPiper PA18 · McNeal, AZThe pilot's in-flight decision to fly at low level into an unfamiliar canyon, which resulted in an off-airport landing when the airplane's climb capability was exceeded. Contributing to the accident was the airplane’s decreased performance due to the high…NTSB WPR12CA340Accident · Minor injuriesData collectionFinal reportPiper PA-22-160 · McKinleyville, CAThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident were the pilot’s lack of experience in the accident airplane make and model and his lack of knowledge regarding the fuel system.NTSB CEN12LA522Accident · No injuriesLimited investigationFinal reportPiper PA18 · Peyton, COThe pilot's failure to maintain airplane control during taxi in gusting wind conditions.NTSB WPR12CA336Accident · No injuriesData collectionFinal reportPiper PA28-150 · Yellow Pine, IDThe pilot's failure to attain and maintain an appropriate glide path, failure to perform a go-around, and failure to maintain directional control during the landing roll.NTSB CEN12LA488Accident · 1 fatalLimited investigationFinal reportJoseph C. Andrews, Jr. Vans · Valentine, NEThe RV-6 pilot's failure to monitor the location of the RV-4, resulting in the on-ground collision. Contributing to the accident was the RV-6 pilot not ensuring proper separation from the RV-4 and his expectation that the pilot of RV-4 would roll out to the…NTSB ERA12LA482Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Green Creek, NJThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel starvation while maneuvering.NTSB ERA12FA483Accident · 1 fatalField investigationFinal reportCessna 172P · Plainville, CTThe pilot's failure to maintain the proper glidepath during final approach in visual meteorological conditions, resulting in collision with a berm.NTSB WPR12CA345Accident · No injuriesData collectionFinal reportCessna 172N · Ashland, ORThe student pilot's improper flare, which resulted in a hard landing.NTSB ERA12FA484Accident · 1 fatalField investigationFinal reportCessna 172M · San Juan, PRMaintenance personnel’s improper lubrication of the right direct aileron control cable and failure to detect the severe corrosion of the cable during a maintenance inspection, which resulted in the in-flight failure of the cable, the pilot’s subsequent…NTSB ERA12CA481Accident · No injuriesData collectionFinal reportCessna 172M · Hammond, NYThe pilot’s failure to maintain directional control of the airplane while landing in gusting wind conditions.NTSB CEN12LA471Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Augusta, KSThe loss of brake effectiveness on landing roll for reasons that could not be determined because a postaccident brake system examination did not reveal any anomalies, which resulted in a runway excursion.NTSB ERA12FA467Accident · 1 fatalField investigationFinal reportBrenholt Larry R RV-4 · Cedartown, GAThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions and his failure to maintain airspeed while maneuvering for a forced landing, which resulted in an aerodynamic stall and collision with terrain.NTSB ANC12CA078Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Talkeetna, AKThe flight instructor's and student pilot's excessive application of brakes during an aborted takeoff, which resulted in a noseover.NTSB ERA12LA468Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · North Myrtle Beach, SCA total loss of engine power due to carburetor icing.NTSB ERA12CA466Accident · No injuriesData collectionFinal reportCessna 172P · St. Augustine, FLUndetermined due to a lack of information about when the damage to the airplane occurred.NTSB ANC12CA076Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Whittier, AKThe pilot's failure to maintain clearance from brush during landing, which resulted in a loss of control.NTSB WPR12LA306Accident · No injuriesLimited investigationFinal reportCessna 172N · Rockford, IDA partial loss of engine power during cruise flight due to the failure of the No. 3 cylinder exhaust valve for reasons that could not be determined due to the damage to the valve head and the missing valve stem. Contributing to the accident was the flight…NTSB ERA12LA456Accident · Serious injuriesLimited investigationFinal reportSeibert Robert M Seibert RV-6 · Ridgeland, SCThe pilot's inadvertent use of the wheel brakes during touchdown and his failure to maintain directional control. Contributing to the accident was the flight instructor's delayed remedial action.NTSB ERA12LA453Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · North Myrtle Beach, SCThe pilot's inadequate use of carburetor heat during cruise flight, which resulted in a partial loss of engine power and subsequent forced landing.NTSB CEN12CA454Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Jenks, OKThe pilot's failure to achieve a proper touchdown point during landing, which resulted in a runway overrun and impact with obstructions.NTSB ERA12LA442Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Pensacola, FLA partial loss of engine power during initial climb for reasons that could not be determined because examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB ANC12CA074Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Tynoek, AKThe pilot's failure to maintain sufficient airspeed during the initial climb after takeoff, which resulted in an aerodynamic stall.NTSB CEN12LA508Accident · Serious injuriesLimited investigationFinal reportCessna 172M · South Wayne, WIInternal engine component failures, which resulted from oil starvation due to debris in the oil system.NTSB CEN12LA424Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCAA · Bedford, INThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s self-induced pressure to return home.NTSB CEN12CA419Accident · No injuriesData collectionFinal reportGrumman American AA-5A · Ray Township, MIThe airplane’s collision with a deer that ran in front of the airplane during the landing roll.NTSB ANC12CA071Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Fairbanks, AKThe pilot's excessive use of brakes during landing, which resulted in a noseover.NTSB ANC12CA069Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Skwentna, AKThe pilot's selection of an unsuitable off-airport landing site, which resulted in a loss of control during the landing roll.NTSB CEN12CA422Accident · No injuriesData collectionFinal reportCessna 172K · Greers Ferry, ARThe pilot’s failure to maintain a positive rate of climb while taking off with a high density altitude.NTSB ANC12CA065Accident · No injuriesData collectionFinal reportPiper PA-22-160 · McGrath, AKThe pilot’s decision to load the airplane in excess of its takeoff capability given the runway conditions, which resulting in a collision with terrain during the initial climb.NTSB CEN12LA408Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Griswold, IAThe pilot’s failure to maintain adequate airspeed during an attempted go-around, resulting in an aerodynamic stall.NTSB CEN12LA401Accident · Serious injuriesLimited investigationFinal reportPiper PA-23 · Baltic, OHLoss of engine power due to fuel starvation as a result of particulate contaminant on the carburetor screens.NTSB ERA12CA420Accident · No injuriesData collectionFinal reportCessna 172M · Smyrna, TNThe pilot’s inadequate flare and improper recovery from a bounced landing, which resulted in a hard landing.NTSB CEN12FA395Accident · 1 fatalField investigationFinal reportNappi Tito C Lancair 235M · Monroe Center, ILThe in-flight fire for a reason that could not be determined due to extensive damage from the fire.NTSB ERA12CA414Accident · No injuriesData collectionFinal reportCessna 177 · West Milford, NJThe pilot's improper full flap retraction while performing a go-around maneuver, which resulted in a loss of airplane control.NTSB ANC12CA057Accident · No injuriesData collectionFinal reportChampion 7GCB · Tyonek, AKThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall while maneuvering.NTSB ANC12CA053Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Skwentna, AKThe pilot’s selection of unsuitable terrain for taxi.NTSB ERA12CA416Accident · No injuriesData collectionFinal reportCessna 172M · Churchville, MDThe tractor operator's failure to confirm the landing airplane's position before entering an active runway, which resulted in a ground collision.NTSB ERA12CA404Accident · No injuriesData collectionFinal reportCessna 172K · Tupelo, MSThe pilot's improper recovery from a bounced landing.NTSB ERA12LA399Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Mariner · Oak Island, NCThe pilot's failure to properly execute the helicopter practice autorotation recovery, which resulted in a collision with the water.NTSB WPR12CA209Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Sula, MTThe pilot's inability to maintain clearance from terrain while operating in a downdraft over mountainous terrain.NTSB WPR12CA260Accident · No injuriesData collectionFinal reportCessna 172P · Hemet, CAThe student pilot's failure to monitor and maintain clearance from an obstacle during taxi.NTSB ERA12RA367Accident · 2 fatalForeign investigationBeech V35B · Sumerduck, VAOn May 28, 2012, about 1604 eastern daylight time, a Beech V35B, N6658R, and a Piper PA-28-140, N23SC, collided in flight in the vicinity of Sumerduck, Virginia. The Beech was destroyed, and the pilot and flight instructor were fatally injured; the Piper was…NTSB WPR12LA227Accident · No injuriesLimited investigationFinal reportCessna 150F · San Diego, CAA total loss of engine power while maneuvering for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN12LA332Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Greenfield, INA partial loss of engine power for undetermined reasons during takeoff.NTSB CEN12CA315Accident · Minor injuriesData collectionFinal reportCessna 172N · Wichita, KSThe student pilot’s failure to maintain airplane control during landing and the flight instructor’s delayed remedial action, which resulted in a collision with terrain.NTSB ERA12LA355Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Melbourne, FLThe failure of the pilot of another airplane to set the parking brake and to maintain a proper visual lookout, which resulted in an on-ground collision.NTSB ERA12CA350Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Norwich, NYThe pilot's inability to maintain directional control during a landing with a deflated left main landing gear tire.NTSB CEN12LA304Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · El Dorado, KSThe pilot's loss of directional control during landing, which resulted in a runway excursion.NTSB ANC12CA039Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Talkeetna, AKThe pilot's failure to maintain directional control of the tailwheel-equipped airplane during landing, which resulted in a ground loop. Contributing to the accident was the flight instructor's failure to adequately monitor the landing.