NTSB investigations: Lycoming HIO-360 series, NC
6 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
| 1986 | 1 |
|---|---|
| 1993 | 1 |
| 1994 | 1 |
| 2006 | 1 |
| 2012 | 1 |
| 2015 | 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\" = 'NC' 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" = 'NC' 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 GAA15CA061Accident · Minor injuriesData collectionFinal reportHughes TH 55 · Morganton, NCThe flight instructor's delayed flare during a simulated auto rotation, which resulted in a tail rotor strike and rollover.NTSB ERA12LA362Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Asheville, NCThe use of an aftermarket skid shoe, which resulted in the skid shoe becoming caught on a runway centerline light during the run-on landing.NTSB ATL06LA085Accident · No injuriesLimited investigationFinal reportHughes 269A · Concord, NCThe loss of engine power for undetermined reasons while maneuvering, resulting in a forced landing to uneven terrain and a roll over.NTSB ATL94LA095Accident · Serious injuriesLimited investigationFinal reportSchweizer 300C · Randleman, NCThe pilot's failure to adequately preflight the helicopter which resulted in a complete loss of engine power. A factor was water in the fuel supply.NTSB ATL94LA002Accident · No injuriesLimited investigationFinal reportHughes 269B · Linville, NCThe pilot's failure to maintain airspeed that would have avoided a loss of tail rotor effectiveness (lte), and his improper compensation for tailwind condition. A factor was the lack of information in the pilot's operating handbook regarding the conditions…NTSB ATL87LA023Accident · No injuriesLimited investigationFinal reportHughes 269C · Eden, NCPilot related that he had placed the helicopter at triad for a 50 hour inspection. Aircraft reportedly defueled to dry tank. Six days later fuel truck log shows aircraft refueled with 23.2 gallons as payback. According to information furnished by owner and…