NTSB investigations: Beech B23, 1984
3 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 | 7 |
|---|---|
| 1970 | 9 |
| 1971 | 16 |
| 1972 | 7 |
| 1973 | 11 |
| 1974 | 6 |
| 1975 | 2 |
| 1976 | 5 |
| 1978 | 5 |
| 1979 | 4 |
| 1980 | 2 |
| 1981 | 2 |
| 1982 | 5 |
| 1983 | 1 |
| 1984 | 3 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 4 |
| 1988 | 4 |
| 1990 | 1 |
| 1991 | 2 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 1 |
| 2000 | 1 |
| 2003 | 1 |
| 2005 | 3 |
| 2008 | 1 |
| 2011 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2019 | 1 |
| 2021 | 1 |
| 2024 | 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 year(c.\"eventDate\") = 1984
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 year(c."eventDate") = 1984
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 CHI84LA192Accident · No injuriesLimited investigationFinal reportBeech 23 · Put-In-Bay, OHDuring the landing roll, about 950 ft down the rwy, the acft hit a dip in the rwy & became airborne again. The plt stated that due to the gusty wind condition, the acft was blown over a grass field on the left side of the rwy. He considered going around, but…NTSB MKC84LA134Accident · No injuriesLimited investigationFinal reportBeech BE23 · Richmond, KSWhile in cruise on a ferry flight the engine lost power and would only develop partial power. The power degraded to the point that insuficient power was available to maintain flight. The pilot landed in a field and substantial damage occured. Post accident…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…