Skip to content

NTSB investigations: Beech C23, TX

18 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19772026

Where

Latest cases

Query with SQL

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" = 'TX' 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

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\" = 'TX' 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" = 'TX' 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

Run 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 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.Sep 24, 2023 · N18994 · Substantial damage NTSB CEN17LA003Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Taylor, TXA total loss of engine power due to fuel starvation as a result of debris obstructing the fuel strainer screen and corrosion of the fuel strainer bowl.Oct 1, 2016 · N9704L · Destroyed NTSB DFW06LA122Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Bishop, TXThe delayed landing flare by the pilot which resulted in a hard landing. A contributing factor was the loss of engine power for undetermined reasons.May 9, 2006 · N5021M · Substantial damage NTSB FTW02FA071Accident · 1 fatalField investigationFinal reportBeech C23 · Sinton, TXThe pilot's failure to maintain clearance with trees while executing a missed approach procedure. Contributing factors were the prevailing fog and the dark night conditions.Jan 18, 2002 · N6622X · Destroyed NTSB FTW97LA301Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Terlingua, TXThe inadvertent stall by the pilot-in-command. A factor was the sudden wind shift.Aug 2, 1997 · N2146W · Substantial damage NTSB FTW92FA023Accident · 1 fatalField investigationFinal reportBeech C23 · Angleton, TXThe pilot's failure to maintain aircraft control. Factors were his lack of total instrument time, his VFR flight into instrument conditions and spatial disorientation.Nov 18, 1991 · N6637W · Destroyed NTSB FTW86LQG13Accident · No injuriesFinal reportBeech C23 · Vega, TXThe acft landed hard following a simulated short field landing over an obstacle. Power was reduced as the acft cleared the imaginary obstacle but there was a slight delay in lowering the nose to maintain airspeed. The acft was flared at a high sink rate…Mar 1, 1986 · N6110X · Substantial damage NTSB FTW83LA376Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Iowa Park, TXDuring a landing, the acft floated about 1/3 to 1/2 of the way down the rwy before touching down. The plt was unable to stop on the remaining rwy & the acft continued off the end & hit a ditch. An exam of the brakes revealed two discrepancies. The temp was…Aug 12, 1983 · N6110X · Substantial damage NTSB FTW83LA337Accident · No injuriesLimited investigationFinal reportBeech C23 · Longview, TXThe acft crashed during a forced landing after the engine quit on the downwwind leg of the traffic pattern. The flt had taken off shortly before with one tank almost full and one almost empty. The fuel selector valve was found in the 'off' position after the…Jul 13, 1983 · N60104 · Substantial damage NTSB FTW83LA067Accident · No injuriesLimited investigationFinal reportBeech C23 · Childress, TXDuring flight, freezing rain was encountered which began to accumulate on the windshield and wings. The pilot reported that he checked and found that the clouds had closed in behind. He diverted to Childress, TX. While en route, additional ice accumulated on…Dec 26, 1982 · N9256S · Substantial damage NTSB FTW82DA365Accident · Serious injuriesFinal reportBeech 23 · Fort Worth, TXThe plt stated the stall warning sounded every time he tried to climb & the acft settled into trees. The acft was 7 lbs over max gross weight requiring 2,369 ft to clear a 50 ft obstacle.Sep 6, 1982 · N45BW · Destroyed NTSB FTW82FRG34Accident · 1 fatalFinal reportBeech C23 · Port Aransas, TXWitnesses observed the acft on a high final approach to rwy 12 when a go-around was initiated over the rwy at approximately 150 to 200 ft AGL. The acft started a steep banked right turn to a downwind position. The bank continued and the acft descended rapidly…Jul 31, 1982 · N6631D · Substantial damage NTSB FTW82DA308Accident · No injuriesFinal reportBeech C23 · Roaring Springs, TXDuring a landing in calm wind conditions, the aircraft continued off the end of the runway and struck a fence. The pilot stated that he had trouble lowering the flaps and that the brakes would not operate properly. During a subsequent inspection, the brakes…Jul 31, 1982 · N60003 · Substantial damage NTSB FTW80FQG15Accident · Serious injuriesClosedBeech C23 · Slaton, TXApr 21, 1980 · N2142W · Substantial damage NTSB FTW80DRG27Accident · No injuriesClosedBeech 23 · Llano, TXFeb 15, 1980 · N60003 · Substantial damage NTSB FTW79DQG48Accident · No injuriesClosedBeech C23 · Amarillo, TXJul 8, 1979 · N2074K · Substantial damage NTSB FTW78FQG32Accident · No injuriesClosedBeech C23 · Amarillo, TXJun 7, 1978 · N9256S · Substantial damage NTSB FTW77FQG45Accident · No injuriesClosedBeech B23 · Gruver, TXJul 30, 1977 · N2190W · Substantial damage