NTSB investigations: Beech E18S
10 cases on aircraft the registry lists as Beech E18S, where the first occurrence was “Loss of control - in flight”. 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
| 1984 | 1 |
|---|---|
| 1986 | 2 |
| 1988 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1997 | 1 |
| 2002 | 2 |
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.\"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\" = 250))
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" = 250))
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 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.NTSB ANC02FA028Accident · 1 fatalField investigationFinal reportBeech E18S · Juneau, AKThe pilot's excessive loading of the airplane that precipitated an inadvertent stall/mush during the initial climb.NTSB NYC97FA057Accident · 2 fatalField investigationFinal reportBeech E-18S · Mabie, WVThe pilot's disregard of the preflight weather briefing for severe weather along his route of flight, and his departure into the known and forecasted severe weather. A factor in the accident was the inadequate FAA oversight of the operator, which fostered an…NTSB CHI95LA053Accident · 1 fatalLimited investigationFinal reportBeech E18S · Kansas City, MOFailure of the pilot to maintain adequate airspeed on final approach, which resulted in an inadvertent stall/spin. Factors related to the accident were: the adverse weather (icing) conditions, the accumulation of airframe/wing ice, the pilot's improper use of…NTSB CHI93FA193Accident · 1 fatalField investigationFinal reportBeech E18S · Ypsilanti, MIThe pilot-in-command's inadequate preflight preparation, false indication (on/off) of attitude indicator, and attitude indicator switched off. Factors were fog, low ceiling, the pilot-in-command's improper use of the attitude indicator, and his lack of total…NTSB ANC90FA027Accident · No injuriesField investigationFinal reportBeech E18F · Anchorage, AKInadequate supervision by company/operator personnel and inadequate preflight planning/preparation by the captain, which resulted in an improperly loaded aircraft.NTSB CHI88FA075Accident · 3 fatalField investigationFinal reportBeech E18S · Warren, MIThe flt was an air taxi cargo flt carrying truck parts. After takeoff, the twr asked the plt if he was in difficulty and the plt replied 'roger' and requested a change of flt plan. The acft was seen flying erratically just above the tree tops. The acft…NTSB MKC87FA017Accident · 1 fatalField investigationFinal reportBeech E18S · Texarkana, ARThe airplane was on a positioning flight so it would be in place for an early Monday morning freight run. Pilot called for missed approach and after receiving clearance, declared he was in VFR conditions and thought he would land on rwy 31. During a turn, the…NTSB FTW86FPA13Accident · No injuriesFinal reportBeech E18S · Terrell, TXThe plt reported the acft yawed left on takeoff and despite attempted remedial action the acft would not clear odstaclesalong the flt path. Pwr was reduced and a straight in landing was made in a fld aprx 1/4 mile north of the rwy. A witness reported the acft…NTSB CHI85FA072Accident · No injuriesField investigationFinal reportBeech B-18S · Bellesville, MIThe plt stated that just after lift off the acft veered to the left going off the rwy striking the ground. Investigationrevealed that the plt in the left seat was receiving training & both plts were at the controls. The acft eng & airframe were inspected &…