NTSB investigations: Taylorcraft BC12-D, IA
10 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
| 1967 | 1 |
|---|---|
| 1969 | 1 |
| 1976 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1985 | 1 |
| 1991 | 1 |
| 1999 | 1 |
| 2009 | 1 |
| 2012 | 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\" = 'IA' 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" = 'IA' 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 CEN13FA078Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Clutier, IAThe pilot’s failure to monitor, recognize, and identify obstacles on approach to landing, which resulted in an inadvertent collision with power lines. Contributing to the accident was the pilot’s expectation and assumption that there were no above-ground…NTSB CEN09CA344Accident · Serious injuriesData collectionFinal reportTaylorcraft BC12-D · Murray, IAThe pilot's failure to maintain control of the airplane while maneuvering at a low altitude.NTSB CHI99FA147Accident · 1 fatalField investigationFinal reportTaylorcraft BC-12D · Newton, IAthe failure of the pilot to maintain flying speed resulting in a stall and spin into the ground.NTSB CHI92LA049Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Decorah, IAInadequate compensation for wind conditions, which resulted in a loss of directional control. Factors related to the accident were: the unfavorable wind conditions, snow covered runway, and snowbanks adjacent to the runway.NTSB MKC85LA145Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Cedar Rapids, IAWhile taxiing to takeoff, the plt was proceeding between 2 rows of hangars. He stated that he was having a problem with the acft transceiver & was adjusting it for taxi instructions. At about that time, the right wing tip of the acft struck the tail rotor of…NTSB MKC81DCD16Accident · Serious injuriesClosedTaylorcraft BC12-D · Mystic, IANTSB MKC79DCD09Accident · No injuriesClosedTaylorcraft BC-12D · Nevada, IANTSB MKC76DCD65Accident · Minor injuriesClosedTaylorcraft BC12-D · Springville, IANTSB MKC70D0055Accident · No injuriesClosedTaylorcraft BC12-D · Grinnell, IANTSB MKC68A0008Accident · 1 fatalClosedTaylorcraft BC12-D · Le Mars, IA