NTSB investigations: Lycoming 0-320 series, VA

6 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

20122026
NTSB investigations: Lycoming 0-320 series, VA per year, 2012–2026: 6 cases
20121
20131
20151
20161
20182

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\" = 'VA' 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 ERA18LA233Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · New Kent, VAThe student pilot’s loss of airplane control during a go-around.Aug 26, 2018 · N1537U · Substantial damageNTSB ERA18FA150Accident · 1 fatalField investigationFinal reportPiper PA28 · Chesapeake, VAThe pilot's loss of airplane control due to spatial disorientation during the departure climb in instrument meteorological conditions.May 22, 2018 · N6177W · DestroyedNTSB ERA16CA239Accident · Serious injuriesData collectionFinal reportPiper PA 22-160 · Harrisonburg, VAThe pilot's loss of directional control during takeoff in gusting crosswind conditions.Jul 2, 2016 · N8130D · Substantial damageNTSB ERA15LA257Accident · Minor injuriesLimited investigationFinal reportPiper PA28 · Galax Hillsville, VAThe pilot's failure to maintain adequate airspeed while turning onto the final approach leg of the traffic pattern, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.Jul 1, 2015 · N43503 · Substantial damageNTSB ERA13FA385Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Danville, VAThe student pilot's failure to maintain control and climb the airplane during a go-around maneuver. Contributing to the accident was the flight instructor's failure to provide adequate oversight of the student pilot by ensuring that the cockpit was free of…Aug 29, 2013 · N9089N · DestroyedNTSB ERA13CA090Accident · No injuriesData collectionFinal reportAmerican AA-5 · Hot Springs, VAThe pilot’s failure to maintain airplane control while attempting to land in crosswind conditions.Dec 20, 2012 · N5813L · Substantial damage