NTSB investigations: Beech C23
11 cases on aircraft the registry lists as Beech C23, where the first occurrence was “In flight encounter with weather”. 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 |
|---|---|
| 1985 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1991 | 3 |
| 1999 | 1 |
| 2005 | 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.\"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\" = 240))
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" = 240))
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 LAX05CA297Accident · No injuriesData collectionFinal reportBeech C23 · Jiggs, NVthe pilot's encounter with a downdraft.NTSB CHI99FA196Accident · 1 fatalField investigationFinal reportBeech C-23 · Mandan, NDthe pilot failed to maintain aircraft control on approach to the airport after encountering high winds, gusts, rain, and thunderstorms in the area.NTSB ATL92FA033Accident · 2 fatalField investigationFinal reportBeech C23 · Lineville, ALThe pilot continued VFR into IMC conditions where he collided with trees and terrain. Factors in this accident were: low clouds, obscured terrain, and the pilot's inadequate prelflight planning.NTSB FTW92FA045Accident · 4 fatalField investigationFinal reportBeech C23 · Dewitt, ARThe pilot's attempt to land in IMC conditions and her subsequent loss of control during climb out due to spatial disorientation. A factor was the pilot's disregard of the pre-flight weather briefing.NTSB ATL91LA055Accident · No injuriesLimited investigationFinal reportBeech C23 · Concord, NCThe pilot's inadequate preflight planning in that he disregarded the crosswind limit in the pilot's operating handbook. Factors were the wet runway and the ravine at the end of the runway.NTSB LAX89LA271Accident · No injuriesLimited investigationFinal reportBeech C23 · S Lake Tahoe, CAThe aircraft's encounter with a downdraft during takeoff. Contributing factors were related to the high density altitude condition which existed and the aircraft's deteriorated takeoff performance capability.NTSB MKC88FA176Accident · 1 fatalField investigationFinal reportBeech C23 · Belle Plaines, IAThe non-instrument rated pilot received a full weather briefing prior to departure during which he was advised that VFR flight was not recommended. In addition he was advised that, while conditions were forecast to improve, the possibility for scattered…NTSB ATL88FA067Accident · 1 fatalField investigationFinal reportBeech B23 · Crossville, TNN6571R crashed into trees near the VOR on top on hinch mtn at about 3000 feet MSL. Trees at the crash site indicated wings level with a descent angle of about 10 degrees. Weather in the area was IMC, characterized by low ceilings (lower than the mtn top…NTSB ATL85LA258Accident · No injuriesLimited investigationFinal reportBeech C23 · Clarksburg, WVThe pilot ran into less than VFR weather and turned around and attempted to make an airport. He became boxed in by weather all around and attempted to land on the highway. He did not make a pss over his intended landing area. When he was on short final, a car…NTSB FTW83LA067Accident · No injuriesLimited investigationFinal reportBeech C23 · Childress, TXDuring flight, freezing rain was encountered which began to accumulate on the windshield and wings. The pilot reported that he checked and found that the clouds had closed in behind. He diverted to Childress, TX. While en route, additional ice accumulated on…NTSB MKC83LA031Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Near Vichy, MOWhile enroute from cape girardeau, MO to rolla, MO, the pilot encountered an area of low ceilings and fog. While he was trying to remain VFR at low altitude, the aircraft struck trees on top of a hill. The pilot climbed abruptly, but the plane stalled,…