Fatal NTSB investigations: Beech A23-19
14 cases on aircraft the registry lists as Beech A23-19. 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
| 1966 | 1 |
|---|---|
| 1967 | 3 |
| 1968 | 3 |
| 1970 | 1 |
| 1972 | 1 |
| 1975 | 1 |
| 1981 | 1 |
| 1988 | 2 |
| 1992 | 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 ('1151212'))
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 ('1151212'))
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 MIA92FA173Accident · 2 fatalField investigationFinal reportBeech BE-A23-19 · Picayune, MSThe failure of the pilot in command to place the fuel selector on the fullest tank, resulting in an engine failure due to fuel starvation over unsuitable terrain.NTSB MKC88FA098Accident · 1 fatalField investigationFinal reportBeech A-23-19 · Big Island, ARIncapacitation of the pilot due to a medical event which resulted in loss of aircraft control.NTSB DEN88FA099Accident · 2 fatalField investigationFinal reportBeech A23-19 · Gunnison, COOn a cross country flt, the plt attempted to climb through a pass which was above the effective service ceiling of the acft. At approximately the effective service ceiling of the acft the acft collided with terrain. The acft was destroyed by impact and post…NTSB LAX81FA108Accident · 2 fatalClosedBeech A23-19 · Big Bear City, CANTSB MIA75AM060Accident · 1 fatalClosedBeech A23-19 · Perry, FLNTSB MIA72AM118Accident · 1 fatalClosedBeech A23 · Leakesville, MSNTSB SEA70AS028Accident · 1 fatalClosedBeech A23-19 · Marysville, WANTSB MIA69F0181Accident · 1 fatalClosedBeech A23-19 · Utica, MSNTSB SEA69D0071Accident · 1 fatalClosedBeech A23-19 · Mccall, IDNTSB DIA68A0047Accident · 2 fatalClosedBeech A23-19 · Chesapeake, VANTSB OAK68A0021Accident · 2 fatalClosedBeech 23 · French Camp, CANTSB LAX68A0001Accident · 4 fatalClosedBeech A23 · Torrance, CANTSB DEN67A0051Accident · 2 fatalClosedBeech A23 · Albuquerque, NMNTSB CHI67A0073Accident · 1 fatalClosedBeech A23-19 · Toledo, OH