NTSB investigations: Lycoming HO-360 series
8 cases on aircraft whose registry engine model is Lycoming HO-360 series, where the first occurrence was “Airframe/component/system failure/malfunction”. 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
| 1984 | 1 |
|---|---|
| 1990 | 3 |
| 1998 | 1 |
| 2002 | 2 |
| 2004 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41513')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41513')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130))
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 LAX04LA331Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Burbank, CAthe failure of maintenance personnel to correctly service the forward landing gear strut dampers in accordance with the manufacturer's maintenance instructions.NTSB FTW03FA028Accident · 1 fatalField investigationFinal reportHughes 269A · Fort Gibson, OKThe in-flight separation of the tail boom resulting from the failure of the fuselage to tail boom attachment fitting lugs, due to fatigue.NTSB LAX02LA228Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Concord, CAThe main rotor mast support tube failure as a result of fatigue.NTSB NYC98LA076Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Blue Ash, OHThe failure of a cooling fan blade and the pilot's improper flare.NTSB LAX90LA187Accident · No injuriesLimited investigationFinal reportHughes 269C · Rialto, CAImproper maintenance procedure by maintenance personnel to troubleshoot a reported deficiency and the pilot's decision to demonstrate the vibration, exceeding the design limits of the helicopter and inducing ground resonance. Contributing to the accident was…NTSB SEA90LA084Accident · No injuriesLimited investigationFinal reportHughes 269A · Bremerton, WAFailure of the tail rotor control for an undetermined reason.NTSB MKC90LA102Accident · No injuriesLimited investigationFinal reportLightcap PITTS-S-1D · Larned, KSFailure of the main landing gear attachment strut, due to fatigue.NTSB FTW85LA030Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Terrell, TXAcft was substantially damaged during an autorotative landing after the plt heard a 'loud pop' from the rear of the helicopter. Investigation revealed the spines on the lower pulley shaft coupling were severly stripped.