NTSB investigations: Taylorcraft DCO-65, CA
15 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.
Cases per year
| 1964 | 3 |
|---|---|
| 1965 | 1 |
| 1967 | 3 |
| 1968 | 1 |
| 1972 | 1 |
| 1978 | 1 |
| 1980 | 1 |
| 1982 | 1 |
| 1991 | 1 |
| 2009 | 1 |
| 2015 | 1 |
Where
Open the mapLatest cases
Query with SQL
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\" = 'CA' 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 ('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."eventStateOrRegion" = 'CA' 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 ('8850408'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 WPR15LA226Accident · Minor injuriesLimited investigationFinal reportTaylorcraft 12-m · Selma, CAThe pilot receiving instruction's use of an excessive pitch attitude during takeoff with the airplane near its maximum gross weight in hot and humid conditions, which degraded the airplane’s climb performance and resulted in a collision with obstacles during…NTSB WPR09LA330Accident · Serious injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Tracy, CAThe loss of engine power for undetermined reasons.NTSB LAX91LA237Accident · No injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Antioch, CAThat the pilot's preflight was improper; that he departed with the carburetor heat on; failed to abort when it became evident that the airplane was not going to take off; and abruptly lifting the airplane so that it became airborne in ground effect, but then…NTSB LAX82DA300Accident · No injuriesFinal reportTaylorcraft DCO-65 · Santa Cruz, CADuring arrival, the pilot entered traffic to land on runway 31 with a wind from 130 deg at 5 KTS. The first approach to land was high, so a go-around was made. On the second approach, the aircraft was low and fast. Reportedly, the aircraft began to veer to…NTSB LAX80DVM27Accident · No injuriesClosedTaylorcraft DCO-65 · San Jose, CANTSB OAK78DVM30Accident · No injuriesClosedTaylorcraft DC-065 · San Jose, CANTSB LAX72AL064Accident · 2 fatalClosedTaylorcraft DCO-65 · Sta.Susana, CANTSB OAK68D0334Accident · No injuriesClosedTaylorcraft DCO-65 · Tracy, CANTSB LAX68D0166Accident · No injuriesClosedTaylorcraft DCO-65 · Pacoima, CANTSB LAX68F0091Accident · No injuriesClosedTaylorcraft L-2 · Compton, CANTSB OAK67D0242Accident · Minor injuriesClosedTaylorcraft DCO-65 · Soledad, CANTSB LAX66D0085Accident · No injuriesClosedTaylorcraft DCO-65 · Inyokern, CANTSB UNK64X2633AccidentClosedTaylorcraft L2 · San Jose, CANTSB UNK64X2373Accident · Minor injuriesClosedTaylorcraft DC065 · Chino, CANTSB UNK64X2349Accident · No injuriesClosedTaylorcraft DC065 · Visilia, CA