NTSB investigations: Continental 0-300 series, 1964, TX

15 cases on aircraft whose registry engine model is Continental 0-300 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 0-300 series, 1964, TX per year, 1964–2026: 214 cases
196415
196516
196612
196716
19689
19696
19709
197110
19726
19736
19742
19757
19763
19773
19786
19793
19812
19823
19835
19842
19864
19873
19882
19901
19924
19933
19941
19951
19961
19983
19992
20003
20011
20022
20032
20041
20052
20073
20083
20092
20101
20112
20131
20141
20152
20184
20194
20201
20221
20231
20245
20254
20262

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\") = 1964
    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 ('17022'))
  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 UNK65X1109Accident · No injuriesClosedCessna 172E · San Antonio, TXDec 24, 1964 · N5743T · Substantial damageNTSB UNK65X0912Accident · No injuriesClosedCessna 172 · Westherford, TXDec 4, 1964 · N2360U · Substantial damageNTSB UNK65X0774Accident · Minor injuriesClosedCessna 172 · Lorenzo, TXNov 21, 1964 · N8111X · Substantial damageNTSB UNK65X0646Accident · No injuriesClosedCessna 172B · Lubbock, TXNov 10, 1964 · N2182Y · Substantial damageNTSB UNK65X0508Accident · No injuriesClosedCessna 172 · Waller, TXNov 1, 1964 · N4101F · Substantial damageNTSB UNK65X0391Accident · Serious injuriesClosedCessna 172 · Ralls, TXOct 23, 1964 · N7321T · DestroyedNTSB UNK65X0364Accident · Serious injuriesClosedCessna 172 · Van, TXOct 21, 1964 · N8233B · DestroyedNTSB UNK65X0269Accident · No injuriesClosedCesna 172 · Amarillo, TXOct 13, 1964 · N4114F · Substantial damageNTSB UNK65X0147Accident · No injuriesClosedCessna 170B · Laporte, TXOct 4, 1964 · N2604D · Substantial damageNTSB UNK64X3341Accident · No injuriesClosedCessna 172 · Goliad, TXAug 12, 1964 · N8349X · Substantial damageNTSB UNK64X1357Accident · Minor injuriesClosedCessna 172 · Munday, TXApr 18, 1964 · N8280B · DestroyedNTSB UNK64X1351Accident · No injuriesClosedCessna 172 · Bronte, TXApr 17, 1964 · N1534Y · Substantial damageNTSB UNK64X1323Accident · No injuriesClosedCessna 172 · Quitaque, TXApr 15, 1964 · N6479E · Substantial damageNTSB UNK64X0412Accident · Minor injuriesClosedCessna 172B · Killeen, TXJan 31, 1964 · N6940X · Substantial damageNTSB UNK64X0287Accident · No injuriesClosedCessna 172D · Dallas, TXJan 19, 1964 · N2485Y · Substantial damage