NTSB investigations: Beech 95-C55
5 cases on aircraft the registry lists as Beech 95-C55, where the first occurrence was “Loss of control - in flight”. 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
| 1987 | 1 |
|---|---|
| 1991 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 2000 | 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 ('1152708')
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\" = 250))
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 ('1152708')
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" = 250))
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 CHI01FA017Accident · 2 fatalField investigationFinal reportBeech 95-C55 · Homer, NEThe inadequate remedial action the flightcrew had during the stall recovery maneuver and the flight instructor's inadequate supervision. A factor was the intentional stall the flightcrew was performing.NTSB LAX97FA049Accident · 1 fatalField investigationFinal reportBeech 95-C55 · San Diego, CAthe pilot's lack of situational awareness (becoming lost/disoriented during the approach), his failure to fly the approach as charted, and his failure to maintain aircraft control, while attempting an abrupt turn toward the airport, which led to an…NTSB CHI93GA204Accident · 2 fatalFinal reportBeech 95-C55 · Fort Madison, IAthe pilot-in command's failure to maintain control of the aircraft. Factors were door not secured, checklist not followed, diverted attention of the pilot-in-command, and emergency procedure not followed.NTSB LAX91FA139Accident · Serious injuriesField investigationFinal reportBeech 55 · Burbank, CAThe pilot misjudged the liftoff speed, and prematurely rotated the aircraft for takeoff.NTSB LAX87FA309Accident · 2 fatalField investigationFinal reportBeech C-55 · Salton City, CAInstructor pilot's inability to recover control of the aircraft after it entered a spin.