Skip to content

NTSB investigations: Taylorcraft BC12-D, MN

23 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" = 'MN' 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\" = 'MN' 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" = 'MN' 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 CEN14CA130Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12 D · Worthington, MNThe pilot's loss of control during a crosswind landing.Feb 3, 2014 · N43462 · Substantial damage NTSB CHI99LA241Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Aitkin, MNthe right spring in the tailwheel assembly's separation. Factors were the fatigue in the landing gear, the maintenance personnel not identifying the fatigue during the annual inspection, and the right main gear's separation.Jul 13, 1999 · N96884 · Substantial damage NTSB CHI99LA010Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Duluth, MNThe inadequate airspeed by the pilot-in-command. Contributing factors were the gusts and the trees.Oct 22, 1998 · N95196 · Substantial damage NTSB CHI93LA112Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Brainerd, MNThe pilot's improper flare which resulted in a bounced, hard landing and the subsequent loss of directional control.Feb 26, 1993 · N44109 · Substantial damage NTSB CHI87FA177Accident · 2 fatalField investigationFinal reportTaylorcraft BC12-D · Morris, MNThe plt was ferrying the acft from Ohio to Alaska. While en route, he stopped & refueled at Morris, MN. After he took off, the plane crashed in an open field about 1/2 mi from the arpt. No known witnesses saw the acdnt, but a passerby found the acft on its…Jul 29, 1987 · N99AW · Destroyed 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…Jun 29, 1986 · N13363 · Destroyed NTSB CHI84LA172Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Winona, MNAfter landing, the plt was turning left onto the taxiway when the wind lifted the right wing and tail of the acft. The acft nosed over.May 1, 1984 · N5184M · Substantial damage NTSB CHI84LA043Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12D · Gatzke, MNThe acft collided with the ground when the pilot attempted a low level turn.Nov 7, 1983 · N95180 · Substantial damage NTSB CHI82DA286Accident · Minor injuriesFinal reportTaylorcraft BC12-D · Brooklyn Park, MNThe pilot took off from a 900 ft sod airstrip with a reported 6 kt head wind. He stated that there was not enough power to climb and the aircraft remained about 20 to 30 ft AGL. Due to the proximity of obstacles a forced landing was made in an open field…Jul 31, 1982 · N96055 · Substantial damage NTSB MKC77FER70Accident · No injuriesClosedTayorcraft BCS-12 · Coon Lake, MNAug 1, 1977 · N94921 · Substantial damage NTSB MKC74AK014Accident · 1 fatalClosedTaylorcraft BC12-D · Slayton, MNOct 2, 1973 · N96184 · Substantial damage NTSB MKC73FER35Accident · Minor injuriesClosedTaylorcraft BC12-D · Blue Earth, MNJan 13, 1973 · N43478 · Substantial damage NTSB MKC71FDM48Accident · No injuriesClosedTaylorcraft BC12-D · Cook, MNMar 2, 1971 · N95029 · Substantial damage NTSB MKC69A0062Accident · 1 fatalClosedTaylorcraft BC12-D · Biwabik, MNJun 15, 1969 · N96276 · Substantial damage NTSB MKC69D0348Accident · No injuriesClosedTaylorcraft BC-12D · Shevlin, MNDec 21, 1968 · N43612 · Substantial damage NTSB MKC69F0218Accident · Serious injuriesClosedTaylorcraft BC12-D · Starbuck, MNOct 13, 1968 · N96035 · Minor damage NTSB CHI69A0039Accident · 1 fatalClosedTaylorcraft BC12-D · Ogilvie, MNOct 10, 1968 · N96557 · Destroyed NTSB MKC68D0583Accident · No injuriesClosedTaylorcraft BC12-D · Ivanhoe, MNMay 12, 1968 · N96530 · Substantial damage NTSB MKC66F0194Accident · Minor injuriesClosedPiper PA-28 · Minneapolis, MNAug 18, 1965 · N506UM · 2 aircraft · Substantial damage NTSB MKC66F0294Accident · No injuriesClosedTaylorcraft BC-12D · So St Paul, MNAug 13, 1965 · N96430 · Substantial damage NTSB UNK64X2859Accident · No injuriesClosedTaylorcraft BC12D · Lax Lake, MNJul 16, 1964 · N96646 · Substantial damage NTSB UNK64X2328Accident · No injuriesClosedTaylorcraft BC12D · Lake George, MNJun 17, 1964 · N96276 · Substantial damage NTSB UNK64X0416Accident · 2 fatalClosedTaylorcraft BC12D · Henning Minn, MNFeb 1, 1964 · N96885 · Destroyed