NTSB investigations: Beech D18S, CA
19 cases on aircraft the registry lists as Beech D18S. 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
| 1965 | 2 |
|---|---|
| 1966 | 2 |
| 1967 | 1 |
| 1972 | 1 |
| 1973 | 4 |
| 1974 | 1 |
| 1975 | 2 |
| 1976 | 2 |
| 1978 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1987 | 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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151004'))
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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151004'))
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 LAX87LA265Accident · No injuriesLimited investigationFinal reportBeech D18S · Riverside, CAThe acft had not been flown for svrl years & was on a flt to ferry it to another location. While cruising at 7500', the plt decided to start using aux fuel. Shortly after moving the fuel selectors to the aux psn, both engs lost power & would not restart. The…NTSB LAX81IA015Incident · No injuriesClosedBeech D18S · Long Beach, CANTSB LAX80FUG07Accident · Minor injuriesClosedBeech D18S · Corona, CANTSB LAX78FUA32Accident · No injuriesClosedBeech D18S · Long Beach, CANTSB OAK76FVG58Accident · No injuriesClosedBeech D18S · Woodland, CANTSB OAK76DXQ32Accident · No injuriesClosedBeech D18S · S.Lake Tahoe, CANTSB OAK76AP032Accident · No injuriesClosedBeech D18S · Oakland, CANTSB OAK75AP037Accident · No injuriesClosedVolpar 18 · San Jose, CANTSB LAX75AL028Accident · 3 fatalClosedBeech D18S · Tustin, CANTSB OAK74FVD03Accident · Serious injuriesClosedBeech B18 · Hayward, CANTSB LAX73DUG63Accident · No injuriesClosedBeech D18S · Perris, CANTSB OAK73AP026Accident · No injuriesClosedBeech D18S · Oakland, CANTSB OAK73AP023Accident · No injuriesClosedBeech D18S · Fresno, CANTSB OAK72FVM30Accident · No injuriesClosedBeech D18S · San Jose, CANTSB LAX68F0010Accident · No injuriesClosedBeech D18S · Burbank, CANTSB LAX66F0279Accident · No injuriesClosedBeech D18S · Santee, CANTSB OAK66A0039Accident · No injuriesClosedBeech D18S · Oakland, CANTSB LAX66A0017Accident · 8 fatalClosedBeech C-45H · Lakewood, CANTSB OAK67D0143Accident · No injuriesClosedBeech D18S · Oakland, CA