NTSB investigations: Lycoming I0360 series, AZ

87 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\" = 'AZ' 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 LAX86LA076Accident · No injuriesLimited investigationFinal reportMooney M20F · San Manuel, AZDuring cruise at 10,500 ft MSL on a night x-country flt, the plt said the eng ran rough with moderate vibration levels. Plt declared an emergency with abq ARTCC, who vectored the acft to an unlighted airstrip. The plt said he had difficultyin seeing the rwy…Dec 28, 1985 · N234GA · Substantial damageNTSB LAX84LA370Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gila Bend, AZA forced landing was made on a road after the plt shut down the eng due to a 'run-away' prop. During the landing roll, the left wing tip struck a reflector post followed by the right wing striking a sign post. An eng overhaul & an annual inspection had been…Jun 26, 1984 · N4820T · Substantial damageNTSB LAX83LA283Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Prescott, AZThe cross country flt was made later than the pilot intended. The pilot had never landed this model acft on a dark night at a high density alt arpt. The pilot reported that things were happening a lot faster than he was accustomed to. By the time he saw the…Jun 14, 1983 · N7927L · Substantial damageNTSB LAX82DA348Accident · No injuriesFinal reportPiper PA-28R-200 · Prescott, AZAccording to the pilot, he planned a fuel stop at needles, CA, but was unaware that services were not available until after arrival. He departed needles with low fuel in both tanks and attempted to reach Prescott, AZ before dark. However, darkness occurred…Sep 19, 1982 · N7675C · Substantial damageNTSB LAX82DA185Accident · 2 fatalFinal reportRockwell 112TC · Fort Apache, AZThe aircraft was observed to fly between two parked campers in a left wing low attitude before hitting a pine tree. The aircraft then went into an inverted position before contacting the ground about 300 yards from the campers. Investigation revealed that the…May 20, 1982 · N4567W · DestroyedNTSB LAX82DUJ19Accident · No injuriesClosedMooney M20E · Chandler, AZDec 2, 1981 · N9159V · Substantial damageNTSB LAX80DUJ70Accident · No injuriesClosedMooney M20E · Holbrook, AZJun 2, 1980 · N9159V · Substantial damageNTSB LAX79DUK13Accident · No injuriesClosedRockwell 112TC · Tucson, AZJun 6, 1979 · N4564W · DestroyedNTSB LAX79FA039Accident · 2 fatalClosedPiper PA-28R · Jerome, AZApr 8, 1979 · N6601F · DestroyedNTSB LAX78FUJ95Accident · Minor injuriesClosedPiper PA-28R · Tuba City, AZAug 19, 1978 · N4951T · Substantial damageNTSB LAX78IA065Incident · No injuriesClosedMooney M20J · Tucson, AZJul 31, 1978 · N201KY · 2 aircraft · No damageNTSB LAX78DUJ63Accident · No injuriesClosedHughes 269B · Glendale, AZMay 31, 1978 · N910KJ · Substantial damageNTSB LAX77FUJ63Accident · No injuriesClosedMooney M20F · Williams, AZJun 22, 1977 · N3770N · Substantial damageNTSB LAX76DUJ89Accident · No injuriesClosedBeech A24R · Prescott, AZJul 2, 1976 · N9285S · Substantial damageNTSB LAX76DUJ34Accident · No injuriesClosedPiper PA-28 · Bagdad, AZOct 2, 1975 · N1593X · Substantial damageNTSB LAX76FUJ30Accident · No injuriesClosedHughes 269C · Phoenix, AZSep 24, 1975 · N9666F · Substantial damageNTSB LAX75DUJ83Accident · Serious injuriesClosedMooney M20E · Coolidge, AZMay 25, 1975 · N3239F · DestroyedNTSB LAX75FUJ27Accident · No injuriesClosedMooney M20C · Stanfield, AZAug 25, 1974 · N6756V · Substantial damageNTSB LAX74DUJ36Accident · No injuriesClosedPiper PA-28R · Gila Bend, AZNov 24, 1973 · N4995S · Substantial damageNTSB LAX73AL042Accident · 2 fatalClosedMooney M20E · Phoenix, AZFeb 20, 1973 · N606H · DestroyedNTSB LAX72FUJ09Accident · No injuriesClosedMooney M20F · Phoenix, AZJun 27, 1972 · N9787M · Substantial damageNTSB DEN72AD056Accident · No injuriesClosedPiper PA-28R · Lukachukai, AZMay 25, 1972 · N4596T · Substantial damageNTSB LAX72DUJ82Accident · No injuriesClosedBeech A23-24 · St Johns, AZMar 18, 1972 · N5777V · Substantial damageNTSB LAX72DUJ60Accident · No injuriesClosedMooney M20E · Keam Canyon, AZDec 11, 1971 · N6697R · Substantial damageNTSB LAX71DUJ96Accident · No injuriesClosedPiper PA-28R · Casa Grande, AZMay 31, 1971 · N3105R · Substantial damageNTSB LAX71FUJ92Accident · No injuriesClosedPiper PA-28R · Laveen, AZMay 19, 1971 · N3250R · Substantial damageNTSB LAX70DUJ39Accident · Minor injuriesClosedMooney M20F · Tombstone, AZJun 8, 1970 · N9268M · Substantial damageNTSB LAX70FUJ41Accident · No injuriesClosedMooney M20E · Tucson, AZJun 3, 1970 · N9328M · Substantial damageNTSB LAX70F0153Accident · Serious injuriesClosedHughes 269B · Grnd Canyon, AZOct 9, 1969 · N9442F · Substantial damageNTSB LAX69D0330Accident · No injuriesClosedHughes 269B · Grnd Canyon, AZApr 1, 1969 · N9442F · Substantial damageNTSB LAX69D0229Accident · No injuriesClosedMooney M20E · Mesa, AZDec 11, 1968 · N3258F · Substantial damageNTSB LAX67D0418Accident · No injuriesClosedMooney M20F · L.Havasu Cty, AZApr 29, 1967 · N3531X · Substantial damageNTSB LAX67D0277Accident · No injuriesClosedMooney M20E · Showlow, AZFeb 2, 1967 · N2619W · Substantial damageNTSB LAX67F0169Accident · No injuriesClosedMooney M20E · Tucson, AZOct 14, 1966 · N2669W · Substantial damageNTSB DEN66D0180Accident · No injuriesClosedPiper PA-28 · Yuma, AZNov 27, 1965 · N5434W · Substantial damageNTSB DEN66D0030Accident · No injuriesClosedMooney M20E · Heber, AZJun 20, 1965 · N5512Q · Substantial damageNTSB UNK64X4118Accident · Minor injuriesClosedMooney MK21 · Springervill, AZSep 23, 1964 · N6940U · Substantial damage