Fatal NTSB investigations: Beech A23A

11 cases on aircraft the registry lists as Beech A23A. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19672026

Fatal NTSB investigations: Beech A23A per year, 1967–2026: 11 cases
1967	1
1970	2
1973	1
1974	1
1976	1
1979	1
1982	1
1996	1
2005	1
2007	1

Where

Open the map

Latest cases

Query with SQL

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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151208')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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

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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151208'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB DEN07FA071Accident · 1 fatalField investigationFinal reportBeech A23A · Holman, NMThe pilot's failure to maintain a safe altitude and clearance, and his improper inflight planning/decision to postpone initiating a climbing turn to avoid obstructions.Mar 13, 2007 · N4761J · Destroyed NTSB NYC05WA064Accident · 3 fatalForeign investigationBeech A23A · Ottengruner, GermanyMar 26, 2005 · N4705J · Substantial damage NTSB MIA96FA099Accident · 1 fatalField investigationFinal reportBeech A23A · Sarasota, FLThe pilot's failure to maintain airspeed while maneuvering (VSO) resulting in an inadvertent in-flight loss of control (stall/spin) and subsequent in-flight collision with terrain.Mar 15, 1996 · N2300W · Destroyed NTSB CHI82FA032Accident · 1 fatalField investigationFinal reportBeech A23A · London, OHThe pilot received two weather briefings for a flight from columbus to springfield, Ohio. VFR flight was not recommended. The pilot took off after the tower closed at 2300 EST. At about 2341 a witness near the crash site heard the loud sound of an aircraft…Jan 24, 1982 · N6940Q · Destroyed NTSB MIA79DA043Accident · 2 fatalClosedBeech A23A · Missing AircraftJan 11, 1979 · N925RZ · Destroyed NTSB FTW76AF078Accident · 4 fatalClosedBeech A23A · Goliad, TXMar 23, 1976 · N2315W · Destroyed NTSB MIA74AM074Accident · 3 fatalClosedBeech A23A · Brooks, GAFeb 24, 1974 · N3655Q · Destroyed NTSB CHI74AC054Accident · 4 fatalClosedBeech A23A · Cabery, ILDec 28, 1973 · N2303W · Destroyed NTSB SEA71AS014Accident · 3 fatalClosedBeech A23A · Medford, ORSep 13, 1970 · N2355W · Destroyed NTSB NYC70AN104Accident · 2 fatalClosedBeech A23A · Montgomeryvlle, PAMar 24, 1970 · N5956S · Destroyed NTSB MIA67A0103Accident · 3 fatalClosedBeech A23 · Hattiesburg, MSMar 31, 1967 · N2345W · Destroyed