NTSB investigations: Lycoming I0360 series, NC

66 cases on aircraft whose registry engine model is Lycoming I0360 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\" = 'NC' 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 ('41515'))
  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 IAD73FLJ35Accident · No injuriesClosedMooney M20E · Evergreen, NCJun 6, 1973 · N3233F · Substantial damageNTSB IAD73DKM37Accident · No injuriesClosedPiper PA-28R · Winston Salem, NCMay 5, 1973 · N7435J · Substantial damageNTSB NYC72FLJ21Accident · No injuriesClosedMooney M20E · Gates, NCJan 16, 1972 · N3233F · Substantial damageNTSB IAD71FLJ20Accident · No injuriesClosedMooney M20F · Pinehurst, NCApr 18, 1971 · N9390V · Substantial damageNTSB IAD71DKM02Accident · No injuriesClosedMooney M20F · Winston-Salem, NCJul 16, 1970 · N3417N · Substantial damageNTSB IAD70AI052Accident · 1 fatalClosedPiper J3C-65 · Asheboro, NCMar 22, 1970 · N1112X · DestroyedNTSB IAD70F0065Accident · No injuriesClosedPiper PA-28R · Statesville, NCSep 16, 1969 · N9302N · Substantial damageNTSB DIA70D0037Accident · No injuriesClosedPiper PA-28 · Franklin, NCAug 2, 1969 · N7532J · Substantial damageNTSB DIA69A0035Accident · Minor injuriesClosedPiper PA-28 · Wadesboro, NCJan 21, 1969 · N7595J · Substantial damageNTSB DIA68F0177Accident · No injuriesClosedMooney M20F · Concord, NCFeb 18, 1968 · N2921L · Substantial damageNTSB DIA68F0110Accident · No injuriesClosedBeech D95A · Greensboro, NCNov 11, 1967 · N5670K · Substantial damageNTSB DIA68D0021Accident · No injuriesClosedMooney M20E · Coats, NCJun 13, 1967 · N6033Q · Substantial damageNTSB DIA68F0011Accident · No injuriesClosedMooney M20E · Greensboro, NCJun 5, 1967 · N5976Q · Substantial damageNTSB DIA67F0021Accident · No injuriesClosedBeech A23 · High Point, NCJan 25, 1967 · N5682S · Substantial damageNTSB MIA67F0183Accident · No injuriesClosedMooney M20E · Buies Creek, NCOct 2, 1966 · N1937Y · Substantial damageNTSB MIA66F0554Accident · No injuriesClosedBeech D95A · Winston-Salem, NCMay 23, 1966 · N8595M · Substantial damage