NTSB investigations: Lycoming GO-480 series, 2016

4 cases on aircraft whose registry engine model is Lycoming GO-480 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 per year

19642026
NTSB investigations: Lycoming GO-480 series, 2016 per year, 1964–2026: 198 cases
19646
19656
19667
196710
19687
19696
19708
19712
19724
19734
19749
19755
19766
19775
19788
19799
19807
19814
19823
19835
19841
19853
19862
19871
19884
19902
19915
19923
19942
19956
19964
19972
19981
19992
20001
20012
20022
20042
20052
20062
20071
20081
20094
20111
20121
20132
20142
20153
20164
20183
20192
20201
20231
20252

Latest cases

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 year(c.\"eventDate\") = 2016
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41527'))
  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.