NTSB investigations: Beech D35, 1968

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

NTSB investigations: Beech D35, 1968 per year, 1964–2026: 115 cases
1964	9
1965	14
1966	11
1967	11
1968	8
1969	5
1970	4
1971	3
1972	5
1973	1
1974	2
1975	2
1977	3
1978	1
1979	2
1983	1
1984	1
1986	1
1987	1
1990	1
1991	1
1993	2
1995	1
1996	2
1997	2
1998	1
1999	2
2000	2
2001	1
2002	5
2005	2
2006	2
2009	1
2010	1
2015	2
2016	1
2018	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 year(c."eventDate") = 1968 AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151510')) 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 year(c.\"eventDate\") = 1968
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151510'))
  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 year(c."eventDate") = 1968
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151510'))
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 LAX69D0187Accident · No injuriesClosedBeech D35 · Apple Valley, CANov 14, 1968 · N2916B · Substantial damage NTSB DEN69F0156Accident · No injuriesClosedBeech D35 · Broomfield, CONov 12, 1968 · N2911B · Substantial damage NTSB LAX69F0169Accident · 1 fatalClosedBeech D35 · National City, CAOct 27, 1968 · N3434B · Substantial damage NTSB LAX69D0194Accident · No injuriesClosedBeech D35 · Wickenburg, AZOct 21, 1968 · N3430B · Substantial damage NTSB MIA69F0119Accident · No injuriesClosedBeech D35 · Lenoir City, TNAug 24, 1968 · N2132D · Substantial damage NTSB MKC69F0066Accident · No injuriesClosedBeech D35 · St.Paul, MNJul 30, 1968 · N3471B · Substantial damage NTSB FTW69A0002Accident · 2 fatalClosedBeech D35 · Medina, TXJul 4, 1968 · N2184D · Destroyed NTSB DIA68A0044Accident · No injuriesClosedBeech 35 · Lynchburg, VAApr 17, 1968 · N71C · Substantial damage