NTSB investigations: Taylorcraft BF12-65

11 cases on aircraft the registry lists as Taylorcraft BF12-65. 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

19652026

NTSB investigations: Taylorcraft BF12-65 per year, 1965–2026: 11 cases
1965	1
1969	2
1971	2
1973	1
1975	1
1987	1
1993	1
2007	1
2009	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8850340')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8850340'))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8850340'))
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 CEN09LA467Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BF12 · Sawyer, MIThe pilot's failure to maintain adequate airspeed while taking off from a short, grass runway.Jul 25, 2009 · N36299 · Substantial damage NTSB SEA07LA217Accident · 2 fatalLimited investigationFinal reportTaylorcraft BF12 · West Linn, ORThe corrosion, fatigue fracture, and subsequent separation of the left wing lift strut attachment fitting. Also causal was the inadequate maintenance and annual inspection by the owner/pilot/mechanic.Jul 28, 2007 · N13060 · Substantial damage NTSB BFO93LA139Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BF12-65 · Sunappee, NHThe passenger's failure to follow proper procedures and inadequate supervision by the pilot.Jul 25, 1993 · N36452 · No damage NTSB CHI87LA160Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12D · Dyckesville, WIAircraft stalled as the pilot attempted to climb and turn back to fly along green bay shoreline. The pilot was flying approx. 100 to 150 feet above the water in order for the passenger to photograph the shoreline.Jul 1, 1987 · N33967 · Destroyed NTSB MIA76DKJ14Accident · Minor injuriesClosedTaylorcraft BF12-D · Hanceville, ALAug 23, 1975 · N34044 · Destroyed NTSB NYC74DGM03Accident · No injuriesClosedTaylorcraft BF1265 · Meadville, PAAug 25, 1973 · N39144 · Substantial damage NTSB MIA72FLG06Accident · No injuriesClosedTaylorcraft BC12 · Sullivans Is., SCAug 10, 1971 · N36452 · Substantial damage NTSB FTW71AF043Accident · 1 fatalClosedTaylorcraft BF1265 · Vinita, OKJan 24, 1971 · N36303 · Destroyed NTSB NYC70D0222Accident · No injuriesClosedTaylorcraft BC-12 · New Salem, NYDec 7, 1969 · N29756 · Substantial damage NTSB NYC70A0001Accident · 1 fatalClosedTaylorcraft BF12 · Phillipsburg, NJJul 1, 1969 · N36427 · Destroyed NTSB MIA49A0049Accident · 2 fatalClosedTaylorcraft BF-12 · Horton, ALOct 30, 1965 · N33957 · Destroyed