NTSB investigations: Beech D17S, TX

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

19652026

NTSB investigations: Beech D17S, TX per year, 1965–2026: 8 cases
1965	1
1967	1
1973	1
1976	1
1978	1
1981	1
1984	1
2010	1

Where

Open the map

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 ('1150538')) 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 ('1150538'))
  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 ('1150538'))
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 CEN10CA568Accident · No injuriesData collectionFinal reportBeech D17S · Fort Worth, TXThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Sep 21, 2010 · N17GB · Substantial damage NTSB FTW84LA236Accident · No injuriesLimited investigationFinal reportBeech D17S · Stratford, TXThe pilot stated after the accident that the engine failure occurred as the acft climbed through 6500 feet. According to the plt the no. 1 cylinder separated from the radial eng. The acft nosed over during the landing on unimproved terrain.Feb 7, 1984 · N1038M · Substantial damage NTSB FTW81FQD26Accident · Minor injuriesClosedBeech D17S · Canutillo, TXJun 6, 1981 · N5447N · Substantial damage NTSB FTW78FPD27Accident · No injuriesClosedBeech D-17S · Ranger, TXJul 28, 1978 · N4574N · Destroyed NTSB FTW76AF104Accident · 2 fatalClosedBeech D-17S · Amarillo, TXJun 20, 1976 · N65297 · Destroyed NTSB FTW73DPD40Accident · No injuriesClosedBeech D17S · Arlington, TXMay 28, 1973 · N9466H · Substantial damage NTSB FTW67F0443Accident · No injuriesClosedBeech D-17S · Fort Worth, TXFeb 6, 1967 · N18575 · Substantial damage NTSB OAK66D0143Accident · No injuriesClosedBeechcraft D-17S · Ft Worth, TXOct 21, 1965 · N1341V · Substantial damage