Fatal NTSB investigations: Taylorcraft BC-65
10 cases on aircraft the registry lists as Taylorcraft BC-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
| 1965 | 1 |
|---|---|
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 2 |
| 1977 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1991 | 1 |
| 1995 | 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.\"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 ('8850306'))
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 ('8850306'))
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 CHI95FA212Accident · 1 fatalField investigationFinal reportTaylorcraft BC-65 · Plato Center, ILthe pilot not maintaining an adequate fuel supply, and not maintaining airspeed.NTSB ANC91LA076Accident · 2 fatalLimited investigationFinal reportTaylorcraft BC-65 · Kakhonak, AKThe uncertificated pilot failed to maintain aircraft control during the initial climb and the physical impairment by drugs (marijuana) of the pilot. Contributing to the accident was the stall which was not identified by the nonrated pilot.NTSB NYC81FA071Accident · 1 fatalClosedTaylorcraft BC-85 · Durham, NHNTSB SEA79FA025Accident · 2 fatalClosedTaylorcraft BC-65 · Orting, WANTSB ANC77FA075Accident · 1 fatalClosedTaylorcraft BC-12D · Kakhonak, AKNTSB FTW71AF028Accident · 1 fatalClosedTaylorcraft BC-65 · Medford, OKNTSB NYC70AN120Accident · 1 fatalClosedTaylorcraft BC12-D · Vineland, NJNTSB MKC70A0015Accident · 2 fatalClosedTaylorcraft BC12-D · Minneapolis, MNNTSB MKC69A0034Accident · 2 fatalClosedTaylorcraft BC-65 · St Charles, IANTSB SEA65A0048Accident · 3 fatalClosedTaylorcraft BC-65 · Tacoma, WA