NTSB investigations: Beech A23-24, FL

8 cases on aircraft the registry lists as Beech A23-24. 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

19692026

NTSB investigations: Beech A23-24, FL per year, 1969–2026: 8 cases
1969	1
1972	1
1975	2
1976	1
1977	1
1989	1
2011	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."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151226')) 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.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151226'))
  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."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151226'))
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 ERA11LA112Accident · Serious injuriesLimited investigationFinal reportBeech A23-24 · Venice, FLThe loss of engine power for undetermined reasons.Jan 12, 2011 · N3670Q · Substantial damage NTSB MIA89FA078Accident · Serious injuriesField investigationFinal reportBeech A23-24 · Clearwater, FLFuel starvation due to the CFI depleting the fuel supply from one of two tanks and failing to select the fullest tank for landing. Contributing to the accident was the cfi's improper decision to turn back to the airport when insufficient altitude was…Feb 4, 1989 · N3697Q · Destroyed NTSB MIA78FA024Accident · 4 fatalClosedBeech A24 · Alachua, FLDec 27, 1977 · N6962Q · Destroyed NTSB MIA76DLA36Accident · No injuriesClosedBeech A23-24 · Chipley, FLFeb 17, 1976 · N3685Q · Substantial damage NTSB MIA76DLD26Accident · No injuriesClosedBeech A23-24 · Vero Beach, FLOct 21, 1975 · N6953Q · Substantial damage NTSB MIA75AM075Accident · 2 fatalClosedBeech A23-24 · Sarasota, FLApr 25, 1975 · N5776V · Destroyed NTSB MIA73FKT09Accident · No injuriesClosedBeech A23-24 · Sanibel, FLJul 30, 1972 · N4739J · Substantial damage NTSB MIA70F0260Accident · No injuriesClosedBeech A23 · Opa Locka, FLDec 27, 1969 · N3647Q · Substantial damage