NTSB investigations: Beech E18S, 1973
19 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\") = 1973
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") = 1973
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 NYC74DFJ25Accident · Minor injuriesClosedBeech E18S · Syracuse, NYNTSB FTW74AF041Accident · No injuriesClosedBeech E18S · Oklahoma Cty, OKNTSB CHI74AC049Accident · No injuriesClosedBeech E18S · Geneva, ILNTSB MKC74AK028Accident · 1 fatalClosedBeech E18S · Muscatine, IANTSB MIA74AM042Accident · No injuriesClosedBeech E18S · San Juan, PRNTSB MKC74FCA15Accident · No injuriesClosedBeech E18S · F.Leonard Wood, MONTSB CHI74AC039Accident · No injuriesClosedBeech E18E · Chicago, ILNTSB FTW74AF026Accident · No injuriesClosedBeech E18S · El Paso, TXNTSB FTW74AF017Accident · 6 fatalClosedBeech E18S · Natchitoches, LANTSB CHI74AC017Accident · No injuriesClosedBeech E18S · Urbana, OHNTSB MKC74FCA06Accident · No injuriesClosedBeech E18S · St Louis, MONTSB CHI74FEG01Accident · Minor injuriesClosedBeech E18S · Vandalia, OHNTSB IAD73AI018Accident · No injuriesClosedBeech E18S · Covington, KYNTSB CHI73AC094Accident · No injuriesClosedBeech E18S · Chicago, ILNTSB FTW73AF071Accident · 1 fatalClosedBeech E18S · Tyler, TXNTSB NYC73AN145Accident · No injuriesClosedBeech E18S · Watertown, NYNTSB MKC73AK064Accident · 6 fatalClosedBeech E18S · Davenport, IANTSB MIA73RM094Accident · 1 fatalClosedBeech E18S · Grn Trtl C, Burkina FasoNTSB CHI73AC076Accident · 1 fatalClosedBeech E18S · Missing Aircraft