NTSB investigations: Beech D18S, 1964
17 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\") = 1964
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") = 1964
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 UNK65X0833Accident · No injuriesClosedBeechcraft D18 · Alief, TXNTSB UNK65X0516Accident · No injuriesClosedBeechcraft D18S · Kingston, NYNTSB UNK64X3994Accident · No injuriesClosedBeechcraft D18S · Sierra Vista, AZNTSB UNK64X3947Accident · No injuriesClosedBeechcraft D18S · Linden, NJNTSB UNK64X3890Accident · 2 fatalClosedBeechcraft D18S · Victoria, TXNTSB UNK64X3734Accident · No injuriesClosedBeechcraft D18 · Marion, INNTSB UNK64X3661Accident · No injuriesClosedBeech D18 · Springfield, OHNTSB UNK64X3083Accident · No injuriesClosedBeechcraft D18S · Aberdeen, SDNTSB UNK64X2839Accident · No injuriesClosedBeechcraft D18S · Wakeman, OHNTSB UNK64X2801Accident · No injuriesClosedBeechcraft D18S · Baltimore, MDNTSB UNK64X2744Accident · No injuriesClosedBeechcraft D18 · Ambler, PANTSB UNK64X2056Accident · No injuriesClosedBeechcraft D-18S · Memphis, TNNTSB UNK64X1751Accident · No injuriesClosedBeechcraft D18S · Minneapolis, MNNTSB UNK64X1369Accident · No injuriesClosedBeechraft D-18S · Uqayyil, Saudi ArabiaNTSB UNK64X0447Accident · 10 fatalClosedBeechcraft D18S · Gainesville, FLNTSB UNK64X0261Accident · No injuriesClosedBeechcraft D18S · Albuquerque, NMNTSB UNK64X0232Accident · Minor injuriesClosedBeechcraft D18S · Kaanapali, HI