NTSB investigations: Lycoming HIO-360 series, 2000
4 cases on aircraft whose registry engine model is Lycoming HIO-360 series, where the first occurrence was “Loss of control - in flight”. 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
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 3 |
| 1990 | 1 |
| 1991 | 2 |
| 1993 | 2 |
| 1996 | 1 |
| 1997 | 3 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 4 |
| 2001 | 2 |
| 2002 | 3 |
| 2003 | 2 |
| 2004 | 3 |
| 2005 | 4 |
| 2007 | 2 |
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 year(c.\"eventDate\") = 2000
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')
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\" = 250))
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 year(c."eventDate") = 2000
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')
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" = 250))
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 LAX00LA276Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Cave Creek, AZThe pilot's inadequate in-flight planning/decision to attempt a hover in atmospheric conditions and over terrain that would require maximum helicopter performance, and which would leave no viable alternate actions in the event of difficulties.NTSB LAX00LA226Accident · No injuriesLimited investigationFinal reportHughes 269C · Santa Clarita, CASettling with power precipitated by a wind direction change during the approach to land sequence and the check pilot's delayed remedial action to correct the event. Factors in the accident were crew resource management coordination concerning flight control…NTSB SEA00LA103Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Kennewick, WAThe pilot's exceedance of the helicopter's hovering capabilities in a downwind hover. Factors included tailwind conditions, the pilot's lack of experience in the type of operation being conducted, and trees in the area where the helicopter settled.NTSB MIA00GA121Accident · 2 fatalFinal reportHughes 269C · Del Rio, TXAn in-flight loss of control while maneuvering for undetermined reasons resulting in an in-flight collision with terrain. A factor in the accident was the in-flight loss of engine power and rotor rpm.