NTSB investigations: Lycoming I0360 series, CO

88 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\" = 'CO' 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 DEN80FTE35Accident · No injuriesClosedPiper PA-28R · Denver, COMar 31, 1980 · N75139 · Substantial damageNTSB DEN79FA032Accident · 3 fatalClosedMooney M20F · Crestone, COMar 19, 1979 · N3881N · DestroyedNTSB DEN79FTE09Accident · No injuriesClosedPiper PA-28R · Ft Collins, CODec 13, 1978 · N1562X · Substantial damageNTSB DEN79FTE08Accident · No injuriesClosedPiper PA28R · Englewood, CODec 1, 1978 · N6507J · Substantial damageNTSB DEN78FTE94Accident · No injuriesClosedHughes 269A · Crook, COAug 31, 1978 · N8892F · Substantial damageNTSB DEN78FTE63Accident · Minor injuriesClosedBeech B24R · Co.Springs, COJun 15, 1978 · N6563R · Substantial damageNTSB MKC77FCQ57Accident · No injuriesClosedMooney M2OF · Holly, COAug 27, 1977 · N3554N · Substantial damageNTSB DEN77DTE56Accident · Minor injuriesClosedMooney M20F · Fredrick, COJun 12, 1977 · N9698M · Substantial damageNTSB DEN77FTE28Accident · Serious injuriesClosedHughes 269B · Erie, COMar 24, 1977 · N9306F · DestroyedNTSB DEN77FTE29Accident · Minor injuriesClosedPiper PA-28 · Englewood, COMar 23, 1977 · N4992T · Substantial damageNTSB DEN77FTE08Accident · No injuriesClosedPiper PA-28R · Boulder, CONov 24, 1976 · N9350K · Substantial damageNTSB DEN75FTE36Accident · No injuriesClosedPiper PA-28R · Longmont, CONov 29, 1974 · N2079T · Substantial damageNTSB DEN74FTE91Accident · No injuriesClosedAero Comdr 112A · Loveland, COJun 27, 1974 · N1174J · Substantial damageNTSB DEN74FTE58Accident · No injuriesClosedPiper PA-28R · Pueblo, COFeb 17, 1974 · N4337T · Substantial damageNTSB DEN74DTE41Accident · No injuriesClosedPiper PA-28R · Denver, COJan 24, 1974 · N56696 · Substantial damageNTSB DEN74DTE13Accident · No injuriesClosedMooney M20F · Meeker, COAug 11, 1973 · N3989N · Substantial damageNTSB DEN73DTE83Accident · No injuriesClosedPiper PA-28R · Cripple Crk, COJun 3, 1973 · N15362 · DestroyedNTSB DEN73FTE55Accident · No injuriesClosedMooney M20E · Greenwd Vill, COFeb 11, 1973 · N3393X · Substantial damageNTSB DEN72FTE70Accident · No injuriesClosedHughes 269B · Fort Collins, COMay 18, 1972 · N9306F · DestroyedNTSB DEN72DTE68Accident · Minor injuriesClosedPiper PA-28R · Alamosa, COApr 29, 1972 · N9371N · Substantial damageNTSB DEN71FXD40Accident · No injuriesClosedMooney M20F · Aurora, CODec 5, 1970 · N9698M · Substantial damageNTSB DEN70F0092Accident · No injuriesClosedBeech 23 · Aspen, COAug 9, 1969 · N5672S · Substantial damageNTSB DEN69D0224Accident · No injuriesClosedMooney M20E · Woodrow, COApr 24, 1969 · N6977U · Substantial damageNTSB DEN69D0115Accident · Serious injuriesClosedPiper PA-28 · Rangely, COSep 8, 1968 · N3966T · DestroyedNTSB DEN69F0041Accident · No injuriesClosedHughes 269A · Broomfield, COJul 8, 1968 · N8892F · Substantial damageNTSB DEN68F0002Accident · No injuriesClosedMooney M20E · Littleton, COMay 25, 1967 · N5624Q · Substantial damageNTSB DEN67A0057Accident · No injuriesClosedHughes 269B · Broomfield, COMar 27, 1967 · N9306F · Substantial damageNTSB DEN67D0137Accident · No injuriesClosedBeech A23 · Lake George, COSep 25, 1966 · N5780V · Substantial damageNTSB DEN67A0009Accident · No injuriesClosedHughes 269B · Las Animas, COJul 24, 1966 · N9345F · Substantial damageNTSB DEN67F0023Accident · No injuriesClosedBeech A23 · Boulder, COJul 6, 1966 · N5778V · Substantial damageNTSB DEN66A0079Accident · No injuriesClosedHughes 269A · Louisville, COApr 30, 1966 · N8829F · Substantial damageNTSB DEN66A0061Accident · No injuriesClosedHughes 269A · Fort Collins, COMar 5, 1966 · N8892F · Substantial damageNTSB DEN65A0086Accident · No injuriesClosedHughes 269A · Broomfield, COJun 29, 1965 · N8892F · Substantial damageNTSB DEN66D0046Accident · No injuriesClosedMooney M-20E · Slater, COJun 18, 1965 · N6927U · Substantial damageNTSB DEN65A0047Accident · Serious injuriesClosedHughes 269B · Colo Springs, COJan 9, 1965 · N9350F · DestroyedNTSB UNK65X0576Accident · No injuriesClosedHughes 269A · Broomfield, CONov 5, 1964 · N8829F · Substantial damageNTSB UNK64X2380Accident · No injuriesClosedHughes 269A · Broomfield, COJun 19, 1964 · N8892F · Substantial damageNTSB UNK64X0212Accident · 3 fatalClosedMooney M20E · De Beque, COJan 11, 1964 · N1248X · Destroyed