NTSB investigations: Lycoming 0-320 series, 2004, OH

5 cases on aircraft whose registry engine model is Lycoming 0-320 series. 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

19642026
NTSB investigations: Lycoming 0-320 series, 2004, OH per year, 1964–2026: 426 cases
196410
19657
196620
196720
196826
196916
197018
197114
197214
197310
19749
19756
19769
197715
197813
197913
198011
198112
198211
19835
198411
19856
19865
19873
19885
19897
19904
19914
19926
19936
19946
19952
19962
199710
19983
19993
20007
20016
20023
20034
20045
20055
20063
20075
20085
20092
20101
20116
20122
20143
20151
20164
20172
20183
20191
20202
20213
20225
20232
20241
20253

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\") = 2004
    AND c.\"eventStateOrRegion\" = 'OH' 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'))
  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 NYC05LA033Accident · 3 fatalLimited investigationFinal reportCessna 172N · Mount Gilead, OHThe pilot's failure to maintain control of the airplane following an inadvertent encounter with instrument meteorological conditions. A factor in the accident was the rapidly deteriorating weather.Dec 30, 2004 · N737AZ · Substantial damageNTSB NYC05LA002Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Harrison, OHThe Cessna 152 pilot's improper traffic pattern procedure and improper radio communication, which resulted in a mid-air collision with a Cessna 172. A factor in the accident was both pilots' failure to maintain an adequate visual lookout.Oct 10, 2004 · N68298 · 2 aircraft · Substantial damageNTSB NYC04LA211Accident · No injuriesLimited investigationFinal reportCessna 172M · Medina, OHThe partial loss of engine power due to inadequate maintenance and by failure to comply with service instruction for low engine compression.Sep 10, 2004 · N172WW · Substantial damageNTSB NYC04FA171Accident · 1 fatalField investigationFinal reportCessna 172M · Brookville, OHThe student pilot's control interference while the flight instructor was maneuvering to avoid a tree, which resulted in a failure to maintain airspeed and a stall/mush.Jul 18, 2004 · N9731V · Substantial damageNTSB NYC04CA076Accident · No injuriesData collectionFinal reportCessna 172N · Youngstown, OHAn inadvertent collision with a deer while landing.Feb 23, 2004 · N738EK · Substantial damage