NTSB investigations: Lycoming HIO-360 series, LA
9 cases on aircraft whose registry engine model is Lycoming HIO-360 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
| 1980 | 1 |
|---|---|
| 1990 | 1 |
| 1994 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2016 | 1 |
| 2021 | 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\" = 'LA' 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 ('41524'))
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" = 'LA' 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 ('41524'))
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 CEN21LA253Accident · No injuriesClass 4 · LimitedFinal reportSchweizer TH55A/269A · Monroe, LAThe pilot’s failure to maintain yaw control during landing which resulted in a loss of tail rotor effectiveness.NTSB CEN16FA304Accident · 1 fatalField investigationFinal reportSchweizer 269C 1 · Jeanerette, LAThe pilot's loss of helicopter control for reasons that could not be determined based on available evidence.NTSB DFW07CA146Accident · No injuriesData collectionFinal reportSchweizer 269C · Slidell, LAThe pilot's encounter with settling with power condition while hovering out of ground effect. A contributing factor was the prevailing tailwind.NTSB DFW07CA037Accident · No injuriesData collectionFinal reportHughes 269B · Houma, LAA partial loss of engine power as a result of a cracked engine cylinder and broken spark plug which resulted in a hard landing. A factor was that it was not possible to attain proper rotor RPM.NTSB FTW03LA122Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Monroe, LAThe pilot's failure to maintain control of the helicopter. A contributing factor was the crosswind.NTSB FTW01LA103Accident · Serious injuriesLimited investigationFinal reportJoe Underwood Lazer Z · Bossier City, LAthe pilot's failure to maintain control during the low level maneuver. A contribiting factor was the windshear.NTSB FTW94LA253Accident · No injuriesLimited investigationFinal reportHughes 269A · Leander, LAInadequate maintenance and a fatigue failure of a #1 cylinder connecting rod bolt. A factor was the lack of suitable terrain available to the pilot for a forced landing.NTSB FTW90LA074Accident · No injuriesLimited investigationFinal reportHughes 269C · Houma, LALoss of engine power for an unknown reason.NTSB FTW80DRD54Accident · Minor injuriesClosedHughes 269B · Wakefield, LA