Fatal NTSB investigations: Beech B23
24 cases on aircraft the registry lists as Beech B23. 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
| 1969 | 2 |
|---|---|
| 1970 | 1 |
| 1971 | 4 |
| 1972 | 1 |
| 1973 | 3 |
| 1974 | 1 |
| 1976 | 1 |
| 1979 | 2 |
| 1981 | 1 |
| 1982 | 3 |
| 1984 | 1 |
| 1988 | 3 |
| 2000 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151240'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151240'))
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 FTW00FA080Accident · 1 fatalField investigationFinal reportBeech B23 · New Braunfels, TXthe seizure of the engine while maneuvering due to the oil pressure relief valve plug ball seat becoming contaminated with metal. Contributing factors were the inadequate engine maintenance, and the lack of suitable terrain for the forced landing.NTSB CHI89FA036Accident · 4 fatalField investigationFinal reportBeech B23 · Jeffersonville, INPilot-in-command's poor inflight decision in attempting to return to the airport after a partial engine failure, and his encountering a stall/spin at low altitude from which he was unable to recover.NTSB LAX89FA001Accident · 1 fatalField investigationFinal reportBeech B23 · Scottsdale, AZThe pilot's mismanagement of fuel. Contributing to the accident was the inadequate lighting of the fuel selector valve.NTSB DEN88FA170Accident · 1 fatalField investigationFinal reportBeech B23 · Cimarron, NMThe pilot to properly preflight his aircraft in accordance with the procedures provided in the operators handbook thus causing the engine to lose power following takeoff due to fuel contamination caused by water.NTSB DEN84FA144Accident · 1 fatalField investigationFinal reportBeech B23 · Ruidoso, NMThe pilot stated that upon landing a gust of wind blew the aircraft off the runway center and he initiated a go-around. Witnesses stated the aircraft climbed to approximately 200 to 300 ft and started a left turn. Engine power appeared to be minimal. As the…NTSB ATL83FA013Accident · 1 fatalField investigationFinal reportBeech B-23 · Lexington, SCThe aircraft crashed in a corn field shortly after takeoff. The aircraft was owned by the pilot who was fatally injured in the accident. The weather was VMC and no system malfunction could be found. The aircraft was seen flying at low altitude prior to the…NTSB FTW82FA152Accident · 2 fatalField investigationFinal reportBeech B23 · Roanoke, TXWitnesses reported that the aircraft appeared to takeoff and climb normally until it reached an altitude of about 100 ft AGL. It then pitched up abruptly to about a 70 deg nose high attitude. After the pitch-up, the aircraft climbed to about 175 to 200 ft…NTSB SEA82DYE06Accident · 1 fatalFinal reportBeech 23 · Greenwater, WAAt about 1620 local time on 4/24/82, the aircraft departed burley, id and proceeded on a VFR flight plan to tacoma, WA. The mountains east of seattle were obscured by an overcast ceiling beginning at 3500 ft. during a descent from 10,500 ft into the seattle…NTSB ATL81FA052Accident · 4 fatalClosedBeech B23 · Mobile, ALNTSB SEA79FA050Accident · 4 fatalClosedBeech B23 · Neihart, MTNTSB LAX79FA056Accident · 2 fatalClosedBeech B23 · Oxnard, CANTSB FTW76AF080Accident · 2 fatalClosedBeech B23 · Richmond, TXNTSB NYC75AN041Accident · 1 fatalClosedBeech B23 · Collegeville, PANTSB CHI74AC023Accident · 3 fatalClosedBeech B23 · Carbondale, ILNTSB NYC74AN019Accident · 3 fatalClosedBeech 23 · Scituate, MANTSB FTW73AF055Accident · 3 fatalClosedBeech B23 · Victoria, TXNTSB LAX72AL063Accident · 4 fatalClosedBeech B23 · Burbank, CANTSB NYC72AN066Accident · 3 fatalClosedBeech B23 · Chesapeake, VANTSB NYC72AN025Accident · 3 fatalClosedBeech B23 · Stow, MANTSB DEN71AD048Accident · 3 fatalClosedBeech 23 · Rocky Ford, CONTSB DEN71AD030Accident · 1 fatalClosedBeech B23 · Mammoth, UTNTSB MIA70AM059Accident · 4 fatalClosedBeech B23 · Miami, FLNTSB MKC70A0021Accident · 1 fatalClosedBeech B23 · Minneapolis, MNNTSB FTW70A0010Accident · 1 fatalClosedBeech B23 · Montgomery, TX