NTSB investigations: Continental E225 series, CA
101 cases on aircraft whose registry engine model is Continental E225 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, newest first
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 ('17015'))
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 ('17015'))
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 OAK70D0021Accident · No injuriesClosedBeech 35 · Lee Vining, CANTSB OAK69D0320Accident · No injuriesClosedNavion B · Bishop, CANTSB OAK69D0290Accident · No injuriesClosedBeech C35 · Chico, CANTSB LAX69F0310Accident · No injuriesClosedBeech F35 · Burbank, CANTSB LAX69A0036Accident · 2 fatalClosedNavion A · Tecate, CANTSB LAX69D0248Accident · Serious injuriesClosedBeech 35G · Van Nuys, CANTSB LAX69F0174Accident · Minor injuriesClosedBeech F35 · Calexico, CANTSB OAK69D0119Accident · No injuriesClosedBeech C35 · Salinas, CANTSB OAK69D0053Accident · No injuriesClosedBeech F35 · Vacaville, CANTSB LAX68D0402Accident · No injuriesClosedNavion A · Palm Sprngs, CANTSB LAX68F0264Accident · No injuriesClosedBeech E35 · Calipatria, CANTSB OAK68D0124Accident · No injuriesClosedBeech F35 · Carmel Vall, CANTSB OAK68D0016Accident · No injuriesClosedBeech E35 · Oakland, CANTSB LAX67D0420Accident · No injuriesClosedNavion A · Burbank, CANTSB LAX67D0366Accident · No injuriesClosedBeech G35 · Bakersfield, CANTSB OAK67D0231Accident · No injuriesClosedBeech F35 · Stockton, CANTSB LAX67F0228Accident · No injuriesClosedBeech A35 · San Diego, CANTSB OAK67D0175Accident · No injuriesClosedBeech C35 · Livermore, CANTSB OAK67D0119Accident · No injuriesClosedBeech F35 · Salinas, CANTSB OAK67D0112Accident · No injuriesClosedBeech G35 · Columbia, CANTSB OAK67F0142Accident · Minor injuriesClosedNavion A · Morgan Hill, CANTSB LAX67F0106Accident · No injuriesClosedBeech E35 · Torrance, CANTSB OAK67D0140Accident · No injuriesClosedBeech G35 · Willits, CANTSB LAX66D0381Accident · No injuriesClosedNavion A · Imperial, CANTSB LAX66D0366Accident · No injuriesClosedBeech G35 · Santee, CANTSB OAK66D0288Accident · No injuriesClosedBeech 35 · Oceano, CANTSB LAX66F0333Accident · No injuriesClosedBeech D35 · Ontario, CANTSB OAK66D0217Accident · No injuriesClosedBeechcraft F35 · Monterey, CANTSB OAK66D0193Accident · No injuriesClosedBeechcraft G35 · Merced, CANTSB OAK66F0170Accident · No injuriesClosedBeechcraft 35 · San Carlos, CANTSB LAX66F0207Accident · No injuriesClosedBeechcraft 35 · Oxnard, CANTSB LAX66F0193Accident · No injuriesClosedNavion A · El Monte, CANTSB OAK66D0144Accident · No injuriesClosedBeech G35 · Santa Rosa, CANTSB LAX66F0091Accident · No injuriesClosedBeechcraft G-35 · National City, CANTSB OAK65F0027Accident · No injuriesClosedBeechcraft G-35 · Snelling, CANTSB LAX65F0041Accident · No injuriesClosedBeechcraft F-35 · Hawthorne, CANTSB LAX65D0071Accident · No injuriesClosedBeechcraft C-35 · Fullerton, CANTSB LAX65F0034Accident · No injuriesClosedBeechcraft B-35 · Bishop, CANTSB OAK66F0017Accident · No injuriesClosedBeechcraft D-35 · Hayward, CANTSB LAX65F0002Accident · No injuriesClosedNavion A · Thousand Oaks, CANTSB UNK65X0712Accident · No injuriesClosedBeechraft A-35 · San Diego, CANTSB UNK65X0697Accident · Minor injuriesClosedBeechcraft B35 · Long Beach, CANTSB UNK65X0565Accident · No injuriesClosedBeechcraft 35 · Concord, CANTSB UNK64X3287Accident · No injuriesClosedBeechcraft A35 · Torance, CANTSB UNK64X3257Accident · No injuriesClosedBeechcraft E35 · Pauma Valley, CANTSB UNK64X2714Accident · No injuriesClosedBeechcraft G35 · Sacramento, CANTSB UNK64X2416Accident · No injuriesClosedBeechcraft D35 · Calexico, CANTSB UNK64X2033Accident · No injuriesClosedNavion NAV4 · Placentia, CANTSB UNK64X1467Accident · No injuriesClosedBeechcraft G35 · Thousand Oaks, CANTSB UNK64X0836Accident · No injuriesClosedNavion NAV4 · Concord, CA