Final NTSB investigations: Continental O-470 series, 1962

1 case 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

19622026
Final NTSB investigations: Continental O-470 series, 1962 per year, 1962–2026: 6,139 cases
19621
1964232
1965242
1966250
1967309
1968181
1969181
1970202
1971180
1972158
1973161
1974160
1975170
1976154
1977144
1978161
1979149
1980136
1981113
1982107
1983124
198481
198587
198671
198774
198875
198975
199078
199174
199270
199364
199461
199565
199659
199753
199870
199980
200054
200172
200268
200386
200471
200563
200668
200776
200854
200958
201057
201178
201252
201350
201447
201563
201650
201745
201850
201950
202044
202144
202251
202338
202446
202539
202613

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\") = 1962
    AND c.\"completionStatus\" = 'Completed'
    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.