NTSB investigations: Beech E18S, WI

10 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19672026

NTSB investigations: Beech E18S, WI per year, 1967–2026: 10 cases
1967	1
1969	2
1970	2
1975	1
1976	1
1985	1
1990	1
1993	1

Where

Open the map

Latest cases

Query with SQL

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" = 'WI' 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

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\" = 'WI' 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" = 'WI' 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

Run 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 CHI93FA158Accident · 1 fatalField investigationFinal reportBeech E-18S · Lone Rock, WIwas a pre-mature extension of the landing gear by the pilot which resulted in the inability of the pilot to maintain the minimum descent altitude. Factors related to the accident were the loose cylinder and loss of oil.May 4, 1993 · N80CB · Destroyed NTSB CHI90LA072Accident · No injuriesLimited investigationFinal reportBeech E18S · Oak Creek, WIImproper planning/decision by the pilot. Factors related to the accident were: the adverse weather conditions, accumulation of structural and/or induction ice, and dark night.Jan 25, 1990 · N48K · Substantial damage NTSB CHI85FA170Accident · No injuriesField investigationFinal reportBeech E18S · Janesville, WIOn April 20,1985 at approx. 2100HRS local time a Beechcraft model E185 N68Y owned and operated by blackhawk airways inc. was conducting a normal runup in preparation for a flight from Janesville, WI. (Jvl) to chicago IL. (Ord). At the completion of the of the…Apr 21, 1985 · N68V · Substantial damage NTSB CHI76AC052Accident · 1 fatalClosedBeech E18S · Burlington, WIMar 1, 1976 · N386 · Destroyed NTSB CHI75FEP65Accident · No injuriesClosedBeech E18S · Burlington, WIJul 25, 1975 · N402FW · Substantial damage NTSB CHI71AC020Accident · No injuriesClosedBeech E18S · Lyndon Sta, WISep 15, 1970 · N387W · Substantial damage NTSB CHI71FDJ07Accident · Serious injuriesClosedBeech E18S · Delavan, WIJul 25, 1970 · N3333C · Destroyed NTSB MKC70A0018Accident · No injuriesClosedBeech E18S · Ashland, WIOct 12, 1969 · N3785B · Substantial damage NTSB CHI69A0070Accident · No injuriesClosedBeech E18S · La Crosse, WIFeb 5, 1969 · N68V · Substantial damage NTSB CHI67D0659Accident · No injuriesClosedBeech E18S · Fond Du Lac, WIApr 23, 1967 · N8211 · Substantial damage