NTSB investigations: Beech C23, OH
10 cases on aircraft the registry lists as Beech C23. 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
| 1970 | 1 |
|---|---|
| 1972 | 1 |
| 1976 | 2 |
| 1980 | 2 |
| 1982 | 1 |
| 1986 | 1 |
| 1991 | 1 |
| 2007 | 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\" = 'OH' 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 ('1151242'))
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" = 'OH' 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 ('1151242'))
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 CHI07CA304Accident · Minor injuriesData collectionFinal reportBeech C23 · Carrollton, OHThe partial loss of engine power during approach due to carburetor ice and the uneven terrain encountered during the forced landing which caused the airplane to nose over. Weather conducive to carburetor icing was a contributing factor.NTSB NYC91LA137Accident · No injuriesLimited investigationFinal reportBeech C-23 · Chesapeake, OHThe pilot's failure to maintain an adequate airspeed that would preclude a stall. Contributing to the accident was the opened door.NTSB ATL87LA008Accident · No injuriesLimited investigationFinal reportBeech C23 · Middlefield, OHStudent plt stated that he was preparing to land after a business x-country flt. On downwind he noted the wind sock ind a x-wind. Made a long final and did not notice x-wind. Stated that at flare he seemed to have a little tailwind since his spd was 85 KTS…NTSB CHI82DA210Accident · No injuriesFinal reportBeech C23 · Strongville, OHThe pilot reported that he had landed long in calm wind conditions at dusk. He stated that he could not stop, and to avoid going off the end of the runway, he tried to ground loop to the left. The aircraft entered a run-up area at the end of the runway where…NTSB CHI80FEG21Accident · No injuriesClosedBeech C23 · Cincinnati, OHNTSB CHI80DEG13Accident · No injuriesClosedBeech C23 · Miamisburg, OHNTSB CHI76FEG19Accident · No injuriesClosedBeech C23 · Cincinnati, OHNTSB CHI76DEG16Accident · No injuriesClosedBeech C-23 · Miamisburg, OHNTSB CHI73FEI22Accident · No injuriesClosedBeech C23 · Cleveland, OHNTSB CHI71DGD36Accident · No injuriesClosedBeech C-23 · Orwell, OH