NTSB investigations: Continental 0-200 series, MD

76 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\" = 'MD' 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 NYC73FIG19Accident · Minor injuriesClosedCessna 150K · College Park, MDDec 14, 1972 · N6434G · Substantial damageNTSB NYC73FIG11Accident · Minor injuriesClosedCessna 150G · College Park, MDSep 1, 1972 · N2631J · DestroyedNTSB NYC72FIG27Accident · Minor injuriesClosedCessna 150 · Gaithersburg, MDJun 25, 1972 · N5439Q · Substantial damageNTSB NYC72FIG22Accident · No injuriesClosedCessna 150 · College Park, MDApr 21, 1972 · N2903S · Substantial damageNTSB NYC72FIG20Accident · No injuriesClosedCessna 150 · Laurel, MDMar 12, 1972 · N6413G · Substantial damageNTSB NYC72FIG16Accident · No injuriesClosedCessna 150J · Crownsville, MDDec 30, 1971 · N50534 · Substantial damageNTSB NYC72AN024Accident · No injuriesClosedCessna 150K · Frederick, MDAug 13, 1971 · N6273G · 2 aircraft · Minor damageNTSB IAD72DIG03Accident · No injuriesClosedCessna 150 · Finksburg, MDJul 5, 1971 · N4538U · Substantial damageNTSB DIA69D0114Accident · No injuriesClosedCessna 150 · Brookeville, MDNov 28, 1968 · N3029J · Substantial damageNTSB DIA69F0006Accident · No injuriesClosedCessna 150 · Fallston, MDJun 6, 1968 · N23450 · DestroyedNTSB DIA68F0002Accident · Minor injuriesClosedCessna 150 · Michellville, MDMay 29, 1967 · N8692S · Substantial damageNTSB DIA67D0043Accident · No injuriesClosedCessna 150 · College Park, MDFeb 11, 1967 · N8259S · Substantial damageNTSB DIA67F0040Accident · No injuriesClosedChampion 402 · Friendly, MDFeb 10, 1967 · N9954Y · DestroyedNTSB DIA67D0032Accident · No injuriesClosedCessna 150 · Hagerstown, MDJan 24, 1967 · N8098S · Substantial damageNTSB DIA67D0031Accident · No injuriesClosedCessna 150F · Gaithersburg, MDJan 24, 1967 · N8716S · Substantial damageNTSB NYC67D0362Accident · No injuriesClosedCessna 150 · Lower Marlboro, MDNov 13, 1966 · N2553J · Substantial damageNTSB NYC67D0177Accident · No injuriesClosedCessna 150F · Hurlock, MDAug 13, 1966 · N8946S · Substantial damageNTSB NYC67D0102Accident · No injuriesClosedCessna 150 · Gaithersburg, MDJul 12, 1966 · N7811E · Substantial damageNTSB NYC66F0712Accident · No injuriesClosedCessna 150 · Friendly, MDMay 24, 1966 · N8759S · Substantial damageNTSB NYC66D0533Accident · No injuriesClosedCessna 150 · Friendly, MDFeb 26, 1966 · N5954T · Substantial damageNTSB NYC66D0507Accident · No injuriesClosedCessna 150 · Gaithersburg, MDFeb 12, 1966 · N8716S · Substantial damageNTSB NYC66D0337Accident · No injuriesClosedChampion 7ECA · Clinton, MDOct 31, 1965 · N9539S · Substantial damageNTSB NYC66D0331Accident · Minor injuriesClosedCessna 150 · Gaithersburg, MDOct 30, 1965 · N8748S · Substantial damageNTSB NYC66D0315Accident · No injuriesClosedCessna 150 · Pocomoke City, MDOct 17, 1965 · N7335X · Substantial damageNTSB NYC66D0058Accident · No injuriesClosedCessna 150 · Friendly, MDJun 29, 1965 · N6193T · Substantial damageNTSB UNK64X1968Accident · No injuriesClosedChampion 402 · Friendly, MDMay 27, 1964 · N9954Y · Substantial damage