NTSB investigations: Beech C23, 1999
11 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\") = 1999
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") = 1999
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 NYC00LA060Accident · No injuriesLimited investigationFinal reportBeech C-23 · Manassas, VAThe pilot's inadequate remedial action to recover the airplane from porpoising during the landing roll out.NTSB NYC00LA037Accident · No injuriesLimited investigationFinal reportBeech C23 · Fincastle, VAThe restricted movement of the fuel selector and the pilot-in-command's failure to verify the fuel selector was in a proper position.NTSB CHI00LA001Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Greenwood, INundetermined.NTSB CHI99LA270Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Port Washington, WIthe loss of engine power for undetermined reasons.NTSB CHI99FA264Accident · 1 fatalField investigationFinal reportBeech C23 · Detroit Lakes, MNAircraft control not obtained/maintained by the pilot. A factor to the accident was the pilot's impairment due to drugs.NTSB MIA99LA202Accident · No injuriesLimited investigationFinal reportBeech C23 · Seneca, SCthe pilot misjudged the flare, landed hard, bounced, departed the runway, which resulted in an impact with a ditch and embankment. A factor in this accident was the improper recovery from a bounced landing.NTSB FTW99LA203Accident · No injuriesLimited investigationFinal reportBeech C23 · Tulsa, OKThe pilot's failure to maintain the proper descent rate, which resulted in a hard landing.NTSB CHI99FA196Accident · 1 fatalField investigationFinal reportBeech C-23 · Mandan, NDthe pilot failed to maintain aircraft control on approach to the airport after encountering high winds, gusts, rain, and thunderstorms in the area.NTSB NYC99LA101Accident · Serious injuriesLimited investigationFinal reportBeech BE-C23 · Annappolis, MDThe pilot's failure to perform a go-around and he landed long resulting in an overrun. A factor in the accident was the night light conditions.NTSB MIA99LA139Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Apex, NCthe pilot's failure to maintain control of the airplane resulting in the airplane drifting, and subsequently impacting with trees.NTSB CHI99LA095Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Kansas City, MOthe pilot's improper positioning of the fuel selector. Factors to the accident were the transmission wires, the building, and the flood levy wall.