NTSB investigations: Beech 58
6 cases on aircraft the registry lists as Beech 58, where NTSB found Directional control. 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
| 2011 | 2 |
|---|---|
| 2012 | 3 |
| 2015 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1152740')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f.\"findingCode\", '01062020')))
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 ('1152740')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f."findingCode", '01062020')))
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 CEN15LA144Accident · No injuriesLimited investigationFinal reportBeech 58 · Denver, COThe pilot’s failure to maintain airplane control during a rejected takeoff from a slush-covered runway at night.NTSB ERA12FA262Accident · 1 fatalField investigationFinal reportBeech 58 · Calhoun, KYThe failure of the pilot to maintain airplane control after experiencing a loss of power from the left engine due to water contamination of the fuel system. Contributing to the accident was the pilot’s inadequate preflight inspection of the airplane and…NTSB ERA12CA182Accident · Minor injuriesData collectionFinal reportBeech 58 · South Charleston, WVThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.NTSB ERA12CA156Accident · No injuriesData collectionFinal reportBeech 58 · Walterboro, SCThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion. Contributing to the accident was the sunglare.NTSB CEN12CA062Accident · Minor injuriesData collectionFinal reportBeech 58 · Connersville, INThe pilot's failure to maintain directional control of the airplane during landing.NTSB CEN11FA302Accident · 4 fatalField investigationFinal reportBeech 58 · Topeka, KSThe pilot failed to maintain control of the airplane while maneuvering in instrument meteorological conditions. Contributing to the accident was the pilot’s minimal experience flying in actual instrument conditions.