NTSB investigations: Beech C23, VA
15 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
| 1974 | 1 |
|---|---|
| 1975 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1988 | 2 |
| 1999 | 2 |
| 2007 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2023 | 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\" = 'VA' 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" = 'VA' 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 ERA24FA053Accident · 1 fatalClass 3 · FieldFinal reportBeech C23 · Midland, VAThe pilot’s decision to descend below the minimum decision altitude of the instrument approach without having the appropriate runway visual references distinctively identified and with the visibility and ceiling below the minimum that was prescribed for the…NTSB ERA21FA148Accident · 1 fatalClass 3 · FieldFinal reportBeech C23 · Purcellville, VAThe pilot's improper decision to depart from the short turf runway with a tailwind.NTSB ERA20CA072Accident · Minor injuriesData collectionFinal reportBeech 23 · Norfolk, VAThe pilot receiving instruction's failure to maintain airplane control during landing with a crosswind, which resulted in a bounced landing, and the flight instructor's delayed remedial action, which resulted in a loss of control during the go-around.NTSB NYC07CA079Accident · No injuriesData collectionFinal reportBeech C23 · Fredericksburg, VAThe pilot's misjudgment of the airplane's speed and distance during the landing approach.NTSB NYC00LA060Accident · No injuriesLimited investigationFinal reportBeech C-23 · Manassas, VAThe pilot's inadequate remedial action to recover the airplane from porpoising during the landing roll out.NTSB NYC00LA037Accident · No injuriesLimited investigationFinal reportBeech C23 · Fincastle, VAThe restricted movement of the fuel selector and the pilot-in-command's failure to verify the fuel selector was in a proper position.NTSB BFO88LA043Accident · No injuriesLimited investigationFinal reportBeech C23 · Manassas, VAThe plt said that earlier he attempted to land at carlisle, pa and during the lndg roll he encountered a wind gust and lost directional control of the acft. The r wing raised and the acft went off the side of the rwy. The plt said he heard a loud bump as the…NTSB BFO88LA019Accident · No injuriesLimited investigationFinal reportBeech C-23 · Roanoke, VAThis was the stu plt fifth training session where he did solo touch & go landings. During this session he made ten landings without incident. Six landings were made with his instr aboard followed by four solo landings. According to the stu during the flare…NTSB BFO85FA008Accident · No injuriesField investigationFinal reportBeech C23 · Clifton, VAShortly after leveling at the cruise altitude of 2500 ft, the pilot noted a gradual RPM decrease and resultant loss of power. Altitude could not be maintained and the pilot selected a rolling open field in which to land when he realized that reaching an…NTSB ATL84LA019Accident · No injuriesLimited investigationFinal reportBeech B-23 · Topping, VAThe acft overran the departure end of the rwy and collided with a ditch during landing. The weather was VMC. According to the pilot 2 go-arounds had been made because the acft was high. On the 3rd approach a touchdown was made about 1/2 way down the 2500 ft…NTSB IAD79FID07Accident · No injuriesClosedBeech C23 · Chesterfield, VANTSB IAD78FA061Accident · 1 fatalClosedBeech C23 · The Plains, VANTSB IAD77DID14Accident · No injuriesClosedBeech C23 · Portsmouth, VANTSB IAD76AI026Accident · 1 fatalClosedBeech C23 · Afton, VANTSB IAD75AI011Accident · No injuriesClosedBeech C23 · Norfolk, VA