NTSB investigations: Lycoming 0-235 series, VA

64 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\" = 'VA' 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 IAD73DID21Accident · No injuriesClosedPiper PA-22 · Chesapeake, VAMay 5, 1973 · N5475Z · Substantial damageNTSB NYC72DIA22Accident · No injuriesClosedPiper PA-12 · Warrenton, VAMay 19, 1972 · N7599H · Substantial damageNTSB IAD71DID27Accident · No injuriesClosedChampion 7ECA · Clarksville, VAJun 20, 1971 · N8376V · Substantial damageNTSB IAD71DID22Accident · No injuriesClosedPiper PA-22 · Monterey, VAMar 31, 1971 · N5703Z · Substantial damageNTSB IAD70FID07Accident · Minor injuriesClosedChampion 7ECA · Milford, VAFeb 12, 1970 · N9644S · Substantial damageNTSB DIA69D0191Accident · Minor injuriesClosedPiper PA-12 · Gladstone, VAApr 21, 1969 · N3248M · Substantial damageNTSB DIA69D0169Accident · Minor injuriesClosedPiper PA-22 · Bowers Hill, VAMar 23, 1969 · N4686Z · Substantial damageNTSB DIA68A0010Accident · 2 fatalClosedCessna 182 · Tangier, VAAug 28, 1967 · N3546U · 2 aircraft · DestroyedNTSB DIA67D0013Accident · No injuriesClosedPiper PA-12 · Lynchburg, VADec 17, 1966 · N3248M · Substantial damageNTSB NYC67F0036Accident · Serious injuriesClosedPiper PA-12 · Chesapeake, VAJun 21, 1966 · N4222M · Substantial damageNTSB NYC66F0395Accident · No injuriesClosedPiper PA-24 · Lunenburg, VADec 29, 1965 · N5911Z · Substantial damageNTSB NYC66F0216Accident · No injuriesClosedPiper PA-22 · West Point, VASep 9, 1965 · N5837Z · Substantial damageNTSB UNK65X0394Accident · No injuriesClosedPiper PA22 · Roanoke, VAOct 24, 1964 · N4537Z · Substantial damageNTSB UNK64X0593Accident · 1 fatalClosedPiper PA22 · Sandston, VAFeb 17, 1964 · N5585Z · Minor damage