NTSB investigations: Continental 0-200 series, 1981

118 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\") = 1981
    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 CHI81FEM33Accident · 3 fatalClosedVarieze RAF · Holland, MIAug 8, 1981 · N16DT · DestroyedNTSB MIA81DKT86Accident · No injuriesClosedCessna 150 · Key West, FLAug 5, 1981 · N23318 · Substantial damageNTSB LAX81DUJ82Accident · No injuriesClosedCessna 150M · Pearce, AZAug 3, 1981 · N714SJ · Substantial damageNTSB CHI81FEC26Accident · No injuriesClosedCessna 150 · Monroe, MIJul 29, 1981 · N17134 · Substantial damageNTSB MKC81DCG52Accident · No injuriesClosedCessna 150 · Lees Summit, MOJul 26, 1981 · N7691C · Substantial damageNTSB SEA81FA048Accident · 2 fatalClosedCessna 150H · Blue River, ORJul 24, 1981 · N6551S · DestroyedNTSB LAX81FA109Accident · 1 fatalClosedCessna 150J · Yuma, AZJul 23, 1981 · N50942 · Substantial damageNTSB SEA81DYK13Accident · No injuriesClosedCessna 150G · Medford, ORJul 21, 1981 · N2800S · Substantial damageNTSB FTW81DRJ22Accident · No injuriesClosedVari-Eze 01 · Natchitoches, LAJul 21, 1981 · N106 · DestroyedNTSB LAX81FVD33Accident · No injuriesClosedCessna 140 · San Rafael, CAJul 19, 1981 · N110V · Substantial damageNTSB NYC81FGT07Accident · Minor injuriesClosedCessna 150 · Columbia, PAJul 8, 1981 · N76CA · DestroyedNTSB LAX81FVG50Accident · No injuriesClosedCessna 150 · Georgetown, CAJul 5, 1981 · N22456 · Substantial damageNTSB DEN81FTE52Accident · No injuriesClosedCessna 150G · Hudson, COJul 1, 1981 · N2934J · Substantial damageNTSB LAX81FA099Accident · 3 fatalClosedPiper PA-28 · Sherman Oaks, CAJun 24, 1981 · N4510K · 2 aircraft · DestroyedNTSB LAX81DUJ69Accident · No injuriesClosedCessna 150L · Bullhead City, AZJun 18, 1981 · N19058 · Substantial damageNTSB CHI81DEE45Accident · No injuriesClosedCessna 150 · Morris, ILJun 18, 1981 · N11729 · Substantial damageNTSB FTW81DA107Accident · Minor injuriesClosedCessna 150 · Angleton, TXJun 16, 1981 · N19064 · 2 aircraft · Substantial damageNTSB ATL81DLJ08Accident · No injuriesClosedCessna 150 · Knightdale, NCJun 16, 1981 · N704ZQ · Substantial damageNTSB NYC81FHD28Accident · Minor injuriesClosedCessna 150 · Hamilton Sq, NJJun 13, 1981 · N704PQ · DestroyedNTSB ATL81FIJ10Accident · No injuriesClosedCessna 150 · Hurricane, WVJun 12, 1981 · N1730Q · Substantial damageNTSB FTW81FPJ27Accident · Minor injuriesClosedCessna 150 · Guthrie, OKJun 10, 1981 · N8070S · DestroyedNTSB ATL81DLG10Accident · No injuriesClosedCessna 150 · North, SCJun 10, 1981 · N5679G · Substantial damageNTSB MKC81DCG38Accident · No injuriesClosedCessna 150L · Tiff City, MOJun 7, 1981 · N11542 · Substantial damageNTSB MIA81DKT49Accident · No injuriesClosedCessna 150 · Key Largo, FLJun 6, 1981 · N8252F · DestroyedNTSB NYC81DHA14Accident · No injuriesClosedCessna 150H · Tobyhanna, PAJun 5, 1981 · N22578 · Substantial damageNTSB DEN81FTE42Accident · No injuriesClosedCessna 150 · La Junta, COMay 31, 1981 · N8713S · Substantial damageNTSB ATL81FLT09Accident · Minor injuriesClosedCessna 150 · Bolivar, TNMay 29, 1981 · N6789G · Substantial damageNTSB CHI81DEP18Accident · No injuriesClosedCessna 150K · La Crosse, WIMay 25, 1981 · N6265G · Substantial damageNTSB ATL81FKG19Accident · No injuriesClosedCessna 150 · Williamson, GAMay 21, 1981 · N5714E · DestroyedNTSB MIA81FLD41Accident · Serious injuriesClosedCessna 150 · Ft.Myers, FLMay 17, 1981 · N6132K · DestroyedNTSB FTW81DQD21Accident · No injuriesClosedCessna 150 · Van Horn, TXMay 9, 1981 · N213DA · Substantial damageNTSB NYC81FHA10Accident · Minor injuriesClosedCessna 150G · Stroudsburg, PAMay 2, 1981 · N4073J · Substantial damageNTSB LAX81DUQ19Accident · No injuriesClosedCessna 150 · Inyokern, CAApr 30, 1981 · N6254K · Substantial damageNTSB FTW81DPG21Accident · No injuriesClosedCessna 150 · Marshall, ARApr 29, 1981 · N50494 · Substantial damageNTSB FTW81FPD19Accident · Minor injuriesClosedChampion 402 · Roanoke, TXApr 25, 1981 · N9956Y · Substantial damageNTSB CHI81FEV13Accident · No injuriesClosedCessna 150M · Williamsville, ILApr 25, 1981 · N63288 · Substantial damageNTSB LAX81FUJ51Accident · No injuriesClosedCessna 150 · Globe, AZApr 20, 1981 · N8870S · DestroyedNTSB CHI81DEP16Accident · No injuriesClosedCessna 150E · Palmyra, WIApr 20, 1981 · N3901J · Substantial damageNTSB FTW81FPJ20Accident · Minor injuriesClosedCessna 150 · Dover, OKApr 19, 1981 · N23005 · Substantial damageNTSB LAX81DVA34Accident · No injuriesClosedCessna 150M · Planada, CAApr 14, 1981 · N3382V · Substantial damageNTSB NYC81FNE15Accident · Minor injuriesClosedCessna 150 · Belchertown, MAApr 7, 1981 · N9213U · Substantial damageNTSB NYC81FNE13Accident · No injuriesClosedCessna 150 · Mansfield, CTMar 28, 1981 · N60118 · Substantial damageNTSB MIA81DKT35Accident · No injuriesClosedCessna 150 · Port Largo, FLMar 28, 1981 · N60946 · Substantial damageNTSB ATL81FKJ16Accident · No injuriesClosedCessna 150 · Ozark, ALMar 19, 1981 · N8207S · Substantial damageNTSB ANC81FAD04Accident · No injuriesClosedTaylorcraft F19 · Wht Sulphr Spg, AKMar 19, 1981 · N3694T · Substantial damageNTSB ANC81FA030Accident · 1 fatalClosedTaylorcraft F-19 · Susitna Lake, AKMar 16, 1981 · N20022 · Substantial damageNTSB CHI81FER27Accident · No injuriesClosedCessna 150F · St Paul, MNMar 13, 1981 · N7823F · Substantial damageNTSB ATL81FKW12Accident · No injuriesClosedCessna 150F · Lebanon, TNMar 11, 1981 · N7891F · DestroyedNTSB ANC81FA024Accident · No injuriesClosedCessna 150 · Chugiak, AKMar 7, 1981 · N7022F · 2 aircraft · Minor damageNTSB ATL81FKQ05Accident · Minor injuriesClosedCessna 150 · Poplarville, MSMar 6, 1981 · N22541 · Substantial damage