NTSB investigations: Beech 58
10 cases on aircraft the registry lists as Beech 58, where the sequence of events included Landing gear not configured. 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
| 2012 | 3 |
|---|---|
| 2016 | 1 |
| 2017 | 1 |
| 2022 | 1 |
| 2024 | 3 |
| 2026 | 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 ('1152740')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '095' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '095' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 CEN26LA240Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Traverse City, MIThe pilot’s failure to extend the landing gear before landing.NTSB ERA25LA094Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Florence, SCThe pilot’s failure to follow the emergency procedures and extend the landing gear manually after the landing gear did not initially extend normally.NTSB CEN25LA017Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Shreveport, LAThe pilot’s inadvertent failure to lower the landing gear before touching down.NTSB CEN24LA307Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Kalamazoo, MIThe pilot’s failure to extend the landing gear before landing.NTSB ERA22LA246Accident · No injuriesClass 3 · LimitedFinal reportBeech 58 · Perry, GAThe pilot’s failure to properly configure the landing gear before landing.NTSB ERA17LA189Accident · No injuriesLimited investigationFinal reportBeech 58 · Augusta, GAThe pilot’s failure to properly configure the airplane for landing. Contributing to the accident were the pilot’s fatigue and self-induced distractions.NTSB GAA16CA161Accident · No injuriesData collectionFinal reportBeech 58 · Huntsville, ALThe pilot's failure to extend the landing gear prior to touchdown resulting in a landing with the landing gear retracted and consequent substantial damage.NTSB CEN12CA436Accident · No injuriesData collectionFinal reportBeech 58 · Sugar Loaf Mountain, MIThe pilot did not complete the before-landing checklist and, subsequently, failed to extend the landing gear prior to landing. Contributing to the accident was the pilot’s distraction with his passengers’ conversation.NTSB ERA12CA424Accident · No injuriesData collectionFinal reportBeech 58 · Atlanta, GAThe pilot's inadvertent retraction of the landing gear during the landing.NTSB CEN12LA283Accident · No injuriesLimited investigationFinal reportBeech 58 · Sioux Falls, SDThe failure of the normal and emergency landing gear system to fully retract or extend the landing gear for reasons that could not be determined during postaccident examinations, which resulted in a partial gear-up landing.