NTSB investigations: Beech A23-24, CA

12 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

19662026

NTSB investigations: Beech A23-24, CA per year, 1966–2026: 12 cases
1966	1
1967	2
1968	1
1969	1
1971	1
1972	2
1977	1
1984	1
1992	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" = 'CA' 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\" = 'CA' 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" = 'CA' 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 WPR11FA403Accident · No injuriesField investigationFinal reportBeech A23-24 · Palo Alto, CAThe student’s and flight instructor’s mismanagement of the fuel supply, resulting in a total loss of engine power due to fuel starvation.Aug 23, 2011 · N5779V · Substantial damage NTSB LAX92FA196Accident · 2 fatalField investigationFinal reportBeech A23-24 · Corona, CA1) The flying pilot's improper landing flare which resulted in a hard landing and significant damage to the aircraft empennage flight controls, 2) the flying pilot's decision to initiate a go around with the obvious serious damage to the aircraft, and 3) the…May 2, 1992 · N666CM · Destroyed NTSB LAX84FA259Accident · 1 fatalField investigationFinal reportBeech A23-24 · Bowman, CAOn a flt from fair oaks, CA, to reno, NV, a flt of about 1 hr 15 mins, the acft experienced a total power loss. The plt asked the pax to select the other fuel tank. The selctor handle was not attached to the valve. But the pax located the handle and turned…Apr 17, 1984 · N5676S · Destroyed NTSB LAX78FA002Accident · 2 fatalClosedBeech A23-24 · El Cajon, CAOct 22, 1977 · N4735J · Destroyed NTSB OAK73DVM11Accident · No injuriesClosedBeech A23-24 · San Jose, CASep 24, 1972 · N3649Q · Substantial damage NTSB OAK72FVD33Accident · Minor injuriesClosedBeech A23 · Concord, CAFeb 25, 1972 · N7956L · Destroyed NTSB LAX72DUG15Accident · No injuriesClosedBeech A23-24 · Salton Sea, CASep 18, 1971 · N7956L · Substantial damage NTSB LAX69F0296Accident · No injuriesClosedBeech A23-24 · S Bernrdino, CAMar 12, 1969 · N6923Q · Substantial damage NTSB OAK69D0061Accident · No injuriesClosedBeech A23-24 · Linden, CAJul 22, 1968 · N5676S · Substantial damage NTSB LAX68F0164Accident · No injuriesClosedBeech A23 · Long Beach, CAOct 9, 1967 · N4735J · Substantial damage NTSB OAK68F0155Accident · No injuriesClosedBeech A23 · S.Lke Tahoe, CAJul 24, 1967 · N5974S · Substantial damage NTSB OAK67D0144Accident · No injuriesClosedBeech A23-24 · Santa Rosa, CAOct 18, 1966 · N5779V · Substantial damage