NTSB investigations: Continental O-470 series, 1968, TX

14 cases on aircraft whose registry engine model is Continental O-470 series. 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: Continental O-470 series, 1968, TX per year, 1964–2026: 411 cases
196424
196516
196627
196720
196814
196910
197016
19717
19727
19737
19747
197512
197615
197712
197813
19796
198013
19815
19828
198311
19844
19858
19863
19871
19886
19894
19902
19911
19924
19932
19945
19952
19961
19974
19982
19996
20016
20023
20033
20042
20052
20063
20074
20087
20094
201011
20115
20123
20132
20142
20156
20164
20173
20182
20196
20204
20214
202210
20232
20242
20252
20264

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\") = 1968
    AND c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17026'))
  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 FTW69F0327Accident · Minor injuriesClosedCessna 182 · Linden, TXDec 15, 1968 · N5123D · Substantial damageNTSB FTW69D0317Accident · No injuriesClosedCessna 182L · Alice, TXDec 7, 1968 · N3303R · Substantial damageNTSB FTW69D0293Accident · No injuriesClosedCessna 182 · Liberty, TXNov 13, 1968 · N2879R · Substantial damageNTSB FTW69D0270Accident · No injuriesClosedCessna 182 · Lubbock, TXOct 20, 1968 · N3382R · Substantial damageNTSB FTW69F0167Accident · No injuriesClosedCessna 180 · El Paso, TXSep 4, 1968 · N4994A · Substantial damageNTSB FTW69F0172Accident · No injuriesClosedCessna 182 · Corpus Christ, TXAug 25, 1968 · N42279 · Substantial damageNTSB FTW69D0195Accident · No injuriesClosedCessna 180 · Dripping Spgs, TXAug 2, 1968 · N4596B · Substantial damageNTSB FTW69D0130Accident · No injuriesClosedCessna 188 · Eagle Pass, TXJul 9, 1968 · N9778V · Substantial damageNTSB FTW69F0064Accident · No injuriesClosedBeech H35 · Lubbock, TXJun 29, 1968 · N8216D · Substantial damageNTSB FTW68F0599Accident · No injuriesClosedCessna 182 · Lubbock, TXMay 29, 1968 · N42279 · Substantial damageNTSB FTW68F0528Accident · No injuriesClosedCessna 180 · Dallas, TXApr 5, 1968 · N7661A · Substantial damageNTSB FTW68F0478Accident · No injuriesClosedCessna 305A · Humble, TXFeb 25, 1968 · N1830 · Substantial damageNTSB FTW68F0464Accident · No injuriesClosedCessna 182J · Andrews, TXFeb 21, 1968 · N3112F · Substantial damageNTSB FTW68D0453Accident · No injuriesClosedCessna 182 · Wichita Falls, TXFeb 17, 1968 · N3410R · Substantial damage