NTSB investigations: Beech E18S

7 cases on aircraft the registry lists as Beech E18S, where the first occurrence was “Loss of control - on ground/water”. 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

19822026

NTSB investigations: Beech E18S per year, 1982–2026: 7 cases
1982	1
1983	3
1985	1
1990	1
1992	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151006', '1151007') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151006', '1151007')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151006', '1151007')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 LAX92LA177Accident · No injuriesLimited investigationFinal reportBeech E18S · Eloy, AZFailure of the pilot-in-command to maintain directional control and to properly compensate for the unfavorable wind conditions encountered during the takeoff ground run. Contributing to the accident was the unforecasted dust devil weather phenomena.Apr 16, 1992 · N711DN · Substantial damage NTSB CHI91LA004Accident · No injuriesLimited investigationFinal reportBeech E-18 · Minneapolis, MNFailure of the pilot-in-command to maintain directional control of the aircraft during landing roll.Oct 5, 1990 · N703M · Substantial damage NTSB MIA86LA042Accident · No injuriesLimited investigationFinal reportBeech E-18S · Opa Locka, FLThe plt stated that while on his takeoff roll, the left main wheel started to shimmy, the acft pulled left then veered off the right side of the rwy, collapsing the tail wheel & coming to rest in the grass.Dec 13, 1985 · N43T · Substantial damage NTSB NYC84LA023Accident · No injuriesLimited investigationFinal reportBeech E18S · Franklin, PAAfter landing, the acft veered off the rwy. Subsequently, it went down an embankment & was substantially damaged. No pre-crash part malfunction or failure was found.Nov 8, 1983 · N383B · Substantial damage NTSB ATL84LA009Accident · No injuriesLimited investigationFinal reportBeech E18S · Denver, NCAfter taxiing onto the rwy the plt ran the engs up to takeoff power of 36' mp & began the takeoff roll. Shortly thereafter she reduced power to about 25'-30' mp because the acft appeared to accelerate slowly. After a quick scan of the instruments which…Oct 3, 1983 · N700M · Substantial damage NTSB MIA83FA063Accident · No injuriesField investigationFinal reportBeech E18-S · Naples, FLThe acft departed the right side of the runway and the right gear separated from the acft. Examination of the fracture surface revealed no evidence of fatigue or other type of slow growth cracking.Jan 21, 1983 · N342T · Substantial damage NTSB FTW82DRG40Accident · No injuriesFinal reportBeech E18S · Corpus Christi, TXThe pilot reported that during the landing roll-out, the aircraft swerved after it had traveled some 1500 to 1700 ft down the runway. During the accident, the nose gear failed and the bottom of the aircraft was damaged from the forward spar to the nose. Also,…Aug 12, 1982 · N37M · Substantial damage