NTSB investigations: Beech E18S, TX
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.
Cases per year
| 1969 | 1 |
|---|---|
| 1970 | 1 |
| 1973 | 2 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1980 | 1 |
| 1982 | 2 |
| 1985 | 1 |
| 1986 | 1 |
| 1997 | 1 |
| 2009 | 1 |
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.\"eventStateOrRegion\" = 'TX' 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" = 'TX' 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" 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 CEN10TA006Accident · No injuriesFinal reportBeech E18S · Jones Creek, TXThe pilot's failure to see and avoid the radio tower.NTSB FTW98LA080Accident · No injuriesLimited investigationFinal reportBeech E18S · Dfw Airport, TXfailure of the pilot in the 2nd airplane (N4980V) to see-and-avoid the standing airplane (N2069C). Related factors were: darkness, and inadequate (vague) instructions issued by the UPS ramp controller.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 FTW85LA142Accident · No injuriesLimited investigationFinal reportBeech E18S · Pharr, TXThe plt took off at about 0600 CST on a local test flt following an eng change. He received a special VFR clearance from the control tower, but did not obtain an IFR clearance. At 0605, the wx at mcallen, TX was in part: 500 ft obscured, visibility 2 mi, wind…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,…NTSB FTW82FRG24Accident · Minor injuriesFinal reportBeech E18S · Charlotte, TXThe aircraft crashed during takeoff from a clearing on a ranch and then was abandoned. The aircraft landing gear struck a concrete trough for watering cattle. Drugs were found on board the aircraft.NTSB FTW81DA001Accident · No injuriesClosedBeech 18 · Dallas, TXNTSB FTW79FRG02Accident · No injuriesClosedBeech E18S · Laredo, TXNTSB FTW76FQD17Accident · Minor injuriesClosedBeech E18S · Shafter, TXNTSB FTW75AF069Accident · 1 fatalClosedBeech E18S · Claude, TXNTSB FTW74DRG79Accident · No injuriesClosedBeech E18S · Laredo, TXNTSB FTW74AF026Accident · No injuriesClosedBeech E18S · El Paso, TXNTSB FTW73AF071Accident · 1 fatalClosedBeech E18S · Tyler, TXNTSB FTW70FRA02Accident · No injuriesClosedBeech E18S · Jasper, TXNTSB FTW69A0077Accident · No injuriesClosedBeech E18S · Big Spring, TX