NTSB investigations: Taylorcraft BC12-D, NM

11 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

19682026

NTSB investigations: Taylorcraft BC12-D, NM per year, 1968–2026: 11 cases
1968	2
1972	1
1973	1
1975	1
1978	1
1986	1
1988	2
2005	1
2018	1

Where

Open the map

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" = 'NM' 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\" = 'NM' 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" = 'NM' 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 CEN18LA222Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft BC12 D · Santa Teresa, NMThe pilot's loss of directional control during landing in gusting crosswind conditions for reasons that could not be determined based on the available information.Jun 10, 2018 · N43443 · Substantial damage NTSB DEN06CA025Accident · Serious injuriesData collectionFinal reportTaylorcraft BC12-D · Los Lunas, NMthe pilot's failure to maintain directional control during landing, which resulted in an inadvertent ground loop.Dec 23, 2005 · N96924 · Minor damage NTSB DEN89LA032Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12D · Carrizozo, NMThe private plt said his Taylorcraft was secured to the ramp by 3 chains. He tried to hand start the engine, with no one at the controls, and the throttle full open. The engine started, the acft broke the right wing tie down ring, and straightened an 's' hook…Nov 13, 1988 · N43603 · Substantial damage NTSB DEN88FA112Accident · Serious injuriesField investigationFinal reportTaylorcraft BC12-D · Albuquerque, NMThe pilot and his passenger decided to make a local personal flight. The pilot said he saw a squall line approaching the airport, but thought he could get off the ground before it arrived. He took off and started a left crosswind turn. A gust of wind lifted…May 27, 1988 · N43411 · Destroyed NTSB DEN86LA109Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Santa Teresa, NMThe plt stated that he was performing touch & go landings. When the accident occurred. On the first landing a wind gust raised the right wing. The plt stated he 'tried to straighten out' the acft when it went off the right side of the rwy. The left main…Mar 30, 1986 · N43139 · Substantial damage NTSB DEN78FA022Accident · 1 fatalClosedTaylorcraft BC12D · Albuquerque, NMFeb 5, 1978 · N43021 · Substantial damage NTSB DEN76FQA29Accident · No injuriesClosedTaylorcraft BC12-D · Farmington, NMNov 19, 1975 · N95313 · Substantial damage NTSB DEN73FQA35Accident · Minor injuriesClosedTaylorcraft BC12-D · Albuquerque, NMApr 22, 1973 · N39969 · Substantial damage NTSB DEN73AD001Accident · 1 fatalClosedTaylorcraft BC12-D · Lovington, NMJul 2, 1972 · N5016M · Destroyed NTSB DEN68F0201Accident · Serious injuriesClosedTaylorcraft BC12-D · Truth-Consq, NMJan 16, 1968 · N43819 · Substantial damage NTSB DEN68F0187Accident · No injuriesClosedTaylorcraft BC12-D · Albuquerque, NMJan 1, 1968 · N95810 · Substantial damage