NTSB investigations: Lycoming I0360 series, HI
12 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 per year
| 1972 | 1 |
|---|---|
| 1974 | 1 |
| 1977 | 2 |
| 1986 | 1 |
| 1996 | 1 |
| 2006 | 1 |
| 2012 | 1 |
| 2016 | 2 |
| 2018 | 1 |
| 2026 | 1 |
Where
Open the mapLatest cases
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\" = 'HI' 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" = 'HI' 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 WPR26LA365Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172R · Ho'olehua, HINTSB WPR18LA280Accident · No injuriesClass 3 · LimitedFinal reportMooney M20J · Kapolei, HILoss of engine power due to water in the fuel lines.NTSB GAA17CA025Accident · No injuriesData collectionFinal reportCessna 172 · Kapolei, HIThe pilot’s use of an excessive pitch attitude during the landing flare, which resulted in a bounced landing.NTSB GAA16CA472Accident · No injuriesData collectionFinal reportCessna 172 · Kahului, HIThe pilot's incorrect pitch control during the landing flare, which resulted in a porpoise and hard landing.NTSB WPR12CA088Accident · No injuriesData collectionFinal reportCessna 172S · Mokuleia, HIThe pilot's improper landing flare and inadequate recovery from a bounced landing.NTSB LAX06CA150Accident · No injuriesData collectionFinal reportCessna 172S · Honolulu, HIthe pilot's misjudged flare resulting in a hard landing and a porpoise pilot induced oscillation.NTSB LAX97FA032Accident · 5 fatalField investigationFinal reportPiper PA-34-200 · Halawa, HIthe pilot's inadvertent VFR flight into instrument meteorological conditions (IMC), and his failure to maintain sufficient clearance and/or altitude from mountainous terrain. Factors related to the accident were: darkness, adverse weather conditions, and…NTSB LAX86LA188Accident · Minor injuriesLimited investigationFinal reportHughes 269 · Kahului, HIA Hughes 269 went out of control after turning left into a 20 kt tailwind condition. The plt indicated that the engine failed. The eng was run on a eng test stand and no deficientcies were found. A fuel sample was found to be within specified parameters. Ac…NTSB OAK78DA012Accident · 2 fatalClosedPiper PA-28R · Ke-Ahole, HINTSB OAK77FJA05Accident · No injuriesClosedPiper PA28R · Lanai City, HINTSB OAK74FJA16Accident · No injuriesClosedHughes 269B · Lihue, HINTSB OAK73FJA02Accident · No injuriesClosedHughes 269B · Honolulu, HI