Skip to content

NTSB investigations: Beech A23, CA

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

19652026

Where

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 ('1151204')) 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 ('1151204'))
  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 ('1151204'))
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 GAA17CA148Accident · Serious injuriesData collectionFinal reportBeech A23 · Beckwourth, CAThe student pilot’s inadvertent use of the control yoke to correct for a drift and his subsequent failure to maintain directional control during takeoff.Feb 14, 2017 · N425RS · Substantial damage NTSB SEA08CA049Accident · No injuriesData collectionFinal reportBeech A23 · Death Valley, CAThe pilot's improper flare during landing.Nov 29, 2007 · N8770M · Substantial damage NTSB LAX06FA055Accident · 2 fatalField investigationFinal reportBeech A23 · Mammoth Lakes, CAa loss of engine power for undetermined reasons, and, the failure of the pilot to maintain an adequate airspeed while maneuvering following the loss of power, which resulted in a stall/spin.Dec 12, 2005 · N3590R · Destroyed NTSB LAX05LA258Accident · Serious injuriesLimited investigationFinal reportBeech A23 · Rancho Murieta, CAfuel starvation due to the inadequate fuel system management by both pilots. Also causal was the inadequate preflight inspection by both the instructor and student and their failure to verify the fuel quantities in each fuel tank, and, the instructor's…Aug 3, 2005 · N1456L · Substantial damage NTSB LAX92LA250Accident · No injuriesLimited investigationFinal reportBeech A-23 · Willows, CAThe pilot's poorly planned approach. Contributing to this accident was the pilot misjudged the flare altitude and failed to maintain the proper airspeed.Jun 16, 1992 · N1482L · Substantial damage NTSB LAX90LA037Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Reedley, CAPilot's improper recovery from a bounce landing.Nov 18, 1989 · N3551R · Substantial damage NTSB LAX88FA114Accident · 2 fatalField investigationFinal reportBeech A23 · Big Bear City, CAThe passenger told friends that the pilot was going to perform some aerobatic maneuvers near the lodge where they were staying. The other residents in the lodge reported that the airplane flew very low over the house and proceeded towards the east. After…Feb 20, 1988 · N1461L · Destroyed NTSB OAK74FVG23Accident · No injuriesClosedBeech A23A · Fair Oaks, CAJan 23, 1974 · N8893M · Substantial damage NTSB LAX71DUM12Accident · No injuriesClosedBeech A23 · San Diego, CAAug 25, 1970 · N148SL · Substantial damage NTSB OAK70A0033Accident · 3 fatalClosedBeech B23 · Angels Camp, CADec 26, 1969 · N3565R · Destroyed NTSB OAK69D0173Accident · No injuriesClosedBeech A23 · San L Obispo, CAOct 7, 1968 · N1450L · Substantial damage NTSB LAX68F0335Accident · No injuriesClosedBeech A23 · March Field, CAFeb 17, 1968 · N3589R · Substantial damage NTSB LAX68D0284Accident · No injuriesClosedBeech A23 · Julian, CAJan 14, 1968 · N8794M · Destroyed NTSB OAK68D0175Accident · No injuriesClosedBeech A23 · Plsnt Grove, CAAug 28, 1967 · N2377J · Substantial damage NTSB LAX68D0068Accident · No injuriesClosedBeech A23 · El Centro, CAJul 28, 1967 · N8897M · Substantial damage NTSB LAX68D0019Accident · No injuriesClosedBeech A23 · Imperial, CAMay 25, 1967 · N8897M · Substantial damage NTSB OAK67D0267Accident · No injuriesClosedBeech A23 · Gualala, CAFeb 26, 1967 · N8874M · Substantial damage NTSB LAX67A0061Accident · 1 fatalClosedBeech 23 · Chatsworth, CADec 23, 1966 · N3556R · 2 aircraft · Substantial damage NTSB OAK67D0088Accident · No injuriesClosedBeech A23 · Auburn, CASep 27, 1966 · N8753M · Substantial damage NTSB LAX67F0093Accident · No injuriesClosedBeech A23 · Catalina Isle, CAJul 12, 1966 · N3588R · Substantial damage NTSB LAX67D0003Accident · No injuriesClosedBeech 23 · Upland, CAJun 5, 1966 · N1456L · Substantial damage NTSB LAX66D0353Accident · No injuriesClosedBeech A23 · Kernville, CAMay 6, 1966 · N8794M · Substantial damage NTSB OAK66F0104Accident · No injuriesClosedBeechcraft A23 · Auburn, CAOct 10, 1965 · N8753M · Substantial damage NTSB LAX66F0060Accident · No injuriesClosedBeechcraft A-23 · Pixley, CAAug 13, 1965 · N8897M · Substantial damage