NTSB investigations: Beech E18S, 1975
18 cases on aircraft the registry lists as Beech E18S. 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 | 6 |
|---|---|
| 1965 | 2 |
| 1966 | 8 |
| 1967 | 7 |
| 1968 | 7 |
| 1969 | 8 |
| 1970 | 13 |
| 1971 | 6 |
| 1972 | 5 |
| 1973 | 19 |
| 1974 | 13 |
| 1975 | 18 |
| 1976 | 15 |
| 1977 | 12 |
| 1978 | 8 |
| 1979 | 17 |
| 1980 | 9 |
| 1981 | 3 |
| 1982 | 3 |
| 1983 | 7 |
| 1984 | 3 |
| 1985 | 8 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 3 |
| 1990 | 4 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 3 |
| 1994 | 3 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 3 |
| 2000 | 1 |
| 2002 | 2 |
| 2003 | 1 |
| 2004 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2009 | 2 |
| 2011 | 1 |
| 2026 | 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\") = 1975
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151006', '1151007'))
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") = 1975
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151006', '1151007'))
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 NYC76AN061Accident · No injuriesClosedBeech E18S · Boston, MANTSB MKC76AK033Accident · 2 fatalClosedBeech E18S · Kansas City, MONTSB CHI76AC036Accident · Minor injuriesClosedBeech E18S · Fort Wayne, INNTSB IAD76AI025Accident · No injuriesClosedBeech E18S · Lexington, KYNTSB FTW76AF044Accident · 2 fatalClosedBeech E18S · Missing AircraftNTSB NYC76AN038Accident · 1 fatalClosedBeech E18S · Charlotte, NCNTSB LAX76FUJ20Accident · No injuriesClosedBeech E18S · Grand Canyon, AZNTSB CHI75FEP65Accident · No injuriesClosedBeech E18S · Burlington, WINTSB CHI75AC097Accident · 2 fatalClosedBeech E18S · Toledo, OHNTSB FTW75AF069Accident · 1 fatalClosedBeech E18S · Claude, TXNTSB IAD75AI058Accident · 1 fatalClosedBeech E18S · Salisbury, MDNTSB CHI75FEES9|CHI75FEE59Accident · No injuriesClosedBeech A36 · Rockford, ILNTSB ANC75AA076Accident · No injuriesClosedBeech E18S · Montague Is, AKNTSB CHI75AC079Accident · No injuriesClosedBeech E18S · Columbus, OHNTSB CHI75AC074Accident · 1 fatalClosedBeech E18S · Argos, INNTSB NYC75FEE52Accident · 1 fatalClosedBeech E18S · Wheeling, ILNTSB MKC75AK046Accident · 1 fatalClosedBeech D18S · Dodge City, KSNTSB CHI75AC048Accident · 1 fatalClosedBeech E18S · Rockford, IL