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.

NTSB LAX81FVG09Accident · No injuriesClosedStits SA11A · Red Bluff, CADec 12, 1980 · N9708A · Substantial damageNTSB LAX80FUQ23Accident · No injuriesClosedPiper PA-12 · Van Nuys, CAAug 19, 1980 · N3164M · Substantial damageNTSB LAX80FUQ08Accident · 2 fatalClosedCulver LCA · Mojave, CAJan 19, 1980 · N41701 · DestroyedNTSB LAX80DVG08Accident · No injuriesClosedPiper PA-18 · Colusa, CADec 1, 1979 · N2663A · Substantial damageNTSB LAX79FVG77Accident · 2 fatalClosedDouglas VJ22 · Courtland, CASep 3, 1979 · N96315 · DestroyedNTSB OAK79DVD28Accident · No injuriesClosedPiper PA-22 · Brentwood, CAMay 1, 1979 · N931A · Substantial damageNTSB OAK79FVM08Accident · 1 fatalClosedStarduster 1 · Santa Cruz, CAJan 6, 1979 · N88991 · DestroyedNTSB OAK79DXQ04Accident · No injuriesClosedPiper PA-22 · Blue Canyon, CANov 26, 1978 · N2673A · Substantial damageNTSB OAK78FVG71Accident · No injuriesClosedPiper PA-22 · Fair Oaks, CAAug 5, 1978 · N3562A · Substantial damageNTSB OAK78DVA54Accident · No injuriesClosedPiper PA-18 · Coalinga, CAJun 29, 1978 · N1045A · Substantial damageNTSB LAX78FUG34Accident · 2 fatalClosedMustang II · Norco, CAJun 17, 1978 · N5SH · DestroyedNTSB LAX78FA043Accident · 1 fatalClosedPiper PA-18 · Upland, CAMay 22, 1978 · N1256A · DestroyedNTSB OAK78FVM19Accident · Serious injuriesClosedMustang Mini · San Jose, CAApr 29, 1978 · N2736 · DestroyedNTSB LAX78FUM19Accident · Minor injuriesClosedPiper PA-22 · Santee, CAApr 16, 1978 · N8682C · Substantial damageNTSB LAX78FUG18Accident · No injuriesClosedPiper PA-22 · San Bernardino, CAFeb 25, 1978 · N1418C · Substantial damageNTSB LAX78FUG15Accident · Minor injuriesClosedCallair A-2 · Lucerne Valley, CAJan 27, 1978 · N27N · Substantial damageNTSB LAX78FA019Accident · 3 fatalClosedPiper PA-22 · Devore, CAJan 4, 1978 · N1511P · DestroyedNTSB LAX77FVM24Accident · No injuriesClosedPiper PA-22 · S.Luis Obispo, CAAug 19, 1977 · N2278A · Substantial damageNTSB LAX77FUQ37Accident · No injuriesClosedSpezio 1 · Goleta, CAJul 10, 1977 · N21HM · Substantial damageNTSB OAK77DVA39Accident · No injuriesClosedLuscombe 8E · Fresno, CAJun 25, 1977 · N1807K · Substantial damageNTSB LAX77DUM30Accident · Serious injuriesClosedPiper PA-22 · Descanso, CAJun 14, 1977 · N6034V · Substantial damageNTSB OAK77DVA24Accident · No injuriesClosedPiper PA-20 · Mariposa, CAMar 11, 1977 · N1592A · Substantial damageNTSB LAX77FUQ02Accident · No injuriesClosedPiper PA-22 · Lancaster, CAOct 17, 1976 · N8625C · Substantial damageNTSB LAX76FUA27Accident · Minor injuriesClosedCessna 140 · Dana Point, CAApr 27, 1976 · N2031N · Substantial damageNTSB OAK76DVG46Accident · No injuriesClosedPiper PA-22 · Auburn, CAFeb 28, 1976 · N3780A · Substantial damageNTSB LAX75DUQ26Accident · No injuriesClosedPiper PA-22 · Castaic, CAApr 23, 1975 · N1228C · Substantial damageNTSB LAX75DUM13Accident · Minor injuriesClosedPiper PA-22 · Julian, CAJan 6, 1975 · N1327C · Substantial damageNTSB LAX75AUM05Accident · No injuriesClosedPiper PA-20 · Santee, CASep 5, 1974 · N7387K · Substantial damageNTSB LAX74FUA24Accident · No injuriesClosedPiper PA-22 · Long Beach, CAJun 23, 1974 · N3523A · Substantial damageNTSB LAX74FUD05Accident · No injuriesClosedPiper PA-22 · Compton, CAMar 8, 1974 · N1542P · Substantial damageNTSB LAX74DUG39Accident · No injuriesClosedSpezio DAL-1 · Redlands, CAJan 26, 1974 · N21HM · Substantial damageNTSB LAX73DUG30Accident · No injuriesClosedPiper PA-22 · Bg Bear Cty, CAJan 20, 1973 · N8928C · Substantial damageNTSB LAX73FUQ16Accident · 2 fatalClosedCougar A · Lancaster, CANov 5, 1972 · N6151 · DestroyedNTSB OAK73FVA22Accident · No injuriesClosedPiper PA-22 · Riverdale, CAOct 1, 1972 · N2540A · Substantial damageNTSB LAX73DUQ08Accident · Minor injuriesClosedPiper PA-22 · Van Nuys, CAAug 27, 1972 · N8730C · Substantial damageNTSB OAK72DVG67Accident · No injuriesClosedPiper PA-18A · Lincoln, CAJun 4, 1972 · N2854D · Substantial damageNTSB LAX72FUA35Accident · Minor injuriesClosedPiper PA-22 · Hntngtn Bch, CAMay 10, 1972 · N3434A · Substantial damageNTSB LAX72FUQ72Accident · Serious injuriesClosedFunk B85C · Pacoima, CAApr 2, 1972 · N21DC · Substantial damageNTSB LAX72DUQ45Accident · No injuriesClosedPiper PA-22 · Lancaster, CANov 16, 1971 · N2241A · Substantial damageNTSB OAK71DVG78Accident · No injuriesClosedThorp T-18 · Lake Head, CAMay 21, 1971 · N2264B · DestroyedNTSB LAX71DUM40Accident · No injuriesClosedPiper PA-22 · Jacumba, CAMay 14, 1971 · N5344Z · Substantial damageNTSB LAX71FUQ79Accident · No injuriesClosedPiper PA-22 · Quartz Hill, CAMay 9, 1971 · N3616A · Substantial damageNTSB LAX71FUA40Accident · No injuriesClosedCessna 140 · Long Beach, CADec 11, 1970 · N2031N · Substantial damageNTSB OAK71DVD03Accident · No injuriesClosedInterstate S-1B1 · Tracy, CAAug 8, 1970 · N49208 · Substantial damageNTSB OAK70F0181Accident · 1 fatalClosedPiper PA-18A · Maxwell, CANov 22, 1969 · N1465C · DestroyedNTSB LAX70D0154Accident · No injuriesClosedCougar DM-1 · Chino, CASep 28, 1969 · N9676Z · Substantial damageNTSB LAX70F0152Accident · Serious injuriesClosedPiper PA-12 · 29 Palms, CASep 18, 1969 · N4439M · Substantial damageNTSB OAK70D0024Accident · No injuriesClosedCougar 125-A · Lower Lake, CAMay 25, 1969 · N73637 · Substantial damageNTSB LAX69D0342Accident · No injuriesClosedPiper PA-20 · San Diego, CAMay 4, 1969 · N7387K · Substantial damageNTSB OAK69D0258Accident · No injuriesClosedPiper PA-22 · La Selva Bch, CAMar 28, 1969 · N921A · Substantial damage