NTSB investigations: Taylorcraft DC-65, 1965

8 cases on aircraft the registry lists as Taylorcraft DC-65. 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: Taylorcraft DC-65, 1965 per year, 1964–2026: 30 cases
1964	3
1965	8
1966	1
1967	2
1969	2
1970	1
1972	1
1977	1
1979	2
1986	1
1987	1
1990	2
1996	1
2000	1
2004	2
2006	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") = 1965 AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8850402')) 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\") = 1965
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8850402'))
  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") = 1965
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8850402'))
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 FTW66F0431Accident · Minor injuriesClosedTaylorcraft DCO-65 · Gurdon, ARDec 12, 1965 · N58603 · Substantial damage NTSB SEA66F0134Accident · Minor injuriesClosedTaylorcraft DC-65 · Hooper, WASep 13, 1965 · N36341 · Destroyed NTSB FTW66F0265Accident · No injuriesClosedTaylorcraft L-2M · Covington, LAAug 7, 1965 · N50084 · Substantial damage NTSB FTW66F0108Accident · Minor injuriesClosedTaylorcraft DC-65 · Monroe, LAJun 21, 1965 · N5337N · Destroyed NTSB NYC65F0196Accident · Minor injuriesClosedTaylorcraft DC-65 · Winchester, VAMay 9, 1965 · N46140 · Substantial damage NTSB MKC65D0127Accident · No injuriesClosedTaylorcraft DCO · Pacific Junct, IAMay 3, 1965 · N57922 · Destroyed NTSB OAK65F0008Accident · No injuriesClosedCessna 140 · San Jose, CAFeb 5, 1965 · N2095N · 2 aircraft · Substantial damage NTSB LAX65F0004Accident · Serious injuriesClosedTaylorcraft DC-65 · Goldhill, NVJan 9, 1965 · N67704 · Destroyed