NTSB investigations: Beech A23

7 cases on aircraft the registry lists as Beech A23, where the first occurrence was “Loss of control - in flight”. 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

19852026

NTSB investigations: Beech A23 per year, 1985–2026: 7 cases
1985	1
1988	1
1995	1
1996	1
2001	2
2003	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151204') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151204')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151204')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 NYC04CA019Accident · Serious injuriesData collectionFinal reportBeech A23 · Salem, NJThe pilot's delay in aborting the takeoff after his failure to obtain a proper climb rate. Factors related to the accident were the tailwind conditions, and the wet turf runway.Nov 1, 2003 · N8772M · Substantial damage NTSB CHI01FA297Accident · 3 fatalField investigationFinal reportBeech A23 · Stevens Point, WIthe pilot not obtaining/maintaining aircraft control.Aug 30, 2001 · N3516R · Destroyed NTSB MIA01FA223Accident · 3 fatalField investigationFinal reportBeech A23 · Blairsville, GAThe failure of the pilot to maintain airspeed resulting in an inadvertent stall an subsequent in-flight collision with trees then the ground during the uncontrolled descent.Aug 19, 2001 · N8869M · Destroyed NTSB FTW97LA056Accident · No injuriesLimited investigationFinal reportBeech A23 · Conway, ARthe pilot's inadequate compensation for the crosswind during the landing, and his failure to remain clear of the tree during the attempted go-around. The crosswind and the proximity of the small tree were related factors.Dec 7, 1996 · N3597R · Substantial damage NTSB CHI95LA206Accident · Serious injuriesLimited investigationFinal reportBeech 23A · Spearfish, SDThe pilot's failure to maintain flying speed resulting in an aerodynamic stall. Factors associated with this accident were remedial action by the pilot was not possible due to the low altitude at which the stall took place.Jul 2, 1995 · N2397Q · Destroyed NTSB MKC88LA149Accident · No injuriesLimited investigationFinal reportBeech C23 · Crete, NEThe student pilot said he lost control shortly after liftoff while attempting a soft field takeoff. The acft made an uncontrolled descent to the terrain on a farm field adjacent the airstrip, causing substantial damage to the acft, but no injuries to the…Aug 5, 1988 · N3566R · Substantial damage NTSB SEA85LA210Accident · Serious injuriesLimited investigationFinal reportBeech A23 · Winnemucca, NVThe student had recently purchased the acft. On 9/5/85, an instructor plt, who had delivered the acft to the Winnemucca arpt, gave the student a total of 0.4 hr dual instruction, which included 2 landings. The instructor then indorsed the student's log book…Sep 10, 1985 · N2377J · Destroyed