NTSB investigations: Continental IO-360 series, KY
6 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
| 1964 | 1 |
|---|---|
| 1968 | 1 |
| 1970 | 1 |
| 1973 | 1 |
| 1982 | 1 |
| 1984 | 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\" = 'KY' 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" = 'KY' 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 ATL85FA058Accident · Serious injuriesField investigationFinal reportCessna 337 · Butler, KYPilot reported rear eng failure followed by front engine. Examination of wreckage disclosed that fuel was in right fuel system, no fuel was located in left inboard system. Water was found in both engine fuel flow dividers. It was not determined if the pilot…NTSB ATL83LA048Accident · No injuriesLimited investigationFinal reportCessna T-337C · Fulton, KYThe pilot stated that a normal short field approach to runway 27, with the stall warning horn sounding occasionally and touchdown approximately 200 feet from the threshold was accomplished. He also stated that after passing the first half of the runway he…NTSB IAD74FLQ09Accident · No injuriesClosedCessna 337C · Murray, KYNTSB CHI71DGJ09Accident · No injuriesClosedCessna 337 · Sandy Hook, KYNTSB CHI69D0323Accident · No injuriesClosedMaule M-4 · Midway, KYNTSB UNK64X0913Accident · Minor injuriesClosedCessna 172 · Georgetown, KY