Skip to content

NTSB investigations: Taylorcraft BC12-D, MI

18 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" = 'MI' 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\" = 'MI' 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" = 'MI' 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 CHI03CA022Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Albion, MIA failure by the pilot to maintain sufficient airspeed while maneuvering. Contributing factors were the resulting stall/spin, the relatively low altitude and the soft terrain encountered.Nov 17, 2002 · N5066M · Substantial damage NTSB CHI00LA205Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Decatur, MIthe left main landing gear brake was locked during landing. A factor associated with the accident was the uneven terrain on which the landing was made.Jul 18, 2000 · N5080M · Substantial damage NTSB CHI96FA332Accident · 1 fatalField investigationFinal reportTaylorcraft BC-12D · Bellaire, MIthe pilot's improper remedial action, while recovering from an intentional stall, which resulted in an inadvertent spin and collision with the terrain. The lack of altitude for recovery was a related factor.Sep 8, 1996 · N43687 · Substantial damage NTSB CHI86FEC01Accident · Minor injuriesFinal reportTaylorcraft BC12-D · Leslie, MIThe acft was damaged during a forced lndg following a loss of power after a low pass over an off arpt intended landing area. The plt was overflying a field belonging to a friend in preparation for a possible landing when a loud clunk was heard from the eng…Apr 1, 1986 · N94903 · Substantial damage NTSB CHI84LA323Accident · Serious injuriesLimited investigationFinal reportFairchild BC12-D · Hessel, MIAcft departed in VFR conditions for short x-country flt. No weather briefing was obtained. On initial encounter with deteriorating ceiling and visibility conditions, plt reduced altitude in attempt to maintain ground reference. Course reversal not initiated…Aug 1, 1984 · N94955 · Destroyed NTSB CHI78FA023Accident · 1 fatalClosedTaylorcraft BC12D · Lowell, MIFeb 16, 1978 · N96797 · Destroyed NTSB CHI76FEM49Accident · Serious injuriesClosedTaylorcraft BC12-D · Mancelona, MIJul 6, 1976 · N43873 · Substantial damage NTSB CHI76FEM16Accident · No injuriesClosedTaylorcraft BC12-D · Big Rapids, MIOct 5, 1975 · N95982 · Substantial damage NTSB CHI75FEC11Accident · No injuriesClosedTaylorcraft BC12-D · Durand, MIAug 18, 1974 · N96279 · Substantial damage NTSB CHI74DEC22Accident · Minor injuriesClosedTaylorcraft BC12-D · Owosso, MIDec 15, 1973 · N5123M · Substantial damage NTSB CHI73DEM59Accident · No injuriesClosedTaylorcraft BC12-D · Allegan, MIMay 10, 1973 · N96723 · Substantial damage NTSB CHI70F0326Accident · No injuriesClosedTaylorcraft BC12-D · Gulliver, MIOct 29, 1969 · N96116 · Substantial damage NTSB CHI70F0050Accident · No injuriesClosedTaylorcraft BC12-D · Fulton, MIJun 21, 1969 · N95989 · Substantial damage NTSB CHI69A0028Accident · 1 fatalClosedTaylorcraft BF12D · Chapin, MISep 14, 1968 · N43000 · Destroyed NTSB CHI67F0165Accident · No injuriesClosedTaylorcraft BC12-D · Alma, MIJun 22, 1966 · N43863 · Substantial damage NTSB CHI65D0068Accident · Minor injuriesClosedTaylorcraft BC-12D · Iron River, MIFeb 20, 1965 · N20V · Substantial damage NTSB UNK65X1040Accident · No injuriesClosedTaylorcraft BC12D · Charlotte, MIDec 18, 1964 · N5066M · Substantial damage NTSB UNK64X0783Accident · No injuriesClosedTaylorcraft BC12D · Flushing, MIMar 1, 1964 · N96179 · Substantial damage