NTSB investigations: Beech C23, GA
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
| 1978 | 1 |
|---|---|
| 1982 | 1 |
| 1983 | 1 |
| 1992 | 1 |
| 1994 | 2 |
| 1997 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2011 | 1 |
| 2017 | 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\" = 'GA' 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" = 'GA' 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 ERA17FA106Accident · 2 fatalField investigationFinal reportBeech C23 · Winder, GAThe flight instructor's inadequate preflight planning and operation of the airplane outside its center of gravity envelope, which resulted in a loss of control while maneuvering.NTSB ERA11LA179Accident · No injuriesLimited investigationFinal reportBeech C23 · Carrollton, GAThe mechanic's failure to re-connect a fuel line following an annual inspection. Contributing to the accident was the pilot's improper decision to depart with a known mechanical deficiency.NTSB ATL03LA047Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Valdosta, GAThe pilot's failure to maintain adequate airspeed during a go-around resulting in an inadvertent stall and collision with trees.NTSB MIA02LA013Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Athens, GAthe pilot misjudged the ailment of the airplane on the active runway, inadvertently taking off from a parallel taxiway, and subsequently departing the hard surface into a 40 foot drop off. A factor in this accident was a dark night, and the pilot's total…NTSB ATL97FA060Accident · 1 fatalField investigationFinal reportBeech C23 · Athens, GApilot impairment of judgment and performance, due to alcohol; and his failure to maintain sufficient altitude or clearance from obstacles, while maneuvering at low altitude at night. Darkness was a related factor.NTSB ATL95FA023Accident · 1 fatalField investigationFinal reportBeech C23 · Statesboro, GAThe pilot's impairment of judgment and performance due to alcohol, improper planning/decision, flight into adverse weather conditions, and failure to maintain proper altitude/clearance from wooded terrain. Factors related to the accident were: darkness and…NTSB ATL94LA068Accident · No injuriesLimited investigationFinal reportBeech C23 · Dahlonega, GAThe poor in-flight decision by the pilot to divert his attention from the runway on short final in order to retrieve a flashlight.NTSB ATL92LA070Accident · No injuriesLimited investigationFinal reportBeech C-23 · Dalton, GAThe pilot's inadequate compensation for gusting winds while taxiing for takeoff which resulted in a lost of control. A factor was gusting quartering tail winds.NTSB ATL83FA083Accident · Serious injuriesField investigationFinal reportBeech C23 · Peachtree City, GAThe eng lost power shortly after the plt was making a takeoff. Subsequently, the acft was badly damaged during a landing in an area of relatively small trees & brush. An exam of the acft revealed there was water in the left fuel tank & carburetor. The fuel…NTSB ATL82IA245Incident · No injuriesIncident investigationFinal reportBeech C23 · Duluth, GADuring preflight, the pilot found the right aileron front push-pull rod end broken. This defect would have precluded aileron control. Metallurgical examination of the fracture revealed that the part had failed due to reverse bending fatigue as a result of…NTSB MIA78FA042Accident · 1 fatalClosedBeech C23 · Eatonton, GA