Fatal NTSB investigations: Beech 23
35 cases on aircraft the registry lists as Beech 23. 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
| 1964 | 3 |
|---|---|
| 1965 | 3 |
| 1967 | 2 |
| 1968 | 2 |
| 1969 | 4 |
| 1970 | 2 |
| 1972 | 2 |
| 1973 | 2 |
| 1974 | 1 |
| 1975 | 1 |
| 1977 | 1 |
| 1987 | 2 |
| 1992 | 1 |
| 1996 | 3 |
| 1997 | 1 |
| 2000 | 2 |
| 2002 | 1 |
| 2007 | 1 |
| 2011 | 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 ('1151202'))
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 ('1151202'))
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 CEN12FA082Accident · 1 fatalField investigationFinal reportBeech 23 · West Milton, OHThe non-instrument-rated pilot's decision to attempt a flight into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and subsequent loss of control of the airplane.NTSB NYC07LA177Accident · 1 fatalLimited investigationFinal reportBeech BE-23 · Science Hill, KYA loss of engine power for an undetermined reason.NTSB NYC02FA098Accident · 3 fatalField investigationFinal reportBeech 23 · King George, VAThe pilot's improper in-flight decision to perform low passes; and his failure to maintain airspeed which resulted in a stall and collision with trees.NTSB CHI01FA052Accident · 1 fatalField investigationFinal reportBeech BE-23 · Rolla, MOThe pilot's inadequate preflight during the pre-buy inspection, the pilot's incapacitation due to carbon monoxide, and the fractured muffler.NTSB ATL00FA023Accident · 2 fatalField investigationFinal reportBeech 23 · Macon, GAThe loss of engine power for undetermined reasons. A factor was conditions favorable for the formation of carburetor ice.NTSB FTW97RA101Accident · 1 fatalForeign investigationBeech 23 · Santa Catarina, MexicoNTSB CHI96FA327Accident · 1 fatalField investigationFinal reportBeech 23 · Tomahawk, WIthe student pilot's impairment of judgment and performance due to alcohol which led to his initiation of VFR flight into instrument meteorological conditions and loss of control. Factors were: the dark night and the weather conditions.NTSB FTW96FA339Accident · 1 fatalField investigationFinal reportBeech 23 · Wimberley, TXThe pilot's failure to maintain airspeed. Factors were the high density altitude, the tail wind, and the pilot's failure to adhere to the limitations prescribed by his flight instructor.NTSB CHI96FA209Accident · 2 fatalField investigationFinal reportBeech 23 · Fulton, MOthe inadequate intake valve springs on the #1 cylinder.NTSB LAX92FA313Accident · 3 fatalField investigationFinal reportBeech 23 · Fall River Mill, CAThe pilots decision to turn down wind at a critical phase of the go around with inadequate airspeed resulting in a stall mush uncontrolled descent. Contributing to the accident was the unfavorable wind conditions and a stabilator interference caused by a…NTSB MIA87FA250Accident · 3 fatalField investigationFinal reportCommonwealth 185 · St. Petersburg, FLThe pilot of the Commonwealth erroneously reported his positon to the tower for landing instructions. He then failed to follow the instructions and collided with a Beech 23 acft that was on downwind to land at albert whitted airport. Both aircraft involved in…NTSB MIA87FA189Accident · 2 fatalField investigationFinal reportBeech 23 · Miramar, FLAfter the plt lndd, the acft was serviced with 58.9 gal of fuel. Its fuel capacity was 60 gal. Subsequently, when the plt took off, the acft remained on the rwy for about 2500' of the available 3000'. After lift-off, the acft entered a rgt turn & reached a…NTSB CHI77FA036Accident · 2 fatalClosedBeech 23 · Morris, ILNTSB IAD75AI064Accident · 1 fatalClosedBeech 23 · Kenly, NCNTSB NYC74AN108Accident · 2 fatalClosedBeech 23 · Sparta, NJNTSB LAX74AL043Accident · 3 fatalClosedBeech 23 · Gorman, CANTSB MIA74AM016Accident · 1 fatalClosedBeech 23 · Fitzgerald, GANTSB CHI73AC032Accident · 2 fatalClosedBeech 23 · Kenosha, WINTSB NYC72AN157Accident · 3 fatalClosedBeech 23 · Spring Run, PANTSB MIA71AM028Accident · 2 fatalClosedBeech 23 · Gates, TNNTSB MIA71AM004Accident · 4 fatalClosedBeech 23 · Ocala, FLNTSB DEN70A0011Accident · 3 fatalClosedBeech 23 · Colo.Springs, CONTSB IAD70A0004Accident · 1 fatalClosedBeech 23 · Selbyville, DENTSB CHI69A0098Accident · 3 fatalClosedBeech 23 · Mackinaw Cty, MINTSB FTW71AF045Accident · 4 fatalClosedBeech 23 · Helena, ARNTSB CHI69A0059Accident · 1 fatalClosedBeech 23 · Marion, OHNTSB OAK69A0035Accident · 2 fatalClosedBeech 23 · ZNTSB NYC67A0152Accident · 4 fatalClosedBeech 23 · Naushon Isl, MANTSB MKC67A0049Accident · 3 fatalClosedBeech 23 · Maquoketa, IANTSB NYC66A0037Accident · 4 fatalClosedBeech 23 · Rutland, VTNTSB LAX66A0003Accident · 2 fatalClosedBeechcraft 23 · Steamboat, NVNTSB NYC65A0139Accident · 1 fatalClosedPiper PA-22 · Lodi-Garfield, NJNTSB UNK65X0603Accident · 2 fatalClosedBeechcraft 23 · Grd Junction, TNNTSB UNK64X2629Accident · 3 fatalClosedBeechraft 23 · Linton Que, CanadaNTSB UNK64X1816Accident · 4 fatalClosedBeechraft M-23 · Washougal, WA