NTSB investigations: Lycoming 0-290 series, CA
128 cases on aircraft whose registry engine model is Lycoming 0-290 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 ('41506'))
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 ('41506'))
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 LAX81FVG09Accident · No injuriesClosedStits SA11A · Red Bluff, CANTSB LAX80FUQ23Accident · No injuriesClosedPiper PA-12 · Van Nuys, CANTSB LAX80FUQ08Accident · 2 fatalClosedCulver LCA · Mojave, CANTSB LAX80DVG08Accident · No injuriesClosedPiper PA-18 · Colusa, CANTSB LAX79FVG77Accident · 2 fatalClosedDouglas VJ22 · Courtland, CANTSB OAK79DVD28Accident · No injuriesClosedPiper PA-22 · Brentwood, CANTSB OAK79FVM08Accident · 1 fatalClosedStarduster 1 · Santa Cruz, CANTSB OAK79DXQ04Accident · No injuriesClosedPiper PA-22 · Blue Canyon, CANTSB OAK78FVG71Accident · No injuriesClosedPiper PA-22 · Fair Oaks, CANTSB OAK78DVA54Accident · No injuriesClosedPiper PA-18 · Coalinga, CANTSB LAX78FUG34Accident · 2 fatalClosedMustang II · Norco, CANTSB LAX78FA043Accident · 1 fatalClosedPiper PA-18 · Upland, CANTSB OAK78FVM19Accident · Serious injuriesClosedMustang Mini · San Jose, CANTSB LAX78FUM19Accident · Minor injuriesClosedPiper PA-22 · Santee, CANTSB LAX78FUG18Accident · No injuriesClosedPiper PA-22 · San Bernardino, CANTSB LAX78FUG15Accident · Minor injuriesClosedCallair A-2 · Lucerne Valley, CANTSB LAX78FA019Accident · 3 fatalClosedPiper PA-22 · Devore, CANTSB LAX77FVM24Accident · No injuriesClosedPiper PA-22 · S.Luis Obispo, CANTSB LAX77FUQ37Accident · No injuriesClosedSpezio 1 · Goleta, CANTSB OAK77DVA39Accident · No injuriesClosedLuscombe 8E · Fresno, CANTSB LAX77DUM30Accident · Serious injuriesClosedPiper PA-22 · Descanso, CANTSB OAK77DVA24Accident · No injuriesClosedPiper PA-20 · Mariposa, CANTSB LAX77FUQ02Accident · No injuriesClosedPiper PA-22 · Lancaster, CANTSB LAX76FUA27Accident · Minor injuriesClosedCessna 140 · Dana Point, CANTSB OAK76DVG46Accident · No injuriesClosedPiper PA-22 · Auburn, CANTSB LAX75DUQ26Accident · No injuriesClosedPiper PA-22 · Castaic, CANTSB LAX75DUM13Accident · Minor injuriesClosedPiper PA-22 · Julian, CANTSB LAX75AUM05Accident · No injuriesClosedPiper PA-20 · Santee, CANTSB LAX74FUA24Accident · No injuriesClosedPiper PA-22 · Long Beach, CANTSB LAX74FUD05Accident · No injuriesClosedPiper PA-22 · Compton, CANTSB LAX74DUG39Accident · No injuriesClosedSpezio DAL-1 · Redlands, CANTSB LAX73DUG30Accident · No injuriesClosedPiper PA-22 · Bg Bear Cty, CANTSB LAX73FUQ16Accident · 2 fatalClosedCougar A · Lancaster, CANTSB OAK73FVA22Accident · No injuriesClosedPiper PA-22 · Riverdale, CANTSB LAX73DUQ08Accident · Minor injuriesClosedPiper PA-22 · Van Nuys, CANTSB OAK72DVG67Accident · No injuriesClosedPiper PA-18A · Lincoln, CANTSB LAX72FUA35Accident · Minor injuriesClosedPiper PA-22 · Hntngtn Bch, CANTSB LAX72FUQ72Accident · Serious injuriesClosedFunk B85C · Pacoima, CANTSB LAX72DUQ45Accident · No injuriesClosedPiper PA-22 · Lancaster, CANTSB OAK71DVG78Accident · No injuriesClosedThorp T-18 · Lake Head, CANTSB LAX71DUM40Accident · No injuriesClosedPiper PA-22 · Jacumba, CANTSB LAX71FUQ79Accident · No injuriesClosedPiper PA-22 · Quartz Hill, CANTSB LAX71FUA40Accident · No injuriesClosedCessna 140 · Long Beach, CANTSB OAK71DVD03Accident · No injuriesClosedInterstate S-1B1 · Tracy, CANTSB OAK70F0181Accident · 1 fatalClosedPiper PA-18A · Maxwell, CANTSB LAX70D0154Accident · No injuriesClosedCougar DM-1 · Chino, CANTSB LAX70F0152Accident · Serious injuriesClosedPiper PA-12 · 29 Palms, CANTSB OAK70D0024Accident · No injuriesClosedCougar 125-A · Lower Lake, CANTSB LAX69D0342Accident · No injuriesClosedPiper PA-20 · San Diego, CANTSB OAK69D0258Accident · No injuriesClosedPiper PA-22 · La Selva Bch, CA