Final NTSB investigations: Beech 95-B55 (T42A), 2002

4 cases on aircraft the registry lists as Beech 95-B55 (T42A). 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 95-B55 (T42A), 2002 per year, 1964–2026: 333 cases
19644
196510
19669
196712
19689
19698
19709
19718
19723
197311
19746
19758
19768
19777
19785
19798
198011
19815
19827
19839
19849
19855
19868
19875
19882
19897
19905
19913
19926
19932
19944
19953
19967
19979
19983
19994
20006
20017
20024
20036
20044
20057
20062
20074
20085
20091
20104
20116
20122
20133
20142
20151
20164
20173
20183
20195
20202
20212
20224
20231
20242
20254

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\") = 2002
    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 ('1152706'))
  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.