NTSB investigations: Lycoming I0360 series, OH

76 cases on aircraft whose registry engine model is Lycoming I0360 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, newest first

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\" = '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 ('41515'))
  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 CHI78FEK20Accident · Minor injuriesClosedHughes 269B · Mechanicsburg, OHMay 24, 1978 · N9336F · DestroyedNTSB CHI78FEG04Accident · No injuriesClosedPiper PA-28R · Miamisburg, OHMar 15, 1978 · N1207T · Substantial damageNTSB CHI77FEG22Accident · Serious injuriesClosedPiper PA-28 · Piqua, OHJul 31, 1977 · N2873R · Substantial damageNTSB CHI77FEK15Accident · No injuriesClosedPiper PA-28 · Heath, OHMay 1, 1977 · N9260K · Substantial damageNTSB CHI77FEK14Accident · No injuriesClosedBeech A23-24 · Findley, OHMar 19, 1977 · N2394W · 2 aircraft · Substantial damageNTSB CHI77FEI13Accident · Minor injuriesClosedHughes 269-C · Cleveland, OHFeb 26, 1977 · N9679F · Substantial damageNTSB CHI76FEK31Accident · No injuriesClosedMooney M20E · Urbana, OHSep 26, 1976 · N1991Y · Substantial damageNTSB CHI76FEG06Accident · Serious injuriesClosedPitts S2A · Harrison, OHOct 15, 1975 · N80032 · Substantial damageNTSB CHI76FEK07Accident · No injuriesClosedMooney M20E · Van Wert, OHOct 9, 1975 · N3259F · Substantial damageNTSB CHI76FEG04Accident · No injuriesClosedLake LA-4 · Batavia, OHSep 2, 1975 · N1082L · Substantial damageNTSB CHI74FEK23Accident · No injuriesClosedPiper PA-28R · Marion, OHApr 21, 1974 · N55438 · Substantial damageNTSB CHI74DEK21Accident · No injuriesClosedEnstrom F28A · Marion, OHApr 6, 1974 · N1150R · Substantial damageNTSB CHI73FEG20Accident · No injuriesClosedBeech A24R · Piqua, OHMar 1, 1973 · N104GD · Substantial damageNTSB CHI72FEI38Accident · Minor injuriesClosedPiper PA-28R · Elyria, OHApr 6, 1972 · N3744T · Substantial damageNTSB CHI72DEI31Accident · No injuriesClosedPiper PA-28R · Painesville, OHJan 22, 1972 · N2607R · Substantial damageNTSB CHI72FEK07Accident · No injuriesClosedPiper PA-28R · Columbus, OHNov 25, 1971 · N7441J · Substantial damageNTSB CHI72DEG23Accident · No injuriesClosedBeech A24R · Jamestown, OHNov 12, 1971 · N104GD · Substantial damageNTSB CHI71DEI54Accident · No injuriesClosedBeech A23-24 · Ravenna, OHMay 6, 1971 · N5977S · Substantial damageNTSB CHI71FGA12Accident · No injuriesClosedMooney M20E · Cincinnati, OHApr 12, 1971 · N9061V · Substantial damageNTSB CHI71DGD45Accident · No injuriesClosedPiper PA-28R · Painsville, OHFeb 17, 1971 · N2607R · Substantial damageNTSB CHI69D0337Accident · No injuriesClosedBeech A-24 · Toledo, OHSep 27, 1968 · N5699S · Substantial damageNTSB CHI69F0287Accident · No injuriesClosedPiper PA-28R · Youngstown, OHAug 17, 1968 · N4584J · Substantial damageNTSB CHI68A0077Accident · Serious injuriesClosedHughes 269B · Sinking Spgs, OHFeb 27, 1968 · N9406F · DestroyedNTSB CHI67D0274Accident · No injuriesClosedMooney M21 · Cleveland, OHOct 3, 1966 · N2711W · Substantial damageNTSB CHI67F0064Accident · No injuriesClosedMooney M20E · Saint Paris, OHJun 26, 1966 · N5841Q · Substantial damageNTSB CHI66D0050Accident · No injuriesClosedPiper PA-23 · Cleveland, OHJun 11, 1965 · N4042P · Substantial damage