NTSB investigations: Taylorcraft BC12-D, MT
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.
Cases per year
| 1965 | 1 |
|---|---|
| 1967 | 2 |
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1974 | 2 |
| 1975 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1984 | 1 |
| 1994 | 1 |
| 2015 | 1 |
| 2018 | 1 |
| 2023 | 1 |
Where
Open the mapLatest cases
Query with SQL
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\" = 'MT' 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" = 'MT' 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" DESCRun 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 WPR24LA069Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Whitefish, MTThe failure of the airport authorities to renew the airport closure NOTAM for the airport. Contributing to the accident, was the pilot’s inability to see the runway closure sign.NTSB GAA18CA533Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12 · Cut Bank, MTThe pilot’s failure to see and avoid power wires while maneuvering at low altitude. Contributing to the accident was the pilot’s inability to determine the airplane’s altitude due to sun glare.NTSB WPR15LA246Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12 D · Libby, MTThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB SEA94LA056Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Sidney, MTThe pilot's inadequate compensation for the crosswind resulting in loss of directional control.NTSB DEN85LA039Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Conrad, MTPlt stated takeoff was being made on a dirt trail, heading 270 degrees, with a 20 kt headwind. Just prior to rotation wind shifted to a direction from the south-southwest. Acft drifted off right side of trail, contacted a ditch and nosed over.NTSB DEN81FA021Accident · 2 fatalClosedTavlorcraft BC-12D · Stevensville, MTNTSB DEN80FA005Accident · 1 fatalClosedTaylorcraft BC12-D · St.Ignatius, MTNTSB SEA76FTI12Accident · No injuriesClosedTaylorcraft BC12-D · Hamilton, MTNTSB SEA74DTI17Accident · Minor injuriesClosedTaylorcraft BC12-D · Missoula, MTNTSB SEA74DYA20Accident · Minor injuriesClosedTaylorcraft BC12-D · Montpelier, MTNTSB SEA73FTI08Accident · Minor injuriesClosedTaylorcraft BC12-D · Whitefish, MTNTSB SEA71FTA06Accident · No injuriesClosedTaylorcraft BC12-D · Baker, MTNTSB SEA71DDA07Accident · No injuriesClosedTaylorcraft BC12-D · Melstone, MTNTSB SEA70F0031Accident · Minor injuriesClosedTaylorcraft BC12-D · Kalispell, MTNTSB SEA69F0098Accident · 2 fatalClosedTaylorcraft BC12-D · Winnett, MTNTSB SEA68D0144Accident · Minor injuriesClosedTaylorcraft BC12-D · Harrison, MTNTSB SEA67A0067Accident · 1 fatalClosedTaylorcraft BC12-D · Havre, MTNTSB SEA66A0002Accident · 1 fatalClosedTaylorcraft BC-12D · Biddle, MT