Fatal NTSB investigations: Beech B90
8 cases on aircraft the registry lists as Beech B90. 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
| 1975 | 1 |
|---|---|
| 1978 | 1 |
| 1994 | 1 |
| 1999 | 2 |
| 2001 | 1 |
| 2004 | 1 |
| 2009 | 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 ('1152912'))
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 ('1152912'))
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 ERA09LA435Accident · 1 fatalLimited investigationFinal reportBeech B90 · West Point, VAThe inadvertent deployment of the instructor's reserve parachute.NTSB CHI04FA066Accident · 3 fatalField investigationFinal reportBeech B90 · Dodge City, KSThe pilot failed to maintain clearance with terrain due to pilot fatigue (lack of sleep).NTSB DEN01FA098Accident · 1 fatalField investigationFinal reportBeech King Air B90 · San Jon, NMthe pilot's failure to maintain aircraft control due to his incapacitation for an undetermined reason. A contributing factor was the subsequent inadvertent stall/spin to the ground.NTSB MIA99FA245Accident · 8 fatalField investigationFinal reportBeech B-90 · West Palm Beach, FLa total loss of engine power due to fuel exhaustion. Contributing factors in this accident were the pilot's operation of the airplane in an overweight condition, inadequate pre-flight and in-flight planning.NTSB LAX99LA190Accident · 1 fatalLimited investigationFinal reportBeech B90 · Mokuleia, HIThe pilot's incapacitation due to the effects of hypoxia from repeated flights to altitudes above 18,000 feet msl without supplemental oxygen.NTSB MIA94MA048Accident · 10 fatalMajor investigationFinal reportBeech B90 · Okeechobee, FLThe pilot's improper remedial action concerning a right engine power anomaly, and his failure to maintain adequate airspeed during go-around from an aborted precautionary landing, which resulted in a loss of aircraft control and an uncontrolled descent.…NTSB MIA78FA031Accident · 5 fatalClosedBeech B-90 · Yazoo City, MSNTSB CHI75AC056Accident · 4 fatalClosedBeech B90 · Joliet, IL