NTSB investigations: Lycoming HIO-360 series, IN

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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19782026

NTSB investigations: Lycoming HIO-360 series, IN per year, 1978–2026: 9 cases
1978	1
1986	1
1987	1
1990	1
1998	1
2001	1
2003	1
2006	1
2007	1

Where

Open the map

Latest cases

Query with SQL

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" = 'IN' 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

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\" = 'IN' 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" = 'IN' 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

Run 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 CHI08CA020Accident · Serious injuriesData collectionFinal reportSchweizer 269C · Hazelton, INThe pilot's failure to maintain adequate main rotor speed during the intentional autorotation, and his subsequent inability to reduce the descent rate prior to impact. A contributing factor was the intentional autorotation initiated by the pilot.Dec 5, 2007 · N75068 · Substantial damage NTSB CHI06TA148Accident · Minor injuriesFinal reportSchweizer 269C · Schererville, INThe pilot's improper autorotation following an actual loss of engine power during a practice autorotation, which resulted in a hard landing. A factor associated with the accident was the loss of engine power at the beginning of the practice autorotation for…Jun 6, 2006 · N54LC · Substantial damage NTSB CHI04LA032Accident · Serious injuriesLimited investigationFinal reportHughes TH-55A · West Lafayette, INThe fractured cluster fitting resulting in a loss of directional control during initial climb and the improper repair of cluster fitting by unknown personnel. The night conditions were a contributing factor.Nov 18, 2003 · N9240D · Substantial damage NTSB CHI01FA257Accident · 2 fatalField investigationFinal reportSchweizer 269C · Waterloo, INAircraft control not maintained for undetermined reasons.Aug 5, 2001 · N6129M · Substantial damage NTSB CHI98LA332Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Decker, INThe pilot's failure to maintain obstacle clearance resulting in a collision with a fence.Sep 4, 1998 · N75068 · Substantial damage NTSB CHI91LA048Accident · No injuriesLimited investigationFinal reportHughes 269A · Sellersburg, INA pilot induced loss of engine power by inadvertent deactivation of the fuel mixture control.Dec 26, 1990 · N90270 · Substantial damage NTSB CHI87LA072Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Martinsville, INWhile landing to the east the plt was blinded by the sun and the acft struck telephone wires.Jan 31, 1987 · N9257 · Destroyed NTSB CHI86LA127Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Ft. Wayne, INApprox 10-15 minutes after takeoff the student pilot lost control of the helicopter and crash landed into trees. Following the accident, the only unusual thing FAA personnel could locate was a failed horizontal stabilizer spar. Post-crash examination of the…Apr 23, 1986 · N8752F · Destroyed NTSB CHI78FEX16Accident · No injuriesClosedEnstrom F28C · Wheatland, INMay 8, 1978 · N51684 · Substantial damage