NTSB investigations: Lycoming 0-320 series, TN

11 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 per year

20082026
NTSB investigations: Lycoming 0-320 series, TN per year, 2008–2026: 11 cases
20081
20101
20111
20131
20141
20171
20202
20221
20231
20261

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\" = 'TN' 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\" = '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 ERA26LA255Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Lafayette, TNThe passenger’s abrupt manipulation of the flight controls during takeoff, which resulted in a loss of directional control and collision with a fence.Jun 30, 2026 · N6814H · 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 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 ERA20CA228Accident · Minor injuriesClass 4 · Data collectionFinal reportThorp Thorp T 18 · Madisonville, TNThe pilot's failure to maintain directional control during the landing roll on a soft turf runway, which resulted in a nose-over.May 29, 2020 · N70BZ · Substantial damageNTSB ERA20CA185Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA22 · Fayetteville, TNThe pilot's failure to maintain directional control during landing in gusting crosswind conditions.May 11, 2020 · N4454A · Substantial damageNTSB GAA17CA329Accident · No injuriesData collectionFinal reportCessna 172 · Nashville, TNThe pilot’s failure to maintain directional control during the landing roll.Jun 8, 2017 · N4284Q · Substantial damageNTSB ERA14CA169Accident · No injuriesData collectionFinal reportCessna 172M · Knoxville, TNThe student pilot's failure to maintain directional control during the takeoff roll, which resulted in a collision with an obstacle.Mar 23, 2014 · N8893V · Substantial damageNTSB ERA13CA140Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Livingston, TNThe student pilot’s failure to maintain directional control during the landing roll.Feb 17, 2013 · N43077 · Substantial damageNTSB ERA11CA115Accident · No injuriesData collectionFinal reportCessna 172N · Lebanon, TNThe student pilot´s failure to maintain directional control during an aborted takeoff, resulting in a runway excursion.Jan 15, 2011 · N1946F · Substantial damageNTSB ERA10LA131Accident · No injuriesLimited investigationFinal reportCessna 172 · Jackson, TNThe student pilot's loss of directional control during the takeoff roll, which resulted in a collision with a snow bank.Feb 3, 2010 · N97075 · Substantial damageNTSB NYC08CA191Accident · Minor injuriesData collectionFinal reportCessna 172M · Chuckey, TNThe pilot's failure to maintain directional control of the airplane during the takeoff roll. Contributing to the accident was his failure to abort the takeoff.May 22, 2008 · N74WC · Substantial damage