NTSB investigations: Lycoming 0-320 series, 1988, UT

4 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, 1988, UT per year, 1964–2026: 149 cases
19643
19652
19662
19672
19684
19695
19703
19712
19721
19731
19742
19754
19764
19771
19782
19793
19805
19813
19821
19842
19854
19864
19871
19884
19902
19912
19921
19934
19942
19952
19963
19974
19983
19993
20002
20012
20025
20032
20045
20062
20073
20085
20091
20102
20114
20121
20132
20142
20151
20161
20172
20181
20191
20202
20213
20221
20232
20242
20251
20263

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\") = 1988
    AND c.\"eventStateOrRegion\" = 'UT' 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 DEN88FA212Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Kanosh, UTPlt obtained wx briefing and filed VFR flt plan from burley, ID, to chandler, AZ, with enroute refueling stop at fillmore, UT. Plt landed on dirt road at fillmore and taxiied acft to roadside truck stop. Acft serviced with auto gas. Acft departed fillmore but…Jul 13, 1988 · N3541Z · DestroyedNTSB DEN88LA136Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-160 · Ogden, UTThe low time private plt and his non-pilot wife were practicing touch and go landings. The plt used the right seat and his wife used the left seat. While on final apch, the plt recognized that the airplane was too high, added full flaps and cut the power. The…Jun 25, 1988 · N5113W · Substantial damageNTSB DEN88FA096Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Milford, UTThe plt (with a recent instrument rating) rcvd a wx briefing fm cedar city (cdc) fss & filed an IFR flt plan fm provo (pvu) to st george (sgu). Current sgu wx wasn't available, but wx for cdc (abt 45 mi nne) was provided. The plt was adzdof moist unstable…Apr 14, 1988 · N3850M · DestroyedNTSB DEN88LA057Accident · No injuriesLimited investigationFinal reportCessna 172N · Duchesne, UTThe student plt was performing a cross country training flight. At his first stop, during the takeoff portion of a touch and go landing, the aircraft swerved to the left and struck a three foot snow bank on the left side of the runway. The plt reported that…Jan 22, 1988 · N4897G · Substantial damage