NTSB investigations: Continental 0-200 series, 1978

209 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 year(c.\"eventDate\") = 1978
    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 FTW78FRD56Accident · No injuriesClosedCessna 150 · Lake Charles, LASep 16, 1978 · N9409U · Substantial damageNTSB CHI78DEE67Accident · No injuriesClosedCessna 150 · Wheeling, ILSep 16, 1978 · N9437U · Substantial damageNTSB FTW78FQG50Accident · No injuriesClosedCessna 150L · Dalhart, TXSep 15, 1978 · N18177 · Substantial damageNTSB FTW78DPJ38Accident · No injuriesClosedCessna 150 · Tuttle, OKSep 14, 1978 · N66482 · Substantial damageNTSB NYC78FHM28Accident · No injuriesClosedCessna 150 · West Milford, NJSep 10, 1978 · N5459Q · 2 aircraft · Substantial damageNTSB NYC78FA089Accident · 2 fatalClosedCessna 150M · Millbury, MASep 9, 1978 · N9470U · DestroyedNTSB CHI78FEP66Accident · No injuriesClosedCessna 150 · Kenosha, WISep 3, 1978 · N66238 · Substantial damageNTSB NYC79FHD23Accident · No injuriesClosedCessna 150L · Robinsville, NJSep 2, 1978 · N19590 · Substantial damageNTSB IAD78FA105Accident · 2 fatalClosedCessna 150 · Louisville, KYSep 2, 1978 · N18123 · 2 aircraft · DestroyedNTSB FTW78FRJ32Accident · Minor injuriesClosedCessna 150J · Mooringsport, LAAug 31, 1978 · N50835 · Substantial damageNTSB LAX78FUQ42Accident · Serious injuriesClosedCessna 150J · Santa Barbara, CAAug 29, 1978 · N61258 · Substantial damageNTSB MIA78DLD72Accident · No injuriesClosedCessna 150 · Ft Pierce, FLAug 28, 1978 · N11589 · Substantial damageNTSB OAK78DVG75Accident · No injuriesClosedCessna 150 · Placerville, CAAug 27, 1978 · N50537 · Substantial damageNTSB CHI78DEP62Accident · No injuriesClosedCessna 150 · Milwaukee, WIAug 20, 1978 · N3035V · Substantial damageNTSB CHI78DEP60Accident · No injuriesClosedCessna 150K · Kenosha, WIAug 18, 1978 · N6490G · Substantial damageNTSB NYC78FGM45Accident · No injuriesClosedCessna 150 · Franklin, PAAug 17, 1978 · N10687 · Substantial damageNTSB CHI78FEM32Accident · Minor injuriesClosedCessna 150L · Lansing, MIAug 17, 1978 · N18686 · Substantial damageNTSB ANC78DAH67Accident · No injuriesClosedCessna 150 · Tyonek, AKAug 17, 1978 · N63048 · Substantial damageNTSB DEN78FQD29Accident · No injuriesClosedCessna 150 · Vado, NMAug 12, 1978 · N2060Z · Substantial damageNTSB MIA78FKT68Accident · Serious injuriesClosedCessna 150 · Pahokee, FLAug 10, 1978 · N3932V · DestroyedNTSB IAD78FLT09Accident · No injuriesClosedCessna 150 · Covington, KYAug 10, 1978 · N51285 · 2 aircraft · Substantial damageNTSB MKC78FCQ36Accident · 1 fatalClosedVari-Eze · Liberal, KSAug 7, 1978 · N36EZ · DestroyedNTSB MIA78FKG70Accident · No injuriesClosedCessna 150 · Savannah, GAAug 7, 1978 · N5699E · Substantial damageNTSB LAX78FUQ41Accident · Serious injuriesClosedCessna 150A · Pacoima, CAAug 6, 1978 · N7102X · DestroyedNTSB CHI78FA052Accident · 2 fatalClosedPiper PA-22 · East Moline, ILAug 6, 1978 · N3217B · 2 aircraft · DestroyedNTSB MKC78DER87Accident · No injuriesClosedCessna 150G · Lester Prairie, MNAug 3, 1978 · N4681X · Substantial damageNTSB ANC78DAG90Accident · No injuriesClosedCessna 150L · Wasilla, AKJul 30, 1978 · N11764 · Substantial damageNTSB MKC78FCA40Accident · Minor injuriesClosedCessna 150 · St Charles, MOJul 29, 1978 · N19552 · Substantial damageNTSB FTW78DPG70Accident · No injuriesClosedCessna 150 · Lakeview, ARJul 29, 1978 · N7143S · DestroyedNTSB LAX78DVA68Accident · No injuriesClosedCessna 150 · Bakersfield, CAJul 28, 1978 · N714BF · Substantial damageNTSB CHI78FE130Accident · No injuriesClosedCessna 150F · Northfield, OHJul 26, 1978 · N7726F · Substantial damageNTSB IAD78DKM15Accident · No injuriesClosedCessna 150 · Lucia, NCJul 24, 1978 · N6288K · Substantial damageNTSB FTW78FPD25Accident · No injuriesClosedCessna 150G · Grand Prairie, TXJul 24, 1978 · N6337S · Substantial damageNTSB FTW78DPD26Accident · Minor injuriesClosedCessna 150J · Iowa Park, TXJul 23, 1978 · N61128 · Substantial damageNTSB MIA78FKG64Accident · Minor injuriesClosedCessna 150 · Athens, GAJul 22, 1978 · N60746 · Substantial damageNTSB IAD78FLJ17Accident · No injuriesClosedCessna 150 · Washington, NCJul 21, 1978 · N6922F · Substantial damageNTSB CHI78DEE66Accident · No injuriesClosedCessna 150 · Aperville, ILJul 18, 1978 · N3026S · Substantial damageNTSB CHI78FEK26Accident · No injuriesClosedCessna 150F · Marysville, OHJul 17, 1978 · N6299R · Substantial damageNTSB CHI78FEG14Accident · No injuriesClosedCessna 150M · Cleves, OHJul 17, 1978 · N714NN · Substantial damageNTSB CHI78FEK24Accident · 1 fatalClosedCessna 150M · Urbana, OHJul 16, 1978 · N66382 · DestroyedNTSB SEA78DTA16Accident · No injuriesClosedCessna 150 · Miles City, MTJul 15, 1978 · N19313 · Substantial damageNTSB FTW78FRG62Accident · No injuriesClosedCessna 150 · Sandia, TXJul 15, 1978 · N5585E · Substantial damageNTSB ANC78FA052Accident · 1 fatalClosedCessna 150M · Cantwell, AKJul 15, 1978 · N66744 · Substantial damageNTSB DEN78FQA38Accident · No injuriesClosedCessna 150G · Albuquerque, NMJul 10, 1978 · N3643J · Substantial damageNTSB DEN78DTE72Accident · No injuriesClosedCessna 150 · Sterling, COJul 10, 1978 · N50546 · Substantial damageNTSB SEA78DYM43Accident · No injuriesClosedCessna 150 · Vancouver, WAJul 9, 1978 · N9256U · Substantial damageNTSB NYC78FHJ19Accident · No injuriesClosedCessna 150 · Islip, NYJul 8, 1978 · N5486Q · 2 aircraft · Substantial damageNTSB CHI78FEV44Accident · No injuriesClosedCessna 150 · Peoria, ILJul 8, 1978 · N45530 · Substantial damageNTSB NYC78FGT11Accident · No injuriesClosedVari-Eze 1 · Lewisberry, PAJul 7, 1978 · N886 · Substantial damageNTSB OAK78DXQ32Accident · Minor injuriesClosedCessna 182 · Minden, NVJul 6, 1978 · N3453J · Substantial damage