Skip to content

NTSB investigations: Taylorcraft DCO-65

85 cases on aircraft the registry lists as Taylorcraft DCO-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, newest first

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8850408')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8850408'))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8850408'))
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 LAX71AL046Accident · 2 fatalClosedTaylorcraft DCO-65 · Yuma, AZJan 12, 1971 · N48728 · Destroyed NTSB ANC71DAG30Accident · No injuriesClosedTaylorcraft L-2 · Gulkana, AKSep 25, 1970 · N57744 · Substantial damage NTSB CAN71AP903Accident · Serious injuriesClosedTaylorcraft L2 · Williams Lake, CanadaAug 22, 1970 · N48448 · Destroyed NTSB IAD70FIG18Accident · Minor injuriesClosedTaylorcraft DCO-65 · Cumberland, MDJun 11, 1970 · N46113 · Destroyed NTSB NYC70D0113Accident · No injuriesClosedTaylorcraft L-2 · Tuckahoe, NJAug 6, 1969 · N46112 · Substantial damage NTSB MIA69A0082Accident · 2 fatalClosedTaylorcraft DCO-65 · Wilson, ARMay 30, 1969 · N53761 · Destroyed NTSB FTW69A0066Accident · 2 fatalClosedTaylorcraft L-2 · Van Buren, ARMar 29, 1969 · N53716 · Destroyed NTSB CHI69F0501Accident · Serious injuriesClosedTaylorcraft DCO-65 · Hortonville, WIDec 29, 1968 · N53514 · Destroyed NTSB FTW68F0612Accident · Serious injuriesClosedTaylorcraft DC-65 · Mamou, LAMay 24, 1968 · N47847 · Substantial damage NTSB NYC68D0413Accident · No injuriesClosedTaylorcraft L-2B · Tewksbury, MAMar 27, 1968 · N47120 · Substantial damage NTSB OAK68D0334Accident · No injuriesClosedTaylorcraft DCO-65 · Tracy, CAMar 12, 1968 · N50966 · Substantial damage NTSB MKC68F0320Accident · Serious injuriesClosedTaylorcraft DCO-65 · Leoti, KSNov 19, 1967 · N47672 · Substantial damage NTSB LAX68D0166Accident · No injuriesClosedTaylorcraft DCO-65 · Pacoima, CASep 10, 1967 · N57582 · Substantial damage NTSB LAX68F0091Accident · No injuriesClosedTaylorcraft L-2 · Compton, CAAug 6, 1967 · N48981 · Substantial damage NTSB FTW68F0122Accident · Serious injuriesClosedTaylorcraft DCO-65 · Bonita, LAJul 25, 1967 · N52502 · Substantial damage NTSB OAK67D0242Accident · Minor injuriesClosedTaylorcraft DCO-65 · Soledad, CAMar 4, 1967 · N48603 · Substantial damage NTSB NYC67F0118Accident · Minor injuriesClosedTaylorcraft DCO-65 · Cobleskill, NYJul 24, 1966 · N46093 · Substantial damage NTSB SEA66F0182Accident · Minor injuriesClosedTaylorcraft DC0-65 · Kent, WADec 11, 1965 · N49174 · Substantial damage NTSB CHI66F0505Accident · Minor injuriesClosedTaylorcraft DCO-65 · Waupaca, WINov 26, 1965 · N53514 · Substantial damage NTSB MKC66D0362Accident · No injuriesClosedTaylorcraft L-2 · Adair, IANov 21, 1965 · N48247 · Substantial damage NTSB NYC66F0341Accident · No injuriesClosedTaylorcraft DCO · East Berkshire, VTOct 14, 1965 · N46444 · Substantial damage NTSB DEN66D0112Accident · No injuriesClosedTaylorcraft L-2 · New River, AZAug 17, 1965 · N49195 · Substantial damage NTSB LAX66D0085Accident · No injuriesClosedTaylorcraft DCO-65 · Inyokern, CAJul 4, 1965 · N48291 · Minor damage NTSB NYC65A0150Accident · 2 fatalClosedTaylorcraft DCO-65 · Westerly, RIJun 19, 1965 · N58041 · Destroyed NTSB NYC65F0214Accident · Serious injuriesClosedTaylorcraft L2 · Salem, NJApr 27, 1965 · N50135 · Substantial damage NTSB CHI65D0023Accident · No injuriesClosedTaylorcraft DC065 · Flat Rock, INJan 17, 1965 · N47625 · Substantial damage NTSB UNK65X1292Accident · Minor injuriesClosedTaylorcraft DC065 · Canyon Dam, TXJan 15, 1965 · N57538 · Substantial damage NTSB UNK65X1184Accident · No injuriesClosedTaylorcraft DCO · Vinita, OKDec 29, 1964 · N50605 · Substantial damage NTSB UNK65X0701Accident · Minor injuriesClosedTaylorcraft DC065 · Emlenton, PANov 14, 1964 · N57731 · Destroyed NTSB UNK64X3266Accident · No injuriesClosedTaylorcraft DC065 · Salina, KSAug 8, 1964 · N47547 · Substantial damage NTSB UNK64X2635Accident · No injuriesClosedTaylorcraft DC065 · Amarillo, TXJul 4, 1964 · N48350 · Substantial damage NTSB UNK64X2633AccidentClosedTaylorcraft L2 · San Jose, CAJul 4, 1964 · N50839 · Substantial damage NTSB UNK64X2373Accident · Minor injuriesClosedTaylorcraft DC065 · Chino, CAJun 19, 1964 · N47724 · Substantial damage NTSB UNK64X2349Accident · No injuriesClosedTaylorcraft DC065 · Visilia, CAJun 18, 1964 · N48674 · Substantial damage NTSB UNK64X2097Accident · 2 fatalClosedTaylorcraft DC0-65 · Dewitt, MIJun 3, 1964 · N50968 · Destroyed