NTSB investigations: Taylorcraft BC12-D, OH
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
| 1964 | 3 |
|---|---|
| 1966 | 2 |
| 1968 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 1974 | 2 |
| 1975 | 2 |
| 1976 | 2 |
| 1980 | 1 |
| 1988 | 1 |
| 1989 | 2 |
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\" = 'OH' 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" = 'OH' 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 CHI90LA038Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Millbury, OHFailure of the pilot to properly secure the aircraft and/or adequately brief the passenger (student pilot), and inadvertent bumping of the throttle by the passenger.NTSB CHI89LA162Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Garrettsville, OHThe pilot did not maintain adequate airspeed and allowed the aircraft to inadvertently enter a stall/spin. Turbulence was considered to be a contributing factor.NTSB ATL88LA163Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Canfield, OHThe plt reported that the he elected to go-around after realizing he was going to land long. A gust of wind lifted up the left wing as he initiated the go-around, and he lost control of the airplane. It subsequently impacted the terrain on the right side of…NTSB CHI81DEG01Accident · No injuriesClosedTaylorcraft BC12D · Cincinnati, OHNTSB CHI76FEG20Accident · Minor injuriesClosedTaylorcraft BC-12D · Dayton, OHNTSB CHI76FEI32Accident · Serious injuriesClosedTaylorcraft BC12-D · Kirby, OHNTSB CHI76AC016Accident · 1 fatalClosedTaylorcraft BC12-D · Circleville, OHNTSB CHI76FEK03Accident · Minor injuriesClosedTaylorcraft BC12-D · Georgesville, OHNTSB CHI75FEI12Accident · No injuriesClosedTaylorcraft BC12-D · Wharton, OHNTSB CHI74DE118Accident · No injuriesClosedCessna 150H · Wadsworth, OHNTSB CHI73FEI48Accident · No injuriesClosedTaylorcraft BC12-D · Wadsworth, OHNTSB CHI71FEG27Accident · No injuriesClosedTaylorcraft BC12-D · Phillipsburg, OHNTSB CHI69D0297Accident · No injuriesClosedTaylorcraft BC12-D · Up.Sandusky, OHNTSB CHI67F0283Accident · Minor injuriesClosedTaylorcraft BC12-D · Elyria, OHNTSB CHI66D0689Accident · No injuriesClosedTaylorcraft BC-12D · Waynesville, OHNTSB UNK65X0510Accident · No injuriesClosedTaylorcraft BC12D · Fulton, OHNTSB UNK64X4025Accident · Minor injuriesClosedTaylorcraft BC120 · Wadsworth, OHNTSB UNK64X2917Accident · Minor injuriesClosedTaylorcraft BC12D · Brunswick, OH