NTSB investigations: Continental C145 series, CA
118 cases on aircraft whose registry engine model is Continental C145 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 ('17012'))
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 ('17012'))
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 OAK78DVD11Accident · No injuriesClosedCessna 170B · Willits, CANTSB OAK77DVD23Accident · No injuriesClosedCessna 170A · Oakland, CANTSB LAX77FUD02Accident · No injuriesClosedCessna 170B · Compton, CANTSB LAX77FQU10Accident · No injuriesClosedGlobe GC-1B · Pearblossom, CANTSB LAX76FUG65Accident · No injuriesClosedCessna 170B · Upland, CANTSB OAK76FVG45Accident · No injuriesClosedCessna 170 · Cordelia, CANTSB OAK76DVD16Accident · Minor injuriesClosedCessna 170 · Tamales, CANTSB OAK76DVG29Accident · No injuriesClosedCessna 170 · San Andreas, CANTSB OAK75DVM33Accident · No injuriesClosedCessna 170 · San Jose, CANTSB OAK75DVD23Accident · No injuriesClosedCessna 170 · Garberville, CANTSB OAK74DVG69Accident · No injuriesClosedCessna 170A · Redding, CANTSB OAK74DVA79Accident · No injuriesClosedCessna 170B · Auberry, CANTSB LAX74DVA40Accident · No injuriesClosedCessna 170A · Kennedy Mds, CANTSB OAK74DVM17Accident · No injuriesClosedCessna 170B · Paso Robles, CANTSB OAK74DVD11Accident · No injuriesClosedCessna 170A · Ukiah, CANTSB OAK74AP008Accident · 2 fatalClosedCessna 170B · Mammoth Lks, CANTSB LAX73DUG46Accident · Serious injuriesClosedCessna 170A · Apple Vally, CANTSB LAX73FUQ26Accident · No injuriesClosedCessna 170B · Santa Paula, CANTSB OAK73DVD20Accident · No injuriesClosedCessna 170B · Hayward, CANTSB LAX73DUM04Accident · No injuriesClosedCessna 170A · Calexico, CANTSB OAK73FVG12Accident · No injuriesClosedCessna 170B · Sacramento, CANTSB OAK73DVD12Accident · Minor injuriesClosedCessna 170B · Livermore, CANTSB LAX72FUA34Accident · Minor injuriesClosedCessna 170B · Torrance, CANTSB LAX72FUG52Accident · Minor injuriesClosedCessna 170 · Chino, CANTSB LAX72FUA33Accident · No injuriesClosedGlobe GC-1B · S.J.Cpstrno, CANTSB LAX72FUQ37Accident · No injuriesClosedCessna 170B · Quartz Hill, CANTSB OAK72DVD14Accident · No injuriesClosedCessna 170 · Santa Rosa, CANTSB OAK72DVG23Accident · No injuriesClosedCessna 170B · Grass Vally, CANTSB LAX71FUA57Accident · No injuriesClosedCessna 170A · Long Beach, CANTSB LAX71DUA09Accident · No injuriesClosedCessna 170B · Fullerton, CANTSB LAX70DUA18Accident · No injuriesClosedCessna 170B · Sj Capstrno, CANTSB LAX70DUM04Accident · No injuriesClosedCessna 170A · Calexico, CANTSB OAK70D0189Accident · No injuriesClosedCessna 170 · Concord, CANTSB LAX69D0358Accident · No injuriesClosedCessna 170A · Oxnard, CANTSB OAK69D0137Accident · Minor injuriesClosedCessna 170B · Tahoe Valley, CANTSB OAK69D0093Accident · No injuriesClosedCessna 170 · Vacaville, CANTSB OAK69D0068Accident · No injuriesClosedCessna 170 · Chico, CANTSB OAK69D0012Accident · No injuriesClosedCessna 170 · Morgan Hill, CANTSB OAK68D0343Accident · No injuriesClosedCessna 170B · Stratford, CANTSB LAX68D0345Accident · No injuriesClosedCessna 170 · Lakeside, CANTSB OAK68F0288Accident · Minor injuriesClosedCessna 170 · Lodi, CANTSB OAK68D0262Accident · No injuriesClosedCessna 170A · Morgan Hill, CANTSB LAX68D0158Accident · No injuriesClosedCessna 170B · Saugus, CANTSB OAK68D0047Accident · Minor injuriesClosedAeronca 15AC · Oakdale, CANTSB OAK68F0028Accident · No injuriesClosedAeronca 15AC · Fairfield, CANTSB OAK68D0055Accident · No injuriesClosedCessna 170 · Concord, CANTSB OAK67D0270Accident · No injuriesClosedCessna 170B · Lake Tahoe, CANTSB OAK67D0090Accident · No injuriesClosedCessna 170B · Elk Grove, CANTSB LAX67A0008Accident · 1 fatalClosedCessna 170A · Santa Maria, CANTSB OAK67D0028Accident · No injuriesClosedCessna 170B · Stockton, CA