Skip to content

Taylorcraft BC12D-85

NTSB investigations · 16

Matched to the registry by N-number and event date, newest first.

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('8850322') 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('8850322')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('8850322')
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 ERA22LA430Accident · Serious injuriesClass 4 · LimitedFinal reportTaylorcraft BC12 · Buffalo, NYThe pilot’s failure to maintain aircraft control during initial climb after a go-around, which resulted in an aerodynamic stall and spin at low altitude.Sep 24, 2022 · N5619M · Substantial damage NTSB NYC90LA058Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Roxbury, MEPilot factor in that he failed to plan the approach for gusty wind conditions and impacted trees short of the runway.Jan 28, 1990 · N44068 · Destroyed NTSB LAX84FA221Accident · 1 fatalField investigationFinal reportTaylorcraft BC12D-85 · Edwards Afb, CAThe acft collided with the ground and rolled inverted in the desert near Edwards Afb. Examination of the wreckage gave no evidence of a failure or malfunction of equipment. The coroner reported that the plt died of a gunshot wound to the head before the acft…Feb 15, 1984 · N5603M · Destroyed NTSB MIA79DLD61Accident · No injuriesClosedTaylorcraft BC12D · Brooksville, FLMay 2, 1979 · N95757 · Substantial damage NTSB NYC78FA012Accident · 2 fatalClosedTaylorcraft BC12-D · Mercer, MEDec 4, 1977 · N6607N · Destroyed NTSB NYC74FNC14Accident · Serious injuriesClosedTaylorcraft BC12-D · Greenville, MEAug 12, 1973 · N39271 · Destroyed NTSB MKC73AK030Accident · 2 fatalClosedTaylorcraft BC12-D · Eagle Butte, SDNov 1, 1972 · N6601N · Substantial damage NTSB ANC73DAG39Accident · Minor injuriesClosedTaylorcraft BC12-D · Chugiak, AKSep 16, 1972 · N96099 · Substantial damage NTSB CHI72DEA15Accident · No injuriesClosedTaylorcraft BC12-D · Palmyra, INOct 1, 1971 · N5610M · Substantial damage NTSB CHI72FET05Accident · Minor injuriesClosedTaylorcraft BC-12D · Syracuse, INAug 15, 1971 · N5242M · Substantial damage NTSB MKC68F0207Accident · No injuriesClosedTaylorcraft BC12-D · Crane Lake, MNSep 2, 1967 · N5290M · Substantial damage NTSB DEN66D0281Accident · No injuriesClosedTaylorcraft BC12-D · Seely, WYMar 6, 1966 · N95051 · Substantial damage NTSB LAX66D0257Accident · No injuriesClosedTaylorcraft BC12-D · Minden, NVFeb 13, 1966 · N27426 · Substantial damage NTSB NYC66F0495Accident · No injuriesClosedTaylorcraft BC-65 · Tarentum, PAFeb 12, 1966 · N22657 · Substantial damage NTSB ANC66D0010Accident · No injuriesClosedTaylorcraft BCS-12 · Ketchikan, AKJul 11, 1965 · N94997 · Substantial damage NTSB UNK65X0825Accident · Minor injuriesClosedTaylorcraft BC12D · Fishers Ldg, AZNov 25, 1964 · N43726 · Substantial damage

Back to Taylorcraft BC12D-85