NTSB investigations: Continental 0-200 series, 2002, CA

2 cases on aircraft whose registry engine model is Continental 0-200 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-200 series, 2002, CA per year, 1964–2026: 793 cases
196420
196524
196646
196749
196850
196945
197042
197138
197229
197323
197434
197525
197628
197727
197826
197923
198016
198115
198210
198311
198413
198511
198612
19879
198811
19898
19909
19914
19926
199310
19944
19958
19966
19974
19985
19996
20007
200111
20022
20032
20041
20058
20064
20073
20083
20093
20113
20124
20132
20151
20161
20173
20184
20194
20203
20217
20226
20254

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\") = 2002
    AND c.\"eventStateOrRegion\" = 'CA' 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 ('17020'))
  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.