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 ANC07TA080Accident · No injuriesFinal reportPiper PA-18 · McGrath, AKThe pilot's failure to maintain control of the airplane during the landing roll. Contributing to the accident was rough and uneven terrain conditions.NTSB ATL07LA111Accident · 1 fatalLimited investigationFinal reportPiper PA-22-160 · Leonardtown, MDThe pilot's inadequate performance planning and failure to abort the takeoff.NTSB LAX07FA241Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · S. Lake Tahoe, CAThe pilot's inadequate preflight planning/decision, and his failure to maintain clearance from trees during takeoff-initial climb. Contributing to the accident were turbulence, downdrafts, and rising terrain.NTSB CHI07CA245Accident · No injuriesData collectionFinal reportCessna 172N · New Hudson, MIThe student pilot's improper flare, which resulted in a hard landing. An additional cause was the pilot's inadequate recovery from a bounced landing. Factors in the accident include the pilot's failure to maintain directional control during the landing roll…NTSB CHI07CA234Accident · No injuriesData collectionFinal reportBeech 23 · Georgetown, OHThe pilot's decision to land with a quartering tailwind and his failure to maintain directional control during landing, which resulted in a runway excursion and impact with a fence. Factors contributing to the accident were the quartering tailwind and the…NTSB NYC07LA177Accident · 1 fatalLimited investigationFinal reportBeech BE-23 · Science Hill, KYA loss of engine power for an undetermined reason.NTSB ATL07CA109Accident · No injuriesData collectionFinal reportCessna 172P · Newport, RIThe pilot's failure to maintain directional control during the landing roll.NTSB NYC07LA175Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Collegeville, PAThe pilot's inadequate recovery from a bounced landing.NTSB DEN07LA127Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Basin, WYThe carburetor icing causing a partial loss of engine power, and the pilot's failure to maintain aircraft control leading to the inadvertent stall. A factor contributing to the accident was the conditions conducive for carburetor icing.NTSB SEA07CA211Accident · No injuriesData collectionFinal reportArtic S-1B2 · McCall, IDThe pilot's failure to maintain airspeed during the landing flare resulting in a hard landing and subsequent failure to maintain directional control during the landing roll. The soft terrain condition adjacent to the runway was a factor.NTSB ATL07LA106Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Sussex, NJA loss of engine power for undetermined reasons.NTSB SEA07CA206Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Ontario, ORThe pilot's improper recovery from a bounced landing and failure to maintain directional control during landing.NTSB NYC07LA168Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · E.Stroudsburg, PAThe pilot's improper fuel management resulting in loss of engine power.NTSB DFW07CA163Accident · No injuriesData collectionFinal reportCessna 172M · Throckmorton, TXThe pilot's failure to maintain clearance from power transmission lines. A contributing factor was the prevailing dusk illumination.NTSB ATL07LA104Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Gardner, MAThe pilot's failure to maintain control of the airplane during an aborted landing.NTSB SEA07CA194Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Jordan, MTThe pilot's failure to maintain aircraft control during a go-around. Contributing factors were the pilot's selection of unsuitable terrain for landing and the rough/uneven terrain.NTSB NYC07LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Enterprise, ALThe designated examiner's improper decision to simulate an engine failure on short final approach, in conjunction with a short-field landing maneuver, and his inadequate remedial action. Contributing to the accident was the private pilot's inadvertent…NTSB ANC07LA064Accident · No injuriesLimited investigationFinal reportChampion 7GCB · King Salmon, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in the right main landing gear collapsing during takeoff. Factors contributing to the accident were rough/uneven terrain, and the collapse of the main landing gear.NTSB CHI07LA249Accident · No injuriesLimited investigationFinal reportCessna C-177 · Webster, WIThe loss of engine power for an undetermined reason, and the pilot's misjudged flare during the subsequent forced landing.NTSB LAX07CA201Accident · No injuriesData collectionFinal reportCessna 172K · Newcastle, UTThe pilot's inadequate compensation for the gusty and crosswind condition, and his failure to maintain control of the airplane during takeoff.NTSB ANC07LA060Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKA fracture and collapse of the main landing gear. Contributing to the accident was an inadequate annual inspection by other maintenance personnel, and corrosion.NTSB CHI07CA202Accident · No injuriesData collectionFinal reportCessna 172N · Yorkville, ILThe inadequate fuel consumption calculations by the pilot, the fuel exhaustion during cruise flight, and the unsuitable landing area encountered by the pilot. Contributing factors were the night light conditions and trees.NTSB ATL07CA099Accident · No injuriesData collectionFinal reportCessna 172P · Perry, GAThe student pilot's failure to maintain directional control on landing roll out resulting in the airplane departing the runway and collision with a ditch.NTSB ANC07LA056Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe malfunction of an engine magneto during cruise flight, which resulted in a partial loss of engine power, and an on-ground encounter with terrain. A factor associated with the accident was the high vegetation at the off-airport landing site.NTSB SEA07CA180Accident · No injuriesData collectionFinal reportRobinson R22 · Tucson, AZThe certified flight instructor's inadequate supervision of the practice autorotation. Contributing factors included the terrain drop off and the failure of the pilot undergoing instruction to maintain adequate rotor rpm.NTSB DEN07LA108Accident · 2 fatalLimited investigationFinal reportSchwarz RV-6A · Greeley, COthe pilot's failure to maintain airspeed resulting in an inadvertent stall and impact with terrain.NTSB NYC07LA148Accident · 2 fatalLimited investigationFinal reportSyracuse Vans RV-4 · Wallkill, NYThe pilot's improper decision to attempt low altitude aerobatics, and his failure to maintain airspeed during the aerobatics, which resulted in an inadvertent stall while maneuvering.NTSB CHI07LA177Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Rio Creek, WIThe pilot's improper aircraft weight and balance, and his failure to maintain sufficient airspeed to avoid a stall during takeoff-initial climb.NTSB ANC07LA055Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Nenana, AKThe pilot's failure to maintain directional control during landing, which resulted in a ground-loop and main landing gear collapse. Factors contributing to the accident were the ground-loop and landing gear collapse.NTSB CHI07LA179Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Columbia, ILThe certified flight instructor's (CFI's) inadequate preflight planning/preparation of a test altitude that would afford an on airport landing in the event of engine power loss. Additional causes were the CFI not flying a traffic pattern that would allow for…NTSB ATL07CA098Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Coats, NCThe CFI's failure to maintain a visual look out while taxiing resulting in an on ground collision with a hole on the grass runway and collapse of the right main landing gear.NTSB MIA07WA110Accident · No injuriesForeign investigationPiper PA-28-161 · Atlantic OceanNTSB DFW07LA130Accident · No injuriesLimited investigationFinal reportCessna 172K · Amarillo, TXThe failure of the left main landing gear spring assembly as a result of an unapproved repair by an unknown person(s), which resulted in a loss of directional control during the landing roll.NTSB ANC07LA045Accident · No injuriesLimited investigationFinal reportCessna 177 · Centreville, ALThe pilot's failure to refuel the airplane prior to fuel exhaustion, which resulted in a loss of engine power and substantial damage during a forced landing on a road.NTSB SEA07CA144Accident · No injuriesData collectionFinal reportBillings/Humbyrd Thorpe T-18 · Corona, CAA loss of engine power during the initial climb due to a fuel system malfunction. The pilot's incorrect maintenance modification to the fuel system and continued operation with known deficiencies were factors.NTSB ANC07CA042Accident · No injuriesData collectionFinal reportPiper PA-18 · Talkeetna, AKThe pilot's delay in aborting the landing, which resulted in an in-flight collision with trees.NTSB ANC07CA039Accident · Minor injuriesData collectionFinal reportPiper PA-18 · Fairbanks, AKThe pilot's failure to maintain altitude/clearance while maneuvering, which resulted in a collision with trees. A factor contributing to the accident was dusk lighting conditions.NTSB NYC07LA123Accident · Serious injuriesLimited investigationFinal reportDever Stits Playmate SA11A · Connellsville, PAThe pilot's inability to maintain control of the airplane due to an undetermined physiological impairment.NTSB DFW07CA115Accident · No injuriesData collectionFinal reportCessna 172P · Harrah, OKThe pilot's failure to compensate for the existing wind conditons while landing. A factor was the crosswind.NTSB MIA07CA099Accident · No injuriesData collectionFinal reportCessna 172K · Emporia, VAThe failure of the student pilot to maintain directional control of the airplane during the takeoff roll resulting in the on-ground collision with a ditch.NTSB LAX07CA166Accident · No injuriesData collectionFinal reportPiper J3C-65 · Quincy, CAThe pilot's excessive use of the brakes, which resulted in a nose over.NTSB CHI07FA140Accident · 3 fatalField investigationFinal reportCessna 172N · Sharonville, OHThe inadequate visual lookout of the pilots in both airplanes and their not maintaining clearance from each others airplane during climb.NTSB MIA07CA096Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Fairmont, WVThe pilot's failure to maintain directional control during landing.NTSB CHI07CA134Accident · Minor injuriesData collectionFinal reportCessna 172I · Shelby, OHThe pilot's failure to properly achieve the correct touch down point which resulted in a runway over run and subsequent nose over into a ditch. Other factors were the pilot's improper decision to land with a tailwind and the ditch.NTSB MIA07CA095Accident · Minor injuriesData collectionFinal reportCessna 172-M · Oxford, METhe student pilot's failure to maintain a climb during a go-around resulting in collision with an embankment.NTSB LAX07LA153Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Tucson, AZA loss of engine power while maneuvering due to a broken exhaust valve. Contributing to the accident was the rough terrain.NTSB CHI07CA132Accident · No injuriesData collectionFinal reportCessna 172P · Kenosha, WIThe pilot's improper recovery from a bounced landing, which resulted in a flat nose wheel tire and a buckled firewall. A factor was the porpoising that was encountered during the flare.NTSB MIA07CA093Accident · No injuriesData collectionFinal reportPiper J5A · Richmond, VAThe improper positioning of the elevator flight control surface by the pilot-in-command while taxiing with a tailwind, resulting in the airplane nosing over.NTSB NYC07CA111Accident · Minor injuriesData collectionFinal reportCessna 172S · Montgomery, NYThe pilot's improper flare while landing, which resulted in a loss of directional control and collision with terrain.NTSB SEA07CA122Accident · Serious injuriesData collectionFinal reportPiper PA-22 · Chiloquin, ORThe pilot's failure to maintain aircraft control during takeoff and initial climb. High vegetation was a factor.