NTSB investigations: Lycoming 0-540 series, OH

82 cases on aircraft whose registry engine model is Lycoming 0-540 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 ('41532'))
  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 CHI74FEI26Accident · Minor injuriesClosedPiper PA-32 · Cleveland, OHJan 29, 1974 · N3793W · Substantial damageNTSB CHI74FEI16Accident · No injuriesClosedPiper PA-24 · Ashland, OHOct 30, 1973 · N6453P · Substantial damageNTSB CHI74DEG04Accident · No injuriesClosedPiper PA-32 · Vandalia, OHJul 31, 1973 · N4740S · Substantial damageNTSB CHI73FEK03Accident · No injuriesClosedPiper PA-24 · Lima, OHJul 1, 1972 · N6004P · Substantial damageNTSB CHI71FGG29Accident · No injuriesClosedPiper PA-28 · Columbus, OHMar 21, 1971 · N9081W · Substantial damageNTSB CHI71FGA18Accident · No injuriesClosedPiper PA-28 · Middletown, OHMar 4, 1971 · N8664W · Substantial damageNTSB CHI71DGG11Accident · No injuriesClosedPiper PA-28 · Columbus Grv, OHSep 6, 1970 · N8542W · Substantial damageNTSB CHI71FGG07Accident · No injuriesClosedPiper PA-32 · Findlay, OHAug 12, 1970 · N3325W · Substantial damageNTSB CHI71FGA02Accident · No injuriesClosedPiper PA-24 · Chilo, OHJul 11, 1970 · N5278P · Substantial damageNTSB CHI70D0381Accident · No injuriesClosedPiper PA-24 · Cleveland, OHOct 6, 1969 · N6104P · Substantial damageNTSB CHI69F0623Accident · No injuriesClosedPiper PA-24 · Napoleon, OHApr 21, 1969 · N5466P · Substantial damageNTSB CHI69A0019Accident · 1 fatalClosedPiper PA-32 · Brunswick, OHAug 15, 1968 · N3393W · DestroyedNTSB CHI69D0204Accident · Minor injuriesClosedPiper PA-28 · Tiffin, OHJul 16, 1968 · N8658W · Substantial damageNTSB CHI69D0098Accident · No injuriesClosedPiper PA-24 · Port Clinton, OHJun 13, 1968 · N5118P · Substantial damageNTSB CHI69D0057Accident · No injuriesClosedPiper PA-23 · Lorain, OHMay 22, 1968 · N5070Y · Substantial damageNTSB CHI69D0001Accident · No injuriesClosedPiper PA-24 · Bowlng Green, OHApr 28, 1968 · N6410P · Substantial damageNTSB CHI68F0610Accident · No injuriesClosedPiper PA-23 · Middletown, OHFeb 24, 1968 · N4874P · Substantial damageNTSB CHI68D0613Accident · No injuriesClosedPiper PA-32 · Put-In-Bay, OHJan 21, 1968 · N3411W · Substantial damageNTSB CHI68F0571Accident · No injuriesClosedPiper PA-28 · Bluffton, OHJan 18, 1968 · N8631W · Substantial damageNTSB CHI68D0292Accident · No injuriesClosedPiper PA-24 · E.Rochester, OHAug 15, 1967 · N6410P · Substantial damageNTSB FTW68F0119Accident · No injuriesClosedPiper PA-24 · Guymon, OHJul 22, 1967 · N6428P · Substantial damageNTSB CHI68D0211Accident · No injuriesClosedPiper PA-32 · North Benton, OHJul 16, 1967 · N3694W · Substantial damageNTSB CHI68F0046Accident · No injuriesClosedPiper PA-24 · Xenia, OHJun 21, 1967 · N5684P · Substantial damageNTSB CHI67D0156Accident · No injuriesClosedPiper PA-24 · Sugar Creek, OHJul 27, 1966 · N7653P · Substantial damageNTSB CHI67D0053Accident · No injuriesClosedPiper PA-24 · Put-In-Bay, OHJun 25, 1966 · N6483P · Substantial damageNTSB CHI66F0632Accident · No injuriesClosedPiper PA-24 · Johnstown, OHMar 18, 1966 · N6960P · Substantial damageNTSB CHI66F0624Accident · No injuriesClosedPiper PA-24 · Hamilton, OHMar 9, 1966 · N6032P · Substantial damageNTSB CHI66F0554Accident · No injuriesClosedPiper PA-24 · Granville, OHJan 30, 1966 · N5448P · Substantial damageNTSB CHI66D0051Accident · No injuriesClosedPiper PA-23 · Newark, OHJul 8, 1965 · N4528P · Substantial damageNTSB CHI66D0006Accident · No injuriesClosedPiper PA-24 · Columbus, OHJun 19, 1965 · N8001P · Substantial damageNTSB UNK64X4176Accident · No injuriesClosedPeper PA24 · Wooster, OHSep 27, 1964 · N8219P · Substantial damageNTSB UNK64X3211Accident · Minor injuriesClosedPiper PA28 · Sabina, OHAug 4, 1964 · N8502W · Substantial damage