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 CEN12CA294Accident · Serious injuriesData collectionFinal reportBeckert Bruce A RV-6 · Au Gres, MIThe pilot’s low altitude maneuvering, which resulted in an inadvertent stall and subsequent impact with the water.NTSB ANC12CA037Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Gakona, AKThe pilot’s decision to take off in variable wind conditions, which resulted in a loss of control and the airplane striking an object after takeoff.NTSB CEN12CA285Accident · Minor injuriesData collectionFinal reportChampion 7GCBC · Genoa, NEThe pilot’s loss of directional control of the airplane during an aborted landing. Contributing to the accident was the pilot’s improper flare.NTSB WPR12LA198Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Hanksville, UTThe pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude in high density altitude conditions, which resulted in the airplane’s inability to climb or maintain clearance from terrain.NTSB WPR12CA204Accident · No injuriesData collectionFinal reportCessna 172P · Spokane, WAThe student pilot's improper landing flare and inadequate recovery from a bounced landing.NTSB WPR12LA195Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Kailua-Kona, HIA loss of engine power while maneuvering for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN12CA278Accident · No injuriesData collectionFinal reportGalloway/Ward RV-4 · Redwood Falls, MNThe pilot’s failure to maintain control of the airplane during takeoff in gusty wind conditions.NTSB CEN12CA270Accident · No injuriesData collectionFinal reportCessna 172M · Three Rivers, MICollision with a deer during the takeoff roll.NTSB ERA12LA312Accident · Minor injuriesLimited investigationFinal reportShoup Ronald R RV-6A · Milton, FLA loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB ANC12CA034Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Palmer, AKThe student pilot did not maintain sufficient airspeed during a steep turn after takeoff, which resulted in an aerodynamic stall.NTSB ERA12CA311Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Eaton, NYThe pilot's improper approach to landing, which resulted in the airplane touching down short of the runway.NTSB ERA12CA310Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Burlington, NCThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.NTSB ERA12LA314Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lake Wales, FLThe student pilot’s decision to depart from an intersection with insufficient runway remaining for takeoff, which resulted in a rejected takeoff and subsequent runway excursion.NTSB ANC12TA035Accident · No injuriesFinal reportPiper PA-18-150 · Paxon, AKA separation of the right main landing gear suspension strut assembly due to overstress, which resulted in the collapse of the main landing gear while landing.NTSB WPR12CA187Accident · No injuriesData collectionFinal reportGlass Roy L RV-6 · Coolidge, AZThe pilot’s loss of directional control during landing.NTSB ANC12CA030Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Fairbanks, AKThe pilot’s loss of directional control during landing. Contributing to the accident was the pilot's decision not to initiate a go-around.NTSB WPR12LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · San Manuel, AZThe pilot’s failure to maintain directional control during the takeoff, which resulted in a runway excursion.NTSB WPR12LA174Accident · No injuriesLimited investigationFinal reportWillerton Vans RV6A · Sequim, WAThe pilot's inadequate landing flare, which resulted in a hard landing.NTSB ERA12CA276Accident · Minor injuriesData collectionFinal reportPiper PA-28-151 · Iuka, MSThe pilot's improper preflight planning and inflight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA12CA270Accident · No injuriesData collectionFinal reportCessna 172M · Pottstown, PAThe pilot’s inadequate recovery from a bounced landing, which resulted in a loss of control.NTSB CEN12LA230Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Isabel, SDThe partial loss of engine power due to carburetor ice.NTSB ANC12FA028Accident · 2 fatalField investigationFinal reportPiper PA-18 · Sleetmute, AKOperation of the airplane by a non-certificated pilot and his failure to maintain adequate airspeed and airplane control, which resulted in an aerodynamic stall.NTSB CEN12CA207Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Crowley, LAThe student pilot's improper landing flare, which resulted in a nose-over.NTSB ERA12LA259Accident · No injuriesLimited investigationFinal reportCessna 172P · Brooksville, FLThe pilot's improper landing flare, which resulted in a hard landing.NTSB CEN12CA200Accident · Minor injuriesData collectionFinal reportCessna 172P · Colorado Springs, COThe pilot did not maintain control of the airplane during takeoff, which resulted in a hard landing and subsequent nose over.NTSB WPR12CA142Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Jean, NVThe student pilot did not maintain directional control during the landing roll.NTSB CEN12LA197Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Pinconning, MIThe pilot's failure to properly align his airplane with the runway during final approach. Contributing to the accident was the sunglare that obscured the pilot's view of the runway.NTSB ERA12LA241Accident · No injuriesLimited investigationFinal reportCessna 172K · Belfast, METhe flight instructor’s failure to ensure the radio was set correctly to activate the pilot-controlled lighting, which resulted in poor positioning for a proper landing and a subsequent off-runway forced landing during an attempted go-around. Contributing to…NTSB CEN12LA195Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Indianapolis, INThe student pilot did not maintain directional control while practicing a soft-field takeoff.NTSB CEN12FA188Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Mexico, MOThe pilot’s failure to maintain airplane control during takeoff, which resulted in an aerodynamic stall and subsequent collision with trees. Contributing to the accident was the pilot’s inadequate preflight performance planning before departing on the soft,…NTSB ERA12LA234Accident · No injuriesLimited investigationFinal reportCessna 172K · Pensacola, FLA total loss of engine power due to the improper installation of the crankshaft gear bolt or lockplate by maintenance personnel. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB ERA12CA228Accident · Minor injuriesData collectionFinal reportPiper PA-28-151 · Charleston, SCThe pilot's improper landing flare, which resulted in a hard landing.NTSB ERA12CA222Accident · Minor injuriesData collectionFinal reportCessna 172N · Orleans, VTThe pilot’s failure to maintain clearance from a power line while conducting low-altitude flight.NTSB WPR12CA117Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Randle, WAThe pilot exceeded the helicopter's performance, resulting in low rotor rpm and settling.NTSB CEN12CA183Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Fort Collins, COThe pilot did not maintain adequate airspeed and airplane control during the go-around, which resulted in the airplane impacting trees.NTSB WPR12FA123Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Brockton, MTThe pilot’s failure to maintain adequate airspeed and airplane control while maneuvering at a low altitude, which resulted in a stall and subsequent impact with terrain.NTSB CEN12LA182Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · East Troy, WIThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN12LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Rapid City, SDThe loss of engine power during climb due to carburetor icing. Contributing to the accident was the limited travel of the carburetor heat valve which prevented application of maximum carburetor heat.NTSB ERA12CA211Accident · No injuriesData collectionFinal reportCessna 172M · Mayaquez, PRThe pilot did not maintain control of the airplane while landing in crosswind conditions.NTSB ERA12LA191Accident · No injuriesLimited investigationFinal reportCessna 172N · Flat Rock, VAThe partial loss of engine power due to the failure of the exhaust valve spring seat for reasons that could not be determined.NTSB CEN12FA154Accident · 1 fatalField investigationFinal reportCessna 172N · Floresville, TXThe medical incapacitation of the pilot due to a sudden cardiac arrhythmia or acute myocardial infarction.NTSB ANC12CA022Accident · No injuriesData collectionFinal reportCessna 172I · McCarthy, AKThe pilot lost directional control during landing.NTSB WPR12LA099Accident · No injuriesLimited investigationFinal reportCessna 172M · Cusick, WAA total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA12CA172Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Greenville, SCThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.NTSB WPR12LA093Accident · 1 fatalLimited investigationFinal reportCessna 172N · Fresno, CAThe non-certificated pilot’s failure to maintain clearance from power lines. Contributing to the accident was the pilot’s impairment due to performance-impairing drugs.NTSB ERA12CA162Accident · No injuriesData collectionFinal reportCessna 172L · Grand Isle, VTThe pilot's inability to stop the airplane on a grass runway with undetected ice.NTSB CEN12LA192Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Seguin, TXA loss of engine power for undetermined reasons.NTSB WPR12LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Chehalis, WAThe pilot did not correctly manage his glide profile during a simulated engine-out forced landing. Contributing to the accident was the pilot's decision not to add additional engine power, which resulted in a runway undershoot.NTSB WPR12CA079Accident · No injuriesData collectionFinal reportCessna 172M · Richland, WAThe student pilot's improper landing flare and inadequate directional control during landing.NTSB ERA12LA148Accident · No injuriesLimited investigationFinal reportCessna 172I · Springfield, TNThe pilot did not apply carburetor heat during approach to landing, which resulted in a total loss of engine power due to carburetor icing.