NTSB investigations: Taylorcraft BC12-D, 1974

13 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

19642026
NTSB investigations: Taylorcraft BC12-D, 1974 per year, 1964–2026: 531 cases
196439
196523
196624
196722
196827
196926
197023
197122
197216
197317
197413
197518
197618
19779
197811
19793
19808
19817
19829
19838
19848
19853
198613
19877
198812
19897
19905
199110
19925
199310
19945
19953
19963
19972
19988
19997
20005
20016
20023
20032
20043
20058
20065
20072
20097
20101
20113
20124
20132
20144
20153
20162
20171
20183
20194
20201
20211
20221
20233
20243
20252
20261

Latest 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 year(c.\"eventDate\") = 1974
    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.

NTSB FTW75FPD18Accident · Minor injuriesClosedTaylorcraft BC12-D · N.Richld Hils, TXNov 19, 1974 · N43708 · DestroyedNTSB UNK75X0100Accident · No injuriesClosedTaylorcraft BC12-D · Niagara On Lk, CanadaOct 27, 1974 · N96383 · Substantial damageNTSB FTW75DPD11Accident · Serious injuriesClosedTaylorcraft BC12-D · Justin, TXOct 5, 1974 · N43131 · Substantial damageNTSB FTW75FRJ16Accident · Minor injuriesClosedTaylorcraft BC12-D · Longview, TXSep 29, 1974 · N44046 · Substantial damageNTSB ANC75FAG37Accident · Minor injuriesClosedTaylorcraft BC12-D · Anchorage, AKSep 20, 1974 · N43142 · Substantial damageNTSB FTW75FPG20Accident · Serious injuriesClosedTaylorcraft BC12-D · Jacksonville, ARSep 15, 1974 · N96768 · DestroyedNTSB CHI75FEI12Accident · No injuriesClosedTaylorcraft BC12-D · Wharton, OHAug 18, 1974 · N43969 · Substantial damageNTSB CHI75FEC11Accident · No injuriesClosedTaylorcraft BC12-D · Durand, MIAug 18, 1974 · N96279 · Substantial damageNTSB OAK74FVG35Accident · Minor injuriesClosedTaylorcraft BC12-D · Burson, CAMar 18, 1974 · N96325 · Substantial damageNTSB FTW74DQG46Accident · No injuriesClosedTaylorcraft BC12-D · Midland, TXMar 17, 1974 · N43347 · Substantial damageNTSB SEA74DTI17Accident · Minor injuriesClosedTaylorcraft BC12-D · Missoula, MTFeb 8, 1974 · N96809 · Substantial damageNTSB SEA74DYA20Accident · Minor injuriesClosedTaylorcraft BC12-D · Montpelier, MTFeb 3, 1974 · N39916 · Substantial damageNTSB CHI74DE118Accident · No injuriesClosedCessna 150H · Wadsworth, OHJan 5, 1974 · N22151 · 2 aircraft · Substantial damage