Skip to content

NTSB investigations: Taylorcraft BC12-D

531 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

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 ('8850316')) 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 ('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."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

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 CHI69A0039Accident · 1 fatalClosedTaylorcraft BC12-D · Ogilvie, MNOct 10, 1968 · N96557 · Destroyed NTSB CHI69D0297Accident · No injuriesClosedTaylorcraft BC12-D · Up.Sandusky, OHSep 14, 1968 · N96399 · Substantial damage NTSB CHI69A0028Accident · 1 fatalClosedTaylorcraft BF12D · Chapin, MISep 14, 1968 · N43000 · Destroyed NTSB NYC69D0136Accident · No injuriesClosedTaylorcraft BC12-D · Norway, MESep 1, 1968 · N43989 · Substantial damage NTSB ANC69F0069Accident · Serious injuriesClosedTaylorcraft BC12-D · Anchorage, AKAug 30, 1968 · N94907 · Substantial damage NTSB SEA69F0098Accident · 2 fatalClosedTaylorcraft BC12-D · Winnett, MTAug 19, 1968 · N95010 · Destroyed NTSB NYC69A0020Accident · Minor injuriesClosedTaylorcraft BC12-D · Barre Plains, MAAug 18, 1968 · N43118 · 2 aircraft · Substantial damage NTSB FTW69F0051Accident · No injuriesClosedTaylorcraft BC12-D · Amelia, LAJul 19, 1968 · N43328 · Substantial damage NTSB MKC69D0173Accident · Minor injuriesClosedTaylorcraft BC12-D · Lacygne, KSJul 13, 1968 · N96438 · Substantial damage NTSB FTW69D0096Accident · No injuriesClosedTaylorcraft BC12-D · Hallsville, TXJul 13, 1968 · N44046 · Substantial damage NTSB ANC69F0023Accident · No injuriesClosedTaylorcraft BCS12D · Kenai, AKJul 3, 1968 · N43822 · Substantial damage NTSB MIA69F0064Accident · Minor injuriesClosedTaylorcraft BC12-D · Lithonia, GAJun 15, 1968 · N43596 · Destroyed NTSB FTW68A0109Accident · 2 fatalClosedTaylorcraft BC12-D · Winnie, TXJun 15, 1968 · N95103 · Destroyed NTSB FTW68A0106Accident · 1 fatalClosedTaylorcraft BC12-D · Round Rock, TXJun 9, 1968 · N95155 · Destroyed NTSB MKC68D0583Accident · No injuriesClosedTaylorcraft BC12-D · Ivanhoe, MNMay 12, 1968 · N96530 · Substantial damage NTSB SEA68F0286Accident · No injuriesClosedTaylorcraft BCS12D · Redmond, WAMar 31, 1968 · N95796 · Substantial damage NTSB LAX68D0366Accident · Minor injuriesClosedTaylorcraft BC12-D · Marana, AZMar 18, 1968 · N39931 · Substantial damage NTSB OAK68F0326Accident · No injuriesClosedTaylorcraft BC12-D · San Jose, CAFeb 25, 1968 · N43420 · 2 aircraft · Substantial damage NTSB MIA68D0384Accident · No injuriesClosedTaylorcraft BC12-D · Oak Grove, ALJan 21, 1968 · N95779 · Substantial damage NTSB DEN68F0201Accident · Serious injuriesClosedTaylorcraft BC12-D · Truth-Consq, NMJan 16, 1968 · N43819 · Substantial damage NTSB MKC68A0044Accident · 2 fatalClosedTaylorcraft BC12-D · Wolbach, NEJan 7, 1968 · N96559 · Destroyed NTSB DEN68A0029Accident · 2 fatalClosedTaylorcraft BC12-D · Bountiful, UTJan 4, 1968 · N95775 · Destroyed NTSB DEN68F0187Accident · No injuriesClosedTaylorcraft BC12-D · Albuquerque, NMJan 1, 1968 · N95810 · Substantial damage NTSB SEA68D0162Accident · Minor injuriesClosedTaylorcraft BC12-D · Ketchum, IDOct 6, 1967 · N95561 · Substantial damage NTSB SEA68D0144Accident · Minor injuriesClosedTaylorcraft BC12-D · Harrison, MTSep 20, 1967 · N95731 · Substantial damage NTSB MIA68D0193Accident · No injuriesClosedTaylorcraft BC12 · Millry, ALSep 17, 1967 · N34238 · Substantial damage NTSB MKC68F0151Accident · No injuriesClosedTaylorcraft BC12-D · Rolette, NDAug 4, 1967 · N43612 · Substantial damage NTSB MKC68A0008Accident · 1 fatalClosedTaylorcraft BC12-D · Le Mars, IAAug 1, 1967 · N43350 · 2 aircraft · Destroyed NTSB SEA68F0080Accident · Minor injuriesClosedTaylorcraft BC12-D · Puyallup, WAJul 30, 1967 · N96298 · Substantial damage NTSB FTW68D0127Accident · Minor injuriesClosedTaylorcraft BC12-D · Arlington, TXJul 30, 1967 · N43464 · Substantial damage NTSB CHI68A0012Accident · 2 fatalClosedTaylorcraft BC12-D · Holcombe, WIJul 26, 1967 · N96507 · Destroyed NTSB SEA68F0070Accident · No injuriesClosedTaylorcraft BC12-D · Bellevue, WAJul 12, 1967 · N95896 · Substantial damage NTSB NYC68F0069Accident · No injuriesClosedTaylorcraft BC12-D · Mt Pleasant, PAJul 10, 1967 · N43203 · Substantial damage NTSB NYC68D0072Accident · No injuriesClosedTaylorcraft BC12-D · Hanover, PAJul 9, 1967 · N43505 · Substantial damage NTSB OAK68D0072Accident · No injuriesClosedTaylorcraft BC12-D · Fremont, CAJun 30, 1967 · N43275 · Substantial damage NTSB LAX68D0052Accident · Minor injuriesClosedTaylorcraft BC12-D · 29 Palms, CAJun 30, 1967 · N94999 · Substantial damage NTSB SEA68D0057Accident · No injuriesClosedTaylorcraft BC-12 · Kelso, WAJun 11, 1967 · N96896 · Substantial damage NTSB CHI68D0129Accident · Minor injuriesClosedTaylorcraft BC-12D · Dixon, ILJun 9, 1967 · N95746 · Destroyed NTSB NYC68D0161Accident · No injuriesClosedTaylorcraft BC12-D · Scotia, NYJun 7, 1967 · N96428 · Substantial damage NTSB NYC68D0017Accident · Minor injuriesClosedTaylorcraft BC-12D · Falconer, NYMay 26, 1967 · N94988 · Substantial damage NTSB SEA67A0067Accident · 1 fatalClosedTaylorcraft BC12-D · Havre, MTMay 24, 1967 · N96684 · Destroyed NTSB LAX68D0007Accident · No injuriesClosedTaylorcraft BC12 · San Manuel, AZMay 21, 1967 · N39206 · Substantial damage NTSB NYC67D0550Accident · No injuriesClosedTaylorcraft BC12-D · Roxbury, MEMar 19, 1967 · N43989 · Substantial damage NTSB FTW67A0089Accident · 2 fatalClosedTaylorcraft BC12-D · Pleasanton, TXMar 5, 1967 · N43090 · Destroyed NTSB LAX67D0276Accident · No injuriesClosedTaylorcraft BC12-D · Yuma, AZJan 11, 1967 · N39279 · Substantial damage NTSB OAK67F0198Accident · Serious injuriesClosedTaylorcraft BC12-D · Fair Oaks, CADec 11, 1966 · N43515 · Substantial damage NTSB SEA67D0198Accident · No injuriesClosedTaylorcraft BC12-D · Jerome, IDNov 20, 1966 · N39230 · Substantial damage NTSB LAX67D0209Accident · No injuriesClosedTaylorcraft BC12-D · 29 Palms, CANov 16, 1966 · N5136M · Substantial damage NTSB CHI67A0055Accident · 2 fatalClosedTaylorcraft BC12-D · Burlington, WIOct 23, 1966 · N39294 · Destroyed NTSB CHI67F0258Accident · No injuriesClosedTaylorcraft BC12-D · Lombard, ILOct 8, 1966 · N43826 · Substantial damage