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 WPR21LA192Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Lewiston, IDThe pilot's failure to maintain directional control during taxiing in crosswind conditions, which resulted in a taxiway excursion and collision with a fence.NTSB CEN21LA208Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 23 · Hutchinson, KSThe pilot’s failure to abort the takeoff and his high pitch attitude after takeoff, which resulted in an exceedance of the critical angle of attack and a subsequent aerodynamic stall.NTSB ERA21LA205Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Columbia, KYThe pilot’s failure to obtain a proper touchdown point on the runway, which resulted in a runway excursion.NTSB ERA21LA213Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-161 · Okeechobee, FLA total loss of engine power for reasons that could not be determined based on available information.NTSB ERA21LA198Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Fredericksburg, VAThe student pilot reported that, during the landing roll, he applied brakes and the airplane veered right. He was unable to correct back to the centerline or brake effectively; the airplane exited the runway and struck an embankment before coming to rest. The…NTSB WPR21LA168Accident · No injuriesClass 4 · LimitedFinal reportDavis Donald M Bushby Mustang II · Maricopa, AZThe pilot’s failure to maintain airplane control during takeoff with a quartering right tailwind.NTSB WPR21LA163Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Wilsall, MTThe pilot's failure to maintain directional control during the landing roll with a crosswind.NTSB ERA21LA352Accident · No injuriesClass 4 · LimitedFinal reportHine T L/Johnson R Bush Wacker · Thomaston, GAA loss of directional control upon landing for reasons that could not be determined as a result of a delayed report. Contributing was the pilot’s decision to continue a flight with an unknown airworthiness issue.NTSB WPR21LA160Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Cottonwood, AZThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB WPR21LA157Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Bellingham, WAThe student pilot’s inadequate flare resulting in a loss of control during landing with a crosswind and subsequent nose over.NTSB ERA21LA183Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Weyers Cave, VAMaintenance personnel’s inadequate inspection of the rudder control system, which resulted in failure of the rudder control assembly and the pilot’s loss of control during a go-around.NTSB ERA21LA177Accident · No injuriesClass 3 · LimitedFinal reportForisch Edward Bushby Mustang M II · Worcester, MABinding of the left aileron bellcrank push/pull rod, which resulted in an uncommanded right turn.NTSB CEN21LA175Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Augusta, KSInadequate maintenance at the time the carburetor was replaced, which resulted in the improperly installed throttle cable and a partial loss of engine power. Contributing to the accident was an inadequate annual inspection that failed to detect the improper…NTSB ERA21LA168Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Crystal River, FLThe student pilot’s inadequate compensation for a crosswind during landing, which resulted in a loss of directional control and a runway excursion.NTSB WPR21LA151Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Yacolt, WAA partial loss of power caused by carbon build up in the cylinders, which prevented the exhaust valves from seating properly. Contributing to the accident was flying in moderate icing conditions which resulted in reduced aircraft performance and vibrations.NTSB ANC21FA028Accident · Minor injuriesClass 3 · FieldFinal reportPiper PA-18A · Anchorage, AKA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR21LA139Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Twin Falls, IDThe pilot’s failure to maintain airplane control during initial climb with a crosswind when the airspeed decreased, the airplane exceeded its critical angle of attack and aerodynamical stalled at too low an altitude for the pilot to recover before the…NTSB WPR21LA137Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Three Forks, MTThe pilot’s improper landing flare, which resulted in a loss of directional control, runway excursion and impact with terrain.NTSB CEN21LA159Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Erie, COThe pilot’s failure to maintain directional control during a full-stop landing, resulting in a runway excursion and impact with a snow berm.NTSB WPR21LA136Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Myrtle Creek, ORThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in a runway excursion and impact with terrain.NTSB ERA21LA175Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Fort Pierce, FLThe flight instructor’s delayed remedial action and failure to maintain directional control during a crosswind landing, which resulted in a runway excursion.NTSB GAA21WA040Accident · 2 fatalClass 4 · ForeignPiper PA-28-161 · Acklin, BahamasNTSB ERA21LA149Accident · No injuriesClass 4 · LimitedFinal reportBeech 23 · Rogersville, TNThe pilot's improper landing flare, which resulted in an initial hard landing, separation of the left main landing gear, and a runway excursion during a subsequent landing attempt.NTSB CEN21LA147Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-23 · Oshkosh, WIThe failure of the nose landing gear lower drag link for reasons that could not be determined based on available information, which resulted in the collapse of the nose landing gear.NTSB ERA21LA144Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Boynton Beach, FLA total loss of engine power for undetermined reasons.NTSB ERA21LA141Accident · 1 fatalClass 3 · LimitedFinal reportSteinman Mark E Lancair 320 · Atlantic Ocean (Atlantic Ocean)The airplane’s impact with water for reasons that could not be determined.NTSB GAA21WA027Accident · 3 fatalClass 5 · ForeignPiper PA-28-140 · Ilopango, El SalvadorNTSB CEN21LA127Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Prairie du Sac, WIThe student pilot’s loss of directional control during takeoff, which resulted in the collision with a snowbank. Contributing to the accident was the compacted snow conditions on the runway surface.NTSB WPR21LA112Accident · No injuriesClass 4 · LimitedFinal reportMaule M-5-180C · Price, UTThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in a ground loop, runway excursion and collision with terrain.NTSB CEN21LA119Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Silt, COThe pilot’s failure to avoid powerlines while flying at low altitude.NTSB CEN21LA120Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Clare, MIThe pilot’s failure to maintain directional control during landing that resulted in a runway excursion and impact with terrain.NTSB ERA21LA111Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-28-161 · Boynton Beach, FLThe pilot’s controlled flight into the ocean at night due to his unrecognized spatial disorientation. Contributing to the accident was the pilot’s distraction with the tuning of his transponder while maneuvering over an area with reduced visual references.NTSB ANC21LA012Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-14 · Anchorage, AKThe instructor pilot’s selection of an unsuitable snow-covered runway for landing practice, and the pilot under instruction’s failure to maintain directional control during a landing roll, which resulted in a loss of control in unpacked snow and a subsequent…NTSB ERA21LA164Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Miami, FLThe pilot’s failure to maintain control of the airplane during takeoff, which resulted in an aerodynamic stall and impact with terrain. Also causal was the flight instructor’s inadequate remedial action.NTSB ERA21LA106Accident · No injuriesClass 3 · LimitedFinal reportAmerican AA5 · Leesburg, VAThe weakened structure of the left horizontal stabilizer, which resulted in elevator flutter and subsequent partial separation of the left elevator in flight. Contributing to the accident were the lack of elevator authority while landing due to the damaged…NTSB ERA21LA088Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Cleveland, GAA total loss of engine power due to carburetor icing.NTSB ERA21LA090Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Locust Grove, GAThe pilot’s improper recovery from a bounced landing, which resulted in a loss of directional control and subsequent runway excursion.NTSB CEN21LA099Accident · No injuriesClass 4 · LimitedFinal reportCessna 150K · Peyton, COThe student pilot did not maintain directional control of the airplane while landing. Contributing to the accident was the pilot’s diverted attention to the incorrect flap setting.NTSB ERA21LA081Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Tampa, FLA total loss of engine power due to the student pilot inadvertently moving the fuel selector to the OFF position.NTSB WPR21LA069Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · San Diego, CAA partial loss of engine power due to the fatigue fracture of the No. 3 exhaust valve rocker arm stud.NTSB ERA21LA079Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Nantucket, MAThe pilot's failure to maintain adequate clearance from obstacles during the attempted go around following an approach to landing in sun glare.NTSB ERA21LA074Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Dexter, METhe pilot’s loss of directional control while landing, which resulted in an encounter with snow and subsequent nose over.NTSB WPR21LA067Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Dillon, MTThe student pilot’s exceedance of the airplane’s critical angle attack during an attempted go-around, which resulted in an aerodynamic stall.NTSB WPR21LA080Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Palm Springs, CAThe student pilot’s failure to maintain aircraft control during an attempted go-around, which resulted in an exceedance of the airplane’s critical angle of attack, aerodynamic stall, and subsequent impact with terrain.NTSB ERA21LA061Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Bellefonte, PAThe pilot's failure to maintain directional control while landing, which resulted in a runway excursion.NTSB CEN21LA068Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · French Lick, INThe pilot’s improper in-flight decision making which resulted in a total loss of engine power due to fuel starvation.NTSB ERA21LA055Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Manville, NJThe pilot’s failure to maintain a proper glidepath while on approach to the runway, and the flight instructor’s delayed remedial action, which resulted in the airplane colliding with a tree on final approach.NTSB CEN21LA087Accident · No injuriesClass 4 · LimitedFinal reportPiper PA12 · Gilliam, LAThe non-instrument rated pilot’s encounter with poor weather conditions resulting in his performing a precautionary landing to a cornfield and subsequently nosing over.NTSB ERA21LA050Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Cynthiana, KYThe pilot’s failure to maintain proper glide path during a visual approach that was conducted at night, resulting in a collision with trees and terrain.NTSB ERA21LA045Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Manville, NJThe pilot's failure to maintain directional control while landing in a gusty crosswind, which resulted in a runway excursion and noseover.