NTSB investigations: Taylorcraft DCO-65
8 cases on aircraft the registry lists as Taylorcraft DCO-65, where the first occurrence was “Loss of control - in flight”. 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
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1989 | 2 |
| 1991 | 1 |
| 2001 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8850408')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 CHI01LA177Accident · Serious injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Kenosha, WIthe inadvertent stall by the pilot. The low altitude was a contributing factor.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 NYC89LA216Accident · No injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Andreas, PAFailure of the pilot to maintain airspeed, which resulted in a stall.NTSB NYC89LA090Accident · Minor injuriesLimited investigationFinal reportTaylorcraft L-2M · Olcott, NYThe inattentiveness of the pilot to maintain airspeed while turning base leg for landing which resulted in a stall and subsequent collision with a hangar.NTSB CHI88LA127Accident · Minor injuriesLimited investigationFinal reportTaylorcraft L-2 · Three Rivers, MIThe owner of the acft stated that he released the acft to the PIC so that he could 'checkout' another plt and help her with her tailwheel landings. During their fourth tkof, the plt being checked out attempted to climb out of ground effect with insufficient…NTSB FTW86LA064Accident · Serious injuriesLimited investigationFinal reportTaylorcraft L-2 · Graham, TXWitnesses stated the aircraft stalled during a sharp right bank at approximately 150 feet. The propeller exhibited no signs of rotation at impact. The engine was dissassembled in an attempt to determine the apparent failure. No evidence of pre-impact failure…NTSB CHI84LA162Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Palmyra, WIThe pilot lost control of the acft on the landing flare & collided with a tree. The acft was blown to the left of the rwy & before he could execute a go-around the propeller struck some high brush alongside the rwy. The plt pulled power off, landed in rough…NTSB SEA83LA030Accident · Serious injuriesLimited investigationFinal reportTaylorcraft L-2 · Near Gooding, IDThe pilot made a steep turn close to the ground while taking photographs of coyotes. The aircraft stalled and contacted the ground.