Skip to content

NTSB investigations: Beech D18S, TX

23 cases on aircraft the registry lists as Beech D18S. 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

19642026

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" = '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 ('1151004')) 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\" = '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 ('1151004'))
  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 ('1151004'))
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 FTW93LA001Accident · No injuriesLimited investigationFinal reportBeech D18S · Brookston, TXSmoke trailing from the left engine for an undetermined reason(s). Factors contributing to the accident were unsuitable terrain conditions.Oct 1, 1992 · N90460 · Substantial damage NTSB FTW84LA317Accident · No injuriesLimited investigationFinal reportBeech D-18S · Mcallen, TXThe PIC was observing from the right seat while the C0-PLT was in the left seat taking off. During the takeoff roll, the co-plt lost directional control of the acft & the PIC was unable to recover. The acft veered off the left side of the rwy, the right main…Jul 20, 1984 · N113B · Substantial damage NTSB FTW84FA086Accident · 1 fatalField investigationFinal reportBeech D18S · Brownsville, TXThe plt had just taken off at night on a flt to Mexico when he declared an intent to return & land with some unspecified emergency. While he was using his radio, the sound of both engs, running at hi power, was audible. When asked if he required assistance,…Dec 6, 1983 · N44609 · Destroyed NTSB FTW83LA162Accident · No injuriesLimited investigationFinal reportBeech D-18S · 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 · N80017 · 2 aircraft · Substantial damage NTSB FTW82DA211Accident · No injuriesFinal reportBeech D18S · Beeville, TXThe pilot and three passengers departed on a pleasure flight. The pilot stated that after climbing several hundred feet and while at 110 mph, the right propeller went into high pitch following a propeller governor failure. This resulted in a loss of engine…Jun 3, 1982 · N7510 · Substantial damage NTSB FTW82FPA11Accident · No injuriesFinal reportBeech D18S · Dallas, TXDuring a night, ILS approach, the plane struck a powerline about two miles short of the runway after the pilot was provided a low altitude alert. The left engine lost power and was feathered. The pilot feared possible gear damage and left it extended. Unable…Feb 26, 1982 · N8517Z · Substantial damage NTSB FTW77FRG27Accident · 1 fatalClosedBeech D18S · Mc Allen, TXFeb 19, 1977 · N762D · Destroyed NTSB FTW77FA012Accident · Minor injuriesClosedBeech D18S · Sachse, TXNov 19, 1976 · N2050D · Destroyed NTSB FTW76DRA42Accident · No injuriesClosedBeech D18S · Tomball, TXMay 23, 1976 · N80036 · Substantial damage NTSB FTW76FRG54Accident · 1 fatalClosedBeech D18S · Mcallen, TXMay 18, 1976 · N5302U · Destroyed NTSB FTW76DPA19Accident · Minor injuriesClosedBeech D18S · Mexia, TXMar 21, 1976 · N3451B · Substantial damage NTSB FTW76AF049Accident · No injuriesClosedBeech D18S · Mineral Wells, TXDec 8, 1975 · N629Z · Substantial damage NTSB FTW68A0014Accident · No injuriesClosedBeech D18S · Dallas, TXAug 5, 1967 · N44609 · Substantial damage NTSB FTW68A0002Accident · No injuriesClosedBeech D18S · Kelleen, TXJul 11, 1967 · N8952A · Substantial damage NTSB FTW67A0120Accident · No injuriesClosedBeech D18S · Killeen, TXJun 11, 1967 · N441MH · Substantial damage NTSB FTW67A0082Accident · 3 fatalClosedBeech D18S · Dallas, TXFeb 10, 1967 · N7388 · Destroyed NTSB FTW67F0364Accident · No injuriesClosedBeech D18S · Dallas, TXJan 4, 1967 · N123EM · Substantial damage NTSB FTW67I0033Incident · No injuriesClosedBeech D18 · Houston, TXSep 9, 1966 · N441MH · Substantial damage NTSB FTW66A0100Accident · 5 fatalClosedBeech D18S · Houston, TXMay 11, 1966 · N189L · Destroyed NTSB FTW66F0283Accident · No injuriesClosedBeechcraft D-18S · Ft Worth, TXAug 16, 1965 · N234S · Substantial damage NTSB FTW65F0009Accident · No injuriesClosedBeechcraft D-18S · El Paso, TXMar 4, 1965 · N87Q · Substantial damage NTSB UNK65X0833Accident · No injuriesClosedBeechcraft D18 · Alief, TXNov 25, 1964 · N62R · Substantial damage NTSB UNK64X3890Accident · 2 fatalClosedBeechcraft D18S · Victoria, TXSep 9, 1964 · N220J · 2 aircraft · Destroyed