Fatal NTSB investigations: Beech D-45
11 cases on aircraft the registry lists as Beech D-45. 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 |
|---|---|
| 1974 | 1 |
| 1976 | 1 |
| 1982 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 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 ('1152012'))
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 ('1152012'))
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 ERA12FA062Accident · 2 fatalField investigationFinal reportBeech D-45 · Williston, FLThe flight instructor's failure to maintain airspeed in changing wind conditions during a steep climb after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the flight instructor’s ostentatious display close to the ground.NTSB FTW02FA113Accident · 2 fatalField investigationFinal reportBeech D-45 · Minden, LAThe private pilot's failure to maintain aircraft control during a go-around. Contributing factors were the private pilot's impairment due to drugs, the pilot-rated passenger's lack of experience in the airplane, and the prevailing gusty crosswind conditions.NTSB LAX01FA178Accident · 2 fatalField investigationFinal reportBeech D45 · Julian, CAThe pilot's selection of an insufficient altitude over rising mountainous terrain and his failure to maintain adequate terrain clearance.NTSB CHI00FA003Accident · 1 fatalField investigationFinal reportBeech D-45 · Oswego, ILthe visual lookout not obtained by the pilot of the Beech T-34 and the inadequate procedure by the Lima Lima Flying Squadron. The delayed entry into the maneuver by the pilot of the Beech D-45 was a contributing factor.NTSB IAD98FA103Accident · 2 fatalField investigationFinal reportBeech T-34B · Quantico, VAThe failure of the flight instructor to maintain airspeed which resulted in an inadvertent stall/spin.NTSB MIA97FA034Accident · 2 fatalField investigationFinal reportBeech D-45 · Poplarville, MSthe noninstrument-rated pilot's intentional operation of the airplane with known deficiencies in equipment (inoperative attitude indicator and directional gyro) with an estimated time of arrival after official twilight. Also, poor in-flight planning decision…NTSB LAX82FVA13Accident · 1 fatalFinal reportBeech T-34B · Lemoore, CAThe T-34 pilot entered a downwind behind a Cessna 150 aircraft. When the T-34 pilot was abeam the approach end of runway 32R, he was cleared for a touch and go. By this time, the Cessna 150 was on the runway. The Cessna pilot requested a 180 degree turn to…NTSB LAX77FA008Accident · 1 fatalClosedBeech D-45 · Avalon, CANTSB CHI74FEP44Accident · 1 fatalClosedBeech T34B · Wautoma, WINTSB UNK69X0125Accident · 1 fatalClosedBeech T-34B · Atsugi Nas, JANTSB FTW69A0082Accident · 2 fatalClosedBeech T-34B · Bishop, TX