NTSB investigations: Beech E18S, IL
15 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
| 1966 | 1 |
|---|---|
| 1970 | 1 |
| 1971 | 1 |
| 1973 | 3 |
| 1974 | 1 |
| 1975 | 3 |
| 1976 | 1 |
| 1977 | 1 |
| 1979 | 1 |
| 1984 | 1 |
| 1987 | 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\" = 'IL' 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" = 'IL' 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 CHI87FA085Accident · 2 fatalField investigationFinal reportBeech E18S · Quincy, ILThe acft, at near gross weight (CG unknown), was on initial climb after takeoff. A witness reported that engines soundednormal. At about 400 ft AGL the acft was reported to pitch up about 10 degrees, then level off and enter a left turn. The acft made another…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 CHI79FEE43Accident · Minor injuriesClosedBeech E18S · Chicago, ILNTSB CHI78FEE14Accident · No injuriesClosedBeech E18 · Chicago, ILNTSB CHI77FEE04Accident · No injuriesClosedBeech E18S · W Chicago, ILNTSB CHI75FEES9|CHI75FEE59Accident · No injuriesClosedBeech A36 · Rockford, ILNTSB NYC75FEE52Accident · 1 fatalClosedBeech E18S · Wheeling, ILNTSB CHI75AC048Accident · 1 fatalClosedBeech E18S · Rockford, ILNTSB CHI75FEE02Accident · Serious injuriesClosedBeech E18S · Lansing, ILNTSB CHI74AC049Accident · No injuriesClosedBeech E18S · Geneva, ILNTSB CHI74AC039Accident · No injuriesClosedBeech E18E · Chicago, ILNTSB CHI73AC094Accident · No injuriesClosedBeech E18S · Chicago, ILNTSB DCA72AZ004Accident · 16 fatalClosedBeech E18S · Peoria, ILNTSB CHI71IC006Incident · No injuriesClosedBeech E18S · Rockford, ILNTSB CHI66F0565Accident · No injuriesClosedBeechcraft E18S · Chicago, IL