NTSB investigations: Beech C23, 1993
8 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\") = 1993
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") = 1993
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 CHI94LA059Accident · No injuriesLimited investigationFinal reportBeech C23 · Eden Prairie, MNan inadequate preflight by both the CFI and student pilot. Factors contributing to the accident was poor communications between the CFI and student pilot, and hilly terrain.NTSB CHI93LA331Accident · No injuriesLimited investigationFinal reportBeech 23 · Milwaukee, WIthe student pilot's improper recovery from a bounced landing.NTSB SEA93LA180Accident · No injuriesLimited investigationFinal reportBeech C23 · Lakeview, ORA fractured exhaust valve. The rough terrain was a factor.NTSB MIA93FA163Accident · 3 fatalField investigationFinal reportBeech C23 · St Petersburg, FLFailure of the pilot to maintain adequate airspeed during the go-around, which resulted in an inadvertent stall. Factors related to the accident were: the pilot's lack of familiarity with the airport, and his selection of the wrong runway.NTSB NYC93LA135Accident · No injuriesLimited investigationFinal reportBeech C23 · Montgomery, NYA power loss due to a collapsed air duct and a consequent blockage of induction air, which resulted in a forced landing and an on ground collision with a ditch.NTSB MIA93LA139Accident · No injuriesLimited investigationFinal reportBeech 23 · Tampa, FLThe pilot-in-command's improper landing flare, which resulted in the aircraft bouncing and entering a porpoise maneuver. Contributing to the accident was his failure to recover from the bounced landing and perform a go-around.NTSB CHI93LA188Accident · No injuriesLimited investigationFinal reportBeech C23 · Kansas City, MOThe pilot-in-command was operating the airplane at an excessive taxi speed, and did not maintain visual separation with the tied down airplane. Factors contributing to the accident were a light rain and fog condition, and a foggy interior window.NTSB FTW93LA130Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Searcy, ARThe pilot's improper flare and his improper recovery for a bounced landing. The crosswind and the pilot's improper compensation for the wind were factors.