NTSB investigations: Lycoming I0360 series, 1971

65 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\") = 1971
    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 MIA71DKG71Accident · No injuriesClosedPiper PA-28 · Fitzgerald, GAMar 30, 1971 · N5041S · Substantial damageNTSB MKC71FCG49Incident · No injuriesClosedPiper PA-28R · Springfield, MOMar 21, 1971 · N2109T · Minor damageNTSB NYC71FHJ22Accident · No injuriesClosedMooney M20F · Flushing, NYMar 1, 1971 · N6820V · Substantial damageNTSB CHI71DBM15Accident · No injuriesClosedBeech A23-24 · Rochester, INFeb 28, 1971 · N6924Q · Substantial damageNTSB MIA71FLD48Accident · No injuriesClosedHughes 269B · Tampa, FLFeb 25, 1971 · N9557F · Substantial damageNTSB LAX71DUM28Accident · Minor injuriesClosedPiper PA-28R · Jacumba, CAFeb 22, 1971 · N4675J · Substantial damageNTSB NYC71DFA51Accident · No injuriesClosedBeech A23-24 · Rome, NYFeb 17, 1971 · N7664R · Substantial damageNTSB CHI71DGD45Accident · No injuriesClosedPiper PA-28R · Painsville, OHFeb 17, 1971 · N2607R · Substantial damageNTSB NYC71FHA33Accident · No injuriesClosedPiper PA-28R · Forty Fort, PAFeb 10, 1971 · N7484J · Substantial damageNTSB OAK71DVG59Accident · No injuriesClosedMooney M20E · Fair Oaks, CAFeb 4, 1971 · N6092Q · Substantial damageNTSB CHI71FDJ40Accident · No injuriesClosedPiper PA-28R · Milwaukee, WIFeb 2, 1971 · N4970S · Substantial damageNTSB FTW71FPG35Accident · No injuriesClosedMooney M20E · Little Rock, ARJan 31, 1971 · N9302M · Substantial damageNTSB CHI71DBA27Accident · No injuriesClosedMooney M20F · Whitestown, INJan 24, 1971 · N9377M · Substantial damageNTSB NYC71FHM15Accident · Serious injuriesClosedMooney M20F · Morristown, NJJan 21, 1971 · N9393M · Substantial damageNTSB NYC71IN076Incident · No injuriesClosedCessna 150 · Danbury, CTJan 2, 1971 · N22785 · 2 aircraft · Minor damage