Fatal NTSB investigations: Continental 0-200 series, 1978

24 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 per year

19642026
Fatal NTSB investigations: Continental 0-200 series, 1978 per year, 1964–2026: 439 cases
19644
19653
19665
19673
196811
19698
19707
19714
19723
19736
19743
19756
19764
197713
197824
197910
198014
198112
198210
198315
198410
19859
19864
198714
198814
19897
199011
19916
199210
19933
19944
19955
19966
19977
19985
19994
20004
200113
20026
20037
20049
200511
20067
200710
20084
20096
20105
20116
20126
20132
20145
20155
20163
20175
20188
20194
20204
20216
20223
20238
20244
20253
20261

Latest cases

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.\"highestInjuryLevel\" = 'Fatal'
    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 FTW79FA023Accident · 1 fatalClosedCessna 150M · Baytown, TXDec 12, 1978 · N714GN · DestroyedNTSB IAD79FA021Accident · 1 fatalClosedCessna 150L · Bolivar, TNDec 4, 1978 · N1540Q · Substantial damageNTSB IAD79FA015Accident · 1 fatalClosedCessna 172 · Mt Airy, NCNov 21, 1978 · N3292L · 2 aircraft · DestroyedNTSB SEA79FA008Accident · 1 fatalClosedCessna 150H · Swan Lake, MTOct 31, 1978 · N7056S · DestroyedNTSB CHI79FEX02Accident · 1 fatalClosedCassutt LSS · Cloverdale, INOct 22, 1978 · N7133 · DestroyedNTSB SEA79FA001Accident · 2 fatalClosedCessna 150H · Omak, WAOct 6, 1978 · N22421 · DestroyedNTSB OAK78FA057Accident · 2 fatalClosedPiper PA-28 · Concord, CASep 22, 1978 · N36762 · 2 aircraft · DestroyedNTSB NYC78FA089Accident · 2 fatalClosedCessna 150M · Millbury, MASep 9, 1978 · N9470U · DestroyedNTSB IAD78FA105Accident · 2 fatalClosedCessna 150 · Louisville, KYSep 2, 1978 · N18123 · 2 aircraft · DestroyedNTSB MKC78FCQ36Accident · 1 fatalClosedVari-Eze · Liberal, KSAug 7, 1978 · N36EZ · DestroyedNTSB CHI78FA052Accident · 2 fatalClosedPiper PA-22 · East Moline, ILAug 6, 1978 · N3217B · 2 aircraft · DestroyedNTSB CHI78FEK24Accident · 1 fatalClosedCessna 150M · Urbana, OHJul 16, 1978 · N66382 · DestroyedNTSB ANC78FA052Accident · 1 fatalClosedCessna 150M · Cantwell, AKJul 15, 1978 · N66744 · Substantial damageNTSB OAK78FVG59Accident · 1 fatalClosedVarieze · Dorris, CAJul 3, 1978 · N942 · DestroyedNTSB LAX78FA058Accident · 1 fatalClosedCessna 182 · San Diego, CAJul 1, 1978 · N2341G · 2 aircraft · DestroyedNTSB MKC78FA049Accident · 1 fatalClosedCessna 150H · St Louis, MOJun 19, 1978 · N50374 · DestroyedNTSB FTW78FA051Accident · 1 fatalClosedCessna 150 · Mckinney, TXJun 10, 1978 · N63577 · DestroyedNTSB CHI78FA042Accident · 1 fatalClosedCessna 150M · Waukesha, WIMay 28, 1978 · N9376U · DestroyedNTSB MIA78FA086Accident · 1 fatalClosedCessna 150L · Ft.Lauderdale, FLMay 21, 1978 · N18131 · DestroyedNTSB OAK78FA024Accident · 2 fatalClosedCessna 150M · Carson City, NVMar 24, 1978 · N714BU · DestroyedNTSB LAX78FA038Accident · 1 fatalClosedCessna 150L · Huntington Bch, CAMar 11, 1978 · N114NS · 2 aircraft · DestroyedNTSB FTW78FA030Accident · 1 fatalClosedCessna 150M · Denton, TXFeb 25, 1978 · N9355U · DestroyedNTSB DEN78FTE30Accident · 1 fatalClosedCessna 150G · Ft Garland, COFeb 18, 1978 · N6244S · DestroyedNTSB LAX78FUQ10Accident · 1 fatalClosedCessna 150 · Pacoima, CAJan 7, 1978 · N66667 · No damage