Fatal NTSB investigations: Taylorcraft DCO-65
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 | 1 |
|---|---|
| 1965 | 1 |
| 1969 | 2 |
| 1971 | 1 |
| 1972 | 2 |
| 1974 | 1 |
| 1976 | 2 |
| 1977 | 1 |
| 1990 | 1 |
| 1994 | 1 |
| 2011 | 2 |
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.\"highestInjuryLevel\" = 'Fatal'
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."highestInjuryLevel" = 'Fatal'
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 CEN11FA480Accident · 1 fatalField investigationFinal reportTaylorcraft DCO-65 · Boyne City, MIThe pilot failed to maintain airplane control while maneuvering at low altitude, which resulted in a stall/spin and impact with the terrain.NTSB CEN11LA194Accident · 1 fatalLimited investigationFinal reportTaylorcraft DCO-65 · Americus, INThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.NTSB FTW94FA102Accident · 4 fatalField investigationFinal reportTaylorcraft DCO-65 · San Antonio, TXThe failure of the pilot of the other aircraft to maintain adequate clearance during formation flight. A factor was the pilot's inadequate preflight planning and preparation regarding inflight formation procedures.NTSB ANC90FA167Accident · 2 fatalField investigationFinal reportTaylorcraft DCO-75 · Mckinley Park, AKFailure of both pilots to maintain adequate visual lookout to see-and-avoid other aircraft.NTSB SEA77FA035Accident · 2 fatalClosedTaylorcraft L-2B · Yelm, WANTSB CHI77FA005Accident · 1 fatalClosedTaylorcraft DC0-65 · Belleville, ILNTSB MKC76AK057Accident · 2 fatalClosedTaylorcraft DCO-65 · Bernie, MONTSB SEA74AS048Accident · 1 fatalClosedTaylorcraft DCO-65 · Viola, IDNTSB NYC73AN018Accident · 2 fatalClosedTaylorcraft L-2B · No.Andover, MANTSB LAX72AL064Accident · 2 fatalClosedTaylorcraft DCO-65 · Sta.Susana, CANTSB LAX71AL046Accident · 2 fatalClosedTaylorcraft DCO-65 · Yuma, AZNTSB MIA69A0082Accident · 2 fatalClosedTaylorcraft DCO-65 · Wilson, ARNTSB FTW69A0066Accident · 2 fatalClosedTaylorcraft L-2 · Van Buren, ARNTSB NYC65A0150Accident · 2 fatalClosedTaylorcraft DCO-65 · Westerly, RINTSB UNK64X2097Accident · 2 fatalClosedTaylorcraft DC0-65 · Dewitt, MI