NTSB investigations: Beech 95-C55
5 cases on aircraft the registry lists as Beech 95-C55, where the first occurrence was “Airframe/component/system failure/malfunction”. 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 |
| 1996 | 1 |
| 2001 | 1 |
| 2004 | 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\" = 130))
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" = 130))
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 DEN04LA075Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Rifle, COthe pilot's failure to verify the manual extension of the landing gear resulting in an inadvertent wheels up landing. Contributing factors include the electrical systems failure for undetermined reasons, the pilot's diverted attention and the pilot's improper…NTSB ATL01LA102Accident · No injuriesLimited investigationFinal reportBeech 55 · Jacksonville, FLThe failure of the left landing gear extention rod for undetermined reasons that resulted in a landing with the gear retracted.NTSB FTW96LA123Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Dallas, TXfailure of the pilot to use a more favorable runway, and his failure to go-around, when he realized the airplane would not touch down at the proper touchdown point. Factors relating to the accident were: the inoperative flap motor, failure of the pilot to…NTSB LAX91FA324Accident · 3 fatalField investigationFinal reportBeech 95-C55 · Granada Hills, CAA loss of directional control following an undetermined autopilot failure, during which the pilot failed to perform the emergency procedure to correct a mis-trim condition. Contributing to the accident was a perceived elevator control problem; the inability…NTSB ATL88FA032Accident · No injuriesField investigationFinal reportBeech 95C-55 · Atlanta, GAAcft was being positioned to begin cargo revenue flt. As acft turned final and ldg gear handle was put in down position PIC noted dimming of all lights & communications were lost. PIC unaware gear were still retracted until prop tips contacted rwy. During…