Fatal NTSB investigations: Beech D-50
10 cases on aircraft the registry lists as Beech D-50. 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
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1972 | 1 |
| 1974 | 1 |
| 1976 | 2 |
| 1979 | 1 |
| 1986 | 1 |
| 1996 | 1 |
| 2019 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1152512'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1152512'))
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 WPR19FA096Accident · 1 fatalClass 3 · FieldFinal reportBeech 50 · Riverside, CAThe pilot’s failure to maintain airspeed and control of the airplane following a loss of right engine power for reasons that could not be determined based on the available information.NTSB SEA96FA201Accident · 1 fatalField investigationFinal reportBeech D50 · Seattle, WAfailure of the pilot to follow proper emergency procedures (properly configure the airplane and feather the appropriate propeller) after loosing power in one engine, which resulted in his inability to maintain altitude until reaching an airport. Factors…NTSB LAX86FA085Accident · 1 fatalField investigationFinal reportBeech D-50 · Santa Rosa, CAThe plt, who was the mechanic for the acft & who possesses FAA inspection authorization, was familiar with this acft and had flown it the day before the accident. The plt failed to refuel the acft after making two additional flts. The main fuel tank gages…NTSB LAX79FA049Accident · 5 fatalClosedBeech D-50 · Julian, CANTSB FTW77FA024Accident · 1 fatalClosedBeech :50 · Mcallen, TXNTSB MIA76AM093Accident · 2 fatalClosedBeech D50 · Missing AircraftNTSB LAX74AL048Accident · 3 fatalClosedBeech D50 · Sunland, CANTSB NYC73AN075Accident · 1 fatalClosedBeech D50 · Avoca, PANTSB NYC65A0126Accident · 3 fatalClosedBeechcraft D50 · Hollidaysburg, PANTSB UNK64X2209Accident · 1 fatalClosedBeechcraft D-50 · Nineveh, TX