NTSB investigations: Continental IO-346 series, OH
14 cases on aircraft whose registry engine model is Continental IO-346 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
| 1965 | 3 |
|---|---|
| 1966 | 2 |
| 1967 | 1 |
| 1968 | 1 |
| 1970 | 2 |
| 1971 | 1 |
| 1974 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 2000 | 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\" = 'OH' 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 ('17033'))
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" = 'OH' 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 ('17033'))
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 NYC00FA094Accident · 1 fatalField investigationFinal reportBeech A23 · Akron, OHThe pilot's improper decision to operate the airplane with known deficiencies. A factor in this accident was the inability of the engine to attain full power for undetermined reasons.NTSB CHI81FEI24Accident · No injuriesClosedBeech A23 · Wooster, OHNTSB CHI80FEI19Accident · No injuriesClosedBeech A-23 · New Phila, OHNTSB CHI74FEI43Accident · No injuriesClosedBeech A23 · Tiffin, OHNTSB CHI72FEG26Accident · No injuriesClosedBeech A23A · Harrison, OHNTSB CHI71FGG20Accident · No injuriesClosedBeech A23A · Hicksville, OHNTSB CHI70DGD11Accident · No injuriesClosedBeech A-23 · Toledo, OHNTSB CHI68D0606Accident · No injuriesClosedBeech A23 · Cleveland, OHNTSB CHI68D0334Accident · No injuriesClosedBeech A23 · Chagrin Fall, OHNTSB CHI67D0366Accident · No injuriesClosedBeechcraft A23 · Medina, OHNTSB CHI66D0597Accident · No injuriesClosedBeechcraft 23 · Toledo, OHNTSB CHI66D0429Accident · No injuriesClosedBeechcraft A23 · Wauseon, OHNTSB CHI66D0354Accident · No injuriesClosedBeechcraft A23 · Richmond Hts, OHNTSB CHI65F0200Accident · No injuriesClosedBeechcraft A23 · Toledo, OH