NTSB investigations: Lycoming 0-320 series, 1969, MI

14 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, 1969, MI per year, 1964–2026: 393 cases
19648
196511
196611
196715
196815
196914
197010
19719
197213
19738
197412
19757
197615
197710
19788
19799
19808
19818
198210
198316
19846
19855
19868
19875
19887
19892
19904
19919
19927
19937
19946
19957
19963
19975
19983
19995
20005
20018
20022
20035
20045
20053
20066
20076
20081
20105
20111
20124
20134
20142
20154
20162
20173
20185
20192
20204
20211
20223
20231
20241
20253
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 year(c.\"eventDate\") = 1969
    AND c.\"eventStateOrRegion\" = 'MI' 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 CHI70D0343Accident · No injuriesClosedPiper PA-28 · Holland, MINov 16, 1969 · N9559W · Substantial damageNTSB CHI70F0392Accident · No injuriesClosedPiper PA-22 · Gwinn, MINov 8, 1969 · N1804P · Substantial damageNTSB CHI70D0281Accident · No injuriesClosedPiper PA-28 · Alma, MISep 30, 1969 · N6796W · Substantial damageNTSB CHI70F0202Accident · No injuriesClosedTurner T-40 · Clark Lake, MIJul 29, 1969 · N115ET · Substantial damageNTSB CHI70D0114Accident · No injuriesClosedCessna 177 · Charlevoix, MIJul 19, 1969 · N2349Y · DestroyedNTSB CHI70F0080Accident · Serious injuriesClosedPiper PA-28 · Chesaning, MIJul 5, 1969 · N4224J · DestroyedNTSB CHI70D0064Accident · Minor injuriesClosedPiper PA-28 · Alma, MIJun 29, 1969 · N3979K · Substantial damageNTSB CHI70F0046Accident · Minor injuriesClosedPiper PA-28 · Blissfield, MIJun 15, 1969 · N4590R · Substantial damageNTSB CHI69D0617Accident · No injuriesClosedPiper PA-28 · Wayland, MIMay 6, 1969 · N8211N · Substantial damageNTSB CHI69F0602Accident · No injuriesClosedPiper PA-28 · Grand Ledge, MIApr 20, 1969 · N6440R · Substantial damageNTSB CHI69F0503Accident · No injuriesClosedCessna 177 · Westland, MIMar 18, 1969 · N3150T · Substantial damageNTSB CHI69F0464Accident · No injuriesClosedPiper PA-28 · Ypsilanti, MIFeb 4, 1969 · N4527R · Substantial damageNTSB CHI69F0457Accident · No injuriesClosedPiper J5A · Freeland, MIJan 29, 1969 · N35762 · Substantial damageNTSB CHI69F0433Accident · No injuriesClosedPiper PA-28 · Plainwell, MIJan 7, 1969 · N4607R · Substantial damage