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 DEN08CA020Accident · No injuriesData collectionFinal reportCessna 172N · Grand Junction, COthe pilot's improper flare resulting in a hard landing.NTSB DEN08CA019Accident · No injuriesData collectionFinal reportGrumman American AA-5 · Wheatland, WYThe pilot's improper decision to execute an off-airport landing on a dirt road. A contributing factor was the soft terrain.NTSB ANC08CA008Accident · No injuriesData collectionFinal reportPiper PA-18 · Anchorage, AKThe pilot's selection of an unsuitable landing area which resulted in an on ground encounter with terrain, and a nose over.NTSB LAX08CA015Accident · No injuriesData collectionFinal reportCessna 172N · Daggett, CAThe flight's encounter with a strong gusty wind condition.NTSB ANC08LA007Accident · No injuriesLimited investigationFinal reportCessna 172M · Rangeley, METhe pilot's failure to maintain aircraft control during the landing flare/touchdown. A factor contributing to the accident was the pilot's diverted attention.NTSB DFW08CA011Accident · No injuriesData collectionFinal reportCessna 172 · McAllen, TXThe pilot's failure to maintain airspeed during the landing approach resulting in an inadvertent stall.NTSB NYC08CA011Accident · No injuriesData collectionFinal reportSlagle Thorp T-18 · Franklin, KYThe pilot's failure to maintain control of the airplane during the landing.NTSB MIA08LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Hillsville, VAThe pilot's failure to maintain control of the airplane during a go-around.NTSB LAX08LA009Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Prescott, AZThe failure of maintenance personnel to detect fatigue cracks in the number 3 exhaust rocker arm, which lead to a partial loss of engine power.NTSB CHI08LA006Accident · 1 fatalLimited investigationFinal reportPiper PA-28-151 · Festus, MOThe pilot's inadequate aircraft preflight, fuel system water contamination and fuel starvation which resulted in a loss of engine power during landing approach. An additional cause was the emergency landing procedure not followed by the pilot following a loss…NTSB DFW08CA003Accident · Minor injuriesData collectionFinal reportCessna 172N · Oxford, MSThe pilots inadvertent stall during takeoff. A contributing factor was his failure to calculate the aircraft gross weight prior to the flight.NTSB MIA08LA002Accident · 1 fatalLimited investigationFinal reportBellanca 7GCAA · Toughkenamon, PAThe reason for this accident is undetermined.NTSB MIA08FA003Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Newton, GAThe failure of the right wing wooden spar due while the airplane was in cruise flight, due to the mechanic's inadequate annual inspection and his failure to comply with an airworthiness directive.NTSB LAX08FA002Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Oak Hills, CAThe pilot's continued flight into instrument meteorological conditions and failure to maintain terrain clearance during cruise flight. Contributing to the accident were mountainous terrain, dark night, and fog.NTSB DEN08CA002Accident · Minor injuriesData collectionFinal reportCessna 172N · Calhan, COThe student pilot's failure to maintain directional control during the takeoff roll.NTSB CHI08CA005Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Hot Springs, ARThe total loss of engine power due to inadequate fuel consumption calculations by the pilot resulting in fuel starvation while maneuvering over a lake at too low altitude for a safe landing. An additional cause was the unsuitable terrain encountered during…NTSB SEA08FA005Accident · 1 fatalField investigationFinal reportPiper PA-18 · Crowley Ranch, ORThe pilot's failure to maintain adequate clearance from a power transmission line while maneuvering. Contributing to this accident was the pilot's diverted attention, and decision to maneuver at a low altitude.NTSB SEA08CA004Accident · No injuriesData collectionFinal reportPiper PA 28-151 · Salt Lake City, UTThe leak at the fuel line fitting, which resulted in a fire during engine start.NTSB CHI08CA002Accident · No injuriesData collectionFinal reportPiper PA28-161 · Grand Forks, NDThe lack of experience and the excessive taxi speed by the pilot. A contributing factors was the airport sign.NTSB NYC07CA242Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Indiana, PAThe student pilot's failure to maintain directional control while landing.NTSB LAX07CA288Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Laurel, MTCorrosion and fatigue-induced failure of the landing gear structure.NTSB CHI07CA311Accident · Minor injuriesData collectionFinal reportGrumman American AA-5 Traveler · Warrenton, MOThe low airspeed gust factor by the pilot, the altitude/clearance not maintained by the pilot, and the inadequate compensation for wind conditions by the pilot during the landing approach. Contributing factors were the trees and wind gusts.NTSB SEA07CA273Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Chandler, AZThe pilot's inadequate compensation for wind conditions while landing, which resulted in an undershoot and an in-flight collision with terrain. Factors associated with the accident were the downdraft, the uneven terrain, and the flight instructor's delayed…NTSB MIA07LA155Accident · 1 fatalLimited investigationFinal reportGrumman AA-5A · Worthington, KYThe separation of the engine's No. 4 piston from the crankshaft for unidentified reasons and the pilot's continued operation with known equipment deficiencies.NTSB SEA07CA269Accident · Minor injuriesData collectionFinal reportRobinson R-22 Beta · Bend, ORProper descent rate not obtained/maintained during a pinnacle approach.NTSB NYC07CA235Accident · No injuriesData collectionFinal reportCessna 172 · Meriden, CTThe student pilot's inadequate recovery from a bounced landing.NTSB ANC07CA101Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Cooper Landing, AKThe pilot's failure to maintain altitude/clearance from objects, which resulted in an in-flight collision with trees during takeoff/initial climb. A factor contributing to the accident was the pilot's decision to takeoff into known adverse weather.NTSB SEA07CA265Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · Flagstaff, AZThe pilot's failure to attain an adequate airspeed, which resulted in a forced landing off the end of the runway. A contributing factor to the accident was the gusting wind.NTSB SEA07FA246Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Alsea, ORTerrain clearance was not maintained while maneuvering. A low altitude during the maneuver and hilly terrain were factors.NTSB LAX07CA279Accident · No injuriesData collectionFinal reportCessna 172L · Helena, MTunexpected collision with birds on short final that damaged the airplane wing structure.NTSB LAX07FA272Accident · 1 fatalField investigationFinal reportGrumman American AA-5 · Joshua Tree, CAThe pilot's failure to maintain terrain clearance during descent. Contributing to the accident were dark night conditions and mountainous terrain.NTSB CHI07CA296Accident · Minor injuriesData collectionFinal reportCessna 172 Skyhawk · Stockton, MOThe pilot's improper recovery from a bounced landing, her subsequent loss of control of the airplane, and the inadvertent stall.NTSB ANC07LA099Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tok, AKThe pilot's selection of an unsuitable takeoff area and failure to maintain clearance from trees during takeoff. Contributing to the accident were soft, muddy terrain conditions.NTSB MIA07CA144Accident · Minor injuriesData collectionFinal reportCessna 177 · Columbia, SCThe loss of engine power as a result of the fuel mixture cable failure for undetermined reasons.NTSB MIA07CA143Accident · Minor injuriesData collectionFinal reportCessna 172N · Carrabelle, FLThe improper flare by the pilot-in-command resulting in a hard landing.NTSB ATL07FA125Accident · 2 fatalField investigationFinal reportCessna 172M · Mansfield, MAThe pilot's improper use of wing flaps during takeoff, which resulted in reduced climb performance and a subsequent stall. Contributing to the accident was the exceedance of the airplane's maximum gross weight.NTSB NYC07FA217Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Syria, VAThe pilot's inadvertent flight into instrument meteorological conditions and his failure to maintain aircraft control. Contributing to the accident was the dark night conditions.NTSB SEA07LA251Accident · No injuriesLimited investigationFinal reportCessna 172M · Thompson, UTThe pilot's failure to maintain terrain clearance while maneuvering in a box canyon.NTSB CHI07CA294Accident · No injuriesData collectionFinal reportCessna 172M · Pontiac, MIThe pilot's misjudgment of the landing flare and her improper recovery from the bounced landing.NTSB ANC07TA093Accident · No injuriesFinal reportPiper PA-18-150 · Valdez, AKThe pilot's selection of unsuitable terrain for takeoff. A factor contributing to the accident was an inadvertent stall/mush.NTSB LAX07LA263Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Modesto, CAThe failure of the airplane's exhaust muffler during takeoff that was due to an inadequate annual inspection. Contributing to the accident were the pilot's inadequate inspection to isolate the smoke source, and the pilot's decision to continue flight with an…NTSB CHI07LA288Accident · 1 fatalLimited investigationFinal reportCessna 172M · Union Star, MOThe student pilot's failure to maintain adequate airspeed and the subsequent inadvertent stall while buzzing residences. Contributing to the accident was the pilot performing buzzing maneuvers.NTSB DEN07CA151Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Rawlins, WYthe pilot's failure to maintain directional control during landing. A contributing factor to the accident was the crosswind.NTSB ATL07CA132Accident · No injuriesData collectionFinal reportCessna C172N · Manassas, VAThe student pilot's failure to correct for a pilot-induced oscillation/porpoise, during flare/touchdown, which resulted in a hard landing.NTSB ANC07LA090Accident · No injuriesLimited investigationFinal reportCessna 150G · Kenai, AKThe pilot's excessive flap setting during takeoff.NTSB ATL07CA117Accident · Minor injuriesData collectionFinal reportCessna 172K · Charlotte, NCThe pilot's failure to maintain directional control while landing.NTSB NYC07CA195Accident · No injuriesData collectionFinal reportCessna 172L · Winston-Salem, NCThe pilot's improper recovery from a bounced landing.NTSB NYC07FA193Accident · 2 fatalField investigationFinal reportCessna 172N · Rochester, NYThe pilot's failuire to maitain adequate airspeed during a turning maneuver which resulted in an inadvertent stall.NTSB ATL07CA118Accident · No injuriesData collectionFinal reportPiper PA28-140 · Front Royal, VAThe pilot's improper recovery from a bounced landing.NTSB CHI07LA266Accident · No injuriesLimited investigationFinal reportCessna 172M · Marine City, MIA loss of engine power for undetermined reasons. Factors contributing to the accident were the insufficient runway remaining and the soft terrain.