NTSB investigations: Lycoming I0360 series, 1972

67 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 year(c.\"eventDate\") = 1972
    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 DEN72DTC22Accident · Minor injuriesClosedPiper PA-28R · Gillette, WYMar 25, 1972 · N2120T · Substantial damageNTSB LAX72DUJ82Accident · No injuriesClosedBeech A23-24 · St Johns, AZMar 18, 1972 · N5777V · Substantial damageNTSB NYC72DFJ30Accident · No injuriesClosedPiper PA-28R · Olean, NYMar 8, 1972 · N4605J · Substantial damageNTSB CHI72FEE59Accident · No injuriesClosedMooney M-20E · Northbrook, ILMar 5, 1972 · N2575W · Substantial damageNTSB MIA72FKG77Accident · No injuriesClosedPiper PA-28 · Fairburn, GAMar 1, 1972 · N4625J · Substantial damageNTSB MIA72AM088Accident · Serious injuriesClosedCessna 310J · Cartersville, GAMar 1, 1972 · N15CM · 2 aircraft · Substantial damageNTSB OAK72DVG37Accident · No injuriesClosedPiper PA-28R · Napa, CAFeb 14, 1972 · N4306T · Substantial damageNTSB NYC72FFJ28Accident · No injuriesClosedBeech A23-24 · Penn Yan, NYFeb 12, 1972 · N7982L · Substantial damageNTSB SEA72DTI13Accident · No injuriesClosedMooney M20E · Great Falls, MTFeb 6, 1972 · N9228V · Substantial damageNTSB MKC72FER38Accident · No injuriesClosedPiper PA-28R · Hopkins, MNFeb 3, 1972 · N7576J · Substantial damageNTSB OAK72DVM22Accident · No injuriesClosedMooney M21F · Salinas, CAJan 24, 1972 · N3525X · Substantial damageNTSB CHI72DEI31Accident · No injuriesClosedPiper PA-28R · Painesville, OHJan 22, 1972 · N2607R · Substantial damageNTSB NYC72FLJ21Accident · No injuriesClosedMooney M20E · Gates, NCJan 16, 1972 · N3233F · Substantial damageNTSB NYC72FGM28Accident · No injuriesClosedPiper PA-28R · Central City, PAJan 16, 1972 · N2340T · Substantial damageNTSB MKC72AK044Accident · No injuriesClosedPiper PA-28 · Fergus Falls, MNJan 11, 1972 · N2952R · Substantial damageNTSB FTW72FRA31Accident · Minor injuriesClosedHughes 269C · Pasadena, TXJan 5, 1972 · N9667F · Substantial damageNTSB LAX72FUM16Accident · No injuriesClosedHughes 269B · Mt.Laguna, CAJan 2, 1972 · N9459F · Substantial damage