NTSB investigations: Beech C23
14 cases on aircraft the registry lists as Beech C23, where the first occurrence was “In flight collision with object”. 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 | 2 |
|---|---|
| 1984 | 2 |
| 1987 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2002 | 1 |
| 2004 | 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\" = 220))
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" = 220))
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 FTW04LA183Accident · 1 fatalLimited investigationFinal reportBeech C23 · Morrilton, ARThe pilot's inadequate preflight planning/preparation to assure adequate takeoff performance to clear obstacles.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.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 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 CHI96LA288Accident · No injuriesLimited investigationFinal reportBeech 23 · Wilmot, WIimproper planning/decision by the flight instructor (CFI) by failing to ensure that the airplane would be able to clear brush and trees near the departure end of the runway.NTSB CHI95LA091Accident · No injuriesLimited investigationFinal reportBeech 23 · Hutchinson, KSinadequate preflight planning by the pilot. Contributing factors to this accident were the pilot selecting the wrong runway for takeoff and the tailwind condition.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 LAX91FA219Accident · Serious injuriesField investigationFinal reportBeech C23 · Cibola, AZThe pilot's failure to maintain adequate clearance between the aircraft and ground vehicle during a low pass resulting in an in flight collision with the vehicle, loss of control, and in flight collision with terrain. Factors related to the accident was the…NTSB LAX89LA300Accident · No injuriesLimited investigationFinal reportBeech C23 · Selma, CAThe pilot's failure to maintain proper clearance from the power line, while maneuvering at low altitude. The power line was a related factor.NTSB ATL87LA110Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Branchville, ALThe plt was ldg at the private airstrip to the north with a tailwind, because trees located on the north end of the rwy precluded ldg to the south into the wind. He made three attempts to land on the 1,754 ft runway; witnesses reported that a 7-12 kt tailwind…NTSB ATL84LA231Accident · No injuriesLimited investigationFinal reportBeech C23 · Gainesboro, TNThe acft collided with a static wire while flying along a river. The collision occurred at 350 ft AGL about 5 miles NE of the arpt. The left wing hit the wire which cut into the wing and penetrated a fuel cell. Fuel escaped from this cell and when the acft…NTSB NYC84FA117Accident · 4 fatalField investigationFinal reportBeech C23 · Champion, PAN23968, crashed into trees shortly after takeoff from rwy 27 at seven springs airport. Plt told the resort manager of seven springs that he could not seem to get airborne & after he did get airborne he could not clear the trees. Investigation revealed the…NTSB NYC83FA034Accident · 2 fatalField investigationFinal reportBeech C23 · Hazleton, PAOn 11/28/82, the pilot encountered icing conditions and landed at Hazleton, PA. The aircraft was not deiced at Hazleton and icing conditions continued until the morning of 11/29/82. While departing on 11/29/82, the aircraft was observed to use more than two…NTSB LAX82DA340Accident · Serious injuriesFinal reportBeech C23 · Bear Valley, CAThe pilot landed long and fast on the runway. He was using runway 19 and the wind was from the north at 15-20 KTS. He landed and while still rolling at 65 KTS initiated a go-around. He did not climb high enough to clear small tree and after colliding with…