NTSB investigations: Taylorcraft BC12-D, UT
6 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 | 1 |
|---|---|
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1987 | 1 |
| 2003 | 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\" = 'UT' 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" = 'UT' 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 DEN03LA066Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · West Jordan, UTthe dual student's failure to maintain aircraft control and the flight instructor's inadequate supervision of the student. A contributing factor was the unfavorable wind gust.NTSB DEN87LA229Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Manila, UTThe student plt was landing at an uncontrolled airport with an asphalt runway 5300 x 60 ft oriented 250 degrees. She said she made 3 passes over the airport to check for conditions and then executed a normal landing. Shortly after touchdown the aircraft…NTSB DEN71DXT04Accident · No injuriesClosedTaylorcraft BC12-D · Tooele, UTNTSB DEN70D0139Accident · No injuriesClosedTaylorcraft BC12-D · Cedar City, UTNTSB DEN68A0029Accident · 2 fatalClosedTaylorcraft BC12-D · Bountiful, UTNTSB UNK64X0849Accident · No injuriesClosedTaylorcraft BC12D · Moab, UT