NTSB investigations: Lycoming 0-235 series, IN

94 cases on aircraft whose registry engine model is Lycoming 0-235 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\" = 'IN' 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 ('41505'))
  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 CHI82DA055Accident · No injuriesFinal reportPiper PA-38-112 · Lebanon, INWhile the instructor was demonstrating recovery procedures from a low approach, the main gear struck snow on a small rise about 400 feet short of the runway. Subsequently, the pilot was forced to land in about 18 inches of snow and the gear failed. The…Feb 14, 1982 · N24007 · Substantial damageNTSB CHI81DEX26Accident · No injuriesClosedCessna 152 · Shelbyville, INJul 11, 1981 · N757MT · Substantial damageNTSB CHI81DEX09Accident · No injuriesClosedCessna 152 · Columbus, INJan 2, 1981 · N4691L · Substantial damageNTSB CHI81FEX05Accident · No injuriesClosedCessna 152 · Noblesville, INNov 6, 1980 · N69178 · Substantial damageNTSB CHI81FET29Accident · No injuriesClosedBellanca 7ECA · Gary, INSep 13, 1980 · N90915 · Substantial damageNTSB CHI80FEX14Accident · No injuriesClosedGrumman AA-1C · Mt Comfort, INApr 26, 1980 · N9926U · Substantial damageNTSB CHI80DET13Accident · No injuriesClosedCessna 152 · Francesville, INMar 22, 1980 · N67995 · Substantial damageNTSB CHI79FET30Accident · No injuriesClosedCessna 152 · East Chicago, INSep 9, 1979 · N24489 · Substantial damageNTSB CHI79DET29Accident · No injuriesClosedGrumman AA1C · Roselawn, INSep 8, 1979 · N9585U · Substantial damageNTSB CHI79FEX12Accident · No injuriesClosedCessna 152 · Bloomington, INDec 28, 1978 · N49417 · Substantial damageNTSB CHI78FET35Accident · Minor injuriesClosedCessna 152 · Lake Village, INSep 2, 1978 · N25035 · Substantial damageNTSB CHI78FET24Accident · No injuriesClosedEaa Biplane GB-1 · Wanatah, INJun 25, 1978 · N3GB · Substantial damageNTSB CHI78FET14Accident · No injuriesClosedGrum Amer AA-1B · Fort Wayne, INFeb 18, 1978 · N8973L · Substantial damageNTSB CHI78FET11Accident · No injuriesClosedGrum Amer AA1-B · Fort Wayne, INFeb 5, 1978 · N9892L · Substantial damageNTSB CHI77DEX35Accident · No injuriesClosedBellanca 7ECA · Lebanon, INJul 1, 1977 · N8337V · Substantial damageNTSB CHI77DET15Accident · No injuriesClosedPiper PA-16 · Roselawn, INJun 4, 1977 · N5631H · Substantial damageNTSB CHI76DET32Accident · No injuriesClosedPiper PA-18 · Valparaiso, INOct 4, 1975 · N269T · Substantial damageNTSB CHI76DEA09Accident · No injuriesClosedAmer Avco AA1-A · Anderson, INSep 20, 1975 · N9288L · Substantial damageNTSB CHI74DEA36Accident · No injuriesClosedAmer Avco AA-1B · English, INMay 2, 1974 · N8880L · Substantial damageNTSB CHI74FEA20Accident · No injuriesClosedPiper PA-22 · Monroe City, INNov 12, 1973 · N4919Z · Substantial damageNTSB CHI74DET07Accident · Minor injuriesClosedLuscombe 8F · Crown Point, INAug 31, 1973 · N1883B · Substantial damageNTSB CHI73FEA07Accident · Minor injuriesClosedAmer Avco AA1 · W.Lafayette, INAug 22, 1972 · N6115L · Substantial damageNTSB CHI70FBA02Accident · No injuriesClosedPiper PA-22 · Mooresville, INJan 15, 1970 · N4977Z · Substantial damageNTSB CHI70DBA01Accident · No injuriesClosedPiper PA-22 · Monticello, INJan 14, 1970 · N5687Z · Substantial damageNTSB CHI70F0175Accident · No injuriesClosedChampion 7ECA · Greenwood, INAug 29, 1969 · N8337V · Minor damageNTSB CHI68F0592Accident · No injuriesClosedChampion 7ECA · Gary, INFeb 6, 1968 · N5140T · Substantial damageNTSB CHI68D0399Accident · No injuriesClosedPiper PA-22 · English, INOct 30, 1967 · N5797Z · DestroyedNTSB CHI68D0349Accident · No injuriesClosedPiper PA-16 · Noblesville, INOct 1, 1967 · N5224H · Substantial damageNTSB CHI68D0067Accident · No injuriesClosedPiper PA-12 · Evansville, INMay 28, 1967 · N2952M · Substantial damageNTSB CHI67D0643Accident · No injuriesClosedPiper PA-22 · Spiceland, INApr 7, 1967 · N5070Z · Substantial damageNTSB CHI67F0478Accident · No injuriesClosedChampion 7ECA · Gary, INFeb 11, 1967 · N2569F · Substantial damageNTSB CHI66F0770Accident · No injuriesClosedPiper PA-22 · Logansport, INMay 22, 1966 · N5629Z · Substantial damageNTSB CHI66F0381Accident · No injuriesClosedPiper PA-12 · Rensselaer, INSep 25, 1965 · N7743H · Substantial damageNTSB CHI66F0140Accident · No injuriesClosedPiper PA-22 · Michigan City, INJul 25, 1965 · N4767Z · Substantial damageNTSB MKC66D0091Accident · No injuriesClosedPiper PA-12 · Valpariso, INJun 21, 1965 · N2718M · Substantial damageNTSB CHI66F0058Accident · Minor injuriesClosedPiper PA-22 · Jeffersonville, INMay 13, 1965 · N5797Z · Substantial damageNTSB CHI65D0152Accident · No injuriesClosedPiper PA-22 · Warren, INApr 11, 1965 · N5457Z · Substantial damageNTSB UNK65X0936Accident · No injuriesClosedPiper PA22 · Windfall, INDec 6, 1964 · N5687Z · Substantial damageNTSB UNK64X4080Accident · Serious injuriesClosedCommonwealt H185 · Fortville, INSep 20, 1964 · N34132 · Substantial damageNTSB UNK64X3447Accident · No injuriesClosedPiper PA22 · Marion, INAug 18, 1964 · N5348Z · Substantial damageNTSB UNK64X2460Accident · No injuriesClosedLuscombe 8A · Jeffersonvlle, INJun 24, 1964 · N2758K · Substantial damageNTSB UNK64X1203Accident · No injuriesClosedPiper PA22 · Dyer, INApr 6, 1964 · N4876Z · Substantial damageNTSB UNK64X1145Accident · No injuriesClosedPiper PA22 · Richmond, INApr 3, 1964 · N5942Z · Substantial damageNTSB UNK64X0658Accident · No injuriesClosedPiper PA22 · Lake Village, INFeb 22, 1964 · N4652Z · Substantial damage