Skip to content

NTSB investigations: Taylorcraft BC12-D, TX

30 cases on aircraft the registry lists as Taylorcraft BC12-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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8850316')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8850316'))
  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."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8850316'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN15CA356Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Pearland, TXThe student pilot inadvertently shut off the fuel valve while on the downwind leg, which resulted in a total loss of engine power due to fuel starvation and a forced landing short of the runway.Aug 12, 2015 · N95592 · Substantial damage NTSB CEN14LA446Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12 - D · Burnet, TXThe flight instructor’s failure to adequately supervise the student pilot and his decision to conduct training in an airplane without dual brakes, which resulted in the student pilot’s loss of directional control during initial taxi and subsequent impact with…Aug 5, 2014 · N44335 · Substantial damage NTSB CEN13LA567Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12 D · Laguna Park, TXThe pilot’s inadequate flare during landing, which resulted in a hard landing and the subsequent collapse of the left main landing gear.Sep 22, 2013 · N96473 · Substantial damage NTSB CEN11LA688Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Berryville, TXThe pilot did not maintain control of the airplane during a forced landing, which resulted in an aerodynamic stall. Contributing to the accident was the loss of engine power for undetermined reasons.Aug 28, 2011 · N8617 · Substantial damage NTSB DFW06CA143Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Justin, TXThe pilot's improper compensation for the prevailing high wind conditions.May 27, 2006 · N95016 · Substantial damage NTSB FTW93LA182Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Ozona, TXThe pilot's failure to correctly compensate for wind conditions. A factor was the unexpected encounter with the crosswind.Jun 4, 1993 · N96984 · Substantial damage NTSB FTW88FA069Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Big Spring, TXThe pilot was on a local pleasure flight practicing aerobatic maneuvers in the vicinity of the airport. Witnesses thought the pilot was entering the pattern for landing at the completion of the aerobatic practice. They noted a power reduction after which the…Feb 20, 1988 · N29779 · Destroyed 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…Jul 5, 1983 · N1776B · Destroyed NTSB FTW81FA144Accident · 1 fatalClosedTaylorcraft BC12-D · Kerrville, TXSep 19, 1981 · N43506 · Destroyed NTSB FTW80DRG70Accident · Minor injuriesClosedTaylorcraft BC12-D · Seguin, TXSep 2, 1980 · N39279 · Substantial damage NTSB FTW75FPD18Accident · Minor injuriesClosedTaylorcraft BC12-D · N.Richld Hils, TXNov 19, 1974 · N43708 · Destroyed NTSB FTW75DPD11Accident · Serious injuriesClosedTaylorcraft BC12-D · Justin, TXOct 5, 1974 · N43131 · Substantial damage NTSB FTW75FRJ16Accident · Minor injuriesClosedTaylorcraft BC12-D · Longview, TXSep 29, 1974 · N44046 · Substantial damage NTSB FTW74DQG46Accident · No injuriesClosedTaylorcraft BC12-D · Midland, TXMar 17, 1974 · N43347 · Substantial damage NTSB FTW73FRG41Accident · Minor injuriesClosedTaylorcraft BC12-D · San Antonio, TXJan 13, 1973 · N95340 · Substantial damage NTSB FTW72FQD23Accident · Serious injuriesClosedTaylorcraft BC12-D · Pecos, TXFeb 13, 1972 · N96911 · Destroyed NTSB FTW72FRA08Accident · Minor injuriesClosedTaylorcraft BC12-D · Bryan, TXSep 5, 1971 · N95689 · Substantial damage NTSB FTW72FPD01Accident · Serious injuriesClosedTaylorcraft BC12-D · Southlake, TXJul 1, 1971 · N95948 · Substantial damage NTSB FTW70FQG02Accident · No injuriesClosedTaylorcraft BC12-D · Turkey, TXJan 23, 1970 · N95013 · Substantial damage NTSB FTW69F0451Accident · Minor injuriesClosedTaylorcraft BC12-D · Kermit, TXApr 3, 1969 · N5208M · Substantial damage NTSB FTW69D0375Accident · No injuriesClosedTaylorcraft BC12-D · Mcgregor, TXJan 23, 1969 · N95689 · Substantial damage NTSB FTW69D0096Accident · No injuriesClosedTaylorcraft BC12-D · Hallsville, TXJul 13, 1968 · N44046 · Substantial damage NTSB FTW68A0109Accident · 2 fatalClosedTaylorcraft BC12-D · Winnie, TXJun 15, 1968 · N95103 · Destroyed NTSB FTW68A0106Accident · 1 fatalClosedTaylorcraft BC12-D · Round Rock, TXJun 9, 1968 · N95155 · Destroyed NTSB FTW68D0127Accident · Minor injuriesClosedTaylorcraft BC12-D · Arlington, TXJul 30, 1967 · N43464 · Substantial damage NTSB FTW67A0089Accident · 2 fatalClosedTaylorcraft BC12-D · Pleasanton, TXMar 5, 1967 · N43090 · Destroyed NTSB FTW65F0012Accident · No injuriesClosedTaylorcraft BC-12D · Shallowater, TXMar 15, 1965 · N95056 · Substantial damage NTSB FTW65A0080Accident · 2 fatalClosedTaylorcraft BC-12D · Arlington, TXFeb 14, 1965 · N39213 · Destroyed NTSB UNK64X2402Accident · 1 fatalClosedTaylorcraft BC12D · Clute, TXJun 20, 1964 · N96593 · Destroyed NTSB UNK64X0967Accident · 2 fatalClosedTaylorcraft BC12D · Rendon, TXMar 17, 1964 · N39935 · Destroyed