NTSB investigations: Continental 0-200 series, TN

94 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\" = 'TN' 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 IAD76II002Incident · No injuriesClosedCessna 150 · Nashville, TNJul 13, 1975 · N1623Q · 2 aircraft · No damageNTSB IAD75FKW19Accident · No injuriesClosedCessna 150 · Crossville, TNJun 16, 1975 · N2676J · Substantial damageNTSB IAD75DKW18Accident · No injuriesClosedCessna 150 · Murfreesboro, TNMay 26, 1975 · N6905G · Substantial damageNTSB IAD75FKW14Accident · No injuriesClosedCessna 150 · Columbia, TNMay 6, 1975 · N10850 · Substantial damageNTSB IAD75FKW09Accident · Serious injuriesClosedCessna 150 · Monterey, TNJan 1, 1975 · N6555T · Substantial damageNTSB IAD75FLT06Accident · No injuriesClosedCessna 150 · Brunswick, TNDec 19, 1974 · N2908V · Substantial damageNTSB IAD74DKW34Accident · No injuriesClosedCessna 150G · Surgoinsvile, TNApr 21, 1974 · N3176X · Substantial damageNTSB IAD74FKW05Accident · Minor injuriesClosedCessna 150G · Chattanooga, TNJul 14, 1973 · N4733X · Substantial damageNTSB IAD73DKW01Accident · No injuriesClosedCessna 150D · Dixon Spring, TNJul 1, 1973 · N4486U · Substantial damageNTSB IAD73FLT19Accident · No injuriesClosedCessna 150 · Covington, TNJun 18, 1973 · N3918J · Substantial damageNTSB MIA73FLT07Accident · No injuriesClosedCessna 150K · Memphis, TNSep 27, 1972 · N5772G · Substantial damageNTSB MIA73FLT05Accident · No injuriesClosedCessna 150F · Memphis, TNSep 23, 1972 · N8279S · Substantial damageNTSB MIA72DKW25Accident · No injuriesClosedCessna 150G · Rogersville, TNApr 29, 1972 · N8595J · Substantial damageNTSB MIA72FKW16Accident · No injuriesClosedCessna 150H · Nashville, TNFeb 4, 1972 · N50299 · Substantial damageNTSB MIA72DLT03Accident · No injuriesClosedCessna 150 · Millington, TNJul 31, 1971 · N6806G · Substantial damageNTSB MIA71FLT14Accident · Serious injuriesClosedCessna 150 · Memphis, TNMay 4, 1971 · N6943F · Substantial damageNTSB MIA71FKW29Accident · No injuriesClosedCessna 150 · Nashville, TNJan 3, 1971 · N3212X · Substantial damageNTSB MIA71DKW28Accident · No injuriesClosedCessna 150 · Mountain Cty, TNJan 3, 1971 · N5994G · Substantial damageNTSB MIA71DKW22Accident · No injuriesClosedCessna 150 · Whitwell, TNNov 9, 1970 · N3211X · Substantial damageNTSB MIA71FKW16Accident · No injuriesClosedCessna 150 · Lafollette, TNOct 25, 1970 · N3644J · Substantial damageNTSB MIA71FKD06Accident · Serious injuriesClosedCessna 150C · Memphis, TNSep 6, 1970 · N7831Z · Substantial damageNTSB MIA70DKW13Accident · No injuriesClosedCessna 150 · Robbins, TNJun 18, 1970 · N7952Z · Substantial damageNTSB MIA70DKW07Accident · No injuriesClosedCessna 150 · Madisonville, TNMay 17, 1970 · N7170X · Substantial damageNTSB MIA70FKW06Accident · Serious injuriesClosedCessna 150 · Chattanooga, TNMay 11, 1970 · N5864E · DestroyedNTSB MIA70D0270Accident · Minor injuriesClosedCessna 150 · Spring City, TNDec 26, 1969 · N60192 · DestroyedNTSB MIA70D0234Accident · No injuriesClosedCessna 150G · Cookeville, TNNov 30, 1969 · N6307S · Substantial damageNTSB MIA70F0135Accident · No injuriesClosedCessna 150 · Knoxville, TNSep 20, 1969 · N3262J · Substantial damageNTSB MIA70D0124Accident · No injuriesClosedCessna 150 · Murfreesboro, TNSep 6, 1969 · N23362 · Substantial damageNTSB MIA70D0061Accident · No injuriesClosedCessna 150 · Lobelville, TNJul 14, 1969 · N61200 · Substantial damageNTSB MIA69F0439Accident · No injuriesClosedCessna 150 · Wrigley, TNApr 20, 1969 · N7186S · Substantial damageNTSB MIA69F0423Accident · No injuriesClosedCessna 150E · Cumingsville, TNMar 29, 1969 · N3022J · Substantial damageNTSB MIA69D0091Accident · No injuriesClosedCessna 150 · Lebanon, TNAug 22, 1968 · N50284 · Substantial damageNTSB MIA69A0006Accident · 1 fatalClosedCessna 150 · Woodbury, TNJul 31, 1968 · N5631E · 2 aircraft · DestroyedNTSB MIA68F0525Accident · No injuriesClosedCessna 150 · Donelson, TNJun 7, 1968 · N2996J · Substantial damageNTSB MIA68D0539Accident · No injuriesClosedCessna 150 · Gallatin, TNMay 31, 1968 · N8266S · Substantial damageNTSB MIA68F0100Accident · No injuriesClosedChampion 7FC · Columbia, TNAug 10, 1967 · N9842Y · Substantial damageNTSB MIA68D0075Accident · No injuriesClosedCessna 150 · Clarksville, TNJul 29, 1967 · N2938S · Substantial damageNTSB MIA67F0574Accident · No injuriesClosedCessna 150 · Springfield, TNJun 17, 1967 · N8685G · Substantial damageNTSB MIA67F0277Accident · No injuriesClosedCessna 150 · Somerville, TNNov 12, 1966 · N8135F · Substantial damageNTSB MIA67F0219Accident · No injuriesClosedCessna 150 · Ashland City, TNOct 8, 1966 · N8681G · Substantial damageNTSB MIA66D0062Accident · No injuriesClosedCessna 150D · Columbia, TNJul 8, 1965 · N4486U · Substantial damageNTSB UNK64X3299Accident · No injuriesClosedCessna 150 · Columbia, TNAug 9, 1964 · N4291U · Substantial damageNTSB UNK64X1771Accident · No injuriesClosedCessna 150 · Clarkrange, TNMay 15, 1964 · N7302X · Substantial damageNTSB UNK64X0114Accident · No injuriesClosedCessna 150 · Powell, TNJan 2, 1964 · N2039Z · Substantial damage