NTSB investigations: Continental C90 series, CA
113 cases on aircraft whose registry engine model is Continental C90 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 ('17009'))
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 ('17009'))
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 LAX75DUM26Accident · No injuriesClosedPiper PA-18 · Imperial, CANTSB LAX75DUM11Accident · Minor injuriesClosedPiper PA-18 · Imperial, CANTSB LAX75AL024Accident · No injuriesClosedBell 47G-5 · Riverside, CANTSB OAK75AP007Accident · 2 fatalClosedChampion 7FC · Newman, CANTSB OAK75DVD38Accident · No injuriesClosedCessna 140 · Hayward, CANTSB OAK74DVA72Accident · No injuriesClosedAlon A-2 · Fresno, CANTSB LAX74DUM34Accident · No injuriesClosedCessna 140 · Borrego Spg, CANTSB OAK74FVW16Accident · Minor injuriesClosedChampion 7EC · Lone Pine, CANTSB LAX74FUM10Accident · No injuriesClosedPiper PA-18 · Santee, CANTSB OAK74FVG01Accident · Serious injuriesClosedCessna 140 · Grass Vally, CANTSB LAX73DUQ40Accident · No injuriesClosedChampion 7FC · Mojave, CANTSB LAX73DUG59Accident · No injuriesClosedChampion 7CCM · Riverside, CANTSB OAK73FVD17Accident · No injuriesClosedChampion 7EC · Fremont, CANTSB OAK73DVA16Accident · Minor injuriesClosedChampion 7FC · Hanford, CANTSB OAK72DVG68Accident · No injuriesClosedCessna 140A · Hayfork, CANTSB OAK72FVD24Accident · No injuriesClosedAeronca 7EC · Sonoma, CANTSB OAK72DVD07Accident · No injuriesClosedLuscombe 8F · Concord, CANTSB LAX72FUQ09Accident · Serious injuriesClosedErco 415-D · Van Nuys, CANTSB LAX72DUQ03Accident · No injuriesClosedPiper PA-18 · Rosamond, CANTSB OAK71DVA85Accident · No injuriesClosedCessna 140 · Columbia, CANTSB LAX71DVW26Accident · No injuriesClosedChampion 7FC · Tecopa, CANTSB LAX71FUA28Accident · No injuriesClosedCessna 140 · Santa Ana, CANTSB OAK71DVM29Accident · Minor injuriesClosedLuscombe 8F · San Carlos, CANTSB OAK71DXQ19Accident · No injuriesClosedLuscombe 8F · Fort Bidwel, CANTSB LAX70FUQ24Accident · No injuriesClosedCessna 140 · S Fernando, CANTSB OAK70D0120Accident · No injuriesClosedErco 415G · Lone Pine, CANTSB LAX70D0066Accident · No injuriesClosedLuscombe 8F · San Frnando, CANTSB OAK69D0259Accident · No injuriesClosedCessna 140A · Exeter, CANTSB OAK69A0059Accident · 1 fatalClosedLuscombe 8F · Novato, CANTSB LAX69D0228Accident · No injuriesClosedAlon A-2 · Riverside, CANTSB LAX69A0029Accident · 1 fatalClosedAlon A-2 · Lockwood, CANTSB OAK69D0051Accident · No injuriesClosedAeronca 7EC · Fremont, CANTSB OAK68D0353Accident · No injuriesClosedAeronca 7EC · Eureka, CANTSB OAK68D0317Accident · No injuriesClosedCessna 140 · Oceano, CANTSB LAX68F0212Accident · No injuriesClosedLuscombe 8F · Santa Monic, CANTSB LAX68F0165Accident · Minor injuriesClosedAlon A-2 · El Monte, CANTSB LAX68F0160Accident · No injuriesClosedChampion 7FC · Lancaster, CANTSB LAX68F0003Accident · Minor injuriesClosedLuscombe 8F · Chino, CANTSB OAK67D0335Accident · No injuriesClosedChampion 7FC · San Carlos, CANTSB LAX67F0408Accident · No injuriesClosedCessna 140A · Santa Ana, CANTSB LAX67D0141Accident · No injuriesClosedCessna 140 · San Diego, CANTSB LAX67D0076Accident · No injuriesClosedCessna 140A · Daggett, CANTSB OAK67D0030Accident · No injuriesClosedAeronca 7EC · San Francisco, CANTSB OAK67F0021Accident · No injuriesClosedChampion 7FC · Concord, CANTSB OAK67D0009Accident · No injuriesClosedErcoupe 415-C · S.Luis Obispo, CANTSB OAK66D0214Accident · No injuriesClosedChampion 7EC · Oakland, CANTSB LAX66F0256Accident · No injuriesClosedChampion 7FC · Santa Monica, CANTSB LAX66D0209Accident · Minor injuriesClosedChampion 7FC · San Diego, CANTSB LAX66D0199Accident · No injuriesClosedCessna 140 · San Diego, CANTSB LAX66D0101Accident · No injuriesClosedLuscombe 8F · Torrance, CA