NTSB investigations: Continental 0-200 series, NJ

126 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\" = 'NJ' 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 NYC77FHD03Accident · No injuriesClosedCessna 150M · Waterford, NJOct 22, 1976 · N7986U · Substantial damageNTSB NYC76FHM16Accident · No injuriesClosedCessna 150 · Wayne Township, NJDec 8, 1975 · N3386V · Substantial damageNTSB NYC76FHM14Accident · Minor injuriesClosedCessna 150H · Lincoln Park, NJOct 23, 1975 · N6443S · Substantial damageNTSB NYC76FHA09Accident · No injuriesClosedCessna 150 · Blairstown, NJSep 7, 1975 · N18676 · DestroyedNTSB NYC76AN018Accident · No injuriesClosedCessna 150 · Readington, NJAug 2, 1975 · N11205 · 2 aircraft · Substantial damageNTSB NYC75AN123Accident · No injuriesClosedCessna 150 · Teterboro, NJJun 22, 1975 · N10979 · 2 aircraft · Substantial damageNTSB NYC75FHA33Accident · No injuriesClosedCessna 150 · Blairstown, NJMar 10, 1975 · N6137G · Substantial damageNTSB NYC75DHA30Accident · No injuriesClosedCessna 150 · Blairstown, NJFeb 11, 1975 · N5687G · Substantial damageNTSB NYC75DHA21Accident · No injuriesClosedCessna 150 · Readington, NJNov 2, 1974 · N5459Q · Substantial damageNTSB NYC75DHM01Accident · Serious injuriesClosedCessna 150 · Flanders, NJJul 7, 1974 · N5498Q · Minor damageNTSB NYC74DHA32Accident · No injuriesClosedCessna 150 · Pattenburg, NJJun 10, 1974 · N11258 · Substantial damageNTSB NYC74DHA31Accident · Minor injuriesClosedCessna 150 · Somerville, NJMay 20, 1974 · N1596Q · Substantial damageNTSB NYC74DHA27Accident · No injuriesClosedCessna 150G · Pittstown, NJApr 20, 1974 · N2899S · Substantial damageNTSB NYC74DHA26Accident · No injuriesClosedCessna 150J · Stillwater, NJApr 13, 1974 · N61208 · Substantial damageNTSB NYC74FHM23Accident · No injuriesClosedCessna 150 · Teterboro, NJMar 31, 1974 · N10070 · Substantial damageNTSB NYC74DHD19Accident · No injuriesClosedCessna 150 · Hammonton, NJNov 3, 1973 · N8561J · Substantial damageNTSB NYC74FHA02Accident · No injuriesClosedCessna 150 · Sussex, NJJul 16, 1973 · N17065 · Substantial damageNTSB NYC73DHD36Accident · No injuriesClosedCessna 150 · Williamstown, NJApr 21, 1973 · N19344 · Substantial damageNTSB NYC73FHD26Accident · No injuriesClosedCessna 150L · Williamstown, NJFeb 14, 1973 · N18210 · Substantial damageNTSB NYC73DHD15Accident · No injuriesClosedCessna 150 · Hammaton, NJNov 11, 1972 · N1625Q · Substantial damageNTSB NYC73FHA10Accident · No injuriesClosedCessna 150K · Manville, NJOct 31, 1972 · N8411M · Substantial damageNTSB NYC73FHD03Accident · No injuriesClosedCessna 150L · Ocean City, NJJul 23, 1972 · N6546G · Substantial damageNTSB NYC72FHM33Accident · Minor injuriesClosedCessna 150 · Morristown, NJFeb 29, 1972 · N5748G · Substantial damageNTSB NYC72DHA19Accident · No injuriesClosedCessna 150 · Manville, NJOct 9, 1971 · N6426G · Substantial damageNTSB NYC72DHD06Accident · No injuriesClosedCessna 150 · Wildwood, NJAug 31, 1971 · N50741 · Substantial damageNTSB NYC71DHD51Accident · No injuriesClosedCessna 150 · Atlantic City, NJMay 28, 1971 · N60767 · Substantial damageNTSB NYC71DHD44Accident · No injuriesClosedCessna 150 · Rio Grande, NJMar 26, 1971 · N1969Z · Substantial damageNTSB NYC71DHA29Accident · No injuriesClosedCessna 150 · Manville, NJJan 8, 1971 · N5942G · Substantial damageNTSB NYC71AN055Accident · 1 fatalClosedCessna 150H · Mountain Lakes, NJNov 7, 1970 · N6676S · Substantial damageNTSB NYC71DHD05Accident · No injuriesClosedCessna 150 · Moorestown, NJJul 8, 1970 · N7024F · Substantial damageNTSB NYC70DHD22Accident · No injuriesClosedCessna 150 · Wildwood, NJMay 1, 1970 · N7948E · Substantial damageNTSB NYC70DHD21Accident · No injuriesClosedCessna 150 · Medford, NJApr 30, 1970 · N60485 · Substantial damageNTSB NYC70DHA09Accident · No injuriesClosedCessna 150 · Sussex, NJApr 25, 1970 · N61208 · Substantial damageNTSB NYC70DHA08Accident · No injuriesClosedCessna 150 · Somerville, NJMar 19, 1970 · N50248 · 2 aircraft · Substantial damageNTSB NYC70D0229Accident · No injuriesClosedCessna 150 · Lakewood, NJDec 18, 1969 · N60412 · Substantial damageNTSB NYC70D0014Accident · No injuriesClosedCessna 150 · Williamstown, NJJun 29, 1969 · N2970J · Substantial damageNTSB NYC69D0374Accident · No injuriesClosedCessna 150 · Flemington, NJMar 23, 1969 · N4288U · Substantial damageNTSB NYC69D0370Accident · No injuriesClosedCessna 150 · Whitehouse, NJMar 17, 1969 · N22439 · Substantial damageNTSB NYC69F0210Accident · Serious injuriesClosedCessna 150J · Morristown, NJOct 15, 1968 · N50589 · Substantial damageNTSB NYC69F0048Accident · No injuriesClosedCessna 150F · Medford, NJJul 17, 1968 · N6486F · Substantial damageNTSB NYC69D0013Accident · Minor injuriesClosedCessna 150F · Lumberton, NJJun 6, 1968 · N8367G · Substantial damageNTSB NYC68D0478Accident · No injuriesClosedCessna 150 · Montville Twp, NJMay 5, 1968 · N8561J · Substantial damageNTSB NYC68F0372Accident · Minor injuriesClosedCessna 150 · Hanover, NJFeb 1, 1968 · N6265T · Substantial damageNTSB NYC68F0269Accident · No injuriesClosedCessna 150 · Teterboro, NJOct 29, 1967 · N8398J · 2 aircraft · Substantial damageNTSB NYC68F0233Accident · No injuriesClosedCessna 150 · Totowa, NJOct 11, 1967 · N6884F · DestroyedNTSB NYC68F0096Accident · No injuriesClosedCessna 150 · Medford, NJJul 26, 1967 · N2779S · Substantial damageNTSB NYC68F0032Accident · No injuriesClosedCessna 150 · Pittstown, NJJun 26, 1967 · N6608T · Substantial damageNTSB NYC67D0661Accident · No injuriesClosedCessna 150 · Colts Neck, NJMay 21, 1967 · N6215T · Substantial damageNTSB NYC67D0699Accident · No injuriesClosedCessna 150 · Sewell, NJApr 29, 1967 · N3976J · Substantial damageNTSB NYC67D0614Accident · No injuriesClosedCessna 150 · Totowa, NJMar 25, 1967 · N8947S · Substantial damage