Final NTSB investigations: Taylorcraft BF

9 cases on aircraft the registry lists as Taylorcraft BF. 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

Final NTSB investigations: Taylorcraft BF per year, 1964–2026: 9 cases
1964	5
1965	1
1967	1
1968	1
2022	1

Where

Open the map

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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8850326')) 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.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8850326'))
  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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8850326'))
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 CEN23LA070Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BF · Navasota, TXThe student pilot failed to maintain directional control during landing.Dec 26, 2022 · N26625 · Substantial damage NTSB ANC69A0013Accident · 2 fatalClosedTaylorcraft BC12-D · Anchorage, AKAug 24, 1968 · N96933 · Destroyed NTSB NYC68F0300Accident · Serious injuriesClosedTaylorcraft BC12-D · Midway, PAOct 22, 1967 · N5049M · Substantial damage NTSB LAX65F0062Accident · Serious injuriesClosedTaylorcraft BC12D · Newbury Park, CAApr 26, 1965 · N95023 · Substantial damage NTSB UNK64X3501Accident · Minor injuriesClosedTaylorcraft BC12D · Thermal, CAAug 21, 1964 · N43418 · Destroyed NTSB UNK64X3457Accident · No injuriesClosedTaylorcraft BC12D · Carlisle, OHAug 18, 1964 · N96976 · Substantial damage NTSB UNK64X2224Accident · No injuriesClosedTaylorcraft BL1265 · Rawlings, WYJun 11, 1964 · N36064 · Destroyed NTSB UNK64X1224Accident · Minor injuriesClosedTaylorcraft BL65 · Mullen, NEApr 8, 1964 · N22268 · Substantial damage NTSB UNK64X0582Accident · No injuriesClosedTaylorcraft BC12D · Cien Fuegos, CubaFeb 16, 1964 · N5103M · Destroyed