NTSB investigations: Beech C23
14 cases on aircraft the registry lists as Beech C23, where the first occurrence was “Overrun”. 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
| 1982 | 3 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1992 | 3 |
| 1995 | 1 |
| 1999 | 1 |
| 2003 | 1 |
Where
Latest 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151242')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 340))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151242')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 340))
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 CHI03LA225Accident · No injuriesLimited investigationFinal reportBeech C23 · Madison, WIThe dual student's delay in executing the aborted takeoff. Also causal was the pilot-in-command's delayed remedial action.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 CHI95LA162Accident · No injuriesLimited investigationFinal reportBeech C23 · Lake Ann, MIthe pilot's inadequate preflight planning/preparation and improper short field landing procedures. Factors associated with the accident were the wet terrain, a tailwind, and the pilots lack of recent experience.NTSB NYC93LA047Accident · No injuriesLimited investigationFinal reportBeech C-24R · Meriden, CTThe pilot's improper airplane preflight, resulting in no airspeed indication during takeoff, and the subsequent abort with insufficient runway available to stop prior to a collision with the terrain.NTSB LAX93LA067Accident · Minor injuriesLimited investigationFinal reportBeech 23-C23 · Oceanside, CAThe pilot's failure to attain the proper touchdown point and to initiate a timely go around when the landing over shoot became apparent.NTSB LAX92LA123Accident · No injuriesLimited investigationFinal reportBeech C-23 · Fullerton, CAWas the pilot's poorly planned approach. Contributing to this accident was the prevailing haze/smoke, the pilot's failure to attain a proper glidepath, proper touch down point and excessive final approach airspeed.NTSB MKC88LA063Accident · No injuriesLimited investigationFinal reportBeech C23 · Sullivan, MOWhen the PIC arrived at his destination, during a personal cross country flight, he circled the unfamiliar arpt three times, observing trees on both ends, and a crosswind of about 60 degrees to the active runway. After landing, and during the ldg roll out, he…NTSB LAX87LA253Accident · No injuriesLimited investigationFinal reportBeech C23 · Brownsville, CADuring a cross country flt, the plt over flew the rwy once for a visual wind speed and direction check. During the first approach the acft was too high so the plt went around. On the second approach, during the flare, the acft stayed airborne down most of the…NTSB MIA86LA096Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Lake Wales, FLThe plt stated that he landed long and was unable to stop. The acft ran off the end of the runway into a lake.NTSB NYC85LA165Accident · No injuriesLimited investigationFinal reportBeech C23 · Penn Yan, NYThe plt was familiar with the arpt, during the landing the plt observed the wind sock indicating calm winds and the acft was landed into the sun. During the landing roll, pwr was added for takeoff. When the acft was aprx 2/3 the way down the rwy, the plt…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…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…NTSB CHI82DA210Accident · No injuriesFinal reportBeech C23 · Strongville, OHThe pilot reported that he had landed long in calm wind conditions at dusk. He stated that he could not stop, and to avoid going off the end of the runway, he tried to ground loop to the left. The aircraft entered a run-up area at the end of the runway where…NTSB ATL82DA135Accident · Minor injuriesFinal reportBeech C23 · Churchville, MDThe pilot stated that he lowered the nose of the aircraft during the approach to expedite his touchdown. He also stated that he did not apply brakes immediately because the aircraft was not firmly on the ground. When he realized he would be unable to stop on…