NTSB investigations: Lycoming 0-290 series, TX

88 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\" = 'TX' 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 FTW72FRA08Accident · Minor injuriesClosedTaylorcraft BC12-D · Bryan, TXSep 5, 1971 · N95689 · Substantial damageNTSB FTW71FRA42Accident · Minor injuriesClosedPiper PA-22 · Dayton, TXMar 22, 1971 · N945A · Substantial damageNTSB FTW71DQG54Accident · No injuriesClosedPiper PA-22 · Ozona, TXFeb 12, 1971 · N1128C · Substantial damageNTSB FTW71FQG43Accident · No injuriesClosedPiper PA-22 · Denver City, TXNov 4, 1970 · N8875C · Substantial damageNTSB FTW71FPD10Accident · Serious injuriesClosedPiper PA-22 · Mineral Wells, TXAug 9, 1970 · N2557A · No damageNTSB FTW71FRA10Accident · No injuriesClosedPiper PA-20 · League City, TXAug 2, 1970 · N7010K · Substantial damageNTSB FTW70DQG17Accident · No injuriesClosedPiper PA-18 · Wayside, TXMay 28, 1970 · N3597A · Substantial damageNTSB FTW70DRG37Accident · No injuriesClosedPiper PA-18 · Norias, TXApr 21, 1970 · N21AA · Substantial damageNTSB FTW70FBG07Accident · Minor injuriesClosedPiper PA-22 · Port Lavaca, TXJan 17, 1970 · N8611C · Substantial damageNTSB FTW70D0239Accident · No injuriesClosedPiper PA-20 · Nacogdoches, TXAug 24, 1969 · N7001K · Substantial damageNTSB DEN69D0197Accident · No injuriesClosedPitts Spcl SC-1 · El Paso, TXMar 16, 1969 · N43S · Substantial damageNTSB FTW69F0433Accident · No injuriesClosedPiper PA-22 · Bay City, TXMar 13, 1969 · N3409A · Substantial damageNTSB FTW69D0375Accident · No injuriesClosedTaylorcraft BC12-D · Mcgregor, TXJan 23, 1969 · N95689 · Substantial damageNTSB FTW68D0524Accident · No injuriesClosedPiper PA-22 · Levelland, TXMar 27, 1968 · N1452A · Substantial damageNTSB FTW68D0356Accident · No injuriesClosedPiper PA-18 · Canyon, TXOct 20, 1967 · N1152C · Substantial damageNTSB FTW68D0116Accident · No injuriesClosedAeronca 7GC · Imperial, TXJul 19, 1967 · N4844E · Substantial damageNTSB FTW68D0069Accident · No injuriesClosedPiper J3C-65 · Canyon, TXJul 6, 1967 · N70653 · Substantial damageNTSB FTW68F0081Accident · Serious injuriesClosedPiper PA-22 · Sherman, TXJun 24, 1967 · N8627C · Substantial damageNTSB FTW68D0080Accident · No injuriesClosedPiper PA-20 · Friendswood, TXJun 21, 1967 · N7756K · Substantial damageNTSB FTW68D0037Accident · No injuriesClosedPiper PA-22 · Dallas, TXJun 1, 1967 · N2615A · Substantial damageNTSB FTW67F0561Accident · No injuriesClosedPiper PA-18 · Dalhart, TXApr 18, 1967 · N8673C · Substantial damageNTSB FTW68F0246Accident · Minor injuriesClosedPiper PA-22 · Dallas, TXNov 19, 1966 · N3238B · Substantial damageNTSB FTW67F0303Accident · No injuriesClosedPiper PA-22 · Addison, TXNov 13, 1966 · N8627C · Substantial damageNTSB FTW67F0388Accident · No injuriesClosedCessna 140 · Lipan, TXAug 18, 1966 · N1722V · Substantial damageNTSB FTW67D0018Accident · No injuriesClosedPiper PA-22 · Levelland, TXMay 18, 1966 · N3555A · Substantial damageNTSB FTW66D0548Accident · No injuriesClosedReynolds JCR-1 · Big Spring, TXFeb 27, 1966 · N9001Z · Substantial damageNTSB FTW66D0492Accident · No injuriesClosedPiper PA-22 · Sunray, TXJan 26, 1966 · N3564A · Substantial damageNTSB FTW66D0441Accident · No injuriesClosedPiper PA-22 · Amarillo, TXNov 26, 1965 · N3382B · Substantial damageNTSB FTW66F0228Accident · Minor injuriesClosedPiper PA-18 · Booker, TXAug 21, 1965 · N256T · Substantial damageNTSB FTW66F0215Accident · No injuriesClosedPiper PA-22 · Big Lake, TXAug 1, 1965 · N8740C · Substantial damageNTSB UNK65X1400Accident · No injuriesClosedPiper PA-18 · Kingsville, TXFeb 7, 1965 · N3512A · Substantial damageNTSB UNK65X1382Accident · No injuriesClosedPiper PA-22 · Seminole, TXFeb 1, 1965 · N8131C · Substantial damageNTSB UNK65X1024Accident · No injuriesClosedPiper PA22 · Sanford, TXDec 16, 1964 · N3751A · Substantial damageNTSB UNK65X0653Accident · No injuriesClosedPiper PA22 · Fort Mckavett, TXNov 11, 1964 · N2386A · Substantial damageNTSB UNK64X3771Accident · No injuriesClosedPiper PA16 · Cotulla, TXSep 4, 1964 · N6803K · Substantial damageNTSB UNK64X2240Accident · No injuriesClosedPiper PA18 · Peacock, TXJun 12, 1964 · N1073A · DestroyedNTSB UNK64X0995Accident · Minor injuriesClosedPiper PA22 · Sweetwater, TXMar 20, 1964 · N2557A · Substantial damageNTSB UNK64X0958Accident · No injuriesClosedPiper PA20 · Anson, TXMar 16, 1964 · N7652K · Substantial damage