NTSB investigations: Beech C23, 2023
4 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 |
|---|---|
| 1971 | 1 |
| 1972 | 6 |
| 1973 | 3 |
| 1974 | 4 |
| 1975 | 10 |
| 1976 | 15 |
| 1977 | 17 |
| 1978 | 19 |
| 1979 | 21 |
| 1980 | 24 |
| 1981 | 9 |
| 1982 | 24 |
| 1983 | 13 |
| 1984 | 8 |
| 1985 | 5 |
| 1986 | 8 |
| 1987 | 10 |
| 1988 | 11 |
| 1989 | 6 |
| 1990 | 4 |
| 1991 | 12 |
| 1992 | 7 |
| 1993 | 8 |
| 1994 | 9 |
| 1995 | 8 |
| 1996 | 6 |
| 1997 | 9 |
| 1998 | 4 |
| 1999 | 11 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 8 |
| 2003 | 4 |
| 2004 | 3 |
| 2005 | 6 |
| 2006 | 3 |
| 2007 | 4 |
| 2008 | 10 |
| 2009 | 1 |
| 2010 | 3 |
| 2011 | 3 |
| 2012 | 1 |
| 2013 | 3 |
| 2015 | 1 |
| 2016 | 8 |
| 2017 | 5 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 2 |
| 2021 | 4 |
| 2022 | 3 |
| 2023 | 4 |
| 2024 | 3 |
| 2025 | 2 |
| 2026 | 2 |
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 year(c.\"eventDate\") = 2023
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 year(c."eventDate") = 2023
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 ERA24FA053Accident · 1 fatalClass 3 · FieldFinal reportBeech C23 · Midland, VAThe pilot’s decision to descend below the minimum decision altitude of the instrument approach without having the appropriate runway visual references distinctively identified and with the visibility and ceiling below the minimum that was prescribed for the…NTSB CEN23LA418Accident · Minor injuriesClass 3 · LimitedFinal reportBeech C23 · Gonzales, TXThe loss of engine power during go-around due to a failed muffler flame tube, which resulted in an exhaust blockage. Contributing to the accident was maintenance personnel's inadequate inspection of the exhaust system during the most recent maintenance.NTSB ERA23LA342Accident · 2 fatalClass 3 · LimitedFinal reportBeech C23 · Greer, SCA partial loss of engine power during the initial climb due to the formation of carburetor ice, resulting in reduced climb capability. Contributing to the accident was the pilot’s failure to maintain proper airspeed during the emergency descent, which…NTSB WPR23LA099Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · Rich County, UTThe pilot’s inability to maintain altitude following an encounter with turbulence and adverse wind conditions.