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 NYC76FGM40Accident · Serious injuriesClosedTaylorcraft BC12-D · Somerset, PAJul 18, 1976 · N95098 · Substantial damage NTSB LAX76FUA29Accident · No injuriesClosedTaylorcraft BC12-D · Torrance, CAJul 18, 1976 · N39238 · 2 aircraft · Substantial damage NTSB CHI76FEM49Accident · Serious injuriesClosedTaylorcraft BC12-D · Mancelona, MIJul 6, 1976 · N43873 · Substantial damage NTSB CHI76FEI32Accident · Serious injuriesClosedTaylorcraft BC12-D · Kirby, OHJun 29, 1976 · N95741 · Destroyed NTSB NYC76FNE23Accident · Minor injuriesClosedTaylorcraft BC12-D · Norfolk, CTJun 6, 1976 · N95148 · Substantial damage NTSB IAD76FKM34Accident · Serious injuriesClosedTaylorcraft BC12-D · Stokesdale, NCJun 4, 1976 · N43950 · Substantial damage NTSB LAX76DUQ39Accident · No injuriesClosedTaylorcraft BC12-D · Pacoima, CAMay 23, 1976 · N95781 · Substantial damage NTSB FTW76FPM17Accident · Minor injuriesClosedTaylorcraft BC12-D · Vian, OKApr 11, 1976 · N96248 · Destroyed NTSB NYC76AN079Accident · 1 fatalClosedTaylorcraft BC12-D · Minorsville, PAFeb 16, 1976 · N43435 · Destroyed NTSB CHI76FEV25Accident · No injuriesClosedPiper PA-31 · Jacksonville, ILFeb 16, 1976 · N5007 · 2 aircraft · Minor damage NTSB CHI76DEP23Accident · Minor injuriesClosedTaylorcraft BC12-D · Chambers Isle, WIJan 25, 1976 · N95927 · Substantial damage NTSB FTW76DPG38Accident · No injuriesClosedTaylorcraft BC12-D · De Witt, ARDec 11, 1975 · N95309 · Substantial damage NTSB DEN76FQA29Accident · No injuriesClosedTaylorcraft BC12-D · Farmington, NMNov 19, 1975 · N95313 · Substantial damage NTSB DEN76FTE41Accident · No injuriesClosedTaylorcraft BC12-D · Aurora, CONov 15, 1975 · N44079 · Substantial damage NTSB IAD76DKM14Accident · No injuriesClosedTaylorcraft BCL2-D · Wilkesboro, NCNov 1, 1975 · N44158 · Substantial damage NTSB MIA76AM038Accident · 1 fatalClosedTaylorcraft BC12-D · Rockledge, FLOct 28, 1975 · N96067 · Destroyed NTSB CHI76FEM16Accident · No injuriesClosedTaylorcraft BC12-D · Big Rapids, MIOct 5, 1975 · N95982 · Substantial damage NTSB SEA76FTI12Accident · No injuriesClosedTaylorcraft BC12-D · Hamilton, MTSep 28, 1975 · N43725 · Substantial damage NTSB ANC76DAG53Accident · Serious injuriesClosedTaylorcraft BC12-D · Pilot Point, AKSep 21, 1975 · N95786 · Substantial damage NTSB CHI76AC016Accident · 1 fatalClosedTaylorcraft BC12-D · Circleville, OHAug 24, 1975 · N43787 · Destroyed NTSB CHI76FEK03Accident · Minor injuriesClosedTaylorcraft BC12-D · Georgesville, OHAug 9, 1975 · N95019 · Substantial damage NTSB FTW76FPG14Accident · 1 fatalClosedTaylorcraft BC12-D · Little Rock, ARAug 7, 1975 · N95883 · Destroyed NTSB NYC76DNC01Accident · No injuriesClosedTaylorcraft BC12-D · Caribou, MEJul 13, 1975 · N43875 · Substantial damage NTSB LAX76FUG01Accident · Minor injuriesClosedTaylorcraft BC12-D · Rialto, CAJul 4, 1975 · N43472 · Substantial damage NTSB CHI75DEE64Accident · Serious injuriesClosedTaylorcraft BC12-D · Chicago Hts, ILMay 26, 1975 · N95278 · Substantial damage NTSB IAD75DKW15Accident · No injuriesClosedTaylorcraft BC12-D · Pikeville, TNMay 11, 1975 · N44050 · Substantial damage NTSB NYC75DNC31Accident · No injuriesClosedCessna 172H · Montpelier, VTMay 5, 1975 · N2831L · 2 aircraft · Substantial damage NTSB IAD75FLJ25Accident · No injuriesClosedTaylorcraft BC12-D · Louisburg, NCMay 4, 1975 · N44215 · Substantial damage NTSB MIA75AM067Accident · 1 fatalClosedTaylorcraft BC12-D · Homosassa Spg, FLMar 8, 1975 · N96102 · Destroyed NTSB FTW75FPD18Accident · Minor injuriesClosedTaylorcraft BC12-D · N.Richld Hils, TXNov 19, 1974 · N43708 · Destroyed NTSB UNK75X0100Accident · No injuriesClosedTaylorcraft BC12-D · Niagara On Lk, CanadaOct 27, 1974 · N96383 · Substantial damage NTSB FTW75DPD11Accident · Serious injuriesClosedTaylorcraft BC12-D · Justin, TXOct 5, 1974 · N43131 · Substantial damage NTSB FTW75FRJ16Accident · Minor injuriesClosedTaylorcraft BC12-D · Longview, TXSep 29, 1974 · N44046 · Substantial damage NTSB ANC75FAG37Accident · Minor injuriesClosedTaylorcraft BC12-D · Anchorage, AKSep 20, 1974 · N43142 · Substantial damage NTSB FTW75FPG20Accident · Serious injuriesClosedTaylorcraft BC12-D · Jacksonville, ARSep 15, 1974 · N96768 · Destroyed NTSB CHI75FEI12Accident · No injuriesClosedTaylorcraft BC12-D · Wharton, OHAug 18, 1974 · N43969 · Substantial damage NTSB CHI75FEC11Accident · No injuriesClosedTaylorcraft BC12-D · Durand, MIAug 18, 1974 · N96279 · Substantial damage NTSB OAK74FVG35Accident · Minor injuriesClosedTaylorcraft BC12-D · Burson, CAMar 18, 1974 · N96325 · Substantial damage NTSB FTW74DQG46Accident · No injuriesClosedTaylorcraft BC12-D · Midland, TXMar 17, 1974 · N43347 · Substantial damage NTSB SEA74DTI17Accident · Minor injuriesClosedTaylorcraft BC12-D · Missoula, MTFeb 8, 1974 · N96809 · Substantial damage NTSB SEA74DYA20Accident · Minor injuriesClosedTaylorcraft BC12-D · Montpelier, MTFeb 3, 1974 · N39916 · Substantial damage NTSB CHI74DE118Accident · No injuriesClosedCessna 150H · Wadsworth, OHJan 5, 1974 · N22151 · 2 aircraft · Substantial damage NTSB CHI74DEC22Accident · Minor injuriesClosedTaylorcraft BC12-D · Owosso, MIDec 15, 1973 · N5123M · Substantial damage NTSB ANC74FAG81Accident · Serious injuriesClosedTaylorcraft BC12-D · Skwentna, AKNov 17, 1973 · N96188 · Substantial damage NTSB MKC74AK023Accident · 1 fatalClosedTaylorcraft BC12-D · Fairbury, NENov 14, 1973 · N5041M · Destroyed NTSB NYC74FHA16Accident · Serious injuriesClosedTaylorcraft BC12-D · Montague, NJNov 4, 1973 · N39210 · Substantial damage NTSB MKC74AK014Accident · 1 fatalClosedTaylorcraft BC12-D · Slayton, MNOct 2, 1973 · N96184 · Substantial damage NTSB DEN74DTC07Incident · No injuriesClosedTaylorcraft DC12D · Evanston, WYAug 11, 1973 · N39243 · Minor damage NTSB LAX74DUQ08Accident · No injuriesClosedTaylorcraft BC12-D · Goleta, CAJul 23, 1973 · N43132 · Substantial damage NTSB IAD74DKM06Accident · Serious injuriesClosedTaylorcraft BC12-D · Wadesboro, NCJul 21, 1973 · N95099 · Substantial damage