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.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB LAX82DUJ19Accident · No injuriesClosedMooney M20E · Chandler, AZNTSB LAX80DUJ70Accident · No injuriesClosedMooney M20E · Holbrook, AZNTSB LAX79DUK13Accident · No injuriesClosedRockwell 112TC · Tucson, AZNTSB LAX79FA039Accident · 2 fatalClosedPiper PA-28R · Jerome, AZNTSB LAX78FUJ95Accident · Minor injuriesClosedPiper PA-28R · Tuba City, AZNTSB LAX78IA065Incident · No injuriesClosedMooney M20J · Tucson, AZNTSB LAX78DUJ63Accident · No injuriesClosedHughes 269B · Glendale, AZNTSB LAX77FUJ63Accident · No injuriesClosedMooney M20F · Williams, AZNTSB LAX76DUJ89Accident · No injuriesClosedBeech A24R · Prescott, AZNTSB LAX76DUJ34Accident · No injuriesClosedPiper PA-28 · Bagdad, AZNTSB LAX76FUJ30Accident · No injuriesClosedHughes 269C · Phoenix, AZNTSB LAX75DUJ83Accident · Serious injuriesClosedMooney M20E · Coolidge, AZNTSB LAX75FUJ27Accident · No injuriesClosedMooney M20C · Stanfield, AZNTSB LAX74DUJ36Accident · No injuriesClosedPiper PA-28R · Gila Bend, AZNTSB LAX73AL042Accident · 2 fatalClosedMooney M20E · Phoenix, AZNTSB LAX72FUJ09Accident · No injuriesClosedMooney M20F · Phoenix, AZNTSB DEN72AD056Accident · No injuriesClosedPiper PA-28R · Lukachukai, AZNTSB LAX72DUJ82Accident · No injuriesClosedBeech A23-24 · St Johns, AZNTSB LAX72DUJ60Accident · No injuriesClosedMooney M20E · Keam Canyon, AZNTSB LAX71DUJ96Accident · No injuriesClosedPiper PA-28R · Casa Grande, AZNTSB LAX71FUJ92Accident · No injuriesClosedPiper PA-28R · Laveen, AZNTSB LAX70DUJ39Accident · Minor injuriesClosedMooney M20F · Tombstone, AZNTSB LAX70FUJ41Accident · No injuriesClosedMooney M20E · Tucson, AZNTSB LAX70F0153Accident · Serious injuriesClosedHughes 269B · Grnd Canyon, AZNTSB LAX69D0330Accident · No injuriesClosedHughes 269B · Grnd Canyon, AZNTSB LAX69D0229Accident · No injuriesClosedMooney M20E · Mesa, AZNTSB LAX67D0418Accident · No injuriesClosedMooney M20F · L.Havasu Cty, AZNTSB LAX67D0277Accident · No injuriesClosedMooney M20E · Showlow, AZNTSB LAX67F0169Accident · No injuriesClosedMooney M20E · Tucson, AZNTSB DEN66D0180Accident · No injuriesClosedPiper PA-28 · Yuma, AZNTSB DEN66D0030Accident · No injuriesClosedMooney M20E · Heber, AZNTSB UNK64X4118Accident · Minor injuriesClosedMooney MK21 · Springervill, AZ