NTSB investigations: Continental 0-200 series, 1969, IL

15 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, 1969, IL per year, 1964–2026: 233 cases
19643
19657
196621
196716
196812
196915
19707
197111
19724
19738
19748
19757
197610
197713
197819
19795
19804
19812
19825
19833
19842
19854
19875
19883
19891
19901
19922
19931
19942
19952
19971
19981
19992
20003
20012
20021
20032
20042
20053
20071
20082
20092
20101
20151
20181
20211
20231
20251
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\") = 1969
    AND c.\"eventStateOrRegion\" = 'IL' 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.

NTSB CHI70D0375Accident · No injuriesClosedCessna 150 · Ottawa, ILDec 27, 1969 · N60087 · Substantial damageNTSB CHI70D0351Accident · No injuriesClosedCessna 150G · E.St Louis, ILDec 2, 1969 · N6309S · Substantial damageNTSB CHI70D0397Accident · No injuriesClosedCessna 150 · Streator, ILNov 21, 1969 · N22102 · Substantial damageNTSB CHI70A0034Accident · No injuriesClosedCessna 150 · Prairie View, ILNov 16, 1969 · N6009T · 2 aircraft · Minor damageNTSB MKC70A0027Accident · 2 fatalClosedCessna 150E · Esmond, ILNov 9, 1969 · N426RA · DestroyedNTSB CHI70F0207Accident · No injuriesClosedCessna 150 · Wheeling, ILAug 15, 1969 · N50973 · Substantial damageNTSB CHI70F0139Accident · No injuriesClosedCessna 150G · Springfield, ILAug 4, 1969 · N3276J · Substantial damageNTSB CHI70D0032Accident · No injuriesClosedCessna 150 · Minooka, ILJun 10, 1969 · N8382G · Substantial damageNTSB CHI69D0674Accident · No injuriesClosedCessna 150 · Ringwood, ILMay 22, 1969 · N6933F · Substantial damageNTSB CHI69D0673Accident · Minor injuriesClosedCessna 150 · Lockport, ILMay 11, 1969 · N23502 · Substantial damageNTSB CHI69F0563Accident · No injuriesClosedCessna 150 · Rockford, ILApr 5, 1969 · N50850 · Substantial damageNTSB CHI69F0548Accident · No injuriesClosedCessna 150 · Collinsville, ILMar 18, 1969 · N8391G · Substantial damageNTSB CHI69F0545Accident · No injuriesClosedCessna 150F · Danville, ILMar 15, 1969 · N8346G · Substantial damageNTSB CHI69D0449Accident · No injuriesClosedCessna 150G · Wheeling, ILJan 19, 1969 · N2823S · Substantial damageNTSB CHI69D0447Accident · No injuriesClosedCessna 150F · Mendota, ILJan 10, 1969 · N8751G · Substantial damage