NTSB investigations: Taylorcraft DCO-65, 1982
2 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 | 8 |
|---|---|
| 1965 | 10 |
| 1966 | 1 |
| 1967 | 5 |
| 1968 | 4 |
| 1969 | 3 |
| 1970 | 3 |
| 1971 | 2 |
| 1972 | 3 |
| 1974 | 4 |
| 1975 | 1 |
| 1976 | 4 |
| 1977 | 4 |
| 1978 | 1 |
| 1980 | 2 |
| 1981 | 1 |
| 1982 | 2 |
| 1984 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 2 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 3 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 3 |
| 2015 | 1 |
| 2026 | 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 year(c.\"eventDate\") = 1982
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 year(c."eventDate") = 1982
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 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.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…