NTSB investigations: Taylorcraft BC12-D
11 cases on aircraft the registry lists as Taylorcraft BC12-D, where the first occurrence was “In flight collision with object”. 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 |
|---|---|
| 1983 | 1 |
| 1986 | 2 |
| 1988 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1997 | 1 |
| 2001 | 1 |
| 2005 | 1 |
| 2006 | 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 ('8850316')
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\" = 220))
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 ('8850316')
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" = 220))
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 NYC07CA034Accident · Serious injuriesData collectionFinal reportTaylorcraft BC12-D · Benton, KYThe pilot's improper decision to fly between the trees during his approach to the runway.NTSB SEA05CA116Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Yellow Pine, IDThe pilot's delay in executing a go-around which resulted in his failure to obtain altitude/clearance with trees.NTSB SEA01LA164Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Winston, ORThe pilot's failure to maintain clearance from a fence during the initial takeoff. A fence was a factor.NTSB LAX97FA288Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Corcoran, CAThe pilot's failure to maintain separation from ground obstacles.NTSB LAX93LA038Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Mariposa, CAThe pilot's failure to maintain a sufficient airspeed margin while on final approach, and, after encountering a down draft, his failure to correct the resulting descent rate and maintain a glide path which would maintain obstacle clearance.NTSB NYC91LA231Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC/2D · Rangeley, MEImproper takeoff planning by the pilot which resulted in an inflight collision with trees during initial climb. A factor related to the accident was the pilot's decision not to use the full lake surface available for takeoff.NTSB ATL88LA250Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Surf City, NCA landing was attempted at a private turf strip in gusty wind conditions. At level off for a 3-point landing on rwy 24, the right wing was lifted sharply by a wind gust. Right aileron and rudder were applied and power was added to go-around. As the airplane…NTSB CHI86LA161Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12D · Lake George, MNThe plt was attempting to takeoff from a field when the accident occurred. During takeoff, the acft failed to clear trees at the departure end of the field. The acft contacted the trees and descended to the terrain. The plt had diverted to this field during a…NTSB NYC86LA106Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · W. Milford, NJOn approach to Milford airport, the flight collided with power lines and crashed. The pilot made a missed approach then on second approach collided with wires, the pilot stated that it was dark and he did not see the wires until it was too late.NTSB FTW83FA313Accident · 1 fatalField investigationFinal reportTaylorcraft BCS 12-65 · Odessa, TXThe acft collided with wires and the ground during recovery from an aerobatic maneuver. The plt had done what appeared to be a maneuver similiar to a hammerhead stall shortly after first takeoff. The acft appeared to be recovering as it 'bottomed out' at…NTSB ATL82DA237Accident · Minor injuriesFinal reportTaylorcraft BC12-D · Spout Springs, NCThe pilot stated that the wind was gusting and shifting as he was landing with a cumulus build-up nearby. He reported that during his landing, he increased his airspeed to compensate for a gusty crosswind. The pilot stated that the mechanical brakes did not…