NTSB investigations: Lycoming 0-320 series, 2008

6 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the defining event was Aerodynamic stall/spin. 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, 2008 per year, 2008–2026: 92 cases
20086
20096
20102
20115
201210
20134
20145
20155
20163
20175
20186
20198
20202
20211
20228
20236
20243
20253
20264

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 year(c.\"eventDate\") = 2008
    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\" = '241'))
  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 CEN09CA041Accident · No injuriesData collectionFinal reportCessna 172 · Monticello, INThe pilot stalled the airplane during a go-around. Contributing to the accident included the pilot's improper in-flight decision, the tailwind landing, and the pilot's failure to put the carburetor Heat to "OFF" during the go-around.Oct 25, 2008 · N54971 · Substantial damageNTSB CEN09LA035Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Broomfield, COThe pilot's failure to maintain control of the airplane, resulting in an inadvertent stall, during a landing attempt. Contributing to the accident was the gusty crosswinds.Oct 24, 2008 · N64055 · DestroyedNTSB ANC08LA122Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot's failure to maintain sufficient airspeed to preclude a stall while maneuvering at a low altitude, resulting in an uncontrolled descent and collision with terrain.Sep 11, 2008 · N7174K · Substantial damageNTSB DEN08FA152Accident · 2 fatalField investigationFinal reportGulfstream American AA-5A · Baxter Pass, COThe pilot's failure to maintain adequate airspeed during a turn, resulting in an unrecoverable aerodynamic stall.Sep 7, 2008 · N26930 · DestroyedNTSB DFW08CA059Accident · Serious injuriesData collectionFinal reportPiper PA-18-150 · Sheffield, TXThe pilot's failure to maintain sufficient airspeed while maneuvering which resulted in a stall.Jan 27, 2008 · N743L · Substantial damageNTSB MIA08FA038Accident · 3 fatalField investigationFinal reportCessna 172L · Clearwater, FLThe pilot's failure to maintain airspeed while maneuvering for approach to land. Contributing to the accident was the pilot's operation of the airplane above the design gross weight.Jan 12, 2008 · N7100Q · Substantial damage