NTSB investigations: Lycoming 0-320 series

514 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the defining event was Loss of control on ground. 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')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '230'))
  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.

NTSB WPR24LA095Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Casper, WYThe pilot’s failure to maintain directional control while taxiing with a crosswind.Feb 26, 2024 · N739UE · Substantial damageNTSB CEN24LA123Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Clarion, IAThe pilot’s failure to maintain directional control during the landing flare in a crosswind with gusts.Feb 26, 2024 · N35719 · Substantial damageNTSB WPR24LA089Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Madera, CAThe pilot’s failure to maintain directional control during landing.Feb 11, 2024 · N737LU · Substantial damageNTSB WPR24LA078Accident · No injuriesClass 3 · LimitedFinal reportCessna 172L · Grass Valley, CALoss of control during the landing roll due to a malfunctioning brake for undetermined reasons.Jan 18, 2024 · N7250Q · Substantial damageNTSB CEN24LA082Accident · No injuriesClass 3 · LimitedFinal reportCessna 172N · Middleton, WIThe student pilot’s failure to maintain directional control during the takeoff roll.Jan 4, 2024 · N3477E · Substantial damageNTSB CEN24LA071Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Stephenville, TXThe pilot’s failure to maintain directional control during landing that resulted in an impact with terrain.Dec 17, 2023 · N4501E · Substantial damageNTSB CEN24LA001Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 23 · Waupaca, WIThe pilot’s failure to maintain directional control during the go-around, that resulted in a runway excursion and an impact with terrain.Oct 1, 2023 · N1963F · Substantial damageNTSB ERA23LA375Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Winston-Salem, NCThe pilot’s loss of directional control upon landing which resulted in substantial damage to the left wing and left horizontal stabilizer.Sep 18, 2023 · N1451U · Substantial damageNTSB ANC23LA083Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · McGrath, AKThe pilot’s failure to maintain directional control during after encountering a wind gust during landing that resulted in an impact with terrain.Sep 16, 2023 · N1755P · Substantial damageNTSB WPR23LA355Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 7GCBC · Woodland, CAThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground loop.Sep 7, 2023 · N234RA · Substantial damageNTSB CEN23LA400Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Eden Prairie, MNThe pilot’s failure to maintain directional control during a landing with a left crosswind.Sep 3, 2023 · N5254D · Substantial damageNTSB ANC23LA072Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Palmer, AKThe pilot’s failure to maintain directional control during the landing rollout.Aug 17, 2023 · N5061G · Substantial damageNTSB WPR23LA312Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Dixon, CAThe pilot’s loss of directional control after striking an unidentified object during landing on an unimproved runway, and his subsequent use of excessive braking that resulted in a nose-over.Aug 9, 2023 · N50443 · Substantial damageNTSB ERA23LA282Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Kennesaw, GAThe student pilot’s loss of directional control while landing, which resulted in a runway excursion and collision with an airport sign.Jul 2, 2023 · N734YD · Substantial damageNTSB ANC23LA039Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot’s failure to maintain directional control during landing with a quartering tailwind, which resulted in a water loop and impact with terrain.May 29, 2023 · N4488Z · Substantial damageNTSB ANC23LA035Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Anchorage, AKThe pilot's excessive braking during the landing roll, resulting in a nose over.May 17, 2023 · N7741D · Substantial damageNTSB CEN23FA183Incident · 1 fatalClass 3 · FieldFinal reportRobinson R22 Beta · Brady, TXThe non-certificated pilot’s failure to ensure the collective friction control was adequately engaged during an on-ground engine run, which resulted in the helicopter inadvertently becoming airborne. Contributing to the crash were the pilot’s various physical…May 14, 2023 · N40506 · Substantial damageNTSB ERA23LA227Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5A · Knoxville, TNThe pilot’s failure to maintain directional control during takeoff in gusting wind conditions.May 4, 2023 · N26941 · Substantial damageNTSB CEN23LA176Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Nacogdoches, TXThe student pilot’s failure to maintain directional control during the landing roll.Apr 28, 2023 · N52602 · Substantial damageNTSB WPR23LA155Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · North Las Vegas, NVThe pilot's failure to maintain directional control of the airplane during the landing roll resulting in collision with taxiway sign.Apr 15, 2023 · N734NJ · Substantial damageNTSB CEN23LA154Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Terrell, TXThe student pilot’s failure to maintain directional control during landing and the flight instructor’s delayed remedial response.Apr 11, 2023 · N1221U · Substantial damageNTSB ERA23LA186Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · White Plains, NYThe pilot's failure to maintain directional control during the landing rollout in gusting wind, which resulted in a runway excursion and subsequent nose over.Apr 3, 2023 · N8500D · Substantial damageNTSB ERA23LA178Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Canton, GAThe pilot’s failure to maintain directional control following a bounced landing, which resulted in a runway excursion and a nose over.Apr 2, 2023 · N6301W · Substantial damageNTSB CEN23LA141Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Maple Lake, MNThe student pilot’s failure to maintain directional control during landing with a gusting crosswind.Mar 19, 2023 · N9088D · Substantial damageNTSB WPR23LA124Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Van Nuys, CAThe pilots failure to maintain directional control during takeoff.Mar 10, 2023 · N73726 · Substantial damageNTSB WPR23LA114Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Ephraim, UTThe pilot’s improper landing flare and loss of directional control.Feb 24, 2023 · N84717 · Substantial damageNTSB CEN23LA111Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Moline, ILThe student pilot’s failure to maintain directional control during the landing roll in gusting crosswind conditions.Feb 19, 2023 · N84688 · Substantial damageNTSB WPR23LA119Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Fullerton, CAThe student pilot's failure to maintain control of the airplane during the landing roll and the flight instructor’s delayed remedial action, which resulted in an impact with an obstacle.Feb 15, 2023 · N8318C · Substantial damageNTSB WPR23LA106Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22 · Sandpoint, IDThe pilot’s failure to maintain directional control during landing and subsequent failure to maintain clearance from a snow berm during a go around.Jan 30, 2023 · N1791P · Substantial damageNTSB WPR23LA135Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Skull Valley, AZThe pilot’s failure to maintain directional control of the airplane while landing in a crosswind.Jan 21, 2023 · N92570 · Substantial damageNTSB CEN23LA089Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · San Antonio, TXThe pilot’s failure to maintain directional control during the landing roll.Jan 20, 2023 · N5610U · Substantial damageNTSB CEN23LA085Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Brush, COThe pilot’s failure to maintain directional control during the landing roll with strong gusty surface winds.Jan 17, 2023 · N41529 · Substantial damageNTSB WPR23LA090Accident · No injuriesClass 4 · LimitedFinal reportMaule MX-7-160 · Minidoka, IDThe pilot’s failure to maintain control during landing on a contaminated runway.Jan 16, 2023 · N30737 · Substantial damageNTSB ANC23LA011Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Kenai, AKThe pilot's failure to maintain directional control during landing in flat light conditions, resulting in the airplane to nose over.Jan 2, 2023 · N94X · Substantial damageNTSB WPR23LA070Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV6 · Afton, WYThe pilot’s failure to maintain control during landing on a contaminated runway.Dec 18, 2022 · N78HJ · Substantial damageNTSB ANC23LA016Accident · No injuriesClass 4 · LimitedFinal reportChampion 7GCBC · Anchorage, AKThe pilot's loss of directional control during takeoff.Dec 3, 2022 · N8365V · Substantial damageNTSB ERA23LA019Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5A · Knoxville, TNThe student pilot’s loss of directional control on landing.Oct 14, 2022 · N26944 · Substantial damageNTSB CEN22LA388Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28 · Lucedale, MSThe pilot’s failure to maintain directional control while landing on the wet turf runway with a higher speed.Aug 15, 2022 · N5341W · Substantial damageNTSB ANC22LA067Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Delta Junction, AKThe pilot’s failure to maintain directional control of the airplane during the takeoff roll following a hard landing.Aug 10, 2022 · N7087D · Substantial damageNTSB ERA22LA324Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Lawrenceville, GAThe student pilot’s failure to maintain directional control while landing with a crosswind.Jul 17, 2022 · N62405 · Substantial damageNTSB WPR22LA260Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Kelso, WAThe student pilot’s inadequate flare resulting in a loss of airplane control during landing with gusting wind conditions.Jul 12, 2022 · N43037 · Substantial damageNTSB WPR22LA244Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Afton, WYThe pilot's inadequate flare and bounced landing which resulted in loss of directional control of the airplane during the landing roll.Jul 10, 2022 · N50678 · Substantial damageNTSB ERA22LA359Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Fitchburg, MAThe pilot's loss of directional control while landing, which resulted in a ground loop.Jul 10, 2022 · N5915D · Substantial damageNTSB CEN22LA306Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Cleveland, MSThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and substantial damage.Jun 26, 2022 · N97789 · Substantial damageNTSB CEN22LA296Accident · No injuriesClass 4 · LimitedFinal reportBaker Eugene L RV6-A · Goldsby, OKThe pilot’s failure to maintain directional control during landing resulting in a runway excursion.Jun 19, 2022 · N18390 · Substantial damageNTSB ANC22LA036Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Gulkana, AKThe pilot’s failure to maintain directional during the landing rollout in crosswind conditions, which resulted in a runway excursion and impact with terrain.May 28, 2022 · N5773M · Substantial damageNTSB WPR22LA185Accident · No injuriesClass 4 · LimitedFinal reportFrazier Robert L RV-6A · Prineville, ORThe pilot’s improper landing flare which resulted in a bounced landing and loss of directional control.May 23, 2022 · N811RF · Substantial damageNTSB WPR22LA176Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18 · Tucson, AZThe pilot’s failure to maintain directional control during landing.May 10, 2022 · N1272A · Substantial damageNTSB ERA22LA201Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Union, SCThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with terrain.Apr 23, 2022 · N737UY · Substantial damageNTSB WPR22LA161Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172I · Blanding, UTThe pilot’s improper landing flare which, resulted in a bounced landing and loss of airplane control during an aborted landing in gusty wind conditions.Apr 20, 2022 · N46055 · Substantial damage