NTSB investigations: Beech D18S, 1965
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
| 1964 | 17 |
|---|---|
| 1965 | 19 |
| 1966 | 24 |
| 1967 | 23 |
| 1968 | 10 |
| 1969 | 19 |
| 1970 | 21 |
| 1971 | 8 |
| 1972 | 16 |
| 1973 | 12 |
| 1974 | 12 |
| 1975 | 10 |
| 1976 | 11 |
| 1977 | 10 |
| 1978 | 9 |
| 1979 | 5 |
| 1980 | 4 |
| 1981 | 5 |
| 1982 | 4 |
| 1983 | 4 |
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 4 |
| 1988 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2000 | 2 |
| 2007 | 1 |
| 2016 | 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 year(c.\"eventDate\") = 1965
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 year(c."eventDate") = 1965
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 UNK66X0117Accident · No injuriesClosedBeech D18S · Ixcalak, MexicoNTSB MIA66F0307Accident · No injuriesClosedBeechcraft D-18S · Miami, FLNTSB CHI66F0388Accident · No injuriesClosedBeechcraft D-18S · Columbus, OHNTSB CHI66D0456Accident · No injuriesClosedBeechcraft D-18S · Ft Wayne, INNTSB CHI66F0224Accident · No injuriesClosedBeechcraft D-18S · Detroit, MINTSB MIA66A0029Accident · No injuriesClosedBeechcraft D-18S · Atlanta, GANTSB CHI66D0213Accident · No injuriesClosedBeechcraft D-18S · Cleveland, OHNTSB FTW66F0283Accident · No injuriesClosedBeechcraft D-18S · Ft Worth, TXNTSB LAX66A0017Accident · 8 fatalClosedBeech C-45H · Lakewood, CANTSB OAK67D0143Accident · No injuriesClosedBeech D18S · Oakland, CANTSB MIA66F0017Accident · No injuriesClosedBeechcraft D18S · Orlando, FLNTSB MIA65F0102Accident · Serious injuriesClosedBeech D18S · Opa-Locka, FLNTSB NYC65F0121Accident · No injuriesClosedBeechraft D-18S · Boston, MANTSB CHI65F0099Accident · No injuriesClosedBeechcraft D-18S · Wakeman, OHNTSB NYC65F0223Accident · Minor injuriesClosedBeechcraft D-18S · New Castle, DENTSB FTW65F0009Accident · No injuriesClosedBeechcraft D-18S · El Paso, TXNTSB LAX65A0062Accident · 1 fatalClosedBeechcraft D18S · Elko, NVNTSB UNK65X1328Accident · No injuriesClosedBeechcraft D-18S · Africa, LibyaNTSB NYC65F0012Accident · No injuriesClosedBeechraft D18S · Frederick, MD