NTSB investigations: Continental E185 series, CA
126 cases on aircraft whose registry engine model is Continental E185 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 ('17014'))
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 ('17014'))
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 LAX74DUG34Accident · No injuriesClosedBeech A35 · Boron, CANTSB OAK74DVM16Accident · No injuriesClosedBeech 35 · Moss Beach, CANTSB LAX74FUA13Accident · No injuriesClosedBeech B35 · Long Beach, CANTSB OAK73DXQ33Accident · No injuriesClosedNavion A · Tahoe City, CANTSB LAX73FUM13Accident · No injuriesClosedBeech A35 · El Cajon, CANTSB OAK73DVG29Accident · No injuriesClosedBeech 35 · San Andreas, CANTSB OAK73DXQ18Accident · No injuriesClosedBeech D35 · Truckee, CANTSB LAX73DUA02Accident · No injuriesClosedBeech 35 · Long Beach, CANTSB OAK72FVG46Accident · Serious injuriesClosedNavion A · Jackson, CANTSB OAK72AP031Accident · 1 fatalClosedBeech E35 · Dublin, CANTSB OAK72DVM17Accident · No injuriesClosedBeech 35 · San Jose, CANTSB OAK72DVM14Accident · No injuriesClosedBeech C35 · Palo Alto, CANTSB OAK72DXQ09Accident · No injuriesClosedBeech D35 · Susanville, CANTSB OAK72DVW03Accident · No injuriesClosedBeech B35 · Bishop, CANTSB LAX71FUA51Accident · No injuriesClosedBeech 35 · Huntingtn B., CANTSB LAX71FUG49Accident · No injuriesClosedBeech 35 · Corona, CANTSB LAX71DVA48Accident · Minor injuriesClosedBeech 35 · Bakersfield, CANTSB LAX71FUG17Accident · No injuriesClosedBeech D35 · Fontana, CANTSB LAX70FUA28Accident · No injuriesClosedBeech 35 · Torrance, CANTSB OAK70FVG04Accident · Serious injuriesClosedBeech 35 · Shingle Sprgs, CANTSB OAK70FVA07Accident · No injuriesClosedBeech D35 · Fresno, CANTSB LAX70AL043Accident · 1 fatalClosedBeech D35 · Newhall, CANTSB LAX70F0115Accident · No injuriesClosedLuscombe 11A · Bakersfield, CANTSB OAK70D0049Accident · No injuriesClosedBeech D35 · Sanger, CANTSB LAX70F0015Accident · No injuriesClosedMeyers MAC145 · Torrance, CANTSB LAX70D0008Accident · No injuriesClosedBeech 35 · Chino, CANTSB LAX69F0306Accident · No injuriesClosedBeech 35 · Long Beach, CANTSB LAX69F0234Accident · No injuriesClosedNavion A · Fullerton, CANTSB OAK69D0246Accident · No injuriesClosedNavion A · Davis, CANTSB LAX69D0212Accident · No injuriesClosedBeech A35 · Santa Ana, CANTSB LAX69D0197Accident · No injuriesClosedBeech 35 · Palm Springs, CANTSB OAK69D0163Accident · No injuriesClosedBeech 35 · San Jose, CANTSB OAK69D0108Accident · No injuriesClosedBeech 35 · Redding, CANTSB OAK69A0011Accident · 2 fatalClosedBeech N35 · Truckee, CANTSB OAK69F0105Accident · No injuriesClosedBeech A35 · Tah0e Valley, CANTSB OAK69D0019Accident · No injuriesClosedBeech 35 · S.Luis Obispo, CANTSB LAX68F0430Accident · No injuriesClosedBeech A35 · S.J.Capistrno, CANTSB LAX68D0391Accident · No injuriesClosedBeech C35 · Oxnard, CANTSB LAX68F0387Accident · No injuriesClosedBeech C35 · Santa Ana, CANTSB OAK68D0346Accident · No injuriesClosedBeech B35 · Stockton, CANTSB LAX68D0344Accident · No injuriesClosedNavion G · Baker, CANTSB LAX68D0299Accident · No injuriesClosedBeech C35 · Santa Ana, CANTSB LAX68D0269Accident · No injuriesClosedBeech A35 · Oxnard, CANTSB OAK68F0209Accident · No injuriesClosedBeech A35 · Visalia, CANTSB LAX68F0277Accident · No injuriesClosedBeech 35 · Fullerton, CANTSB LAX68D0181Accident · No injuriesClosedBeech 35 · Palm Sprngs, CANTSB LAX68D0161Accident · No injuriesClosedBeech A35 · Santee, CANTSB LAX68D0146Accident · No injuriesClosedNavion A · Bakersfield, CANTSB OAK68D0131Accident · No injuriesClosedBeech 35 · Santa Rosa, CANTSB OAK68D0068Accident · No injuriesClosedBeech 35A · San Francisco, CA