NTSB investigations: Lycoming I0360 series, 1973

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 year(c.\"eventDate\") = 1973
    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 SEA73DYA25Accident · No injuriesClosedMooney M20E · American Falls, IDMay 13, 1973 · N5614Q · Substantial damageNTSB IAD73DKM37Accident · No injuriesClosedPiper PA-28R · Winston Salem, NCMay 5, 1973 · N7435J · Substantial damageNTSB DEN73DQA38Accident · No injuriesClosedMooney M20F · Ramah, NMMay 5, 1973 · N9568M · Substantial damageNTSB MKC73FCD61Accident · No injuriesClosedEnstrom F-28A · Altoona, IAMay 4, 1973 · N2517M · Substantial damageNTSB LAX73FUQ83Accident · No injuriesClosedEnstrom F-28A · Goleta, CAMay 4, 1973 · N9572 · Substantial damageNTSB NYC73FHA73Accident · Minor injuriesClosedCessna 177B · Pottstown, PAApr 29, 1973 · N34231 · 2 aircraft · Substantial damageNTSB NYC73FNE31Accident · No injuriesClosedPiper PA-28R · Waterford, CTApr 22, 1973 · N2866R · Substantial damageNTSB FTW73FPJ17Accident · Minor injuriesClosedHughes 269B · Enid, OKApr 21, 1973 · N115AC · Substantial damageNTSB NYC73DNC68Accident · No injuriesClosedMooney M20E · North Conway, NHApr 7, 1973 · N3241F · Substantial damageNTSB CHI73FEE49Accident · Minor injuriesClosedPiper PA-28R · Elgin, ILApr 4, 1973 · N9430N · DestroyedNTSB IAD73FKW21Accident · No injuriesClosedMooney M20F · Alcoa, TNMar 23, 1973 · N3591N · Substantial damageNTSB DEN73DTC20Accident · No injuriesClosedPiper PA-28R · Laramie, WYMar 15, 1973 · N2064T · Substantial damageNTSB NYC73AN120Accident · 3 fatalClosedPiper PA-28 · Falls Creek, PAMar 6, 1973 · N2082T · Substantial damageNTSB MIA73FLA29Accident · No injuriesClosedBeech A24R · Jacksonville, FLMar 6, 1973 · N8017R · Substantial damageNTSB FTW73DRG55Accident · No injuriesClosedPiper PA-28R · Cotulla, TXMar 4, 1973 · N3945T · Substantial damageNTSB FTW73FPG39Accident · Serious injuriesClosedPiper PA-28R · Black Fork, ARMar 1, 1973 · N4974T · DestroyedNTSB FTW73AF049Accident · 1 fatalClosedPiper PA-28R · Baton Rouge, LAMar 1, 1973 · N4991J · DestroyedNTSB CHI73FEG20Accident · No injuriesClosedBeech A24R · Piqua, OHMar 1, 1973 · N104GD · Substantial damageNTSB NYC73DNC54Accident · No injuriesClosedMooney M20E · Biddeford, MEFeb 27, 1973 · N9254M · Substantial damageNTSB LAX73AL042Accident · 2 fatalClosedMooney M20E · Phoenix, AZFeb 20, 1973 · N606H · DestroyedNTSB MKC73FCG29Accident · No injuriesClosedPiper PA-28R · Atchison, KSFeb 19, 1973 · N15021 · Substantial damageNTSB FTW73FQD17Accident · Minor injuriesClosedPiper PA-28R · El Paso, TXFeb 16, 1973 · N5235T · Substantial damageNTSB DEN73FTE55Accident · No injuriesClosedMooney M20E · Greenwd Vill, COFeb 11, 1973 · N3393X · Substantial damageNTSB NYC73FNC52Accident · No injuriesClosedMooney M20F · Caribou, MEFeb 10, 1973 · N2917L · Substantial damageNTSB DEN73AD037Accident · 3 fatalClosedBeech A24R · Alamogordo, NMFeb 10, 1973 · N24578 · DestroyedNTSB FTW73FPG37Accident · No injuriesClosedMooney M20C · N.Little Rock, ARJan 27, 1973 · N2795W · Substantial damage