NTSB investigations: Beech 23, CA
21 cases on aircraft the registry lists as Beech 23. 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.
Cases per year
| 1964 | 5 |
|---|---|
| 1965 | 3 |
| 1966 | 4 |
| 1967 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 1988 | 1 |
| 1992 | 1 |
| 1998 | 1 |
| 2010 | 1 |
| 2023 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 ('1151202'))
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 ('1151202'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 WPR24LA032IncidentClass 3 · LimitedInvestigation openBeech 23 · Santa Ynez, CANTSB WPR10CA175Accident · No injuriesData collectionFinal reportBeech 23 · Twenty Nine Palms, CAThe pilot's encounter with a wind shear/downdraft that exceeded the climb performance capabilities of the airplane during initial climb.NTSB LAX99LA062Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Furnace Creek, CAThe pilot's inadequate preflight inspection when he failed to remove the gust lock from the flight controls.NTSB LAX92FA313Accident · 3 fatalField investigationFinal reportBeech 23 · Fall River Mill, CAThe pilots decision to turn down wind at a critical phase of the go around with inadequate airspeed resulting in a stall mush uncontrolled descent. Contributing to the accident was the unfavorable wind conditions and a stabilator interference caused by a…NTSB LAX89LA026Accident · No injuriesLimited investigationFinal reportBeech 23 · San Carlos, CADuring a telephone interview the pilot stated that he landed too FAR down runway 12. He said that when he considered going around, he was already committed to complete the landing. Winds at the time of the accident were reported to be from 360 degrees at 5…NTSB LAX74AL043Accident · 3 fatalClosedBeech 23 · Gorman, CANTSB OAK71FVD45Accident · Serious injuriesClosedBeech 23 · Petaluma, CANTSB OAK71DVM09Accident · No injuriesClosedBeech A23 · H.Moon Bay, CANTSB LAX68D0237Accident · Minor injuriesClosedBeech A23 · Bakersfield, CANTSB OAK67F0068Accident · No injuriesClosedBeech 23 · Bishop, CANTSB OAK67F0004Accident · No injuriesClosedBeech M23 · Vacauille, CANTSB LAX67D0033Accident · No injuriesClosedBeech 23 · Eagle Mtn., CANTSB OAK66F0202Accident · No injuriesClosedBeechcraft 23 · Concord, CANTSB OAK66D0155Accident · No injuriesClosedBeechcraft 23 · Santa Cruz, CANTSB OAK66F0075Accident · Minor injuriesClosedBeechcraft M-23 · Angels Camp, CANTSB LAX66D0035Accident · No injuriesClosedBeechcraft 23 · Long Beach, CANTSB UNK65X0555Accident · No injuriesClosedBeechcraft 23 · Fresno, CANTSB UNK64X3781Accident · Serious injuriesClosedBeechcraft 23 · Tracy, CANTSB UNK64X2787Accident · No injuriesClosedBeechcraft M23 · Vidal, CANTSB UNK64X1314Accident · No injuriesClosedBeechcraft 23 · Imperial, CANTSB UNK64X1003Accident · No injuriesClosedBeechcraft 23 · Santa Monica, CA