Final NTSB investigations: Taylorcraft BCS12-D
7 cases on aircraft the registry lists as Taylorcraft BCS12-D. 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 | 2 |
|---|---|
| 1970 | 1 |
| 1983 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1992 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8850318'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8850318'))
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 ANC92LA121Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BCS12-D · Sitka, AKThe pilots failure to maintain directional control of the airplane. Contributing to the accident were the crosswind and the large boulders (objects) beside the runway.NTSB MKC88LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · St Charles, MOThe plt rprtd that during the flt, he enctrd thunderstorm activity, as well as a downdraft, which resulted in a loss of about 400 ft of alt. Subsequently, the acft was landed in a corn field & was damaged. About 13 mi se at st louis, the visibility was rprtd…NTSB SEA86LA141Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BCM-12D-85 · Ketchikan, AKThe plt felt a sudden hard jolt while in cruise flt. The acft assumed a nose low, left wing down attitude which the plt was unable to correct by use of power and control inputs. The acft was at a low altitude due to weather. The acft impacted the water in a…NTSB NYC83LA219Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Wakefield, NHThe plt reported that he taxied out of a protected cove to takeoff on the main part of balch lake. After lift-off, he realized the wind was too gusty to be flying, & aborted from aprx 30 to 40 ft AGL. He saw telephone wires ahead that crossed the lake &…NTSB ANC70FAA04Accident · Serious injuriesClosedTaylorcraft BC12-D · Fairbanks, AKNTSB ANC66F0067Accident · Minor injuriesClosedTaylorcraft BCS12D · Sitka, AKNTSB NYC66D0028Accident · No injuriesClosedTaylorcraft BC-12D · Rumford, ME