Fatal NTSB investigations: Beech E33
7 cases on aircraft the registry lists as Beech E33. 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
| 1969 | 2 |
|---|---|
| 1978 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 2011 | 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 ('1151422'))
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 ('1151422'))
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 WPR12FA012Accident · 3 fatalField investigationFinal reportBeech E33 · Daggett, CAA loss of engine power due to the separation of a connecting rod, and the pilot's failure to maintain airplane control during a sudden maneuver to avoid power lines during the descent, which resulted in an unrecoverable aerodynamic stall and subsequent spin.…NTSB LAX93FA118Accident · 1 fatalField investigationFinal reportBeech E33 · Avalon, CAThe pilot's alcoholic impairment of efficiency and judgement which resulted in his attempt to perform aerobatics at night in hilly terrain at an altitude inadequate for terrain clearance.NTSB DEN90LA183Accident · 1 fatalLimited investigationFinal reportBeech E 33 · Tulsa, OKThe pilot's failure to select the right tank prior to the approach resulting in fuel starvation.NTSB DEN89FA152Accident · 1 fatalField investigationFinal reportBeech E33 · Angel Fire, NMImproper planning/decision by the pilot, his premature rotation for takeoff and subsequent failure to obtain or maintain sufficient speed to climb, and his failure to abort the takeoff (while there was sufficient rwy remaining). Contributing factors were: the…NTSB MIA79FA032Accident · 2 fatalClosedBeech E33 · Arcadia, FLNTSB OAK70A0026Accident · 2 fatalClosedBeech E33 · Carson City, NVNTSB IAD70A0005Accident · 1 fatalClosedBeech 35-E33 · Jarrettsville, MD