Skip to content

NTSB investigations: Beech E18S, FL

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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19672026

Where

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" = 'FL' 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\" = 'FL' 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" = 'FL' 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 ERA11FA274Accident · 1 fatalField investigationFinal reportBeech E18S · Miami Gardens, FLThe pilot’s improper response to a loss of power in the No. 2 engine and his failure to ensure that the airplane was airworthy. Contributing to the accident was the inadequate engine maintenance by the operator's maintenance personnel.May 2, 2011 · N18R · Substantial damage NTSB ERA09LA108Accident · Serious injuriesLimited investigationFinal reportBeech E18S · Fort Myers, FLThe failure of the right propeller to go to the feathered position for undetermined reasons following a total loss of right engine power during initial climb due to fuel starvation as a result of the pilot's improper fuel planning.Dec 27, 2008 · N7765N · Substantial damage NTSB MIA08LA014Accident · No injuriesLimited investigationFinal reportCessna C208B · Opa Locka, FLFailure of the local controller to coordinate with the ground controller and the failure of the pilots to see and avoid each other.Nov 6, 2007 · N701SE · 2 aircraft · Substantial damage NTSB ATL02LA131Accident · No injuriesLimited investigationFinal reportBeech 18 · Venice, FLThe pilot's improper use of flight controls during takeoff, that resulted in the loss of control during takeoff.Jun 26, 2002 · N1002C · Destroyed 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 MIA85FA166Accident · Minor injuriesField investigationFinal reportBeech E18S · West Palm Bch, FLDrg takeoff from rwy 13, the l eng lost pwr after the acft had climbed to about 200' AGL & accellerated to aprx 125 KTS with the gear & flaps retracted. The plt aborted the takeoff & turned the acft to land on rwy 9. However, it touched dwnin the grass after…May 6, 1985 · N57AE · Substantial damage NTSB MIA83IA236Incident · No injuriesIncident investigationFinal reportBeech E18S · Opa-Locka, FLBoth normal and emergency landing gear systems failed duringthe landing apch. The gear motor cutout switch was struck anthe emergency instruction plate in the cockpit was installed backwards. The pilot states that he had tried turning the handle in both…Sep 22, 1983 · N967 · Minor 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 MIA81FA008Accident · 3 fatalClosedBeech E18S · Gainesville, FLOct 24, 1980 · N65V · Destroyed NTSB MIA80FA022Accident · 4 fatalClosedBeech E18S · Orlando, FLDec 22, 1979 · N198B · Destroyed NTSB MIA79FKT76Accident · No injuriesClosedBeech 18 · Homestead, FLJun 23, 1979 · N76LA · Substantial damage NTSB MIA79FA033Accident · No injuriesClosedBeech 58 · Ft Lauderdale, FLJan 3, 1979 · N12WF · 2 aircraft · Substantial damage NTSB MIA74DLD52Accident · No injuriesClosedBeech E18S · Williston, FLJan 9, 1974 · N45TB · Substantial damage NTSB MIA69D0148Accident · No injuriesClosedBeech E18S · Marco Island, FLSep 5, 1968 · N820 · Destroyed NTSB MIA68F0122Accident · No injuriesClosedBeech E18S · Tampa, FLAug 8, 1967 · N54K · Substantial damage