NTSB investigations: Continental IO-360 series, HI
4 cases on aircraft whose registry engine model is Continental IO-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
| 1982 | 1 |
|---|---|
| 1986 | 1 |
| 1988 | 1 |
| 2001 | 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\" = 'HI' 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 ('17025', '17045'))
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" = 'HI' 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 ('17025', '17045'))
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 LAX01LA181Accident · No injuriesLimited investigationFinal reportCessna 337C · Paauilo, HIA dual loss of engine power for undetermined reasons.NTSB LAX89LA049Accident · No injuriesLimited investigationFinal reportCessna 337E · Kahului, HIThe plt rprtd that after about 10 hrs on an overwater ferry flt, he noticed high oil temp & low oil pressure indcns fromthe rear eng. Eventually the rear eng began running rough, so he shut it down, feathered its prop and 'increased power on the front…NTSB LAX86LA078Accident · 1 fatalLimited investigationFinal reportCessna R172K · Kamuela, HIThe acft collided with terrain while maneuvering to aviod clouds during a local scenic flt. The plt stated that turbulence caused loss of control and the acft was blown into trees. The winds were from 050 degs at 37 KTS with gusts to 45 KTS. SIGMET oscar five…NTSB LAX82DA190Accident · Minor injuriesFinal reportCessna 172XP · Hilo, HIThe pilot stated that he requested 30 gallons of fuel for an estimated flight time of 3.5 hours. During the flight the engine ran rough and the right tank went to empty. The pilot then switched tanks and about 2 minutes later the pilot stated that the left…