Skip to content

Beech E18S-9700

NTSB investigations · 22

Matched to the registry by N-number and event date, newest first.

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('1151008') 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('1151008')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('1151008')
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 ANC11LA007Accident · No injuriesLimited investigationFinal reportBeech E18S-9700 · New Stuyahok, AKThe pilot's misjudgment of the runway surface condition, resulting in an aborted landing and collision with rising terrain during the ensuing takeoff attempt.Jan 3, 2011 · N9001 · Substantial damage NTSB DFW08CA159Accident · No injuriesData collectionFinal reportBeech E-18 · Guymon, OKThe pilot's failure to maintain directional control during landing roll out. Contributing to the accident was the crosswind.Jun 1, 2008 · N241X · Substantial damage NTSB FTW98LA178Accident · Minor injuriesLimited investigationFinal reportBeech E18S · Del Rio, TXa loss of engine power on the right engine for undetermined reasons, and the pilot's failure to maintain control of the airplane.Apr 9, 1998 · N2083C · Substantial damage NTSB MIA95LA215Accident · 1 fatalLimited investigationFinal reportBeech E-18S · Atlantic Ocean (Atlantic Ocean)Undetermined.Aug 28, 1995 · N171LG · Destroyed NTSB BFO93LA064Accident · No injuriesLimited investigationFinal reportBeech E18S · Xenia, OHInadequate preflight by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.May 1, 1993 · N665M · Substantial damage NTSB CHI93LA155Accident · No injuriesLimited investigationFinal reportMaule M5 · Green Bay, WIThe pilot's failure to maintain control of the airplane.Apr 30, 1993 · N5644D · Substantial damage NTSB ATL83FAG12Accident · No injuriesFinal reportBeech E18S · Jonesboro, GAThe acft ran off the departure end of the rwy and nosed over during takeoff after an engine lost power. The acft had notbeen flown in several weeks and there had been days of rain and humidity. The magnetoes on the right engine were rough but seemed to clear…Sep 20, 1983 · N452CC · Substantial damage NTSB FTW83LA162Accident · No injuriesLimited investigationFinal reportBeech E18 · Dfw Airport, TXN80017 experienced engine trouble and shut down the left engine enroute from amarillo, TX. Later, because of electrical problems the pilot secured all electrical equipment except the no. 2 radio, transponder and rotating beacon after landing, the pilot taxied…Mar 18, 1983 · N130L · 2 aircraft · Minor damage NTSB NYC82FHD18Accident · Serious injuriesFinal reportBeech E18S · Lakewood, NJPrior to flt the spark plugs on both engs were replaced due to minor eng vibration & the landing gear retract system wiring repaired due to the gear not retracting electrically on a prior occasion. After takeoff the gear would not retract electrically & the…Aug 13, 1982 · N380MA · Destroyed NTSB DEN82FA074Accident · 2 fatalField investigationFinal reportBeech E18S · Hakalau, HIThe aircraft departed hilo on the last leg of a 3 flight. A few minutes after takeoff, the pilot called the tower to askfor return and indicated he had a difficulty. No further transmission was made. Witnesses heard intermittent engine sputtering and then the…Apr 29, 1982 · N6911 · Destroyed NTSB MIA80FLA37Accident · Serious injuriesClosedBeech E18S · Gainesville, FLSep 9, 1980 · N43L · Destroyed NTSB CHI79FEV10Accident · No injuriesClosedBeech E18-S · Springfield, ILJan 27, 1979 · N521GP · Substantial damage NTSB MIA78FA099Accident · No injuriesClosedBeech E18S · Birmingham, ALJun 26, 1978 · N5644D · Substantial damage NTSB CHI78FEE11Accident · No injuriesClosedBeech E18S · Chicago, ILDec 17, 1977 · N3131W · Substantial damage NTSB CHI76AC058Accident · No injuriesClosedBeech E18 · Kalamazoo, MIApr 30, 1976 · N2510C · Substantial damage NTSB NYC76AN054Accident · No injuriesClosedBeech E18S · N Springfield, VTDec 9, 1975 · N62V · Substantial damage NTSB CHI75AC026Accident · 2 fatalClosedBeech E18S · Madison, INSep 11, 1974 · N1258 · Destroyed NTSB NYC74AN051Accident · 2 fatalClosedBeech E18S · Corapolis, PADec 7, 1973 · N387B · Destroyed NTSB MIA72AM114Accident · No injuriesClosedBeech E18S · Tallahassee, FLApr 27, 1972 · N5640D · Substantial damage NTSB MKC71FCG39Accident · No injuriesClosedBeech E18S · Kansas City, MODec 16, 1970 · N1258 · Substantial damage NTSB CHI70AC090Accident · No injuriesClosedBeech E18 · Detroit, MIJun 17, 1970 · N1814 · Substantial damage NTSB NYC66F0152Accident · No injuriesClosedBeechcraft E-18S · Red Bank, NJAug 5, 1965 · N1814 · Substantial damage

Back to Beech E18S-9700