NTSB investigations: Beech E18S, 1994
3 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\") = 1994
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") = 1994
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 CHI95LA053Accident · 1 fatalLimited investigationFinal reportBeech E18S · Kansas City, MOFailure of the pilot to maintain adequate airspeed on final approach, which resulted in an inadvertent stall/spin. Factors related to the accident were: the adverse weather (icing) conditions, the accumulation of airframe/wing ice, the pilot's improper use of…NTSB ATL94LA113Accident · Serious injuriesLimited investigationFinal reportBeech E18S · Laurens, SCThe loss of engine power on one engine followed by failure of the propeller to feather or be feathered.NTSB ATL94LA045Accident · No injuriesLimited investigationFinal reportCessna 310R · Memphis, TNThe failure of the pilot of N2069C to follow the ATC directive to give way to N3844C, and the inadequate visual lookout by the pilot of N2069C. A factor was the dark night lighting condition at the time of the accident.