NTSB investigations: Lycoming 0-320 series, CA

24 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the defining event was Loss of control in flight. 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 per year

20082026
NTSB investigations: Lycoming 0-320 series, CA per year, 2008–2026: 24 cases
20082
20091
20101
20133
20142
20152
20163
20184
20195
20211

Latest cases

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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
    AND 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\" = '240'))
  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 WPR21LA311Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Kernville, CAThe pilot’s failure to maintain airplane control during landing after an encounter with a wind gust which resulted in a collision with trees.Jul 25, 2021 · N728KG · Substantial damageNTSB WPR19FA262Accident · 1 fatalClass 3 · FieldFinal reportCessna 177 · Torrance, CAThe pilot’s failure to maintain adequate airspeed and exceedance of the aircraft's critical angle of attack while turning during climb out, which resulted in an aerodynamic stall.Sep 19, 2019 · N2323Y · DestroyedNTSB WPR19FA163Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Antioch, CAA loss of control while conducting low-altitude, high-speed maneuvers.Jun 10, 2019 · N7943C · DestroyedNTSB GAA19CA333Accident · No injuriesData collectionFinal reportPiper PA22 · Riverside, CAThe pilot's failure to the maintain the runway heading during landing with a crosswind, which resulted in impact with runway lighting and a subsequent ground loop during the landing roll.Jun 9, 2019 · N6865B · Substantial damageNTSB GAA19CA247Accident · No injuriesData collectionFinal reportCessna 172 · Auburn, CAThe pilot's improper retraction of the flaps during a go-around and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.May 6, 2019 · N734DX · Substantial damageNTSB WPR19LA100Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 7GCAA · Watsonville, CAThe pilot’s loss of airplane control during a go-around for reasons that could not be determined based on available evidence.Feb 9, 2019 · N11666 · Substantial damageNTSB GAA18CA542Accident · No injuriesData collectionFinal reportPiper PA28 · Chino, CAThe student pilot's failure to maintain lateral control during the aborted landing.Sep 9, 2018 · N7205J · Substantial damageNTSB GAA18CA232Accident · No injuriesData collectionFinal reportCessna 172 · San Jose, CAThe student pilot’s failure to maintain the runway heading during the approach to land, and the flight instructor’s delayed remedial action.Apr 20, 2018 · N23AT · Substantial damageNTSB GAA18CA201Accident · Minor injuriesData collectionFinal reportCessna 172 · Livermore, CAThe student pilot’s failure to maintain runway centerline and flight instructor’s delayed remedial action during landing.Apr 5, 2018 · N1438U · Substantial damageNTSB WPR18CA072Accident · Minor injuriesData collectionFinal reportCessna 172P · Cloverdale, CAThe pilot's failure to maintain airplane control during the approach and his delayed decision to go around.Jan 20, 2018 · N64204 · Substantial damageNTSB WPR17FA029Accident · 1 fatalField investigationFinal reportBellanca 7GCAA · Glamis, CAThe pilot's improper decision to attempt a downwind landing and his failure to maintain adequate airspeed while maneuvering during a go-around and subsequent landing attempt, which resulted in exceedance of the airplane's critical angle of attack and an…Nov 25, 2016 · N88373 · Substantial damageNTSB GAA17CA035Accident · Minor injuriesData collectionFinal reportPiper PA 28 · Fresno, CAThe pilot’s exceedance of the airplane’s critical angle of attack during departure due to being distracted by looking for his phone.Oct 19, 2016 · N5541F · Substantial damageNTSB WPR16FA126Accident · 1 fatalField investigationFinal reportPiper PA 23-150 · Hayward, CAThe failure of the left engine due to water contamination and the pilot's subsequent failure to maintain single-engine minimum control airspeed, which resulted in an uncontrolled descent. Contributing to the accident was the pilot's lack of total and recent…Jun 19, 2016 · N1270P · DestroyedNTSB GAA16CA002Accident · No injuriesData collectionFinal reportCessna 172 · Avalon, CAThe pilot's exceedance of the critical angle of attack in turbulent and downdraft conditions, which resulted in an aerodynamic stall and collision with terrain on final approach.Oct 1, 2015 · N4286Q · Substantial damageNTSB GAA15CA276Accident · No injuriesData collectionFinal reportPiper PA 28 · Van Nuys, CAThe pilot's failure to compensate for turbulence during the landing flare, which resulted in a hard landing and runway excursion.Sep 24, 2015 · N8258S · Substantial damageNTSB WPR14CA354Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Long Beach, CAThe student pilot's failure to maintain helicopter control during a practice hover. Contributing to the accident was the flight instructor's delayed remedial reaction.Aug 24, 2014 · N341SL · Substantial damageNTSB WPR14CA122Accident · No injuriesData collectionFinal reportCessna 172M · Ramona, CAThe student pilot's inadequate flare and failure to maintain directional control during landing, which resulted in a runway excursion and collision with terrain.Feb 25, 2014 · N91712 · Substantial damageNTSB WPR14LA080Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Pacoima, CAThe flight instructor’s inadequate compensation for the gusting crosswind conditions during landing, which resulted in a loss of airplane control.Dec 29, 2013 · N4936D · Substantial damageNTSB WPR14FA078Accident · 2 fatalField investigationFinal reportCessna 172K · Fresno, CAThe pilot’s failure to maintain adequate clearance from trees while on approach, which subsequently led to a loss of airplane control. Also causal was the pilot’s continued operation of the airplane at night with a diagnosed medical condition that degraded…Dec 27, 2013 · N251JM · DestroyedNTSB WPR13FA370Accident · 2 fatalField investigationFinal reportChampion 7GCAA · Paradise, CAThe pilot's failure to maintain airplane control during low-altitude maneuvering after encountering an updraft.Aug 13, 2013 · N9607S · DestroyedNTSB WPR10LA307Accident · 1 fatalLimited investigationFinal reportCessna 172N · Angels Camp, CAThe pilot’s failure to maintain airplane control while maneuvering.Jun 21, 2010 · N733AS · Substantial damageNTSB WPR09LA419Accident · 2 fatalLimited investigationFinal reportJames B. Taplin RV-6 · Orland, CAThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall/spin.Aug 27, 2009 · N43521 · Substantial damageNTSB LAX08FA109Accident · Serious injuriesField investigationFinal reportPiper PA-23-160 · San Dimas, CAA loss of engine power in the left engine due to fuel starvation as a result of the pilot's inadequate preflight inspection and the pilot's failure to abort the takeoff following the power loss.Apr 16, 2008 · N4080P · Substantial damageNTSB SEA08CA088Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Tracy, CAThe flight instructor's inadequate compensation for the tailwind condition and failure to maintain adequate airspeed that led to an inadvertent stall.Mar 8, 2008 · N75SE · Substantial damage