NTSB investigations: Beech E18S, OH
20 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 | 1 |
|---|---|
| 1966 | 2 |
| 1967 | 1 |
| 1970 | 1 |
| 1972 | 1 |
| 1973 | 2 |
| 1974 | 1 |
| 1975 | 2 |
| 1977 | 2 |
| 1979 | 3 |
| 1983 | 1 |
| 1985 | 1 |
| 1991 | 1 |
| 2000 | 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 c.\"eventStateOrRegion\" = 'OH' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'OH' AND c."eventCountry" = 'USA'
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 NYC01FA007Accident · 1 fatalField investigationFinal reportBeech E18S · Wash. Ct. House, OHAn undetermined event, which resulted in an off airport landing. A factor in this accident was the night light condition.NTSB NYC91LA215Accident · Minor injuriesLimited investigationFinal reportBeech E18S · Martinsville, OHA failure of one engine for undetermined reasons. Additionally, the heavy gross weight resulted in inadequate single engine performance, which lead to a forced landing.NTSB CHI85LA302Accident · No injuriesLimited investigationFinal reportBeech E18S · Youngstown, OHDuring initial climb, the plt noted a vibration. He was unable to identify the source & elected to land gear up on the remaining rwy. An exam of the acft revealed that the stick shaker sys had been activated by an electrical problem in the left eng nacelle…NTSB CHI83LA271Accident · No injuriesLimited investigationFinal reportBeech E18S · Youngstown, OHThe plt had not obtained a wx briefing, but had gotten info from another company plt who had flown into the destination arpt earlier. During arrival, he could see the rotating beacon & rwy lights thru some fog & elected to make a visual apch. At aprx 75 ft…NTSB CHI79FEG18Accident · Serious injuriesClosedBeech E-18S · Dayton, OHNTSB CHI79FA049Accident · 1 fatalClosedBeech E18S · Burton, OHNTSB CHI79FEI18Accident · Minor injuriesClosedBeech E18S · North Jackson, OHNTSB CHI77FA066Accident · Minor injuriesClosedBeech E18S · Buckeye Lake, OHNTSB CHI77FA048Accident · 1 fatalClosedBeech E18S · Springfield, OHNTSB CHI75AC097Accident · 2 fatalClosedBeech E18S · Toledo, OHNTSB CHI75AC079Accident · No injuriesClosedBeech E18S · Columbus, OHNTSB CHI75AC043Accident · Minor injuriesClosedBeech E18S · Elyria, OHNTSB CHI74AC017Accident · No injuriesClosedBeech E18S · Urbana, OHNTSB CHI74FEG01Accident · Minor injuriesClosedBeech E18S · Vandalia, OHNTSB CHI72AC102Accident · 1 fatalClosedBeech E18S · Cleveland, OHNTSB CHI70AC058Accident · No injuriesClosedBeech E18S · Cleveland, OHNTSB CHI68D0432Accident · No injuriesClosedBeech E18S · Cleveland, OHNTSB CHI67F0267Accident · No injuriesClosedBeech E18S · Fremont, OHNTSB CHI66D0568Accident · No injuriesClosedBeechcraft E18S · Wakeman, OHNTSB UNK64X2098Accident · 1 fatalClosedBeechcraft E-18S · Wooster, OH