NTSB investigations: Continental IO-346 series, CA
18 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 | 2 |
|---|---|
| 1966 | 3 |
| 1967 | 4 |
| 1968 | 1 |
| 1970 | 1 |
| 1974 | 1 |
| 1977 | 1 |
| 1989 | 1 |
| 2005 | 2 |
| 2007 | 1 |
| 2017 | 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\" = 'CA' 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" = 'CA' 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 GAA17CA148Accident · Serious injuriesData collectionFinal reportBeech A23 · Beckwourth, CAThe student pilot’s inadvertent use of the control yoke to correct for a drift and his subsequent failure to maintain directional control during takeoff.NTSB SEA08CA049Accident · No injuriesData collectionFinal reportBeech A23 · Death Valley, CAThe pilot's improper flare during landing.NTSB LAX06FA055Accident · 2 fatalField investigationFinal reportBeech A23 · Mammoth Lakes, CAa loss of engine power for undetermined reasons, and, the failure of the pilot to maintain an adequate airspeed while maneuvering following the loss of power, which resulted in a stall/spin.NTSB LAX05LA258Accident · Serious injuriesLimited investigationFinal reportBeech A23 · Rancho Murieta, CAfuel starvation due to the inadequate fuel system management by both pilots. Also causal was the inadequate preflight inspection by both the instructor and student and their failure to verify the fuel quantities in each fuel tank, and, the instructor's…NTSB LAX90LA037Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Reedley, CAPilot's improper recovery from a bounce landing.NTSB OAK77FXQ27Accident · Serious injuriesClosedBeech A23A · Lake Tahoe, CANTSB OAK74FVG23Accident · No injuriesClosedBeech A23A · Fair Oaks, CANTSB LAX71DUM12Accident · No injuriesClosedBeech A23 · San Diego, CANTSB OAK69D0173Accident · No injuriesClosedBeech A23 · San L Obispo, CANTSB LAX68D0068Accident · No injuriesClosedBeech A23 · El Centro, CANTSB LAX68F0047Accident · No injuriesClosedBeech A23 · Agua Dulce, CANTSB LAX68D0019Accident · No injuriesClosedBeech A23 · Imperial, CANTSB OAK67D0267Accident · No injuriesClosedBeech A23 · Gualala, CANTSB LAX67A0061Accident · 1 fatalClosedBeech 23 · Chatsworth, CANTSB OAK67D0088Accident · No injuriesClosedBeech A23 · Auburn, CANTSB LAX67D0003Accident · No injuriesClosedBeech 23 · Upland, CANTSB OAK66F0104Accident · No injuriesClosedBeechcraft A23 · Auburn, CANTSB LAX66F0060Accident · No injuriesClosedBeechcraft A-23 · Pixley, CA