Final NTSB investigations: Beech 58, 2016

2 cases on aircraft the registry lists as Beech 58. 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
Final NTSB investigations: Beech 58, 2016 per year, 1964–2026: 279 cases
19641
19671
19711
19726
19731
19742
19757
19765
19779
19788
197913
19806
19818
198211
19839
19847
19856
19863
198710
19883
19896
19905
19916
19928
19938
19945
19957
19966
19973
19987
19996
200010
20016
20027
20034
20043
20053
20061
20077
20081
20093
20106
20115
20128
20133
20154
20162
20173
20183
20191
20225
20231
20246
20263

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.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1152740'))
  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.