NTSB investigations: Beech E18S, 1984
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\") = 1984
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") = 1984
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 CHI85FA072Accident · No injuriesField investigationFinal reportBeech B-18S · Bellesville, MIThe plt stated that just after lift off the acft veered to the left going off the rwy striking the ground. Investigationrevealed that the plt in the left seat was receiving training & both plts were at the controls. The acft eng & airframe were inspected &…NTSB CHI84LA182Accident · Minor injuriesLimited investigationFinal reportBeech E18S · Marion, ILThe acft crashed after takeoff from rwy 29 at williamson county airport. The plt stated that she mismanaged the fuel system & that she 'probably tookoff on fumes.' She further stated that she should have told the company 'I'm to tired to make this flt.'NTSB LAX84LA245Accident · No injuriesLimited investigationFinal reportBeech E18S · Buellton, CAThese acft collided in flt while being ferried. The weather was VMC. N8711 was damaged substantially and N753CW receivedminor damage. Both acft landed at santa ynez arpt where N8711 lost control during rollout and ran off the rwy. N753CW was landed with the…