NTSB investigations: Continental 0-200 series, KY

79 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, newest first

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 c.\"eventStateOrRegion\" = 'KY' 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 IAD73FLQ34Accident · Minor injuriesClosedCessna 150H · Park City, KYJun 9, 1973 · N23168 · DestroyedNTSB CHI73AC016Accident · 1 fatalClosedCessna 150H · Louisville, KYAug 13, 1972 · N23168 · 2 aircraft · Minor damageNTSB CHI72FLQ33Accident · No injuriesClosedCessna 150 · Owenton, KYApr 13, 1972 · N23153 · Substantial damageNTSB CHI72FLQ25Accident · No injuriesClosedCessna 150 · Berea, KYJan 1, 1972 · N6789S · Substantial damageNTSB CHI72FLQ24Accident · 1 fatalClosedCessna 150H · Louisville, KYNov 16, 1971 · N7018S · Substantial damageNTSB CHI72FLQ19Accident · No injuriesClosedCessna 150 · Hawesville, KYNov 10, 1971 · N1014M · Substantial damageNTSB CHI72FLQ10Accident · Serious injuriesClosedCessna 150H · Hazard, KYSep 10, 1971 · N7023S · DestroyedNTSB CHI71FLQ25Accident · No injuriesClosedCessna 150K · New Haven, KYJun 12, 1971 · N6045G · Substantial damageNTSB MIA71DLT15Accident · No injuriesClosedCessna 150 · Whitesville, KYMay 9, 1971 · N6245G · Substantial damageNTSB CHI71FLQ22Accident · No injuriesClosedCessna 150 · Lexington, KYMay 2, 1971 · N8744S · Substantial damageNTSB CHI71DGJ01Accident · No injuriesClosedCessna 150 · Murray, KYJul 12, 1970 · N1282Y · Substantial damageNTSB CHI70DGJ14Accident · No injuriesClosedCessna 150 · Elizabethtown, KYJun 4, 1970 · N3503J · Substantial damageNTSB CHI70DGJ10Accident · No injuriesClosedCessna 150 · Adairville, KYMay 23, 1970 · N22521 · Substantial damageNTSB CHI70F0387Accident · Serious injuriesClosedCessna 150 · Lebanon, KYDec 8, 1969 · N3669J · DestroyedNTSB CHI70F0329Accident · No injuriesClosedCessna 150 · Cherokee Sta, KYNov 8, 1969 · N22664 · Substantial damageNTSB CHI70D0024Accident · No injuriesClosedCessna 150 · Louisville, KYSep 15, 1969 · N5747G · Substantial damageNTSB CHI70F0166Accident · Minor injuriesClosedCassutt HL-1 · Henderson, KYAug 15, 1969 · N4651T · Substantial damageNTSB CHI70D0178Accident · No injuriesClosedCessna 150 · Owensboro, KYAug 7, 1969 · N6367S · Substantial damageNTSB CHI70F0008Accident · Serious injuriesClosedCessna 150 · Lexington, KYMay 28, 1969 · N50829 · DestroyedNTSB CHI69D0669Accident · Minor injuriesClosedCessna 150H · Middletown, KYMay 13, 1969 · N22373 · Substantial damageNTSB CHI69A0089Accident · 1 fatalClosedCessna 150 · Prospect, KYApr 30, 1969 · N8498G · DestroyedNTSB CHI69F0279Accident · No injuriesClosedCessna 150 · Hodgenville, KYOct 22, 1968 · N3032S · Substantial damageNTSB CHI69F0244Accident · No injuriesClosedCessna 150 · Oscar, KYSep 7, 1968 · N23354 · Substantial damageNTSB CHI69D0282Accident · No injuriesClosedCessna 150 · Lynnville, KYAug 25, 1968 · N4422U · DestroyedNTSB CHI69D0206Accident · No injuriesClosedCessna 150 · Mt Sterling, KYJul 2, 1968 · N1247Y · Substantial damageNTSB CHI68F0711Accident · No injuriesClosedCessna 150 · West Paducah, KYApr 26, 1968 · N4127U · Substantial damageNTSB CHI68F0731Accident · No injuriesClosedCessna 150 · Frankfort, KYApr 20, 1968 · N4616X · Substantial damageNTSB CHI67D0342Accident · Minor injuriesClosedCessna 150D · London, KYOct 21, 1966 · N4145U · Substantial damageNTSB CHI65D0045Accident · No injuriesClosedCessna 150 · Arrollton, KYMar 12, 1965 · N5738E · Substantial damage